Tally to ERPNext migration

Docs › Setup guides

Tally to ERPNext Migration

Tally to ERPNext migration, done safely: pick a cut-over date, export masters and balances, clean data, use Data Import, add opening stock and run in parallel.

4 min read · Updated November 2026 · By Vivek Choudhary

A Tally to ERPNext migration is mostly about clean data and a clear cut-over date. When you migrate from Tally, you bring over masters (ledgers, parties, items) and opening balances, not years of old vouchers. Tally stays available for looking up history. This guide covers the manual method with ERPNext's Data Import tool, and mentions Frappe's own Tally Migrator app. For the bigger picture, see the implementation plan.

Before you start

  • ERPNext is set up with the company, fiscal year, chart of accounts, warehouses and taxes. Install the India Compliance app if you need GST.
  • You have a test site to try every import before the live site.
  • Tally books are complete and reconciled up to the cut-over date.
  • Your accountant has agreed the trial balance, receivables, payables and stock value as on that date.
  • One person owns the migration and signs off each check.

Step-by-step migration

  1. Pick the cut-over date. Choose the start of a month, or better, the start of a financial year. Opening balances in ERPNext are dated one day before, or on, that date. Everything after it is entered only in ERPNext.
  2. Export masters from Tally. In TallyPrime use Export from the Gateway to export masters (XML suits tools; Excel or reports suit manual cleaning). You need: ledger list with groups, customers and suppliers with GSTIN, address, state and credit days, stock items with unit, HSN and GST rate, stock groups and godowns.
  3. Export balances. Take the Trial Balance, outstanding bills for each customer and supplier (bill-wise), and the stock summary with quantity and value per item and godown, all as on the cut-over date. Save them as PDF too, for sign-off.
  4. Map and clean. In a spreadsheet, map Tally groups to ERPNext accounts, Sundry Debtors to Customers, Sundry Creditors to Suppliers, godowns to Warehouses and units to UOMs. Remove duplicates, merge parties with spelling variations, check GSTINs and states, and give each item one clear code. This step takes the most time and matters the most.
  5. Data Import, in order. Go to Home > Data > Data Import (or Menu > Import on any list). Select the Document Type, choose Insert New Records, save, click Download Template, fill it, attach it and click Start Import. Fix all warnings and use the Import Log to confirm what was created. A sensible order: Accounts (if not already set), Customer and Supplier Groups, UOMs, Item Groups, Warehouses, Items, Customers, Suppliers, then Addresses and Contacts.
  6. Opening party balances. Use the Opening Invoice Creation Tool to enter each unpaid customer and supplier bill with its date and amount, so ageing and later payment matching work. Enter unadjusted advances as opening payment entries.
  7. Opening ledger balances. Create a Journal Entry with Is Opening set to Yes for all other balances (bank, cash, loans, capital, duties, fixed assets if not entered as assets). Do not repeat debtor, creditor or stock totals that other opening documents already create. ERPNext uses a Temporary Opening account to balance opening entries; it should be zero when everything is posted.
  8. Opening stock. Create a Stock Reconciliation with the opening stock purpose, listing item, warehouse, quantity and valuation rate as on the cut-over date. Add batch or serial numbers if you track them. For many items, import the rows.
  9. Parallel run. For a few weeks after cut-over, enter daily sales, purchases and payments in both systems, or at least compare daily totals. Match sales, purchase, cash, bank and stock figures every few days. Once two cycles match and the team is comfortable, stop using Tally for new entries.

Frappe's Tally Migrator app

Frappe has a tally_migrator repository on GitHub. Its README describes a guided wizard that reads a Tally Masters XML export and creates parties, items, accounts, warehouses and opening balances in ERPNext, with a reconciliation report. It also lists limits: it focuses on masters and opening balances rather than historical transactions, and says it is built and tested for ERPNext v16 and TallyPrime. Check the repository's current status, supported versions and open issues, and always test it on a copy of your site before relying on it.

Check your work

CheckERPNext reportCompare with Tally
Books balanceTrial Balance on the cut-over dateTrial Balance on the same date
Customer duesAccounts ReceivableBill-wise outstanding, Sundry Debtors
Supplier duesAccounts PayableBill-wise outstanding, Sundry Creditors
StockStock Balance (quantity and value)Stock Summary by godown
Clean-upTemporary Opening account balanceShould be zero

Common mistakes

  • Trying to import years of Tally vouchers. It is slow, error-prone and rarely needed; keep Tally for history.
  • Importing parties without cleaning duplicates and GSTINs, which breaks GST returns later.
  • Entering debtors both in the opening journal and through opening invoices, which doubles the balance.
  • Opening stock with a zero valuation rate, which makes margins and stock value wrong.
  • Choosing a mid-month cut-over date, which makes GST returns harder to match.
  • Skipping the parallel run, so mistakes are found only at month-end.

Who does what

TaskUsually done by
Agree cut-over date and sign off balancesOwner and accountant
Export from Tally and clean dataAccounts team with the implementer
Import masters and opening entriesImplementer, on the test site first
Parallel run and daily comparisonAccounts and stores team

Keep a simple migration log: what was imported, from which file, on which date, and who checked it. It saves hours when someone asks why a balance looks different.

Manufacturer? After migration, continue with setting up manufacturing.

Sources

Written from the official documentation and source code below. Menus and fields can differ between versions, so check the docs for your version.

Planning ERPNext or a Frappe app for your business? See our ERPNext implementation and Frappe development services, or talk to us.
ERPWork app icon
ERPWork: ERPNext on your phoneFree Android app for your ERPNext site: check in with location, approve documents, see sales and stock dashboards and get notifications.

Get it on Google PlayLearn more →