Overview
This article will guide you through the process of setting up QuickBooks Online and CoreBridge to prepare for a data sync.
- If you have not Gone Live! with CoreBridge you can still perform these setup steps, however, the actual sync will not occur until you are Live and the sync requirements have been met.
- If you are entering orders or payments in a program other than CoreBridge, we recommend not entering that data again in CoreBridge. Entering it again in CoreBridge may give you duplicate data in QuickBooks.
- If you are entering payments in a program other than CoreBridge, we recommend keeping those bank deposits separate from your CoreBridge deposits.
- If your CoreBridge system has more than one location, data from all locations will sync to the same QuickBooks company. There is no way to send each CoreBridge location's data to separate companies.
- The sync and the reconciliation are 2 distinct processes. Reconciliations should be performed once your system is Live. The sync will happen after that.
- The sync is one-direction only, from CoreBridge to QuickBooks.
Sales Tax
- The sales tax report in QuickBooks will not work with Summary Sync.
- It doesn't work because the report doesn't pull sales numbers from journal entries.
- The CoreBridge sales tax reports will need to be used when preparing sales tax forms.
Sync Requirements
Before the sync can happen the following requirements must be met.
- QuickBooks Online subscription. LINK: Accounting Export Options
- The Summary Sync export method is being used
- If your CoreBridge system has more than one Location, you must have a version of QuickBooks Online that supports "Class Tracking". Each Location name from CoreBridge will be used to create a Class in QuickBooks so that you are able to separate each location(store) on reports. The "Location" feature in QuickBooks Online is not used for the sync.
- Your system must be live.
- One or more Completed orders
- One or more payments.
- One or more Reconciliation that contains payments.
- One or more Reconciliation that contains income.
Related Articles
Please take a few minutes to review these articles. They provide helpful details about the sync.
Bank Feed
If you are using the bank feed, transactions from CoreBridge payments will need to be handled properly in order to not duplicate data in QuickBooks. If you have not synced from CoreBridge you should not Add those transactions or try to Match them. Just let them sit. They will need to be addressed once you sync.
If bank feed transactions from CoreBridge payments have been added to QuickBooks they will cause duplicate data and the related deposits will probably need to be deleted.
Please review this article for more details: Add and match downloaded banking transactions
3rd Party Integration Requirement
Certain 3rd party services that integrate with CoreBridge require special settings to be enabled. Those services are listed here. If a service is integrated with your CoreBridge system please pay special attention to the instructions in the noted instruction step. If a required setting is not enabled, the sales tax that posts to QuickBooks may be erroneous, or the journal entry containing sales tax may fail to sync.
- Pressero: Lump Tax Agencies option must be selected (Step 5)
- XMPie: Lump Tax Agencies option must be selected (Step 5)
- TaxJar: Lump Tax Agencies option must be selected (Step 5)
- Avalara: Lump Tax Agencies option must be selected (Step 5)