What Zoho Books Imports from QuickBooks Online
Zoho Books can take your chart of accounts, customers, vendors, items, and opening balances from QuickBooks Online, but it does not rebuild your old transactions one by one. Open invoices, for example, arrive as opening balances rather than as invoices, so the migration is a fresh start with correct starting figures, not a copy of the file.
This is for an owner or bookkeeper deciding whether to move, and for whoever will run the move. The first half covers what comes across and what does not, based on Zoho's own migration guide (checked October 2026). The second half is the order of work and the checks that tell you the new books are right.
Zoho's Route Runs Through Exported Reports
The guide has you export reports from QuickBooks Online as Excel or PDF, then bring them into Zoho Books in a fixed order. The reports include the Accounts List, the Customer and Vendor Contact Lists, the Product and Service List, the Trial Balance, and the accounts receivable and accounts payable detail. Zoho supplies sample files for the imports, and your data has to follow the column order in those samples, with the mandatory fields filled in.
The consequence is that the migration is only as good as those reports. A messy chart of accounts, duplicate customers, or items nobody uses will move across faithfully. Cleaning the source before you export is cheaper than cleaning it afterwards.
Open Invoices Become Balances, Not Invoices
This is the part that surprises people. Zoho's guide says you do not need to create or import open invoices again. Customer and vendor balances go in as opening balances, taken from the receivable and payable reports as of your start date. The guide does import outstanding bills, open vendor advances (as payments made), and open customer advances (as payments received).
What that means day to day: when a customer pays an invoice you sent from QuickBooks last month, there is no invoice in Zoho to match the payment against. You apply the payment against the opening balance instead. It works, and your aged receivables stay correct, but your team should hear about it before the first payment arrives rather than after.
History does not come with you, so decide what you need
Zoho recommends importing the current financial year, with opening balances as of the start date. Prior years stay in QuickBooks. That is a decision for you, not a defect. An accountant or auditor may need previous years' detail for months or years, so keep the old file reachable, read-only, and exported to a format you can open without a subscription.
Bank history is limited too. The guide notes that only the last 90 days of transactions can be fetched inside Zoho Books through a live feed, and it says to start the feeds from the date of your opening balances. Older bank activity can be added by importing statements. If you need a full year of reconciled bank history in the new system, plan for statement imports.
Inventory, Currencies, and Fields with No Home
Inventory comes across as closing stock from the Inventory Valuation report, entered as initial stock, which creates opening balances for the items. Shipments and warehouses need the separate Zoho Inventory add-on. Balances in foreign currencies are imported using an average exchange rate per currency and tracked under one receivable or payable account, grouped by currency.
Some QuickBooks fields have no Zoho equivalent. The guide marks a few as not necessary for import, and says values like a resale number or credit card number can only come across as custom fields. Decide up front which of those you need to keep, because adding custom fields is easier before the import than after.
Tax Setup Comes Before Everything Else
The guide's prerequisite is to set up the organization profile and add all your taxes first: rates, groups, exemptions, and authorities. Customers and vendors import with tax columns that must match what you created. If you import contacts first and fix the tax setup later, expect skipped rows and re-imports.
Ask whoever handles your sales tax which jurisdictions you collect in before you start. Missing one is easy and awkward to repair once invoices reference it. Keep a short written list of every rate and the accounts it posts to, so the person who checks the first tax report has something to compare it with.
Doing the Move Without Losing Track of the Numbers
A migration is finished when the Trial Balance in Zoho Books matches the closing Trial Balance in QuickBooks Online on your cut-over date, and not before. Everything in this half is in service of getting to that match calmly.
Pick a cut-over date at the start of a period
Choose the first day of a month, a quarter, or your financial year, so that the old books are closed on a clean boundary. The start of the financial year is the simplest because the opening balances are the prior year's closing figures. A mid-month cut-over is possible but forces you to import part of a month's activity, which is where most errors enter.
Close the period in QuickBooks, reconcile its bank accounts, and take the reports after that, not before. Reports exported before the books are closed will not match the final numbers.
Clean the QuickBooks Side Before You Export
Merge duplicate customers and vendors, inactivate accounts and items nobody has used in years, and fix names that differ only by punctuation. Look for uncategorized or "ask my accountant" entries sitting in the books, because an import cannot decide what those should be. Check that every sub-account has a parent that makes sense, since Zoho wants parents entered before their children.
An hour of tidying here usually saves a day of skipped-row errors later, and it gives you a chart of accounts you chose on purpose instead of one that accumulated.
Follow the Import Order Zoho Gives
The guide's sequence is: organization and taxes; chart of accounts, with parent accounts before sub-accounts; settings and modules; customers and vendors; items, with inventory tracking enabled first; bank and credit card accounts; opening balances; bills and then vendor advances; and customer advances. Opening balances go in a set order too: customers and vendors, assets, expenses, banks, liabilities, equity, and income.
The order matters because later steps depend on earlier ones. Opening balances for a customer can be imported only if that customer already exists. Skipping ahead produces errors that read like data problems when they are sequencing problems.
Read the Skipped-Record Count After Every Import
After each upload, Zoho shows a preview with a count of skipped records. If it is above zero, open the dropdown and read the reasons before confirming. Common causes are a missing mandatory field, a tax name that does not match, and a column out of order.
The temptation is to import the good rows and fix the rest later. Resist it for contacts and accounts, because a customer missing today becomes a missing opening balance tomorrow.
Sync the Backdated Entries, Then Compare Trial Balances
The guide ends with a step that is easy to skip: sync backdated transactions with the opening balances in settings. It says only then will the Trial Balance report show accurate account values. Do this, run the Trial Balance as of your cut-over date, and compare it line by line with the QuickBooks report.
A difference lands in the Opening Balance Adjustment account, which the guide says you can adjust later. Treat any balance in that account as a to-do list. A small, explained number is fine. A large or unexplained one means an account was entered wrongly, and it is cheapest to fix in the first week.
Run both systems for one close, then retire the old one
Keep QuickBooks read-only and run your first month-end in Zoho Books while checking it against the old numbers where they overlap. Connect the bank feeds from the opening balance date, build your categorization rules, and let the first month's exceptions show you which rules are missing.
Cancel the old subscription only after your accountant has what they need and you have exported the data you want to keep.
Cascadia's managed Zoho Books service handles this kind of move: mapping the chart of accounts, bringing across customers, vendors, and items, and tying the result back to your previous closing balances before you rely on it. We manage the system, not your books, so your bookkeeper or CPA stays in place. Migrations are scoped as their own project. Afterward the service covers bank feed monitoring, reconciliation rules, and reports, and it connects Books to Zoho CRM, so a closed deal becomes an invoice. If you are still weighing the choice, the Cascadia and QuickBooks comparison and the other Zoho Books comparisons set the options side by side, and our Zoho services page shows the wider picture. For automations beyond the settings, the Deluge post explains where that code runs and how it fails.
