This article will provide step-by-step instructions to help you get the Quickbooks Online (QBO) integration enabled.
Before you begin
In order to get setup, there are a few basic things you’ll need to know:
1. Which of your bank accounts receive(s) Pushpay deposits.
2. Which Quickbooks Online company file you should use (if you have more than one).
3. How your Pushpay Funds match up with your Quickbooks Online chart of accounts, as well as classes & locations if you have them.
4. Have your Quickbooks Online login details handy so you can complete the integration.
Once you are ready to begin, log in to your Pushpay admin portal and select Settings > Integrations:
Connect Quickbooks Online
Select Connect integration for Quickbooks Online, then Authorize Pushpay to connect your QBO account. If you have multiple company files, select the file you want us to send Journals to.
Match bank accounts
This screen shows the deposits your organization can synchronize with Quickbooks Online.
- Bank Deposits = ACH giving processed by Pushpay
- Card Deposits = Card giving processed by Pushpay
- Check Deposits = Checks processed via Check Deposit
- Batch Entry Deposits = Recorded giving in batches that you've marked as Deposited via Batch Entry (available from June)
Enable the deposits you wish to sync, and select the bank account which these deposits are paid into. This will ensure that the journal entries assign giving to the correct bank account in Quickbooks Online.
If there are multiple deposits of the same type, we show you the Listing that the deposit is associated with so that you can select the correct bank account.
2) Match Listings and Locations (optional)
If you use Locations in QBO, and these Locations match exactly with your Pushpay Listings, you’ll have the option to match them together. Matching Listings to Locations will ensure all giving is allocated to the correct Location in QuickBooks Online.
Please note: These mappings are optional, so if you don’t want a specific Listing matched to a Location you can leave it unmapped.
3) Match Funds
In order for us to allocate giving correctly in Quickbooks Online, you’ll need to match each Pushpay Fund to the appropriate revenue account in Quickbooks Online.
If you have Classes enabled in Quickbooks Online, you’ll also have the option to match each Pushpay Fund to a Quickbooks Online Class or Sub-Class, if you wish. If you don’t want to match Funds to a Class, simply leave Classes unmatched.
If you have Locations enabled in Quickbooks Online, and you haven’t already matched these to your Pushpay Listings, you’ll have the option to match each Pushpay Fund to a Quickbooks online Location or Sub-Location, if you wish. If you don’t want to match Funds to a Location, simply leave Locations unmatched.
4) Enable the Integration
Once you've finished mapping your Funds, you’ll have the option to enable the integration now or at a later date. Once you enable the integration, you can expect to see journal entries being created in QBO after a couple of days.
If you choose not to enable the integration right now, you can easily do this at a later date via by navigating back to Settings > Integration screen.
For more details on the Journal Entries that are created in QBO, click here.
Why do I have to map the CCB Fund to Quickbooks Online?
- At this time the CCB/Pushpay integration does not send the Chart of Accounts from CCB into Pushpay for transactions that are initiated from CCB. This means that if you are using the CCB 2-way integration, you will need to map your CCB Fund to one of your Quickbooks Accounts.
- Excluding this fund is not an option, as the journal we send through to Quickbooks Online would not match to the corresponding bank deposit.
- We hope to improve on this experience in the near future.