September 3, 2026

Tally Prime: the cleanup to do before you migrate to QuickBooks or Xero

Why Tally files need a cleanup pass before any conversion

Tally Prime is forgiving in ways QuickBooks Online and Xero are not. It lets a business run for years with a Suspense balance, thousands of “On Account” receipts that were never matched to invoices, optional vouchers sitting outside the books, and a ledger tree that has grown to several hundred ledgers under Tally’s 28 predefined groups. None of that stops Tally from producing a trial balance. All of it stops a migration from balancing. The steps below are the ones we run on every Tally file before a single record is exported, in the order that saves the most rework, with Tally’s own documentation as the reference throughout.

1. Back up, then verify the data

Before anything else, take a backup from Alt+Y (Data) > Backup. Then run Tally’s own integrity check: Alt+Y > Split > Verify Data scans the company and prompts you to resolve any errors it finds. If Verify Data reports problems you cannot resolve by editing, the Repair function (Ctrl+Alt+R) will rebuild the file — but Tally’s documentation is explicit that a partial repair may result in data loss and that Repair removes the Edit Log for the company. Repair a copy, never the only file.

2. Clear the Suspense account

Suspense A/c is a predefined primary group in Tally that appears directly on the Balance Sheet, and its purpose per Tally’s help is to hold amounts “whose purpose isn’t clear yet.” Neither QuickBooks nor Xero has an equivalent that a migration can honestly carry. Every balance in Suspense needs a home before the cutover: reclassify each posting to the ledger it belongs to, and journal the remainder against equity with a note. A Suspense balance carried into a new system becomes a permanent, unexplained line on the opening balance sheet.

3. Match the On Account bills

Tally’s bill-wise details give every receipt and payment three choices: New Ref for a fresh invoice, Agst Ref to settle a specific bill, or On Account for money received without a reference. Tally’s help also notes that when bill-by-bill tracking is switched on for an existing ledger, every earlier bill for that party becomes an On Account bill. In practice, most Tally files we see have a large On Account pile on the busiest debtors and creditors. QuickBooks and Xero want open items: the invoices still unpaid and the bills still owed. So the cleanup is to settle On Account amounts against the invoices they actually relate to, so that the receivables and payables ageing you migrate lists real open documents rather than a net figure with no detail behind it.

4. Decide what to do with optional, cancelled and post-dated vouchers

Tally lets a voucher type be marked Optional by default, which records entries without impacting the books; it also keeps cancelled and post-dated vouchers, all visible under Ctrl+J (Exception Reports). A migration export of “all transactions” can either drag these in or silently drop them, and neither is what you want. Review the exception reports, convert any optional vouchers that represent real transactions into regular ones, delete the rest (Alt+D), and treat post-dated vouchers as items for the new system’s first month, not the old system’s last.

5. Prune the ledger tree against the target’s limits

Tally ships with 28 predefined groups (15 primary, 13 sub-groups) and lets you add as many ledgers under them as you like; only user-created groups can be deleted, and a ledger with transactions cannot be deleted at all. That is why mature Tally files have 400 to 800 ledgers, many of them party accounts that belong in a customer or supplier list rather than a chart of accounts. The target has hard limits: QuickBooks Online caps the chart of accounts at 250 accounts on Simple Start, Essentials and Plus, with only Advanced unlimited. The cleanup is a mapping exercise: every Sundry Debtors and Sundry Creditors ledger becomes a contact, not an account; duplicate and dormant ledgers are merged; and what remains is compared against the target’s cap before, not after, the import.

6. Sort out cost centres, categories and godowns

Tally allocates by cost centre, optionally in parallel across cost categories, and tracks stock across godowns. QuickBooks has classes and locations (Plus allows 40 combined; Advanced unlimited) and Xero has tracking categories, and none of them is a like-for-like replacement for parallel allocation. Tally’s help notes that a cost centre cannot be deleted until its allocations are moved elsewhere, so this is a deliberate consolidation: decide which two or three dimensions the business actually reports on, collapse the rest, and record the decision. Stock is similar: Tally computes Stock-in-Hand from inventory transactions and valuation, so the migrated opening stock is a valued quantity per item per location at the cutover date, not a history of movements. If you run several Tally companies, decide first whether they merge into one file or stay separate: one file or many.

7. Finalise the period the way Tally itself asks you to

Tally’s documentation for splitting company data by financial year contains the best pre-migration checklist Tally publishes, because a split has the same requirements as a cutover: the books for the period must be finalised, all unadjusted forex gains and losses adjusted by journal, purchase and sales bills not left pending, and — for GST-registered businesses — mismatched entries in the GSTR reports cleared. Do that for the last period on Tally regardless of country: reconcile the tax control accounts (GST, VAT, or GST/BAS as applicable), the bank ledgers to statements, and lock the date.

8. Export what the target can take

Tally exports masters and transactions from Alt+E, with an option to include dependent masters and an option to export closing balances as opening balances; any report can be exported from Ctrl+E in Excel or XML. What you export depends on the target. QuickBooks Online imports the chart of accounts from a spreadsheet but does not carry opening balances with it — Intuit’s guide says to post a journal after the accounts import — and its spreadsheet imports must be under 1,000 rows, with lists imported before transactions and invoices limited to 100 per file. Xero takes conversion balances from the previous system’s trial balance at the day before the conversion date, with earlier periods entered as comparative journals rather than transactions. Either way, the export that matters most is a clean trial balance at the cutover date, an open-items list for debtors and creditors, and a valued stock list — which is exactly what steps 2 to 7 produce.

The cleanup is the migration

A Tally conversion that skips this work still “completes.” It just completes with a Suspense balance in equity, a receivables ageing that does not agree to the customers’ own statements, and a chart of accounts that hit the cap halfway through. Our fixed-price scoping review reads the Tally file first and quotes the cleanup and the migration together, so the cost is known before either begins.

Related service: Tally → QuickBooks · Tally → Xero · all conversion routes