Sync Every Transaction with QuickBooks Online

Leverage our integration with Quickbooks for real-time accounting for every transaction that flows through PeopleVine.


PeopleVine can keep all of your revenue channels in sync with QuickBooks. When one of the following activities occur, PeopleVine will automatically sync that data to your QuickBooks account. We currently sync the following:

  • General Transactions
  • Recurring Subscriptions (includes service and sku)
  • Event Tickets (includes event and ticket in description)
  • eCommerce Orders (includes product and sku)
  • Appointments
  • Donations

When a transaction is completed in PeopleVine, we will sync the customer profile, the order info and mark the invoice as paid.  If the customer is already in QuickBooks with the same e-mail address, we will link the accounts.

To get started with QuickBooks, follow these steps:

  1. Login to the PeopleVine Control Panel
  2. Click on the Company Menu > Settings & Tools > Integrated Platforms
  3. Click on QuickBooks Online then click on "Connect to QuickBooks"

4. Walk through the steps to authenticate PeopleVine and then once you're back to PeopleVine you can close that window.

Once you are connected, you will see QuickBooks in your list of integrations.

Setting Up QuickBooks

There are a few things we need you to setup in QuickBooks in order to ensure all transactions sync properly.

First, make sure you add new payment methods that match PeopleVine's payment methods. This includes the following:

  • points
  • giftcard
  • entry
  • voucher

We will automatically match Cash payments to Cash in QB, papercheck to Check in QB and all credit card types to Credit Card in QB. If one of the above does not exist, we will default to Other as the payment method, but if that doesn't exist we default to Cash.

Mapping Quickbooks Products to PeopleVine Items
In order to create accurate reporting, PeopleVine tries to send over consistent data nd product skus to QuickBooks.  We map the following fields to the products by sku in QuickBooks:

  • Memberships use membership_sku
  • Products on an order use product_sku
  • Events use event-# where # is the event_no
  • Event Tickets use ticket-# where # is the event_ticket_no
  • Appointments use either appointment-# or reservation-# where # is the schedule_item_no
  • General charges will create a new sku as transaction-# where # is the transaction_no

If you add an Income Account to your product, this will show up on your General Ledger.  PeopleVine will automatically create the product when an order is processed and the product sku does not exist. 


Where Are Funds Deposited
As soon as a payment comes through it will apply to an existing invoice or setup a new one.  The funds from this payment will be placed in Undeposited Funds unless you setup either a Bank Account or Other Current Assets Account that contains PV in the title (e.g. Bank of PV).

Processing Refunds
When you apply a refund in PeopleVine and the transaction was synced with QuickBooks, we will make our best effort to process the refund in QuickBooks too.  We say "best effort" as you may try to refund something on closed books and we can't update that.

When refunding, we will 1) add a new line item called "processed refund" with a negative amount to balance out the invoice, then 2) we process the refund on the associated payment.


D

Additional Help Tutorials

Find more ways to grow on PeopleVine.

Improvements to Refunding Event Tickets

We made some improvements to refunding event tickets to streamline the process.

Posted November 25, 2020

Know How we Charge Service Fees and Taxes on Subscriptions

We wanted to share with you how we charge taxes and service fees on subscriptions, membership initiation fees and more.

Posted November 19, 2020

Updated PDF Receipt, Better Subscription Billing Reporting and More

We made some updates to our transaction and subscription engine we thought we should share.

Posted November 19, 2020

Process Payments in PeopleVine Using their Square Card on File

When you connect to your Square POS, you enable the ability to process payments to a member's card on file at the POS. This tutorial will show you how they can register it and how it works in PeopleVine.

Posted November 10, 2020

Adding a Card on File at the POS for Square

We recommend you having your members register their card on file at your POS for the most secure and cost-effective way for charging for orders and other items in PeopleVine.

Posted November 10, 2020

Your Members Can Register their Card on File with Square from the Member Portal

Your members are able to add a payment on file to be leveraged at the Square POS.

Posted November 10, 2020

Connect Your Square POS for Order History, Loyalty, Card on File and More

With our integration to Square you can track member spend to their CRM profile in PeopleVine while enabling a secured way for registering your card on file at the POS.

Posted November 9, 2020

Syncing Your Customers, Members and Orders with Square

With our Square integration, you can ensure that your CRM in PeopleVine has the latest data on your customer's behaviors, while ensuring your members are ready in the Square POS.

Posted November 9, 2020

Enable a Webhook to Automatically Tag a Person with an Attribute

You can trigger a webhook to automatically attach an attribute to the person's profile.

Posted November 4, 2020

Get a Quick Glimpse of Your Commerce Revenue by Category

If you're POS is connected to PeopleVine or you're leveraging our eCommerce, you can now get a quick glimpse of how a specific category is performing.

Posted November 2, 2020

Adding Your Member to a Ticket in Toast, Allowing them to Pay from their Phone

Leverage this guide to train your employees how to add a member to a check when using Toast.

Posted October 28, 2020

Troubleshooting Toast - Getting an Error Validating the Loyalty Account

If you're getting an error "Error validating the loyalty account," it is most likely related to a change in the member's profile. Although an unlikely scenario, we wanted to ensure you knew how to handle.

Posted October 28, 2020

Overview of the Integration with Toast POS System and PeopleVine

As we have launched our integration with Toast, we wanted to highlight the overall features and experience.

Posted October 28, 2020

Improvements to the Virtual POS - Tips, Discounts and More

We recently made major updates to the Virtual POS and Commerce engine in an effort to ensure continuity between experiences along with providing better control and reporting on payment details.

Posted October 28, 2020

Setup Access Rules with Public Descriptions in Sevenrooms to Allow Members to Book Specific Areas

You can surface the type of reservation someone is booking by setting up access rules associated with public descriptions.

Posted October 22, 2020

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