Moving from QuickBooks to Odoo for Canadian organisations

Record the QuickBooks edition, hosting method, company-file count, legal entities, branches, locations, classes, inventory usage, currencies and connected applications. Decide which historical period moves, what remains available read-only and who approves the figures. Two files with similar names can have very different structures, so one export or one trial balance is not enough to define the programme.

Gather the trial balance, chart of accounts, customers, vendors, products and services, open invoices and bills, credits, unapplied payments, inventory reports and bank reconciliations. Attach a cut-off date, time zone, filters, currency and owner to each. Reconcile every company file independently before any deliberate group reporting.

Reviewed 6 November 2026. Revalidation owners: migration lead, client accountant, data owners, inventory and bank reviewers before later use.

• QuickBooks edition and company-file identifiers: __________
• Entities, branches, classes, locations and currencies: __________
• History to migrate and read-only retention decision: __________
• Financial and operational approvers: __________

Give every record a unique external ID that includes the company file and record type as needed. A customer name or invoice number alone may repeat between entities or years. Maintain the mapping from external ID to Odoo ID, run version and state so every imported party, document, payment and stock movement can be traced.

Write the dependency sequence explicitly: entities and currencies, accounts, parties, products and warehouses, then documents, payments, reconciliations and stock movements according to the approved design. If a parent record is rejected, stop its dependants or handle them under a documented rule. Never allow an invoice to link to an unintended customer merely because a name matched.

Run a small batch twice in the test environment. The run log must show created, updated, rejected and skipped records and the reason for each outcome. Prove that customers, invoices, payments and stock movements are not duplicated on rerun; deleting everything and reimporting is not the only recovery method.

• External-ID rule and collision review: __________
• Parent rejection and dependant rule: __________
• First-run and rerun control totals: __________

Reconcile quantity, unit cost and value by item, location, cut-off date and valuation method. Review units of measure, tracking, service items and accounts, then compare the inventory report to the ledger. If QuickBooks and Odoo present valuation differently, document the conversion instead of hiding the difference in a single adjustment.

Odoo 19 landed costs can allocate eligible charges. Verify AVCO or FIFO where required and use a separately validated path for Standard Price. Build an imported purchase with receiving, a partial sale before the freight bill and another after it.

Record cost before and after the additional charge, quantity sold and remaining, allocation basis, entry, inventory value and ledger. Test a return, inter-warehouse transfer and stock count, and assign each difference to an owner. Opening quantities without values and unexplained late-cost adjustments are not accepted.

Before cutover, define when entry stops, the final export, approval of files, run order, verification and go/no-go authority. Document a transaction occurring during the cut, read-only access to QuickBooks, who can call rollback and how an old integration is prevented from restoring unapproved data.

Prepare role cards in English and French for routine and exception work, then rehearse sale, purchase, collection and close with synthetic records. After cutover, reconcile the first period, receivables, payables, inventory and banks, and track every defect and residual to closure. Speed of import and a clean-looking dashboard are not the success criteria.

Use the CAD reconciliation workbook for detailed fields, the tax and bilingual discovery workbook for evidence and responsibilities, the branch/POS checklist for physical rollout and the bilingual training plan to prepare each role.