Integrating BoldTrail BackOffice with QuickBooks Online (QBO) simplifies financial management by syncing income and expense items directly from the BoldTrail BackOffice to Quickbooks Online (QBO). This integration helps eliminate manual data entry and ensures your financial records are always up to date.

Go to the User > Add-ons section in BoldTrail BackOffice. Select QuickBooks Online.

Select Quickbooks Online, then click on Configuration or Get Started

You’ll be redirected to the APINation integration setup page. Log in or sign up if needed.

Click the Setup Wizard > Activate button.

Select the related BoldTrail BackOffice (formerly Brokermint) and QBO accounts, then click Enable Connection.

The configuration page allows you to tailor two primary categories for data flow to QuickBooks:

This section provides the recommended settings, enabling most users to get started quickly. For more detailed information on each setting and customization options, refer to the "Configuration Details" section below.

First, we recommend creating the following "Error Handling" items in your QuickBooks:

Second, we recommend configuring the integration with the following settings to get started:

At a minimum, match the "Bank passthrough" account to at least one QuickBooks bank account. We recommend creating a new GL account (Name = Bank - Clearing Account, Account Type = Bank, Subtype = Cash On Hand). This GL account is used for accounting-only operations that never touch your actual bank account.

Then click Save and Continue, and setup is complete.

In this section, learn how to customize each section of the configuration.

BoldTrail Back Office Subaccount

Select which BoldTrail Back Office subaccount you wish to connect:

QuickBooks Account

Select with QuickBooks account you wish to connect:

Here, you'll decide whether the workflow should update Customers/Vendors with information from BoldTrail BackOffice when there is a mismatch between the applications.

You can sync the office, location, or account name to QuickBooks. First, ensure the Class or Location is created in QuickBooks. Then, you will see a list of all Class or Location values from QuickBooks on the configuration page. Simply select the value you wish to match from the list.

Invoices - for Income

Decide if you want to sync invoices (for income items) to QuickBooks. The integration maps the BoldTrail BackOffice item name to the QuickBooks product/service name. If no exact name match is found, choose the QuickBooks Product/Service you want to map to.

Decide if you want to sync bills (for expense items) to QuickBooks, and whether they should map to a category or product/service. The integration matches the BoldTrail BackOffice item name to the QuickBooks category or product/service name. If no exact name match is found, select the QuickBooks category or product/service name you want to use.

Credit Memos

Decide whether you want to sync credit memos and which GL account it should map to if no matching GL account is found.

Deposits

Decide whether you want to sync deposits and which GL account it should map to if no matching GL account is found.

Decide whether you want to sync received payments to QuickBooks.

Decide whether you want to sync made payments to QuickBooks.

Choose whether to sync manual journal entries created in BoldTrail BackOffice to QuickBooks.

Mapping GL Accounts: By default, BoldTrail BackOffice GL accounts will map to QuickBooks GL accounts with the same name. If no matching name is found, select the QuickBooks GL account you wish to map to.

Mapping Customer for Income, Asset, and Equity Accounts: By default, for income, asset, and equity accounts, the BoldTrail BackOffice account name will map to the QuickBooks customer with the same name. If no exact match is found, a new customer will be created. Select the customer you want to map to if a new customer account cannot be created.

Mapping Vendor for Expense and Liability Accounts: By default, for expense and liability accounts, the BoldTrail BackOffice account name will map to the QuickBooks vendor with the same name. If no exact match is found, a new vendor will be created. Select the vendor you want to map to if a new vendor account cannot be created.

Decide whether you want to sync transfers to QuickBooks.

Refunds

Decide whether you want to sync refunds and which product/service it should map to if no matching product/service is found.

Balance Netting

Decide whether you want to sync balance netting transactions. Balance netting transactions in BoldTrail Back Office are used to net agent payables and receivables. These transactions sync to QuickBooks as two transactions: received payment (Dr. Bank passthrough / Cr. Accounts Receivable) and made payment (Dr. Accounts Payable / Cr. Bank passthrough).

Here, you can drag and drop BoldTrail BackOffice's operating, clearing, and escrow accounts to the corresponding QuickBooks bank accounts.

Reach out to the BoldTrail Back Office support team if you have questions or need assistance.