QuickBooks Online Summary Sync will allow you to sync your financial data in journal entry format directly with QuickBooks Online. QuickBooks Online Summary Sync provides a high-level overview of financial performance with faster data transfer and reduced storage needs, making it ideal for businesses that require an overall financial snapshot without delving into individual transactions.
TABLE OF CONTENTS
- Benefits of Integrating with QuickBooks Online Summary Sync
- How to Integrate with QuickBooks Online Summary Sync
- Functionality
Benefits of Integrating with QuickBooks Online Summary Sync
- High-Level Overview: Provides a consolidated view of financial data, offering a snapshot of overall performance without individual transaction details.
- Fast Data Transfer: The Summary Sync method offers quick data transfer, making it suitable for businesses that need a broad financial overview.
- Reduced Storage Needs: Combines data into one summary to minimize storage requirements and streamline bookkeeping.
- Sync Flexibility: Options to configure reconciliation sync to either manual or automatic and set notification preferences for sync failures.
- Customizable Sync Options: Includes settings for syncing balances for pre-invoiced orders, component consumption costs, and CoreBridge locations to QBO classes, if supported.
How to Integrate with QuickBooks Online Summary Sync
To integrate QuickBooks Online Summary Sync with your CoreBridge system, navigate to Settings / Integrations / Marketplace.
1. Select the QuickBooks Online Summary Sync Icon.
Note: QuickBooks Online Summary Sync can also be found within the Finance Folder, All Folder, or by using the search filter.
2. Select Install.
3. Once installed, select View/Edit Settings to connect your QuickBooks Online Summary 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 Summary Sync automatically being selected.
4. Select Connect to QuickBooks.
Note: This will open a pop up that will prompt you to sign into your account using either an email, user ID, or phone number.
There is also an option to Create an Account.
Once connected, you can set up your QuickBooks options. These can be managed at any time in Settings / Integrations / Installed Integrations and selecting QuickBooks Online Summary Sync.
5. 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.
6. 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.
7. Choose the date you would like your sync to begin.
Note: This option only appears if you have selected the Automatic option above.
8. Use the dropdown to select which employee role you would like to have notified via email if a failure occurs.
9. Use the checkboxes to select your Sync Options.
Note: The option to sync to QBO Classes will only be visible if your version of QBO will support it.
10. Select Edit Class Mapping. This will bring up a modal that allows you to make your individual selections.
11. Use the dropdown to select your Accounting Software Classes.
Note: If Add as new on sync is selected, CoreBridge will add a new class to your accounting software.
12. Select Save.
13. Select Edit Account Mapping. This will bring up a modal that will allow you to make individual selections.
14. Use the dropdown to select your Accounting Software Accounts.
Note: If Add as new on sync is selected, CoreBridge will add a new account to your accounting software after syncing.
15. Select Save.
Note: Once everything is set, the you can perform a reconciliation in CoreBridge and it will sync up with QuickBooks automatically if you have chosen that option in the configuration screen for the integration.
Functionality
After creating your account and setting your syncing preferences, QuickBooks Online Summary integration is easy to use within your CoreBridge system.
To view your Payment and Financial Summary details:
Begin by navigating to Accounting / Reconciliation & Sync and clicking on one of the Reconciliation Periods shown on the screen.
To manually sync your QuickBooks Online Summary integration from this page:
1. Check the box to the left of one of the reconciliations displayed on the screen.
2. Select the Sync button on the right.
To view Payment Summary information:
1. Select the Payment Summary tab.
a. To manually sync directly from this page, select the icon in the upper right showing two arrows.
b. Clicking on any of the Payment;Transactions or View Details hyperlinks will open a new modal with more detailed information.
To see a list view of all payments and refunds:
1. Select the Payment and Refunds tab.
a. To manually sync directly from this page, select the icon in the upper right showing two arrows.
Note: Selecting a payment or refund from the list will open a modal with more information on that particular transaction.
To view a financial summary:
1. Select the Financial Summary tab.
a. To manually sync directly from this page, select the icon in the upper right showing two arrows.
Note: When a reconciliation has been synced properly with QuickBooks Online Summary 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:
