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 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 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


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.

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

Add Your Member to Sevenrooms as a Walk-In if They Don't have a Reservation

Looking to ensure your hostess knows when a member entered the building? Enable this feature with Sevenrooms to add a member as a walk-in in Sevenrooms when scanned in.

Posted April 2, 2021

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.

Posted March 19, 2021

Updated Monthly Statement to Print for Your Members

You can now generate quick monthly statements breaking down recent charges along with past due.

Posted March 12, 2021

We Support Fees on SevenRooms Reservations

Are you looking to charge a fee for upcoming reservations? You can add this in Sevenrooms and Peoplevine will ensure to capture this fee before confirming the reservation.

Posted March 10, 2021

Setup Your Mews Account to Work with PeopleVine

We are integrated with the PMS Mews to enable you to sync member data into Mews (along with changes), get reservation data and spend along with process payments into the members' account in Mews.

Posted March 4, 2021

Hide Birthday on the Member Registration

You can easily hide the birthday fields when people enroll by adding one line to your layout css.

Posted March 2, 2021

Replace Your Contact Us with a HAPIform

You can replace your contact us page with a new contact us form, designed to match your brand.

Posted February 26, 2021

When They Arrive in Sevenrooms We'll Check Them in PeopleVine too

To ensure your data is in sync, as soon as someone is marked as arrived in Sevenrooms, we'll ensure you can see this check-in on the membership activity and leveraged for automation.

Posted February 17, 2021

Screen Update to Aloha Payment on File Screens

Our Aloha integration partner, Omnivore, pushed an update to the payment on file experience. Here are some things you should know.

Posted February 12, 2021

Generate Account Statements and E-mail them to Your Members

You can quickly generate a monthly statement highlighting your customer spend and transactions during that time frame.

Posted February 11, 2021

We added Additional Transaction Meta Data for Your Reports and Tracking

We expanded our transaction data and exports to now share with you when it was originally created (not just when it was charged) along with when it was paid on.

Posted February 11, 2021

Adjust the Billing Date of Your Members with Two Clicks

With an ever-changing world and continuous lockdowns/business closures, we create a tool so you can easily push out the next billing date.

Posted February 10, 2021

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