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
-
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.
Auto-export Invoices to QuickBooks
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
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.
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
-
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
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.
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.
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.
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.
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.
Print QuickBooks Company Settings
Shows the settings of the connected QuickBooks Online company. Useful when contacting support.










