Xero Summary Sync allows you to sync financial data in a summary format directly with Xero. This integration offers a streamlined solution for managing high-level financial data. It consolidates transactions into a summarized form and only requires maintaining general ledger accounts, without including individual customers or transactions.
Table of Contents
Benefits of Integrating With Xero Summary Sync
- Streamlined Data Management: Syncs financial data in summary format, offering a high-level view of financial performance without individual transaction details.
- Fast and Efficient: Consolidates data to reduce storage needs and streamline bookkeeping processes.
- Customizable Sync Options: Includes settings for manual or automatic reconciliation sync, customer sync preferences, and purchase order syncing.
- Automated Notifications: Configure roles to receive email notifications in case of sync failures.
How to Integrate With Xero Summary Sync
To integrate Xero Summary Sync with your CoreBridge system, navigate to Settings / Integrations / Marketplace.
1. Once you have navigated to the Integration Marketplace, select Finance.
Note: Xero can also be found within the All folder, or by using the search filter.
2. Select either Learn More or Xero below.
3. Select Install.
4. Once installed, select View/Edit Settings to connect your Xero 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 Xero Summary Sync automatically being selected.
5. Select Connect to Xero.
Note: This will open a modal that will prompt you to sign into your account.
Once connected, you can set up your Xero Summary Sync options. These can be managed at any time in Settings / Integrations / Installed Integrations and selecting Xero Summary Sync.
6. If you have multiple locations, choose whether you would like all of your locations to sync to one Xero company, or if you would like them to sync to individual companies within Xero.
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. Use the dropdown to select which Employee Roles you would like to have notified via email if a failure occurs.
10. Sync Balances for Pre-Invoiced Orders Statuses - Pre-Invoiced Order Statuses include Order, Pre-WIP, Built, Invoicing, and Production Deliverables.
11. Sync Balances for Component Consumption Costs - Component Consumption Cost is the cost of the individual parts used in creating a finished product.
12. Sync CoreBridge Locations to Xero Tracking Categories - Tracking Categories are a way to group your data in Xero for more detailed reporting. Checking this box will sync your CoreBridge Locations to your Xero Tracking Categories, 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.
To ensure the Location Mapping works properly, you will need to add a Tracking Category on the Xero website. To do this, you will need to visit the Xero website and navigate to the Settings menu. Click on Looking for advanced settings?. This will open up a new page with the option to select Tracking Categories. Click Add Tracking Category and enter in the name CB Location.
13. Edit Location Mapping - Location Mapping allows you to link your CoreBridge Locations to Xero Tracking Categories.
Note: If you do not have CB Locations created in Xero, you will see an error message. See example below.
14. Add as new on sync - Xero will add your Location after syncing.
15. Click Save & Sync Now.
Note: Syncing immediately will alert you to any mapping issues right away.
Example:
16. Edit Account Mapping - This allows you to select which of your Xero 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. Select the account category from the tabs.
18. Use the dropdown menu to select the Xero Account you would like to map to.
19. Click Save & Sync.
Note: Syncing immediately will alert you to any mapping issues right away.
Functionality
After creating your account and setting your syncing preferences, Xero Summary Sync integration is easy to use within your CoreBridge system.
Navigate to Accounting / Reconciliation & Sync.
To manually sync your Xero Summary Sync integration from this page:
Note: In order to manually sync, you must have that option set in the dropdown How to Integrate step 7 above.
1. Open the ellipsis at the end of the row.
2. Select Sync to Xero.
To manually sync your Xero Summary 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 Xero.
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 Xero Summary Sync, the Payment Information will display this way in the Reconciliation detail view heading:
Note: If there is an issue with the sync, the Payment Information will display this way in the Reconciliation detail view heading: