Odoo QuickBooks Online Connector: Explanation of Settings

This guide explains every setting of the QuickBooks Online connector. Understanding them helps you set up synchronization between Odoo and QuickBooks Online correctly and avoid common issues.

All settings are per connection: open QuickBooks Online → Connections and open your connection.

Connection

1_connection_initial_import.png

  • Initial Import – imports accounts, departments, partners, payment methods, payment terms, products and taxes from QuickBooks Online and creates the mappings.

  • Test Connection – checks that Odoo can reach your QuickBooks Online company.

  • Re-authenticate Connection – authorizes the connection again, for example after access was revoked.

  • Deactivate – stops all automatic synchronization for this connection.


Invoices & Bills Tab

This is where you enable invoice export, the main feature of the connector.

3a_tab_invoices_bills.png

Auto-export Invoices to QuickBooks

inv_automation.png

Enables automatic export of invoices from Odoo to QuickBooks Online.

  • Enabled → invoices are exported by a scheduled action

  • Disabled → invoices are exported manually with Actions → Export to QuickBooks

Enabling automatic export alone doesn’t export anything until you choose the document types under Invoice Types.

Invoice Types

inv_types.png

Defines which documents are exported.


Product Settings

Products are exported to and imported from QuickBooks Online. These options control how they appear on exported invoices.

inv_product_settings.png

Include Products in Invoices

  • Enabled → invoice lines are exported with their products

  • Disabled → invoice lines are sent with the product description only

Sync Products as Categories

  • Enabled → the product category is sent instead of the product itself (all invoice types)

Export Storable Products as Consumables

Useful if you have storable products in Odoo but don’t want to track inventory in QuickBooks Online.

  • Enabled → storable products are created in QuickBooks Online as non-inventory items


Invoices Import

inv_import.png

  • Shipping Product – the Odoo product used for shipping lines of invoices imported from QuickBooks Online.

  • Discount Product – the Odoo product used for discount lines of imported invoices.

  • Import Invoices Manually – opens wizzard to fetch customer invoices from QuickBooks Online by date range or by QuickBooks IDs and creates them in Odoo.


Custom Fields

3b_custom_fields.png

Maps QuickBooks custom fields to Odoo fields. Click Import Custom Fields Definitions to load the QuickBooks custom fields, then add one mapping line per transaction type and choose Apply on Import and/or Apply on Export.

  • Custom fields are exported for all invoice types, but imported only for Customer Invoices and Customer Credit Notes.

  • Only plain-text Odoo fields can be mapped.

  • Check in QuickBooks Online which document types each custom field is enabled for: QuickBooks ignores or rejects a value sent to any other type.


Payments Tab

Payment synchronization is another main feature of the connector. Import and export each run as a scheduled action. Payments are synced only for invoices and bills that are already synchronized with QuickBooks Online, so turn on Auto-export Invoices to QuickBooks first.

4_tab_payments.png

Auto-import Payments from QuickBooks

Imports payments recorded in QuickBooks Online into Odoo and reconciles them with the invoices. The Odoo invoice becomes In Payment, then Paid.

Auto-export Payments to QuickBooks

Exports payments registered in Odoo to QuickBooks Online.

Set Default Payment Journal and Default Write-off Account on the Defaults tab before importing payments.


Misc Tab

Sends changes of records that are already in QuickBooks Online, for example a new product price or a partner’s new email. One scheduled action does this, controlled by the options below.

5_tab_misc.png

Automatic Updates to QuickBooks

The main switch: enables periodic updates of products and partners from Odoo to QuickBooks Online.

Allow Products Updates

  • Enabled → product changes are updated in QuickBooks Online.

Allow Partners Updates

  • Enabled → customer and vendor changes are updated in QuickBooks Online automatically.

Include Stock Quantities in Export

Sends product stock quantities to QuickBooks Online.

Important:

  • The first export of a storable product always sends its stock (QuickBooks requirement).

  • Later exports send stock only when this option is enabled.

  • Stock is updated automatically only when Allow Products Updates is enabled as well.


Defaults Tab

Fallback values used during synchronization.

6_tab_defaults.png

Default Stock Valuation Account

Used for storable products when neither the product category nor the company has a stock valuation account.

Adjust Inventory Account (QuickBooks)

The QuickBooks Online account used for inventory adjustments, usually called “Inventory Shrinkage”. Available after accounts are imported.

Default Write-off Account

Records the difference when an invoice is paid in QuickBooks Online but the imported payment doesn’t match the Odoo total, so the invoice can be closed in Odoo too.

Default Payment Journal

The journal used for payments imported from QuickBooks Online without any Payment Method defined.


Technical Tab

Visible in developer mode.

7_tab_technical.png

Invoices Cut-off Date

Only invoices after this date are exported automatically. Useful for the initial setup or a partial synchronization.

Batch Export Limit

Limits how many invoices are exported per run.

  • Lower value → safer, slower

  • Higher value → faster, more load

Diff Total Warning Threshold

A warning is shown when the invoice totals in Odoo and QuickBooks Online differ by more than this amount.

Last Customer Payment Point / Last Vendor Payment Point

The time of the last synchronized customer and vendor payments. The next payment import starts from here.

Shows the settings of the connected QuickBooks Online company. Useful when contacting support.

Looking for this article in context? Pick a section above to navigate using the sidebar tree.