Overview
As of July 17th 2024, we have released a new QuickBooks Online integration version (2.1). In this article, we'll take a closer look at how to get the most out of this integration.
Note: this integration is available for customers on the Professional and Business plans.
In a few simple steps, you will be able to sync your invoices between Bonsai and QuickBooks Online. This means you won't need to manually upload invoices and your information will always be in sync between your two accounts.
What information is synced between Bonsai and QuickBooks Online?
When you sync an invoice from Bonsai to QuickBooks Online, the following invoice data will be pushed:
Client / Company name
Client / Company address
Invoice number
Invoice / Issued date
Invoice / Due date
Invoice / Item name
Invoice / Discount (if applicable)
Invoice / Tax amount (if applicable)
Invoice / Expenses (will be pushed as line items)
Payment date and amount (when invoice is paid)
Note: at this time, the QuickBooks Online integration only syncs invoice amounts without online payment fees.
Sync Settings
Manual Syncing
You have the ability to manually sync 'drafted' invoices or invoices that you created prior to connecting to the integration. To manually sync an invoice, simply navigate to Financial Management > Invoices.
Here you can manually select the syncing icon on the righthand side of your invoice:
Once you've selected this, this will push your invoice into QuickBooks Online:
This way, you can stay up-to-date with any invoice or invoice drafts you have across Bonsai and QuickBooks Online.
Automatic Syncing of Paid Invoices
You have the ability to automatically sync invoices that have been paid from Bonsai to QuickBooks Online.
To set your preferences to allow this:
Navigate to the profile icon in the bottom lefthand corner of your account
Select 'Settings'
Navigate to 'Integrations & Data'
Select 'QuickBooks Online'
Here, select 'Automatically push Paid invoices from Bonsai to QuickBooks':
Next, select 'Connect to QuickBooks'.
This will ensure that all paid invoices moving forward will sync to QuickBooks Online.
Automatic Syncing of Sent Invoices
You have the ability to automatically sync invoices that have been 'sent' to your clients, but have not yet been paid.
When you are connecting to the QuickBooks Online integration, select 'Automatically push Sent invoices from Bonsai to QuickBooks':
When you're ready, select 'Connect to QuickBooks'.
This ensures that any invoice that you've 'sent' to a client in Bonsai, is automatically synced within QuickBooks Online. This allows you to track the progress of your invoices every step of the way.
Syncing data from QuickBooks Online to Bonsai
Our QuickBooks Online integration can retrieve data from QuickBooks and sync it to your Bonsai account. This means that when you receive an online payment or record a payment on an invoice in QuickBooks, you can sync that paid status within Bonsai.
When you are connecting to the QuickBooks Online integration, you'll want to select 'Automatically sync Paid invoices from QuickBooks to Bonsai':
Once completed, you'll have the ability to sync a paid invoice status from QuickBooks Online into Bonsai.
To action syncing a paid invoice from QuickBooks Online to Bonsai, you must receive an online payment in QuickBooks or manually record a payment in QuickBooks.
To manually record a payment in QuickBooks Online:
Sync your 'drafted' or 'sent' invoice from Bonsai to QuickBooks Online:
From here, in QuickBooks Online, select 'receive payment' to record the payment:
Once you've recorded payment in QuickBooks Online, it will update the synced invoice status in Bonsai from ‘drafted’, ‘outstanding’, ‘overdue’ to ‘Paid’:
Detailed Data Syncing Rules
1. Client Information
If the client does not have a Bonsai account, the company name or default contact name is sent.
If the client has a Bonsai account, the company name is sent.
2. Address and Email
The client’s profile address and email are sent if they have a Bonsai account. This data is only passed to QuickBooks Online when the client is created.
3. Invoice Line Items
Line items with descriptions are sent as “Name - Description.” If no description is available, only “Name” is sent.
New services or item codes are not created in QuickBooks Online.
4. Invoice Amount with Online Payment Fees
The original invoice amount is sent, excluding payment fees.
Example: For a $100 invoice with $3 in fees, $100 is sent.
5. Expenses
Currently, expenses are sent as invoice line items with the format: "Expense — Name of the expense."
6. Tax
0% Tax Rate: Works without additional setup for US users.
Non-0% Tax Rate: You must ensure the corresponding custom sales tax rate is created in QuickBooks Online. Helpful article: Custom Rates in QuickBooks Online
7. Discounts
Discount amount is pushed to QuickBooks Online
Note: Discrepancies may occur in invoices with discounts, tax > 0%, and expenses due to different discount application methods between Bonsai and QuickBooks.
- In Bonsai the full discount amount is applied to the subtotal excluding expenses.
- In QuickBooks the discount is pro-rated within line items from both the taxable subtotal and the non-taxable subtotal. As Expenses are passed as non-taxable line items, QuickBooks is prorating part of the discount to those expenses, which creates a difference between the taxable subtotal in Bonsai and QuickBooks.
8. Tips
Tips are not supported by the integration.
Integration Limitations
Partially paid invoices are not synced.
Online payment fees and refunds are not sent to QuickBooks Online.
Invoices that have been synced to QuickBooks Online and later deleted cannot be re-synced.
Non-invoice income is not sent to QuickBooks Online.