Odoo + QuickBooks Online integration

Keep both when your accountant or reporting depends on QuickBooks, or when you run Odoo Community, which has Invoicing but not full Accounting. Migrate when you want one system, because an ongoing sync needs upkeep. Odoo calls a fiscal year end the easiest switch point and advises against switching mid tax period, because splitting a tax period across two systems complicates filing.

We load the chart of accounts first, renaming and recoding Odoo’s standard accounts rather than deleting them. Customers, vendors and products follow, with their QuickBooks IDs as External IDs so reloads update instead of duplicating. Then open invoices and bills, and the opening trial balance through clearing accounts. Without clearing accounts, receivables would count twice: once in the balance and once in the open invoices.

The QuickBooks Online Accounting API, a REST API authorized with OAuth 2.0. Access tokens last 60 minutes. Refresh tokens have a rolling 100-day expiry and a hard five-year lifespan, after which the company must reconnect. We always store the latest refresh token securely and alert you well before a reconnect is due.

Intuit allows 500 requests per minute per company and 10 per second per company and app, and throttles batch requests at 40 per minute. A throttled call returns HTTP 429, and Intuit asks apps to wait 60 seconds before retrying. A query returns at most 1,000 records. We queue writes per company, batch where it helps and back off on 429.

It can. Every QuickBooks app starts in the free Builder tier, which allows 500,000 CorePlus calls a month and blocks calls beyond that. Core calls, mostly creating and updating records, are not metered; CorePlus calls, mostly reads, queries and reports, are. Intuit’s own example prices the Silver tier at $300 a month with 1,000,000 CorePlus calls included (checked Sep 2026). We design reads around webhooks and change data capture to keep CorePlus use low.

US QuickBooks companies created after November 10, 2017 use automated sales tax, which calculates tax from addresses. If the integration sends a total tax amount with a tax code, QuickBooks honors it and prorates it across the code’s rates. We send Odoo’s tax amount so both systems show the same invoice total, and map each Odoo tax to a QuickBooks tax code. Non-US companies use a different QuickBooks tax model, mapped during design.

Three ways. The Odoo invoice number becomes the QuickBooks DocNumber, up to 21 characters, and we query for it before retrying a failed create, as Intuit recommends. Every write carries a unique requestid, so QuickBooks returns the original response instead of creating a second record. Updates send the latest SyncToken, so a stale update fails rather than overwriting newer data.

Yes, within your plan. Classes and locations need Plus, which allows 40, or Advanced, which is unlimited; we map them from Odoo analytic accounts or companies. Multicurrency is not available on Simple Start, is switched on only in the QuickBooks interface and cannot be turned off. Each customer or vendor holds one currency, so an Odoo contact invoiced in two currencies needs two QuickBooks records.

Yes. Intuit publishes a QuickBooks connector for Claude, and Odoo 20 includes its own MCP server. Each works inside one system. For questions that span both, such as which Odoo orders are invoiced in QuickBooks but still unpaid, AIONDATA can build a custom MCP server that uses the sync’s mappings, read-only first, with any write action approved by a person.

A standard sync of customers, vendors, products, invoices, bills and payments usually takes a few weeks including testing against a QuickBooks sandbox company and an Odoo test database. Multi-company setups, several QuickBooks companies, multicurrency or heavy customization typically take two to three months. A one-time migration is scoped separately around your cut-over date.