Overview

This article details the accounting export options available with CoreBridge. 


Please note:

  • Your CoreBridge subscription determines which export options are available. Full Sync is not available with every subscription. If you need help determining which export options are available for your subscription please open a support ticket and a support agent will provide that information.

  • Regardless of the export option used, Accounts Receivable should always managed in CoreBridge because it is Live. The sync is one-direction only, from CoreBridge to your accounting application. Transactions in your accounting application do not sync to CoreBridge.

Export Options

There are two export options:


Lump Sync

  • This method provides your CoreBridge financial data in journal entry format. The end result is approximately 20-25 journal entries per month. This is the recommended and most commonly used option and is the easiest to set up and maintain.

  • The only records that needs to be maintained are the G/L accounts.

Full Sync

  • This method provides your CoreBridge financial data in transaction format. Individual transactions such as invoices and payments sync to your accounting application. The end result is 100's or maybe 1000's of transactions per month. This is a significantly more complex option and is only available on some subscriptions. It is more difficult to set up and maintain than the Lump Sync option.

  • Once a transaction syncs to your accounting application it should never be edited or deleted. Changes and deletions to transactions that have synced can cause sync errors and can cause your financials to be different between CoreBridge and your accounting application.

  • In addition to maintaining accounts, all other record types that sync must be maintained such as Customers, Orders, and Payments. You may end up with hundreds of customers and thousands of transactions in your accounting application


Export Methods

There are three export methods:

Desktop Sync Tool

  • This is our in-house software used to export data to supported QuickBooks desktop versions. It can only be installed on Windows. It should not be installed on a hosted server.

Online Sync

  • No additional software required. CoreBridge communicates directly with QuickBooks Online and Xero through the API interface.

Manual File Export

  • Used for accounting applications that aren't supported by either the desktop or online export methods. This method is only used with the Lump Sync export option to provide journal entries. On each Reconciliation there is a button that will create the file needed for import based on the accounting application selected during setup. The file will be used to manually import data from the Reconciliation to the selected accounting application in one of these formats:
    • QuickBooks IIF Format
    • Sage Spreadsheet Format


Lump Sync

Lump sum amounts are exported to your accounting application as a Journal Entry. The amounts that are posted to each Journal Entry come from the values in each CoreBridge Reconciliation.


Accounting Software Supported for Lump Sync

SOFTWARE
TYPE
VERSION / YEAR
EXPORT METHOD
QuickBooks
Desktop for Windows on a local computer
any / 2014 & newer
Desktop Sync Tool
QuickBooks
Desktop for Windows on a local computer
any / 2013 & older
Manual File Export – QuickBooks IIF format
QuickBooks
Desktop on a hosted server
any
Manual File Export – QuickBooks IIF format
QuickBooks
Desktop for MAC
any
Manual File Export – QuickBooks IIF format
QuickBooks
Online
any
Online Sync
Xero
Online
any
Online Sync
SAGE
Desktop/online
Known to work with Business Works 2015
Manual File Export – SAGE Spreadsheet Format


If your accounting application isn't on the supported list please reach out to CoreBridge support for assistance with a possible solution.


Data exported with Lump Sync export includes:

  • Transactions by Class (if supported by your accounting software)
  • Sales by Income Account
  • Bad Debt Expense
  • In-Store Credit Expense
  • Payments by Type
  • Asset Accounts
  • Accounts Receivable
  • Deposit & Credit Liabilities
  • Sales Tax Liability
  • Purchase Orders (only with the Desktop Sync Tool and the Purchasing Module)


Related Articles:


Full Sync

  • Full Sync posts individual transactions to your accounting application. Instead of lump sum amounts, individual records such as customers, invoices and payments will be synced.
  • Full Sync is not available with every subscription.
  • Over time, thousands of records will sync. Keep this in mind if your accounting application has limits to the number of records it can store before it stops allowing further records to be recorded.
  • The records that sync should not be modified or deleted in your accounting software once they sync. The changes do not sync back to CoreBridge. Changes will create sync failures and will cause your financial data in CoreBridge to not match the financial data in your accounting application.


Accounting Software Supported for Full Sync

SOFTWARE
TYPE
VERSION / YEAR
EXPORT METHOD
ADDITIONAL REQUIREMENTS
QuickBooks
Desktop for Windows on a local computer
any / 2014 & newer
Desktop Sync Tool
N/A
QuickBooks
Online
any
Online Sync
(1) Tax must be assigned at the Order level. If your version of QuickBooks assigns tax at the Line Item level you must use Lump Sync. This is usually the case with UK VAT and Australia GST.

(2) If the Automated Sales Tax feature is enabled you must use Lump Sync. This is usually the case with a U.S. version of QuickBooks. If you can get QuickBooks support to switch your company to the Manual Sales Tax Center you can use Full Sync.
Xero
Online
any
Online Sync
N/A


Data exported with Full Sync export includes:

  • Customers
  • Invoices
  • Payments
  • Tax Groups (not synced to QuickBooks Online)
  • Tax Agencies (not synced to QuickBooks Online)
  • Accounts – Income, COGS, and Reconciliation Accounts (COGS not synced to Xero)
  • Billing Items – Parts, Modifiers, Setup Fees (not synced to Xero)
  • Payment Terms (not synced with Xero)
  • Locations/Transactions by Class (If supported by your accounting application. Not synced to Xero)
  • Vendors (not synced to Xero)
  • Vendor Types (not synced to Xero)
  • Purchase Orders (not synced to Xero)


Related Article(s):