A QuickBooks to Zoho Books migration usually breaks in five places. Problem balances come across from QuickBooks unchanged. Account mapping changes some account types. Payables and receivables arrive with the wrong status. Foreign-currency history is converted at rates that do not match the originals. And the parts of a finished file that are not transactions, such as bank reconciliation history, attachments, recurring profiles and locked periods, do not come across at all. Zoho's own migration guide explains how to run the import. This post is meant to be read alongside it, and covers what to check before you start and after you finish.
Start with Zoho's documentation for your edition: the QuickBooks Online migration guide, and, for the India edition, its published list of migration limitations. Editions differ. The India guide describes a migration tool that imports transactions. Some other editions document an opening-balance approach instead. Read the version that matches your organisation before planning anything.
Decide the cut-over before anything else
Most later problems trace back to one early decision: bring the full transaction history across, or start Zoho Books from opening balances at a cut-over date.
- Full history keeps every invoice and bill searchable in one system, but every flaw in the QuickBooks file comes with it.
- Opening balances gives a clean start. Historical detail stays in QuickBooks, so you need continued access to it, and open invoices and bills still have to be entered individually so they can be collected and paid.
For most small businesses, a cut-over at a financial year start, with open items brought across individually, causes the fewest problems. Whichever you choose, record the decision and the date. Every check below refers to it.
1. QuickBooks problem balances travel with you
The migration copies the QuickBooks file as it is. If it holds a balance in Opening Balance Equity, an Undeposited Funds balance that keeps growing, or unreconciled bank accounts, Zoho Books inherits them. Zoho's India limitations page notes that Undeposited Funds is imported as a Cash account. A stale balance there will look like money the business holds.
Clean the QuickBooks file first, at least up to the cut-over date. Reconcile every bank and card account to the cut-over date, clear Undeposited Funds, and bring Opening Balance Equity to zero. Doing it before the migration saves work, because afterwards the same problems exist in two systems.
2. Account mapping changes more than names
Zoho Books creates its own default accounts. According to Zoho's India limitations page, QuickBooks accounts whose names match a Zoho default are not imported separately. Interest Income, Inventory Asset and Undeposited Funds also change account type on import.
After the import, compare the chart of accounts line by line with QuickBooks. Look for two QuickBooks accounts that have merged into one Zoho default, an account that has moved between income and other income, and custom account numbering that has not survived. This matters for reporting. A merged account cannot be separated later without reposting transactions.
3. Payables and receivables need re-checking, not just totals
Zoho's India limitations page contains several items that affect ageing reports:
- Bills are imported with an Open status by default.
- Vendor credits cannot be applied to bills during import and must be applied manually.
- Journals that combine a bank or cash account with receivables or payables are split into two journals through an intermediate account.
- Expenses with items or TDS are imported as bills.
The totals can agree while the detail is wrong. After import, run the receivables and payables ageing in both systems as at the cut-over date and compare them customer by customer and vendor by vendor. Check that the intermediate account used for split journals is back to zero. If it is not, the journal did not come across as intended.
4. Multi-currency history does not translate cleanly
Foreign-currency balances are where the numbers drift. Zoho's opening-balance guide for some editions converts foreign balances using an average exchange rate for each currency. A migrated invoice may carry a rate that differs from the one QuickBooks used. Either way, when a foreign receivable is later settled in Zoho Books, the realised gain or loss is measured against the rate Zoho holds, not the original. The exchange difference reported in the first months after migration can therefore be wrong.
Before cut-over, list every open foreign-currency invoice and bill with its original rate and its base-currency value in QuickBooks. After import, compare the base-currency values. Where they differ, correct them, or post a documented adjustment at the cut-over date. Then decide the rate source going forward. Zoho Books fetches rates automatically through an exchange rate feed by default, and that may not be the rate your tax rules require.
5. What is not a transaction does not move
Zoho's list of what migrates covers masters, opening balances, sales, purchases and journals. It does not cover the parts of a working file that sit around the transactions:
- Bank reconciliation history. Expect bank accounts in Zoho Books to start unreconciled. Reconcile from the first statement after cut-over. Export and keep the QuickBooks reconciliation reports for earlier periods, because they are your evidence that those balances were agreed.
- Attachments. Receipts and documents attached to transactions in QuickBooks need to be exported and kept separately before you lose access to the QuickBooks file.
- Recurring profiles, templates, bank rules and payment reminders. These need rebuilding in Zoho Books. List them in QuickBooks before you start.
- Locked periods. A closing date set in QuickBooks does not carry across. Set it again in Zoho Books under Accountant > Transaction Locking, which can lock Sales, Purchases, Banking and Accounts separately or all together.
- Users, integrations and bank feeds. Each needs setting up again. Connect bank feeds from the cut-over date, so transactions already migrated are not imported a second time.
Verify before you call it complete
Zoho's India migration tool compares the QuickBooks trial balance with Zoho's and shows the net difference for each account before you select Complete Migration. Treat a zero difference as necessary but not sufficient. Before switching off QuickBooks, also check:
- the balance sheet at the cut-over date agrees in both systems, account by account;
- receivables and payables ageing agree by customer and vendor, not just in total;
- each bank account's balance at the cut-over date agrees to the bank statement;
- tax balances (GST, VAT or sales tax payable and receivable) agree to the latest filed return;
- the intermediate and default accounts created by the import are understood and, where temporary, at zero.
Keep QuickBooks accessible, at least read-only, for as long as you may need its history. Check Intuit's terms for your subscription before cancelling.
Where this fits
A migration is often the moment a business discovers what its old file was hiding. If the QuickBooks side needs work first, our QuickBooks cleanup checklist sets out the order.
Wissen Solutions handles QuickBooks to Zoho Books migrations, including the pre-migration cleanup and post-migration verification, through our Zoho Books consulting and migration services. The handover pack includes the reconciliation of both systems at the cut-over date.
Sources (Zoho Books documentation checked 24 October 2026; Zoho updates its help pages and editions differ)
- Zoho Books: Migrate from QuickBooks Online
- Zoho Books (India): Migrate from QuickBooks Online: migration tool, trial balance comparison, Complete Migration
- Zoho Books (India): Limitations when migrating from QuickBooks Online
- Zoho Books (Canada): Migrate from QuickBooks Online: opening-balance approach, average exchange rate for foreign balances
- Zoho Books: Transaction Locking
- Zoho Books: Currencies and exchange rate feeds