Skip to main content
All CollectionsAdminsIntegrations & Add-ons
BoldTrail BackOffice & QuickBooks Integration: General Ledger (V2)
BoldTrail BackOffice & QuickBooks Integration: General Ledger (V2)

Learn how to configure your BoldTrail BackOffice and Quickbooks integration.

Updated this week

Overview

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.

What you need to know before the integration setup

  1. Ensure all charts of accounts in BoldTrail BackOffice match those in QuickBooks.

  2. Make sure you’ve connected your bank accounts in QuickBooks.

  3. This integration requires an Enterprise plan for your BoldTrail BackOffice account.

How the integration works

  • Transactions posted to the BoldTrail BackOffice General Ledger automatically sync to QuickBooks. It's a 1:1 sync.

  • For real estate transactions, separate entries are created in QuickBooks for each side of the transaction (buyer/seller) you are representing. Both income (brokerage gross) and expenses (agent commission and post-split fees/deductions) are synced.

  • For agent billing, both invoices and payments are synced.

Getting started

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.

Customizing Your Integration Workflow

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

  1. Error Handling: Define the protocol for pushing transactions to QuickBooks when no corresponding match is found for GL accounts, services, customers, or vendors.

  2. Transaction Type Selection: Choose which types of transactions you wish to synchronize with QuickBooks.

Recommended Configuration

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:

  • Customer: "Error Customer -C". Create a new customer with name "Error Customer". Click here to learn how to create a customer in QuickBooks.

  • Vendor: "Error Vendor -V". Create a new vendor with name "Error Vendor". Click here to learn how to create a vendor in QuickBooks.

  • GL Account: "Error GL Account". Create a new GL account with name "Error GL Account". Click here to learn how to create a GL account in QuickBooks. We recommend Account Type = Income and Detail Type = Service/Fee Income.

  • Service: "Error Service". Create a new service with name "Error Service". Click here to learn how to create a new service in QuickBooks. We recommend Item Type = Service and Income Account = Error GL Account (which you just created).

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.

Settings Customization

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:

Customer & Vendor Matching

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

Classes and Locations - Office/Location Reporting

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.

Bills - for Expenses

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.

Received Payments

Decide whether you want to sync received payments to QuickBooks.

Made Payments

Decide whether you want to sync made payments to QuickBooks.

Journal Entries

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.

Transfers

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).

Bank Account Mapping

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

Getting Help

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

Did this answer your question?