Accounting and month-end

Switching from Tally or Excel: a checklist for a clean move

Pick the cut-over date, bring across the right data, run both side by side for a month, and check the numbers before you switch off.

Changing billing or accounting software feels risky because the books must not break in the middle of a tax period. With a clear cut-over date and a short checklist, the move takes days, not months.

1. Pick the cut-over date

Start the new software on the first day of a month, ideally of a quarter. GST returns and VAT returns then come from one system per period. The start of a financial year is cleanest, but there is no need to wait for it.

2. Bring across the masters

  • Customers and suppliers: names, GSTIN or TRN, state, addresses, phone and email, credit terms.
  • Items: names, HSN or SAC codes, units, tax rates, prices and barcodes.
  • Chart of accounts: map your ledgers to the new account groups once, and keep the mapping.

Clean up as you go: merge duplicate customers and fix missing GSTINs. It is the cheapest moment to do it.

3. Bring across the balances

  • Opening balances of every ledger as at the day before the cut-over: bank, cash, capital, loans, assets, tax payable.
  • Open invoices and bills, one by one rather than as a single total, so you can collect and pay against each.
  • Opening stock by item, with quantities, value, and batches and expiry dates where you track them.

4. Decide how much history to bring

Old invoices are useful for customer history and for reprinting, but optional. Many businesses bring the current financial year’s invoices and keep the old software read-only for earlier years. Keep the original invoice numbers so that nothing clashes with what was already reported to the tax portal.

5. Run both for one month

For the first month, enter in the new software and keep the old one open for checking. At month end, compare:

  • the trial balance in both systems;
  • receivables and payables by party;
  • stock quantity and value for your top items;
  • the GST or VAT summary for the month.

Differences at this stage are almost always a missing opening balance or a duplicated invoice, and are quick to fix.

6. Switch off and archive

Once the numbers agree, stop entering in the old software. Keep a full backup and an export of its reports for the years you must preserve records (at least eight years in India and five in the UAE).

A worked example: checking the first month

This is an illustration with made-up numbers. A trading business starts the new software on 1 April and runs the old one alongside for the month. On 30 April, the checks come out like this:

CheckOld softwareNew softwareResult
Receivables total₹1,240,000₹1,215,000Difference of ₹25,000
Payables total₹860,000₹860,000Agrees
Closing stock value₹2,050,000₹2,050,000Agrees
GST output for April₹182,000₹182,000Agrees

The receivables difference of ₹25,000 is traced to one customer. A receipt was entered in the old software on 29 March and again in the new one on 3 April. Removing the duplicate clears it. This is the typical shape of a migration problem: one party, one entry, found in an hour because the comparison was by party and not just by total.

Common mistakes when switching

  • Importing a single total for receivables. You then cannot collect or reconcile by invoice.
  • Changing the invoice number series without a plan. Keep the old numbers for old invoices, and decide how new numbers continue, so that numbers are not duplicated on the tax portal.
  • Leaving unclean masters. Duplicate customers and missing tax numbers cause trouble in every return afterwards.
  • Cutting over mid-month. The month then sits in two systems and reconciling it is slow.
  • Not telling the team. Staff continue entering in the old system and the new one is incomplete.
  • Deleting the old data too early. Keep it, read-only, for the retention period.

Who needs to do what

  1. Owner: chooses the date and approves the opening balances.
  2. Accountant or CA: confirms the chart of accounts mapping and the closing balances of the old year.
  3. Billing staff: learn the new invoice screens before the date, using a few practice invoices.
  4. Stores: count stock close to the cut-over date so opening quantities are right.
  5. Everyone: agrees on a stop date for entering in the old system.

A short call with your CA before you start usually saves more time than any later fix, because they know which balances they need to see at the cut-over date.

The first week after the switch

Once the new software is live, spend a few minutes each day on three checks: that every sale of the day has an invoice, that every receipt and payment is matched to a party, and that the cash and bank balances agree with the real ones. Small errors found on day two are cheap to fix; found at month end they are tangled with everything else. Ask staff to note anything confusing, and fix it by the end of the week.

Moving to Zebill

Zebill imports customers, suppliers, items, opening stock, invoices, bills, payments and opening balances from Tally (XML or Excel), Vyapar, Zoho Books, QuickBooks, Xero and plain Excel or CSV files. Rows are checked before anything is saved, old invoices keep their numbers, and an import can be undone within 30 days. Zebill is not affiliated with those products.

Questions people ask

When is the best time to switch accounting software?

The first day of a month, ideally of a quarter, so that each tax return comes from one system. You do not have to wait for the new financial year.

Should I import all my old invoices?

It is optional. Many businesses import the current year and keep the old software read-only for earlier years. If you import, keep the original invoice numbers.

Can I switch in the middle of a financial year?

Yes. Pick the first day of a month, bring across opening balances as at the day before, and keep the earlier months in the old software for reference. Your CA should confirm the opening balances.

What should I check before I stop using the old software?

The trial balance, receivables and payables by party, stock for your top items and the tax summary for the month should agree. Keep a full backup and exported reports before you stop.

Rules change. This article is general information, not tax, legal or HR advice. Check the latest rules on the official portals, and ask your accountant about your own situation.

TallyExcelmigrationimport

Bill with confidence from today

Zebill is free while we are in early access. Set up your business in a few minutes and make your first invoice.