The Xero Detail Sync integration allows users to seamlessly sync detailed financial data, including individual transactions and customer records, directly with Xero. This integration is perfect for those who require comprehensive tracking of financial activities within their accounting software. Unlike summary syncs, Xero Detail Sync ensures that every transaction and customer entry is accurately reflected in Xero, providing full visibility and control over your financial data.
TABLE OF CONTENTS
- Benefits of Integrating with Xero Detail Sync
- What is the difference between the Summary Sync and the Detail Sync integrations?
- How to Integrate With Xero Detail Sync
- Functionality
Benefits of Integrating with Xero Detail Sync
- Comprehensive Tracking: Syncs detailed financial data, including each transaction and customer record, for a complete view of financial activities.
- Detailed Reporting: Provides full visibility into financial transactions, supporting detailed reporting and auditing need
- Sync Flexibility: Options to choose between manual or automatic reconciliation sync, accommodating various workflow preferences.
- Customizable Sync Options: Includes settings for syncing all customers or syncing only as necessary, and options to sync purchase orders.
- Automated Notifications: Configure roles 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 Xero 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 Xero integration you choose will meet your financial tracking and reporting requirements.
How to Integrate With Xero Detail Sync
To integrate Xero Detail Sync with your CoreBridge system, navigate to Settings / Integrations / Marketplace.
1. Once you have navigated to the Integration Marketplace, select Finance.
Note: Xero Detail Sync can also be found within the All folder, or by using the search filter.
2. Select Xero Detail Sync.
3. Select Install.
4. Once installed, select View/Edit Settings to connect your Xero 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 Xero Detail Sync automatically being selected.
5. Select Connect to Xero.
Note: This will open a modal that will prompt you to sign into your account. There is also an option to Create an Account.
Once connected, you can set up your Xero Detail Sync options. These can be managed at any time in Settings / Integrations / Installed Integrations and selecting Xero Detail 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. Reconciliation Sync - You can chose to do this manually or have it run automatically.
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 with Reconciliation.
8. Sync Start Date - Select the date to begin your Automatic Syncing.
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. Select Roles - Use the dropdown to select which employee role 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 your Purchase Orders.
12. Sync CoreBridge Locations to Xero Tracking Categories - Tracking Categories in Xero function as filters for your accounting information. When this box is selected, your CoreBridge Locations are turned into Tracking Categories, allowing you to view and search for information by Location.
Note: This box is automatically selected for those systems with multiple locations.
13. Default Bank Account - Select an account to use as a default.
Note: You must have a Default Bank Account selected in order for Xero to function properly. You can add bank account information on the Xero website under the Accounting tab.
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 Accounting / Advanced section. Select the Tracking Categories option and click Add Tracking Category. Use "CB Location" as the Tracking Category name and then select Save.
14. Select Edit Location Mapping.
15. Select either Save or Save& Sync Now.
Note: On sync CoreBridge will add a new Tracking Category Option to your accounting software.
16. Select Edit Account Mapping. This will bring up a modal that will allow you to make individual selections.
17. 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.
18. Select Save or Save & Sync Now.
Note: Once everything is set, you can perform a reconciliation in CoreBridge and it will sync up with Xero automatically if you have that option chosen in the configuration screen.
Functionality
After creating your account and setting your preferences, Xero Detail Sync 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 Xero Detail Sync 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 Xero, 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:
