Skip to main content

QBO Integration Guide - CAD

  • Updated

You can connect Float to QuickBooks Online (QBO) to sync your chart of accounts, vendors, tax codes, classes, and other accounting data. This guide walks you through setting up the integration, configuring your clearing account, and preparing transactions for export. Float only supports QuickBooks Online, not QuickBooks Desktop.


To set up USD transactions to QBO, see: QBO Integration Guide - USD.

 

Guide Overview

What you need before connecting QBO to Float

How to create a Float Clearing account in QBO

How to connect QBO to Float

How to set your Clearing account in Float

What data syncs between Float and QBO?

How to categorize transactions in Float

How to export transactions to QBO

 

What you need before connecting QBO to Float

Before connecting QBO to Float, make sure you have:

  • Admin access in QBO

  • Either an Administrator or Bookkeeper user role in Float

    • This is required to be able to connect QBO to Float and manage the Clearing Account set up

    • For more details on user roles and their permissions, see: User Roles

  • A Float Clearing Account created in QBO (instructions below)

 

How to create a Float Clearing account in QBO

Float uses a Clearing account in QBO to record the two entries created for every exported transaction.

How to create a Clearing account in QBO:

  1. Head into Transaction > Chart of Accounts
  2. Press "New" to create a new bank account in your chart of accounts
  3. Here is how you can configure the account:
    • Account Type: Bank
    • Detail Type: Chequing
    • Name: Float Clearing Account (Can be anything that you prefer)
  4. Hit "Save and Close" to save


 

How to Connect QBO to Float

  1. In Float, go to Settings > Accounting Sync

  2. Select QuickBooks Online (QBO)

  3. Sign in using your QBO credentials

  4. Select the QBO company you want to connect

  5. Wait up to 30 seconds for the connection to complete and for Float to import your accounting data
     

How to set your Clearing account in Float

After connecting QBO to your Float account, you can set the Clearing account you created in QBO in your Float settings. To do so:

  1. Go to Settings > Accounting Sync

  2. In the CAD Clearing Account section, select the Float Clearing Account you created from the dropdown list

For details on how exports work, see: How do QBO Exports Work?

 

What data is synced between Float and QBO?

Float imports accounting data from QBO so you can categorize and export your transactions accurately. See what's imported and how it's categorized in Float:

Screenshot 2024-12-19 at 6.45.42 PM.png

Important Consideration:

  • QBO Tags are not supported in Float and will not import
  • Customers & Projects are available in Float only on the Professional subscription plan

How to categorize transactions in Float

Once your QBO data is synced into Float, you can begin categorizing transactions.

Required fields to export transactions to QBO:

  • GL Code:
    • Imported from QBO
    • This is a required field to export your card transactions to QBO

Optional fields (not required) to export transactions to QBO:

  • Receipts:
    • Exported as native attachments in QBO
    • Note that "Additional Attachments" are not exported to QBO 
  • Description:
    • Add a description to describe the transaction
  • Tax Code:
    • Imported from QBO
  • Tax Amount:
    • If a Tax Code is added to a transaction, the Tax Amount will update based on the Tax Code
    • A custom Tax Amount can be added
    • If a receipt is added, you can select the Tax Amount from the receipt
  • Tax-Exempt Amount:
    • Can be used to identify a non-taxable part of the expense
    • Ex: A tip from a transaction from a restaurant 
  • Vendor:
    • Imported from QBO
  • QBO Classes:
    • Imported from QBO
  • QBO Customers & Projects:
    • Imported from QBO

Note, you can update which field Spenders are required to categorize on their transactions through Card Submission Policies.

 

How to export transactions to QBO

Once transactions have been categorized with the required and optional fields, you can export them into QBO from the Transaction Exports page. For details, see: Transaction Export Overview.

 

For additional support with the integration between QBO and Float, see: QuickBooks Online Integration - FAQ.

Related articles