Migrate from QuickBooks to Odoo: Complete Guide

Why Migrate from QuickBooks to Odoo?

QuickBooks is a solid small-business accounting tool, but as companies grow they need CRM, inventory, manufacturing, HR, and eCommerce — all integrated. Odoo provides all of these in one platform, eliminating the need for separate tools and manual data syncing.

What Can Be Migrated

Step 1: Export from QuickBooks

Chart of Accounts

1. In QuickBooks: Reports → Account List
2. Export to Excel/CSV
3. Map QB account types to Odoo account types (Asset, Liability, Income, Expense, Equity)

Customers & Vendors

1. Reports → Customer Contact List / Vendor Contact List
2. Export to CSV
3. Include: Name, Email, Phone, Address, Tax ID

Products

1. Reports → Product/Service List
2. Export to CSV
3. Include: Name, SKU, Description, Sales Price, Cost, Category

Open Invoices

1. Reports → Open Invoices (as of migration date)
2. Export to CSV
3. Include: Customer, Invoice Number, Date, Due Date, Amount, Balance Due

Step 2: Prepare Odoo

1. Install Accounting module
2. Select the correct Fiscal Localization package
3. Set your Fiscal Year start date
4. Configure Tax settings to match QuickBooks

Step 3: Import into Odoo

Import Order

1. Chart of Accounts (must exist before anything else)
2. Customers & Vendors
3. Products
4. Open invoices/bills
5. Opening balance journal entry

CSV Import Process

1. Go to the relevant list view (e.g., Accounting → Customers)
2. Click Favorites → Import records
3. Upload CSV file
4. Map columns to Odoo fields
5. Click Test to validate
6. Click Import

Step 4: Opening Balances

Create an opening balance journal entry as of the migration date:

1. Go to Accounting → Journal Entries → New
2. Set date = day before Odoo go-live
3. Enter all account balances from QuickBooks trial balance
4. The offset account should be the Opening Balance Equity account
5. Post the entry

Step 5: Reconnect Bank Feeds

1. Go to Accounting → Configuration → Add a Bank Account
2. Connect to your bank (Plaid or manual import)
3. Import transactions from the migration date forward

Post-Migration Checklist

• Compare Odoo trial balance to QuickBooks trial balance — they must match
• Verify all open invoices appear correctly
• Test a new invoice creation end-to-end
• Verify tax calculations match
• Set the accounting lock date to prevent edits before migration date

Common Pitfalls

• Don't migrate closed transactions — Use an opening balance instead. Migrating years of history is unnecessary and error-prone.
• Don't forget tax mapping — QuickBooks tax codes may differ from Odoo fiscal positions.
• Don't go live without reconciling — Verify trial balance matches before starting operations in Odoo.