The QuickBooks Online Detail Sync provides users with the ability to sync their financial data, including individual transactions and customer records, directly with QuickBooks Online. This integration is perfect for those who require comprehensive tracking of financial activities within their accounting software. Unlike the Summary Sync, the Detail Sync ensures that each transaction and customer entry is fully mirrored in QuickBooks Online, making it easier to track and manage specific financial activities.
Table of Contents
- Benefits of Integrating with QuickBooks Online Detail Sync
- What is the difference between the Summary Sync and the Detail Sync integrations?
- How to Integrate With QuickBooks Online Detail Sync
- Functionality
Benefits of Integrating with QuickBooks Online Detail Sync
- Comprehensive Data Sync: Unlike Summary Sync, the Detail Sync captures every individual transaction and customer entry, offering a complete view of financial activities.
- Detailed Reporting: Provides a transaction-level view that supports detailed reporting, auditing, and compliance needs.
- Sync Flexibility: Users can choose between manual and automatic reconciliation sync options, accommodating different workflow preferences.
- Customizable Sync Options: Options to sync customers as necessary, include purchase orders, and map CoreBridge locations to QBO classes (if supported by the QBO version).
- Automated Notifications: Roles can be configured to receive email notifications in case of sync failures
What is the difference between the Summary Sync and the Detail Sync integrations?
The difference between Summary Sync and Detail Sync in QuickBooks Online integrations lies in the level of data gathered and the way it is used.
Summary Sync consolidates transactions into data groups, providing a high-level overview of financial performance with faster data transfer and reduced storage needs. This makes it ideal for businesses that require an overall financial snapshot without delving into individual transactions.
In contrast, Detailed Sync offers a comprehensive, transaction-level view, capturing every individual sale, expense, and tax detail. This method is suited for businesses needing detailed reporting, auditing, and compliance support. However, because of the amount of data gathered, it involves slower data transfer, higher storage requirements, and more complex bookkeeping.
By understanding these differences, you can choose the appropriate sync method for your business needs and ensure that the QuickBooks Online integration you choose will meet your financial tracking and reporting requirements.
How to Integrate With QuickBooks Online Detail Sync
To integrate QuickBooks Online Detail Sync with your CoreBridge system, navigate to Settings / Integrations / Marketplace.
1. Once you have navigated to the Integration Marketplace, select Finance.
Note: QuickBooks Online Detail Sync can also be found within the All folder, or by using the search filter.
2. Select QuickBooks Online Detail Sync.
3. Select Install.
4. Once installed, select View/Edit Settings to connect your QuickBooks Online Detail Sync account to your CoreBridge system.
Note: This will redirect you to Settings / Integrations / Installed Integrations where all integration settings can be managed with QuickBooks Online Detail Sync automatically being selected.
5. Select Connect to QuickBooks.
6. If you have multiple locations, choose whether you would like all of your locations to sync to one QuickBooks company, or if you would like them to sync to individual companies within QuickBooks.
7. Use the dropdown to choose if you would like your reconciliation sync to be Automatic or Manual.
Note: It is recommended to complete the first sync Manually to check that the mapping has been done correctly. After the first sync has completed, you may select Automatic.
8. Choose the Date you would like your sync to begin.
Note: This option only appears if you have selected the Automatic option above.
9. Customer Sync - This dropdown allows you to choose between syncing all customers or only as necessary.
Note: It is recommended to select Sync Customers Only As Necessary. This will sync only those customers that have had activity.
10. Use the dropdown to select which Employee Roles you would like to have notified via email if a failure occurs.
11. Sync Purchase Orders - Check this box if you would like to Sync Purchase Orders.
12. Sync CoreBridge Locations to QBO Classes - Classes are a way to group your data in QuickBooks for more detailed reporting. Checking this box will sync your CoreBridge Locations to your QuickBooks Classes, allowing you to view and search for information by Location.
Note: This box must be checked in order to see Location Mapping below.
Note: Some of these options may appear differently depending on the number of locations you have and the sync settings chosen above with step 6.
Note: Your QuickBooks version must support class mapping to allow the option to sync to QuickBooks classes. Currently, Quickbooks Essentials and Simple Start do not support class mapping.
13. Select Edit Class Mapping. This will bring up a modal that allows you to make your individual selections.
14. Use the dropdown to select your Accounting Software Classes.
Note: If Add as new on sync is selected, QuickBooks will add your Location after syncing.
15. Select Save & Sync Now.
Note: Syncing immediately will alert you to any issues right away.
16. Select Edit Account Mapping. This allows you to select which of your Quickbooks accounts map with the CoreBridge accounts. Account Mapping is critical for ensuring accurate syncs and reconciliations. For more information, please see Account Mapping With Accounting Integration Software.
Note: We recommend selecting all of your accounts from your accounting software manually to ensure correct mapping. Add as new on sync should be reserved for accounts that are specific to CoreBridge such as Orders in Pre-WIP.
17. Use the dropdown to select your Accounting Software Accounts.
18. Select Save.
Functionality
After creating your account and setting your syncing preferences, QuickBooks Online Detail Sync integration is easy to use within your CoreBridge system.
Navigate to Accounting / Reconciliation & Sync.
To manually sync your QuickBooks Online Detail Sync integration from this page:
Note: In order to manually sync, you must have that option set in the dropdown on the How to Integrate step 7 above.
1. Open the ellipsis at the end of the row.
2. Select Sync to QuickBooks.
To manually sync your QuickBooks Online Detail Sync integration in detail view:
Note: In order to manually sync, you must have that option set in the dropdown on the How to Integrate step 7 above.
1. Click on the row of the Reconciliation you would like to view.
2. Open the ellipsis in the top right corner.
3. Select Sync to QuickBooks.
Note: The option to sync is available regardless of which tab you are in.
Payment Summary tab.
a. Clicking on any of the Payment;Transactions or View Details hyperlinks will open a new modal with more detailed information.
Payment and Refunds tab.
a. Selecting a payment or refund from the list will open a modal with more information on that particular transaction.
Financial Summary tab.
This tab allows you to quickly see an overview of money coming in and going out of your business for the selected reconciliation period.
Note: When a reconciliation has been synced properly with QuickBooks Online Detail Sync, the Payment Information will display this way:
Note: If there is an issue with the sync, it will display in this way in the reconciliation screen:
