- In CoreBridge, navigate to Accounting Module > Accounting Export > Account Setup tab.
- The collection of accounts displayed here are referred to as Reconciliation Accounts. These accounts need to be matched to QuickBooks just like Income accounts.
- My CoreBridge Accounts
The section titled "My CoreBridge Accounts" contains the internal names for the accounts along with the account type. The account type noted needs to match the account type in QuickBooks. This section is for reference only to show what Account Type to use when matching accounts to QuickBooks.
Don't use this section to match accounts to QuickBooks. The section to match to QuickBooks is named My Accounting Software Accounts.
Since CoreBridge exports to various accounting applications, the Account Type name is used generically. Please refer to the Cross-Reference table which shows the actual name of the Account Type in QuickBooks.
- Cross-Reference TableACCOUNT TYPE CROSS-REFERENCEIN COREBRIDGEIN QUICKBOOKSExpenseExpenses (not Other Expense)Accounts ReceivableAccounts Receivable (A/R)LiabilityOther Current LiabilitiesTaxOther Current Liabilities
- My Accounting Software Accounts
This is the section of the page where you will match CoreBridge to QuickBooks.
The account numbers shown in the screenshot are completely random. Use of the numbers shown is not required. - Reconciliation Account matching
Accounts need to match between CoreBridge and QuickBooks for the sync to be successful. Account number, account name, account type, and account hierarchy have to match exactly.
If there is an account in CoreBridge that does not exist in QuickBooks, it will be created automatically in QuickBooks during your 1st sync so there is no need to add it manually. The new account in QuickBooks will be created exactly as displayed in CoreBridge (account number, account name, account type, hierarchy). If you want to have an account created automatically, any parent account noted in CoreBridge with a colon will need to exist in QuickBooks. if you prefer to add an account manually to QuickBooks, be sure it matches exactly to CoreBridge.
- Account Naming and Structure
Special characters may cause sync errors. Some examples are $, &, and quote symbols. Please use only letters and numbers for account names. If a special character causes a sync error, the account name will need to be changed in both CoreBridge and QuickBooks for the sync to be successful.
Accounts can have 3 levels.
Parent:Child:Child
If your existing accounts that will be used in CoreBridge have more than 3 levels please adjust them accordingly in QuickBooks before matching them to CoreBridge.
Each account must have a unique account number and a unique name. Numbers and names cannot be the same between Income accounts and Reconciliation accounts.
2. Match each account in CoreBridge to an account in QuickBooks.
- The accounts listed under "My Accounting Software Accounts" must be matched to QuickBooks.
- Account number, account name, account type, and hierarchy must match.
- If the CoreBridge account represents an account in QuickBooks but it doesn't match exactly, change the account in either QuickBooks or CoreBridge to get them to match.
- If a CoreBridge account needs to be changed, click edit, make any needed changes, then click save.
- If the account being matched is a child account be sure to follow the directions on the page to properly match the account hierarchy. The parent/child hierarchy for Reconciliation accounts follow the QuickBooks method of using a colon to delineate parent and child accounts. For example, Bad Debts as a child of Expenses.
- Expenses:Bad Debts
3. Undeposited Funds account
- When matching the Undeposited Funds account between CoreBridge and QuickBooks, the account in QuickBooks must be the built-in system account designated by QuickBooks.
- If the account is not the system account, you will not be able to record deposits in QuickBooks.
- How to tell if it's the system account when in QuickBooks:
- DETAIL TYPE is "Undeposited Funds"
- NAME is "Undeposited Funds" or "Payments to Deposit"
- How to tell if it's the system account when exporting the COA to Excel:
- DETAIL TYPE is Undeposited Funds
4. OPTIONAL – If you want to keep your CoreBridge accounts separate from existing accounts you can create new accounts. This can be helpful if you are in the process of closing out a previous POS system and don't want to commingle numbers in a single account.
Examples:
- CB A/R (instead of Accounts Receivable)
- CB Deposits (instead of Deposits)
- CB Bad Debt
- CB Sales Tax Payable
Next Steps:
Connecting to QuickBooks and Performing Your First Sync