This article is for centers using Xero accounting software and using the Full Sync option.
Before syncing data to Xero, be sure to read this entire article to understand all of the details on how the sync works. There are certain transactions that will not sync to Xero and will require manual intervention so you will want to be familiar with those. If the required manual intervention is not performed in Xero your financial records will not be complete and will not match to CoreBridge.
When using the Full Sync option, your customer-related data will be re-created in Xero. Once you've gone through your 1st Sync, you should not edit/update/modify/delete any records that sync from CoreBridge to Xero. Xero effectively becomes "look but don't touch". If you change a record in Xero that is synced from CoreBridge, that may cause sync errors or cause your financial data in Xero to not match CoreBridge resulting in erroneous financials.
The Full Sync option is not available to all CoreBridge subscription packages. If you have any questions about availability and pricing, please reach out to email@example.com for more information.
Table of Contents
- Export Options and Requirements
- Records That Sync
- Records That Do Not Sync
- Multiple Locations/Centers
- Customers – Master Accounts
- Customers – Merging
- Invoices and Voiding
- Payments - best practices when using Bank Feeds
- Payments - applying a payment
- Refunds, Bad Debt, and NSF Payments
- Tax Groups and Tax Agencies
- Manual Entry Needed in Xero
- Sync Errors
- Sync Limits
Export Options and Requirements
Please refer to the Accounting Export Options article.
Records That Sync
This section contains the record types that sync from CoreBridge to Xero. No record of the types listed below should ever be changed in Xero if the record was synced with CoreBridge. Once a record has been synced, any changes must occur in CoreBridge. The changes will will update Xero on the following sync.
Customers sync only when in Client status. Lead and Prospect status customers will not sync. Part of the setup is going through your entire customer list in Xero to match the customer name to CoreBridge. If the name is off by even one character or space, the sync will create a second customer in Xero. You will then need to merge the duplicate customer manually in Xero.
If you are using Master Accounts in CoreBridge, the Xero sync will ignore those.
Only Completed orders sync. WIP and BUILT orders will not sync.
Part of the setup is determining whether or not the the same invoice prefix is being used in both CoreBridge and Xero. If an invoice from CoreBridge is using the same number as an invoice in Xero the sync will fail. There are settings in CoreBridge that can be adjusted to prevent numbering conflicts.
Payments will sync only after they are reconciled. Each individual payment is synced and posts to the selected bank account from the setup.
Synced payments are type: Overpayment
Tax Groups sync as Tax Rates
- When tax rates change in CoreBridge, the old rates are managed as archived rates. When you perform a sync after a rate change, the archived records will sync to Xero with names like "old_20_State Tax" and "old_15_County Tax". They need to exist in both CoreBridge and Xero in order to match old invoices with old rates. New records with the same naming convention will also be created and synced if you change the name of an agency or group. Just like any other record that syncs from CoreBridge, changing or deleting Tax Rates in Xero will cause sync errors. It can also cause invoices in Xero to have different rates than the matching invoice in CoreBridge.
Income accounts sync as Revenue Accounts.
Part of the setup involves matching accounts between CoreBridge and Xero. If the names don't match the sync will create a duplicate account in Xero.
Since Xero does not have child/sub accounts, any child/sub account relationship in CoreBridge will be ignored.
Records That Do Not Sync
- Payment Terms
- COGS accounts
- Purchase Orders
- Vendor Types
- Master Accounts
- Locations by Class
- Tax Agencies
If your CoreBridge system has more than one location or you have more than one CoreBridge system, the sync does not provide a way to distinguish each location in Xero.
Customers – Master Accounts
Master Accounts in CoreBridge will not sync. If you use Master Accounts in CoreBridge the hierarchy in Xero will not be the same.
Customers – Merging
If you merge a customer in CoreBridge, the sync cannot perform the merge. A customer merge must be handled manually in Xero.
- When a sync is performed, the sync window will display the number of customers that were merged in CoreBridge when it reaches the Merged Customer task.
- When you click the Failed Item link for the Merged Customers task, the item displayed will be the From customer.
- The To customer will be displayed as a Successful Item for the Customers task and will show that the record was updated.
- Once the customer is manually merged in Xero, the From customer will show as a Successful Item during a sync.
- If you need a list of Customer merges please open a support ticket.
- Line items on an invoice in Xero will contain the item or modifier description only. The actual part and modifier records from CoreBridge do not sync.
- In-Store Credit credit memos will display StoreCredit in the Reference field.
- If you need a support agent to trigger an invoice to sync again, all payments must be manually unapplied from the invoice in Xero first.
Invoices and Voiding
Invoices that sync to Xero should never be voided in Xero. When an invoice in voided in CoreBridge, the sync does not actually void the related invoice in Xero. The void is simply noted with a "-V" appended to the number.
- If a CoreBridge order has been voided, and a payment has already been applied, the CoreBridge payment that syncs to Xero will need to be moved from the voided transaction to the new transaction. If payment has already been applied in Xero, the sync will not be able to move the payment if the original transaction has been reconciled. That will result in a sync error. The payment will need to be removed from the voided transaction manually. If that cannot be done, or if the sync cannot move the payment around after it has been manually removed, that will result in a sync error. At that point, CoreBridge support will need to stop the related transactions from syncing and Xero will need to be updated manually to match CoreBridge.
- Invoices cannot be triggered to sync again if the invoice has been voided in Xero and the CoreBridge invoice number is retained on the voided invoice. In order for an invoice to be triggered to sync again, the reference number in Xero should be changed prior to voiding. When changing the reference number, the new reference number should not be in the same format as a CoreBridge invoice. If an invoice is voided with the existing CoreBridge number and needs to be created again in Xero, the invoice must be created manually and won't be able to have the same number as the CoreBridge invoice.
- Credit Memos can't be voided through the sync.
- Payments post directly to the Default Bank Account assigned in the CoreBridge accounting module.
- Payments will sync only after they have been reconciled in CoreBridge.
- Voided payments in CoreBridge will not sync and need to be voided manually in Xero.
- Payments sync as type: Overpayment
- Do not apply a Bank Feed payment to the CoreBridge invoice. If the bank feed payment is applied to the invoice, the sync will not be able to update the invoice which will cause a sync error. Bank Feed payments will then need to be manually removed from the invoice in Xero so that the sync can properly update the invoice with the CoreBridge payment.
- Payments that are considered order deposits will sync to Xero before the order does. When the related order has been Completed it will then sync. Since the deposit payment synced before the order did, the sync will not apply the payment. Those types of payments will need to be applied manually in Xero to the related CoreBridge invoice.
Payments - best practices when using Bank Feeds
- Do not apply the Bank Feed payment to the CoreBridge invoice.
- Perform a CoreBridge Reconciliation daily to capture payments.
- Sync daily after a Reconciliation has been completed in order to sync payments and invoices.
- Once the CoreBridge payment is applied to the CoreBridge invoice, you will need to reconcile the CoreBridge payment to the Bank Feed payment to avoid duplicates.
- When the CoreBridge payment syncs, the sync will apply the payment to the invoice as long the payment was not a deposit payment.
- Please remember that all accounting transactions must balance. If you are depositing a bank feed payment, that transaction will need an offsetting account in order to balance. If you balance against an income account, you will get duplicate income because the CoreBridge invoice that syncs will provide income.
- You can end up with duplicates because the same payment is syncing to Xero twice: once from CoreBridge and again from the bank feed. Reconciling them will ensure that the transaction doesn't get duplicated.
Payments - applying a payment
- When a deposit payment is entered in CoreBridge on a WIP or BUILT order, the payment will sync to Xero before the invoice once it has been reconciled in CoreBridge. When a payment syncs before the invoice syncs, the payment will not be applied automatically to the invoice in Xero when the invoice finally syncs. The payment will need to be applied manually.
- To apply a payment manually, use one of these methods.
- Open the payment then use Allocate Credit.
- Open the invoice then use Credit this invoice.
Refunds, Bad Debt, and NSF payments will not sync and will need to be manually created in Xero.
- When a sync is performed, these payment types will display as Successful Items for the Payments task. However, they will not sync to Xero. They are displayed for your reference as a reminder to process the transaction manually in Xero.
- When the Successful Item link is clicked, the message will display the payment number along with a reminder. This message is only displayed once. To find the transactions later you will need to run a Payments Report so that you can manually update Xero.
Tax Groups and Tax Agencies
Tax Groups will sync only one time and Tax Agencies do not sync.
- If Tax Groups are archived or deleted in Xero, they cannot be synced again. They will need to be created manually in Xero.
- To create a tax group manually, the Tax Group name in CoreBridge will need to be entered as both the Display Name and Tax Component name in Xero.
- When tax amounts are calculated differently between CoreBridge and Xero, the sync will add the difference as an invoice line item. The adjustment is usually 1 cent.
- When you change the name or the rate in Corebridge of a Tax Group, CoreBridge creates a new record that will sync. The new record will contain the name of the group that was changed and the name of the new record will start with "old_". Although the name may be unfamiliar, do not change the name or delete the record in Xero.
Manual Entry Needed in Xero
Refer to this support article for a summary of manual entries that may need to happen in Xero.
If you get a sync error, all of you financial data from CoreBridge will not sync to Xero. To ensure that all data has synced, the sync must complete successfully with no Failed Items. If you have failed items, click the Failed Item link to view the error.
- If you are able to fix the error, run a sync again to complete the sync.
- If you are not able to fix the error, the error will need to be reported to CoreBridge support for assistance. There are two methods to report errors.
- Take a screenshot of any errors, open a new ticket, then attach the screenshot to the ticket and submit it.
- Click the Troubleshoot Problems button that appears once the sync finishes. Enter your email and click Submit on the window that appears.
- For a list of common errors and possible fixes, please refer to this article: Xero Full Sync - Sync Errors
Xero imposes 3 limits on the API that CoreBridge uses to sync data. If an error message appears during syncing that contains the text "oauth", one of the limits was reached.
- 60 calls in a rolling 60-second window – you should not reach this limit because we set your system to sync at a set rate
- 5000 calls in a rolling 24-hour window – unless you have an extraordinary amount of transactions to sync, you should not reach this limit. The only times that it would be possible to hit this limit is during a 1st sync when your customers, invoices and payments sync for the first time or if you have many transactions and sync once a month. If you reach this limit you will need to wait for 24 hours to sync again. We recommend syncing daily to prevent hitting this limit.
- 30-minute window – if this limit is triggered, just Authorize CoreBridge again using the Connect to Xero button.
Since the Full Sync re-creates transactions in Xero, you can run financial reports as well as other customer-related reports. However, because the data in Xero isn't live, you should always use CoreBridge reports to manage your customers and A/R. You should always use the CoreBridge sales tax reports when remitting sales tax.