QuickBooks to Odoo Migration: What Transfers and What Does Not

QuickBooks and Zoho Books do their core job well: invoicing, bills, bank feeds and value added tax (VAT) returns for a small finance team. Businesses usually start looking at Odoo when the books are no longer the whole story, and stock, purchasing, manufacturing, projects or payroll need to share one database with accounting.

A QuickBooks to Odoo migration, or a move from Zoho Books, turns on two questions: what can you take out of the old product, and what should Odoo receive? Both products export more than people expect, but neither hands over a database Odoo can simply open. This guide covers the exports, the mapping, what to leave behind and how to cut over, with Odoo 19 as the target.

What QuickBooks and Zoho Books Let You Export

Check what your product and edition offer first, because it decides how much reshaping the migration needs.

QuickBooks Online

The Export data tool, under Settings, exports reports and lists to Excel in a single zip file. Intuit's help pages list the Profit and Loss, Balance Sheet, Trial Balance and General Ledger reports and the customer, vendor and employee lists, and the account list and products and services can be exported from their own screens. Attachments export separately, also as a zip file.

Intuit also says that after you cancel a paid subscription, you keep read-only access for one year and can still export. Treat that as a safety net, not a plan, and export everything before you cancel.

QuickBooks Desktop

Desktop exports lists, such as the chart of accounts, customers, vendors and items, to IIF (Intuit Interchange Format) files through File > Utilities > Export. Intuit states that transactions cannot be exported to IIF, so transaction detail leaves Desktop as reports exported to Excel.

Zoho Books

Each module, such as invoices, bills, contacts or items, exports from its list view to CSV, XLS or XLSX, up to the first 25,000 rows. Beyond that, the Data Backup feature under Settings produces one compressed file of CSV files across modules. Zoho's help pages add two timing rules: the download link expires 30 days after the backup, and another backup is not possible for 15 days. Attachments have their own Backup Documents tab, which covers documents added since the last documents backup.

Mapping Accounts, Contacts, Items and Tax Codes

Exports arrive in QuickBooks or Zoho shapes. The real work is reshaping them for Odoo's import tool, which reads Excel and CSV files, offers templates and has a Test button, and loading them in dependency order: accounts and taxes, then contacts, then products, then open documents. Give every record an External ID built from its old code, so later files can refer to it without ambiguity.

Accounts

Map each account to the Odoo chart of accounts from the UAE localization, or create it with the right Odoo type, such as Current Assets, Fixed Assets, Income or Expenses. Odoo tracks who owes what through the partner on each journal item, so one receivable and one payable account normally cover all customers and suppliers. Classes and locations in QuickBooks, or reporting tags in Zoho Books, become analytic accounts.

Contacts

Bring the legal name, address, TRN (Tax Registration Number), payment terms and currency. Zoho Books stores a tax treatment, such as VAT Registered or GCC VAT Registered, and a place of supply on each contact. In Odoo, the emirate goes in the address state, where the UAE localization's fiscal positions pick it up, and customers abroad fall under the non-UAE position. Zoho's designated zone treatments have no ready-made fiscal position in Odoo's UAE localization, so model them deliberately with your tax adviser.

Items

Inventory items become Goods with Track Inventory switched on, non-inventory items become Goods without it, and services become Services. Bundles need a decision: a kit, built with a bill of materials of the Kit type from the Manufacturing app, or separate lines. Bring the cost, sales price, barcode, unit of measure and default taxes with each product.

Tax Codes

Odoo's UAE localization provides 5% sales taxes per emirate, because the VAT return reports standard-rated supplies emirate by emirate, plus zero-rated, export, exempt, import, reverse charge and out-of-scope taxes. Map each old rate separately for sales and purchases. For Zoho Books, the usual mapping is:

• Standard Rate [5%]: Odoo's 5% purchase tax, and on sales the 5% tax for the customer's emirate, chosen by the fiscal position.
• Zero Rate [0%]: the zero-rated tax, or the zero-rated export tax for exports.
• Exempt: the exempt tax.
• Out of Scope: on sales, the out-of-scope tax. Odoo's UAE localization has no out-of-scope purchase tax, so agree the purchase treatment with your tax adviser.

Test every mapping on real transactions from your last VAT period before loading anything else.

Open Items versus History

Move what is still open, and archive what is closed. For most businesses, Odoo should receive:

• the opening trial balance at the cut-over date;
• every open customer invoice and credit note, at the amount still due;
• every open supplier bill and refund, at the amount still due;
• stock quantities by product and location, at agreed costs;
• the fixed asset register, with depreciation to date.

Odoo's own accounting documentation recommends importing each open invoice or bill with only the total amount due, posted to a clearing account, so tax accounts are not affected twice. In the opening trial balance, the receivable and payable lines are replaced with the same clearing accounts. Once both sides are loaded, the clearing accounts net to zero, and Odoo suggests changing their type to Off-Balance Sheet so they drop out of reports.

History stays in the exports and, while it lasts, in the old product's read-only access. Keep the exported reports for every closed year, because UAE law requires corporate tax records to be kept for seven years after each tax period. If you need last year's figures for comparison, load monthly totals per account rather than every transaction. Our guide to opening balances and cut-over covers the method in depth.

A Worked Example: One Zoho Books Customer

Say Zoho's receivables reports show a customer owing AED 18,900: two unpaid invoices of AED 12,600 and AED 7,350, and an unused credit note of AED 1,050. In Odoo, import two customer invoices with single lines of AED 12,600 and AED 7,350 against the receivable clearing account, with no tax, and one customer credit note of AED 1,050 against the same account. The customer owes AED 18,900 in Odoo too, and each document keeps its Zoho number as a reference and its original due date for follow-ups.