Migration guide
Moving from QuickBooks to Odoo
Overview
The short version
The migration itself is mostly accounting data: chart of accounts, customers, vendors, items, open invoices and bills, and balances that must reconcile to the last QuickBooks trial balance.
Why move
Why companies leave QuickBooks
Real inventory
Multi-warehouse stock, lots, serials and barcode scanning.
Fewer add-ons
CRM, inventory, eCommerce and accounting on one database.
Manufacturing
BOMs, work orders and costing that QuickBooks does not offer.
Mapping
How QuickBooks maps onto Odoo
| QuickBooks | Odoo | Note |
|---|---|---|
| Chart of accounts | Chart of accounts | Mapped onto the Odoo localisation |
| Classes / locations | Analytic accounts or companies | |
| Customers and vendors | Contacts | |
| Products and services (items) | Products | |
| Sales tax / VAT codes | Taxes and fiscal positions | |
| Open invoices and bills | Open customer invoices and vendor bills |
What migrates
- Chart of accounts and opening trial balance
- Customers, vendors and contacts
- Products, services, costs and stock quantities
- Open invoices, bills and credits
- Optionally, summarised monthly balances for comparison reporting
What usually stays behind
- Closed transaction history (kept read-only in the old system or as an archive export)
- Bank rules, report layouts and automations (rebuilt in Odoo)
- Audit logs from the old system
Process
Migration steps
- 01
Scope and cut-over date
Agree what moves from QuickBooks, how much history, and a go-live date at a month, quarter or year boundary.
- 02
Extract
Export lists and reports from QuickBooks Online through the API or report exports, or from Desktop through Excel and IIF exports.
- 03
Clean and map
Remove duplicates and inactive records, then map accounts, taxes, products and partners onto the Odoo configuration.
- 04
Trial loads
Load into a test Odoo database at least twice and reconcile trial balance, receivables, payables and stock each time.
- 05
Cut-over
Freeze QuickBooks, load final balances and open items, reconcile, and go live. Keep QuickBooks read-only for reference.
Watch out for
Common pitfalls
Undeposited funds
Clear or reconcile undeposited funds before cut-over.
Inventory cost
QuickBooks FIFO cost must be reconciled to Odoo valuation.
Duplicate items
Item lists often hold duplicates and inactive items.
ERP Builders is an independent Odoo services company and is not affiliated with or endorsed by Odoo S.A. “Odoo” is a trademark of Odoo S.A.
FAQ
Frequently asked questions
Can we migrate all our QuickBooks history?
It is possible but rarely worth it. Most companies migrate open items and balances and keep QuickBooks read-only for history.
QuickBooks Online or Desktop — does it matter?
The approach is the same; only the extraction method differs.
Next step
Moving off QuickBooks?
We will review your data and give you a migration plan with a fixed scope.