Export your data from QuickBooks

In QuickBooks Online, open the gear icon and choose Export data, then pick the reports and lists you need and send them to Excel. Estimates, purchase orders and attachments are not part of that export, so you pull them from their own screens, as Intuit explains in its export guide.

For a standard accounting move, export these:

• Chart of accounts
• Customer and vendor lists
• Products and services list
• Trial balance as of your cutover date
• A/R aging detail and A/P aging detail as of the cutover date
• Inventory valuation summary, if you track stock
• Bank reconciliation reports for the last closed period

QuickBooks Desktop users can send the same reports and lists to Excel from the Reports and Lists menus.

Map your chart of accounts

Compare your QuickBooks accounts with the chart of accounts that Odoo loads for your country. Where an account does the same job, reuse the Odoo one and rename it if you want to keep your old wording. Where it does not exist, create it. Odoo gives every account a type, and that type decides where the account appears in your reports, so choose it with care.

QuickBooks lets you nest sub accounts under a parent. Odoo organizes accounts through codes and groups instead, so settle on a coding scheme now. Odoo's chart of accounts guide explains how groups work.

Keep the result in a simple two-column sheet, with the QuickBooks account on the left and the Odoo account on the right. You will use it again when you load opening balances.

Set up accounting in Odoo

Before importing anything, configure the basics: company details, currency, fiscal year dates, taxes, payment terms, and your bank and cash journals. Installing the fiscal localization for your country gives you a starting chart of accounts and tax setup, which saves a lot of typing.

If you use QuickBooks classes or locations to track departments, projects or branches, decide now how that will work in Odoo. This is usually handled through analytic accounting, and it is far easier to set up before transactions exist than after.

Import contacts and products

Odoo accepts Excel and CSV files. Open the list you want to fill, use the Action menu, choose Import records, and download the template Odoo provides so the columns are already mapped. Upload your file, check the mapping, click Test, and only then click Import. Odoo's import guide walks through each click.

Customers and vendors both go into Contacts. Keep the original QuickBooks name or ID in a reference field so you can trace any record back later. Products should keep the names and SKUs you use today, with sales price, cost and tax settings checked.

Load your opening entries

This is where the accounting really happens. Odoo's accounting documentation says a company moving from other software needs three things in place: opening account balances, open invoices and bills, and an opening inventory count if you carry stock. It also sets three rules to respect:

• The total of your receivable accounts must equal your open customer invoices minus credit notes
• The total of your payable accounts must equal your open vendor bills minus refunds
• The opening trial balance itself must balance, with debits equal to credits

Export the trial balance as of your cutover date, swap the QuickBooks account names for your Odoo accounts using your mapping sheet, and import it as a journal entry. Then enter each open invoice and bill as its own document, not as one lump sum, so aging reports and payments behave normally.

Watch for receivables and payables being counted twice, once in the trial balance and again in the open documents. That is a place where errors slip in easily, and a good reason to have an accountant review this step.

If you track inventory, load the quantity and value of each product as of the cutover date and compare the total with your QuickBooks inventory valuation summary.

Check that everything ties out

Before anyone creates a real transaction in Odoo, confirm each of these:

If any line does not match, stop and find the difference before moving on. A small gap today becomes a hard-to-explain gap at year-end.

Run both systems side by side

Record a short stretch of real transactions in both QuickBooks and Odoo, ideally through one full month-end close, and compare the reports. This is where you find what no checklist predicted, like a tax code that behaves differently or a report your team relies on that looks different in Odoo.

Not every business has time for a full overlap. If yours does not, at least run a week of invoices, bills and bank reconciliation in both.

Switch over and clean up

On the cutover date, set a closing date in QuickBooks so nobody posts new entries by mistake, and make Odoo the only place where transactions are-entered. Reconnect or import your bank transactions, depending on your bank and your Odoo version, and make sure your team knows where to create invoices and record bills.

Keep QuickBooks access until your first month-end close in Odoo ties out, and store your exported files somewhere safe for audits and questions later.

• You have a single company and one currency
• You carry no stock, or very simple stock
• Your QuickBooks books are clean and current
• You have time to run a parallel month

• Inventory and costing need to match exactly
• You have several companies or currencies
• Years of cleanup are waiting in QuickBooks
• The deadline cannot move
• Your online store, payment tools or payroll need reconnecting

How long does it take to migrate from QuickBooks to Odoo?

It depends on the size and tidiness of your data. A small company with clean books and no inventory can finish in a few weeks, while inventory, several companies or heavy cleanup push it longer. The side-by-side run stretches the timeline most, and it is also the step that protects you.

Will I lose my QuickBooks data?

No, as long as you export everything before changing anything and keep the files. The move copies balances and open items into Odoo, and your original QuickBooks data stays untouched until you decide to close that account.

Can I migrate from QuickBooks Desktop as well as QuickBooks Online?

Yes. The steps are the same. Only the way you export differs, since both let you send reports and lists to Excel.

Is there a one-click import tool?

Odoo's standard route is its import tool, which takes Excel or CSV files and has a Test option before you commit. Some third-party connectors exist, but check how they handle opening balances and open invoices before you rely on one.

Do I need to import every past transaction?

No. Most businesses bring opening balances, open invoices and bills, and sometimes the current year-to-date. Older detail can stay in your QuickBooks exports.

What should I check before I stop using QuickBooks?

Confirm that your trial balance, receivable and payable totals, bank balances and inventory value all match on the cutover date, and that one month-end close in Odoo produces the numbers you expect.