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.

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