Skip to main content

QBO Integration Guide - CAD

  • Updated

Everything you need to know about connecting Float to accounting software QuickBooks Online (QBO), categorizing, and exporting transactions.
Note: we currently only allow integrations with QuickBooks Online, and cannot support QuickBooks Desktop. 

- For instructions on how to connect your USD Transactions to QBO, see this guide.
- For instructions on how to connect your Charge Card to QBO, see this guide.

 

How to create a Float Clearing account in QBO

Float needs a clearing account in your Accounting Software to record the two entries for every transaction that gets exported from Float to QBO

To create a clearing account:

  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:
  4. Account Type: Bank
  5. Detail Type: Chequing
  6. Name: Float Clearing Account (Can be anything that you prefer)
  7. Hit "Save and Close" to save


Sync Float with QBO

  1. Navigate to Settings > Manage Accounting Integration > Select QBO
    Enter your QBO credentials and select the account you would like to Sync. Wait up to 30 seconds for the accounting data to be imported into Float

  2. Set your clearing account in Float Settings
    Under Settings > Accounting sync, set the clearing account that you created in QBO earlierear for Float.
    If you want to re-import your accounts, hit the "Sync" button.

 

 

What data is synced between Float and QBO?

Float syncs your accounting data from QBO in order to make it easier for you to categorize expenses.

Screenshot 2024-12-19 at 6.45.42 PM.png

 

Note: Tags in QBO are not imported into Float. QBO Classes are imported from QBO to Float as Custom Fields. Customers and projects are available only on the professional plan.  Please reach out to support@floatcard.com to upgrade!

Categorizing transactions in Float

Now that Float and QBO are synced you can start categorizing your transactions and exporting them into QBO.

For every transaction, there are a few required fields:

  • GL code - imported from QBO and attached by admins

And a couple of optional fields:

  • Receipt - attached to transactions by spenders or admins (exported as native attachments in QBO)
  • Description - attached by spenders or admins
  • Tax code - imported from QBO and attached to transactions by admins or spenders
  • Custom tax amount - attached by admins
  • Non-taxable amount - attached by admins
  • Accounting vendor - imported from QBO and attached by admins or spenders
    Related: How To Create New Vendors
  • Classes - imported from QBO, attached by admins or spenders
  • Customers & Projects to Custom Fields - imported from QBO, attached by admins or spenders
    Related: Custom Fields in Float 🏷️

Exporting transactions to QBO
Once transactions have been categorized with the required and optional fields, you can export them into QBO!

Here's more on Accounting with Float: Transaction Export!

 

Related articles