Short term, sync QuickBooks Online with a connector for customers, invoices, and payments while Odoo owns inventory. Long term migration imports opening balances, chart mapping, open AR/AP, and item masters into Odoo accounting and stock, then cuts over operations. Plan parallel run, lock QuickBooks posting, and validate trial balance and inventory valuation on go-live weekend.
Steps
- Decide scope: coexistence sync vs full replacement of QuickBooks.
- Export QBO chart, items, partners, and open transactions via reports or API.
- Map accounts to Odoo account.account and set opening journal with opening balance wizard.
- Import products with categories, UoM, and initial stock.quant from counted balances.
- Configure taxes and fiscal positions to mirror prior sales tax handling.
- Run parallel invoicing week; reconcile totals between systems daily.
- Cut over: disable QBO sync, post final entries, and train AR on Odoo payment registration.
Common mistakes
- Migrating only GL without open invoice lines on reconcile accounts.
- Duplicate customers from fuzzy name matching on import.
- Ignoring inventory asset account vs stock layer valuation mismatch.
- Keeping two systems posting inventory simultaneously.
- No rollback plan if Odoo tax reports fail first filing cycle.
Odoo version notes
QuickBooks connectors are third-party for Odoo 16–18 Community and Enterprise. US localization modules affect 1099 and sales tax. Migration complexity rises with manufacturing and lot tracking—budget data cleansing. Odoo 17 accounting reports differ from 16; rebuild dashboards after migration version choice.
When to bring in help
If the fix touches custom modules, regulated traceability, or production outages, a focused rescue sprint beats months of trial and error. See our Odoo service.