Importing Your Chart of Accounts from Excel into Zoho Books

For businesses migrating from Tally, QuickBooks, or a spreadsheet, importing your chart of accounts is the first big step. Zoho Books accepts CSV imports, but the format is finicky. Here is how to do it without surprises.

Prepare the source file

Download Zoho's chart of accounts template (Settings → Chart of Accounts → Import → Download Template). The required columns are Account Name, Account Code, Account Type, Description, Parent Account, Currency. Fill these in your spreadsheet using your existing chart's data.

Map every legacy account to a Zoho account type, Asset, Liability, Equity, Income, Expense, Other Income, Other Expense, Contra. This mapping is the most error-prone step; budget an hour to review every line.

Numbering and hierarchy

Use a five-digit numeric Account Code with gaps between major sections (10000 cash, 12000 receivables, etc.). Zoho supports parent-child hierarchies, the Parent Account column references another Account Code. Build the hierarchy explicitly; do not rely on the order of rows.

Reserve account codes for future expansion. After import, you cannot change a code without re-importing, it is easier to leave gaps now than to renumber later.

Import mechanics

Save your spreadsheet as CSV (UTF-8 encoded). Upload via Settings → Chart of Accounts → Import → Choose File. Zoho parses the file and shows a preview. Review every row in the preview. Errors at this stage cost minutes; errors after import cost hours.

Common preview errors: unrecognised Account Type (must match Zoho's exact naming), missing Parent Account (references an account not in the file), duplicate Account Code. Fix in the spreadsheet, re-upload, do not save with errors.

After import

Reconcile: the imported chart should have the same number of accounts as your source. Spot-check 10 random accounts. If you imported opening balances, ensure debits equal credits across the chart and against your closing trial balance from the legacy system.

Lock newly imported accounts that you do not need to edit further (e.g., historical equity accounts). The lock prevents accidental edits, useful when staff are new to Zoho. Locking does not prevent transactions, only changes to account properties.

This guide is general information, not professional advice. For situations that involve specific facts, talk to your accountant, or hire one of ours from the marketplace.