Home / Blog / Migrating from Tally, field by field
Buying & switching

Migrating from Tally to an ERP: what transfers, what doesn’t, and how to cut over

"Easy migration" is a sales line. Here is the actual field-by-field mapping, and the four things that never transfer cleanly.

Migrating from Tally, field by field

Every vendor says migration is easy. What they mean is that the import script works. What you are worried about — will my numbers still tie, will my CA be able to file, will the godown know what to call things — is a different job.

Here is the plan we actually run, including the parts that go wrong.

First decide what you are migrating

The single biggest mistake is trying to bring five years of vouchers across. Do not. Migrate the state of the business, not its diary.

MigrateLeave in Tally (archived, read-only)
Item masters with one agreed code eachHistorical sales and purchase vouchers
Customers & suppliers with GSTIN, terms, credit limitsOld journal entries
Chart of accounts / ledger groupsPrior-year financial statements (export as PDF)
Opening balances as on cut-off dateVoucher-level narration history
Stock as on cut-off, by item, batch and locationCancelled and draft entries
Open receivables and payables, invoice-wiseAnything you have never once looked up

The field-by-field mapping that matters

Item master

Tally's stock item carries name, group, UOM, GST rate and HSN. In an ERP you will also need: stocking UOM versus purchase UOM, reorder level, whether the item is batch or serial tracked, and whether it is a bought-out part, a manufactured item or a job-work input. Those four fields do not exist in your Tally file. Someone has to decide them, item by item, before import.

Ledgers

Ledger groups usually map one-to-one. The friction is that operations people want cost centres and product-line reporting that your Tally chart of accounts never had. Add the dimension at migration, not six months later.

Parties

Duplicates are guaranteed — the same customer under two spellings, one with GSTIN, one without. De-duplicate on GSTIN, then on phone number, then by eye.

Opening stock

Quantity is easy. Valuation is where people get hurt: decide your method (FIFO, weighted average) and make sure the opening value matches the closing value in your last Tally balance sheet, to the rupee. If it does not tie, stop and find out why before go-live.

Four things that never transfer cleanly

  1. Your team's habits. Twelve years of keyboard shortcuts. Budget for genuine frustration in week one, and pick your calmest senior person as the internal helper.
  2. Narration-based knowledge. "Rate revised as discussed" in a voucher note is knowledge that lives nowhere else. Extract the important ones into proper fields — price lists, customer terms — before the switch.
  3. Custom TDL reports. Any Tally customisation your CA wrote will need rebuilding as ERP reports. List them early; there are usually two that genuinely matter and five nobody has opened in a year.
  4. Unposted reality. Material lying with a job worker, sales returns not yet booked, samples out. Reconcile them before you take opening stock, or you will inherit variance on day one — the same variance we catalogue in stock versus books.

The parallel month

Run both systems for one full month. Yes, it is double entry, and yes, it is worth it.

  • Week 1: enter everything in both. Reconcile daily on stock movement only.
  • Week 2: reconcile stock and sales. Fix master gaps as they surface.
  • Week 3: add purchase and payments. Compare GST summaries.
  • Week 4: close the month in both. If the two closings tie, you are done. If not, the difference is your remaining process gap — find it now, not in October.
Cut-over rule. Go live on the first day of a quarter, ideally 1 April. Never mid-month, never in March, never the week before a big dispatch. The calendar is free risk reduction.

Go-live checklist

  1. Opening trial balance in the ERP matches the last Tally balance sheet.
  2. Opening stock value matches, by item class.
  3. Open receivables tie invoice-wise, not just in total.
  4. One person named as data owner, with authority over item codes.
  5. GST settings verified against a test invoice — including e-invoicing if you cross the threshold, which we cover in the compliance checklist.
  6. Tally file backed up twice, in two places, and set to read-only.
  7. A named fallback: who to call on day one, and what you do if dispatch stalls.

If you would rather someone else carried this, that is exactly what our scoping call covers — we map your masters and tell you what the clean-up looks like before anyone talks about software. Start there.

Questions people ask us about this

Can Tally data be imported into an ERP?

Masters transfer well: ledgers, item masters, customers, suppliers, GST details, opening balances and stock as on a date. Transaction history usually should not be migrated wholesale — it is cheaper and safer to keep Tally archived read-only for historical queries.

Will I lose my old data if I move off Tally?

No, if you plan it. Keep the Tally company file, backed up, in read-only use for prior years. You migrate opening balances into the new system and keep the old one as your archive for audits and comparisons.

How long does a Tally migration take?

Two to six weeks for a small business. The export and import take days; cleaning duplicate item codes and agreeing one chart of accounts is what consumes the time.

Want this looked at for your business?

Tell us what you run and what is not working. Our executive walks your process and comes back within 24 hours — no card, no obligation.

Read next