Peoplevine For Your Accounting Team - Learn the Tools, Predict Your Revenue and Follow Your Cash

This article highlights the latest components available to your accounting team to understand how they can find transactions, research transactions, review accounts receivables and more.


Your accounting team's best friends are going to be our Transaction engine and our Subscription engine.  The Transaction engine will report on all revenue generated since you started charging people within Peoplevine while the Subscription engine will provide predictability based on upcoming membership dues.

When taking a payment in Peoplevine, your staff will be provided with a few options, several of these need to be enabled and/or available in the customer's account.  In addition on your website, your members will have the ability to check out via a few (verified) methods.  These methods include:

  • Credit Card - direct validation with your processor (Staff + Member)
  • ACH - direct validation with your processor and must be enabled (Staff + Member)
  • Wire - to track a wire by number for auditing purposes (Staff only)
  • Cash - to track cash payemnts for auding purposes (Staff only)
  • Paper Check - to track check payments by number for auditing purposes (Staff only)
  • Voucher - to track using a voucher or other redemption method for auditing purposes (Staff only)
  • Gift Certificate - allows a member to use their gift card, stipend or deposit (Staff + Member)
  • Entry - for last resort auditing purposes (Staff only)
  • Invoice - enable a member to pay at a later date with a House Account (Staff + Member's have to be enabled)

You will find these transactions and payment types when charging a person and reporting on charges in the Transaction engine.

The Transaction engine provides screens and reports for transparency on how you receive payment including payment type, timeframe, receivables, processor confirmation, etc.  Here are some of the reports we suggest, they can ALL be found under Sell > Transactions:

  • View All Transactions - A raw view of the transactions as they enter our system. You can filter the data with live filtering including transaction type, card type, date chaged, transaction amount and more, in addition to quick YTD, LY, MTD, LM and other useful reports.
    When viewing a transaction you will see different options based on the status of the order.   Although a retry is available for failed payments, it is best to go back to the action to retry.  For every refund, the original transaction will be linked.  Some transactions are composed of transactional line items, you can break these out here or see them when viewing a transaction.  The type refers to the first or main item in the items. 

  • Members Statements - Are available on a member's CRM profile.  Each month, we'll combine their spend into a single statement that you can print, save as PDF and export to CSV to share with your members.  They also have access in their member portal too!


  • Account Receivables - Generate an aging report of past due invoices to gain control over your account receivables.  You can even update the report to show as of a specific date (perhaps the items 2+ years old should be written off - in the future you should leverage our card on file experience).


  • Open Invoices - You can either click on the Total Transactions next to their name to their open intoices or go to the Open Invoices report to see all open invoices.  Quickly filter by date, amount or other methods to see who still owes you money.  This is the same report we use for transactions, but we filter by the status of Invoiced.


  • Transaction Pivot Reports - This report provides you a breakdown of cash flow based on specific focus areas: 

    Transactions By Billable Item which shows you revenue across channels like event tickets, giftcards, membership dues, F&B orders, etc.
    Revenue By Category Across Function including how people paid across which categories
    Transactions By Payment Type + Billable Item to see the breakdown of type of credit card and other payment methods
    Tax By Category Across Function similar to above but showing tax collected

  • Customer Spend Report - Found under the CRM, this provides a real-time view of your top spenders acrosss all functions, e.g. you can find your top spenders in event tickets or F&B.


  • Gift Cards + Stipends Balance - To identify your liabilities for gift cards, stipends, deposits and more, this tool will provide real-time insight on total spend vs. total available.


Transactions will flow in from multiple channels in PeopleVine.  When viewing the transaction, you can click to see more details on the spend.  However, you may find it easier to view the source of this data (e.g. Commerce, Events, Donations, Schedulers, etc.).  Under the Sell suite, you will find several sections and reports to view this information.  A few notable tools include:

  • Order History under Commerce - As orders flow in from your website, F&B experience or your connected POS, you will see a real-time filterable view to help manage your order flow.


  • Coupons and Promos under Commerce - see what discounts were applied to which orders, to understand promotions and/or abuse.


  • Product Sales Report under Commerce - As we record sales from your POS, ecommerce, F&B and other channels that supply order data, we will bring to the front your top sellers along with total revenue, average per check and more.  

The Subscription engine provides reporting on past charged membership dues along with providing insight into future revenue.  You can find these links under Sell > Transactions > Subscriptions:

  • View All Subscriptions


  • Subscriptoin Report


  • Service Report


You will also find additional reports located under our reporting engine.  These enable you to access a more specific break-down of your data for specific use cases:

  • Member Sales + Sign Up by Employee


  • Touchpoint Activity and Revenue


  • Transaction List by Payment Type


  • Transaction List with Gross/Net Revenue after Taxes Breakout


  • Transactions by Revenue Stream

------------------------------------------------------

FAQ

When orders flow from the POS, what syncs to Quickbooks?

We only sync payments from the POS and PMS when they are processed within Peoplevine.  For example if a member pay for their order via the House Account, Stipend or Card on File experience, then this transaction will flow to Quickbooks from Peoplevine.  If it's paid at the POS with a physical credit card, cash or other means, we will NOT send this to Quickbooks.

Additional Help Tutorials

Find more ways to grow on PeopleVine.

Using Adyen as Your Payment Gateway

We support an integration with Adyen, a leader in payments in Europe, to process credit cards for all types of transactions including recurring billing, F&B, merch, event tickets and much more. This article will help you get things setup.

Posted July 20, 2021

Updated Affiliate Reporting for More Visibility and Accuracy

We recently updated our Affiliate engine with more detailed and actionable reporting to help you service your affiliates better and pay them sooner.

Posted July 13, 2021

Single Sign On (SSO) Using a JWT Token with Certificate

A new modern way to authenticate your members by leveraging our Single Sign On JWT Token that is validated by an updating certificate.

Posted July 9, 2021

Setup Micros Simphony to Work with Peoplevine

You can setup your Micros Simphony (with Transaction Services enabled) to lookup members, sync orders and take payment direct from the POS.

Posted June 15, 2021

Looking to Upgrade Your Authorize.Net Connection to 2.0 and Get Features Like Card Updater

If you are a legacy Authorize.net user, we recommend you upgrade to v2. It's quick and easy while giving you best in class security along with features like card updater from Authorize.net.

Posted June 14, 2021

You Can Sync Stripe Tokenized Credit Cards to Peoplevine

Do you have customers who added their payment directly in Stripe or from a previous integration? We can import those tokens to their CRM profile for future card on file charges.

Posted June 9, 2021

Set Member Perks to Issue on a Re-occurring Basis and to Sub Members (or not)

With our recent update to our Member Perks engine, you can now set a perk to re-issue on a regular basis. You can also control whether a sub member should receive this perk.

Posted May 27, 2021

Verify an Applicant hasn't Already Applied Before Continuing - Avoid Data Overlap

We added a new feature that allows you to prompt an applicant to enter their e-mail and/or mobile number in order to verify if they have either applied or are an active member.

Posted May 13, 2021

FAQ: Sevenrooms

Being integrated with Sevenrooms for nearly 3 years, we've learned a lot on how our users leverage it to improve the member experience while maximizing revenue. Here are some off the questions we get asked the most about our integration with Sevenrooms.

Posted May 11, 2021

Integrate Your Hardware to Verify Members as they Arrive

This step by step tutorial will show you how to verify a membership card and check them in via our API.

Posted May 11, 2021

Capture up to 3 Months Past Due When Members Don't Renew After Billing Fails

We are in a weird time where members may feel that no or limited access to the club doesn't warrant dues, so you may find people waiting to pay/activate until you re-open. If they do, this new feature will prompt them to pay up to the last 3 months they were inactive/unpaid.

Posted May 11, 2021

Adding a Card on File with Square for Dining

If you're using Square, we've updated our flow/experience for registering a card with Square for a card on file experience when dining.

Posted April 23, 2021

1 Hour Outage Due to Azure Downtime

We encountered an outage for an hour when Azure became unavailable. We contacted their support on Twitter to get them looking into it. Details inside.

Posted April 2, 2021

© Peoplevine 2021. Powered by PeopleVine. Terms of use | Privacy & cookies