Configuration & Settings

Zoho has no current video on this, so here is how we do it on live migrations. Getting the cut-over right is the single biggest determinant of whether a Zoho Books file is trustworthy a year later.

1. Fix the migration date first

The migration date is the day your Zoho Books ledger starts. Everything on or after it is a live transaction; everything before it is an opening balance. Set it in Settings → Opening Balances, and pick the first day of a financial year or of a GST return period — never a mid-month date, which leaves you reconciling a part-period GSTR-3B against two systems.

Once transactions exist, changing this date is painful. Decide it before you import anything.

2. Enter the trial balance, not the transactions

Take the audited or finalised trial balance from your old system as at the day before the migration date and enter those closing balances as openings. Do not re-key years of history to "have it in Zoho" — keep the old system as the archive for prior years and start clean.

3. Open invoices and bills go in individually

This is where most self-service migrations go wrong. Debtors and creditors must not go in as a single lump-sum ledger balance. Enter each unpaid customer invoice and each unpaid vendor bill as an individual document, dated its original date, so that:

• ageing reports are meaningful from day one;
• payment receipts and vendor payments can be applied against the right document;
• MSME payment-timeline tracking under section 43B(h) actually works.

The same applies to unapplied advances from customers and to advances paid to vendors.

4. Close out Opening Balance Adjustments

Zoho Books parks any difference between your debits and credits in an Opening Balance Adjustments account. A non-zero balance there is not a rounding quirk — it means something did not come across. Do not go live until it is nil.

Usual culprits: a ledger mapped to the wrong account type, TDS or GST clearing balances left behind, stock value entered both as an item opening quantity and as an inventory ledger balance, or debtor and creditor control accounts entered on top of the individual invoices you already keyed.

5. The sign-off checklist

• Zoho trial balance as at the migration date equals the old system's, line by line.
• Opening Balance Adjustments is nil.
• Debtors and creditors ageing totals agree to their control accounts.
• Inventory quantity and value agree to the closing stock statement.
• Bank balances agree to the bank statement, with unpresented items identified.
• GST, TDS and TCS clearing ledgers carry the balances you actually expect to pay or claim.
• A closing date is set so nobody can post back into the migrated period.

Migrating from Tally? Our year-by-year Tally to Zoho migration framework covers ledger mapping, voucher routing and reconciliation in far more depth — or have us run the cut-over for you.