Skip to main content
All CollectionsAdminsIntegrations & Add-ons
BoldTrail BackOffice & QBO Integration: General Ledger & Commissions
BoldTrail BackOffice & QBO Integration: General Ledger & Commissions

Learn how to configure your BoldTrail BackOffice and Quickbooks integration.

Updated over 5 months ago

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 general ledger in BoldTrail BackOffice will automatically sync to QuickBooks.

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

Getting started

  1. Go to the User > Add-ons section in BoldTrail BackOffice.

  2. Select Quickbooks Online, then click on Configuration or Get Started

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

  4. Click the Setup Wizard > Activate button

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

  6. The next step is configuring your integration

Customizing Your Integration Workflow

On the configuration page, you can adjust various to settings to customize how your data flows to Quickbooks.

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.

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.

Bank Account Mapping

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

Finishing Up

When everything is set, click Save and continue.

After setting up the workflow, activate the sync to transfer data between BoldTrail BackOffice and QuickBooks.

Did this answer your question?