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 friend is 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 payments 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.
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 the 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
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
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
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.