Tally to ERPNextWhat we move, rebuild and leave behind
Move after cleanup
  • Parties
  • Items
  • Opening balances
  • Open invoices
  • Stock
Rebuild
  • Chart of accounts
  • Approvals
  • Reports
  • Print formats
Leave behind
  • One ledger per party
  • Tally customisations
  • Negative stock
  • Manual spreadsheets
In short
  • Parties, items, opening balances, open invoices and stock move, after cleanup.
  • The chart of accounts, approvals, reports and print formats are rebuilt.
  • One ledger per party, Tally customisations, negative stock and manual spreadsheets are left behind.
  • Projects take 4 to 24 weeks. Loading the data is a small part of that; the biggest delays are unclear pain points and no internal ERP team.

Why do teams leave Tally for ERPNext?

Teams usually leave Tally because they have grown, not because of price. Tally costs little compared with integrated systems.

Once a company has a few branches or departments, Tally ends up as a standalone accounting tool, with sales, procurement, inventory and HR kept in spreadsheets beside it. At that point teams need approval workflows, role-based access, mobile access and real-time reporting in a single system.

The second reason is integration. Connecting e-commerce, field sales apps or banks to Tally usually needs add-ons or manual re-entry.

ERPNext is business software that runs accounting, inventory, sales, purchasing, manufacturing, HR and CRM in one application.

What did a real Tally to ERPNext migration look like?

We recently moved the Bangladesh operation of an FMCG multinational from Tally to ERPNext. The group is present in more than 40 countries.

The case at a glance Client not named
  • 40+countries where the group is present
  • 1legal entity, with a factory and several depots
  • 200+users
  • ~90,000sales invoices a month
  • ~5 croreBDT of transactions a month on average (about 15 crore a quarter)
  • ~2,500GL accounts in Tally before the move

Sales were not simple. Primary sales are made at the depots. The client also wanted to track secondary sales, which go through dealers and distributors, and distributor stock. It wanted to see both channels together, without booking the secondary sales in its own accounts.

In Tally, sales invoices were handled mostly by hand, because Tally cannot push sales or distributor stock in real time.

Three things Tally could not prevent
  1. Duplicate customer codes
  2. Sales booked before production on the same day
  3. Rounding in pricing rules

ERPNext now handles all three with validations.

What do we move, rebuild and leave behind?

Almost nothing stays unchanged. Parties, items, opening balances, open invoices and stock move after cleanup. The chart of accounts, approvals, reports and print formats are rebuilt. One ledger per party, Tally customisations, negative stock and manual spreadsheets are left behind.

Clients often expect custom reports and bill-wise outstanding balances to carry over automatically. They do not.

ItemDecisionWhat we did
Customers and suppliersRebuildIn Tally a party is a ledger. In ERPNext it is a separate master linked to a control account. We merged duplicate ledgers and mapped the parties that were both customer and supplier.
Chart of accountsRebuildThe client had about 2,500 GL accounts because every party had its own ledger. We rebuilt the chart around a small set of control accounts.
Opening balancesMove after reconcilingReceivables and payables had been calculated by hand, so we reconciled them before cutover.
Open invoicesMove one by oneEach open invoice comes in individually, so that ageing and payment matching work.
StockMove after reconcilingTally allows negative stock and inconsistent valuation. ERPNext blocks negative stock unless that is switched on in its stock settings.
Voucher numbersClean upWe resolved the duplicates carried over from Tally.
ApprovalsBuild newTally has no real approval mechanism, so we built multi-level workflows routed by amount and nature.
Reports and print formatsRebuildFamiliar Tally reports and Tally Definition Language customisations are rebuilt, with Excel and PDF formats.
Manual spreadsheetsLeave behindReplaced by real-time secondary sales and distributor stock.
Old processes copied as they areLeave behindMoving the same process to a new ERP does not fix the pain point.
What we decided for each item in this migration.

Why did the chart of accounts have to be rebuilt?

In Tally every customer and supplier is a ledger, so the client’s chart of accounts had grown to about 2,500 GL accounts. In ERPNext a party is a separate master linked to a control account, so we rebuilt the chart around a small set of control accounts.

Before, in Tally
About 2,500 GL accounts

One ledger for every party.

After, in ERPNext
Control accountsA small set
Customersseparate master
Suppliersseparate master

Parties are no longer ledgers. Each one is a master record linked to a control account.

The chart of accounts before and after. The grid has 2,500 squares, one for each account.

Should you migrate your history or open with balances?

Either works, and history is not an obstacle to moving. We generally encourage bringing history across, because it gives you more visibility and year-on-year comparison inside ERPNext. It is also more work.

Option 1

Open with balances

Load opening balances at a cutover date. Less work, but past transactions stay outside ERPNext.

Option 2 Generally encouraged

Bring your history

Bring past transactions across for more visibility and year-on-year comparison inside ERPNext. More work: each past transaction is remapped to the new chart of accounts and masters.

Who does the remapping?

  • You do it, using our templates. This costs you less.
  • Our team does it. We quote this separately, based on how much history you bring over.

How long does a Tally to ERPNext migration take?

4 to 24 weeks, depending mainly on your operational structure. Very little of that time goes into loading data.

Most of it goes into understanding your business, designing new processes and configuring ERPNext. The rest goes into data cleanup, user training and validation.

Where the time goes
  • Most of the timeUnderstanding your business, designing new processes, configuring ERPNext
  • The restData cleanup, user training, validation
  • Very littleLoading data
Illustrative: the bar shows the order of size, not measured percentages.

Clients now also ask for process automation and AI features, which adds design time.

The main delays are on the client side. Pain points are often unclear, and there is rarely a formal in-house ERP team to handle requirements, decisions and sign-off.

What changes after go-live?

Improves first

Stock, receivables, bank balance and budget positions at each branch, in real time, without waiting for consolidated reports.

Feels slower at first

Data entry. People are very fast on the Tally keyboard, so ERPNext forms and approval steps feel slow for the first few weeks.

Schedule user training before go-live.

How do you start, and what should you bring to the first meeting?

  1. Record your pain points and how each process works today.
  2. Audit Tally for duplicate ledgers, duplicate vouchers and negative stock.
  3. Redesign the chart of accounts and party masters.
  4. Design processes, approvals and reports.
  5. Load masters, then opening balances and open invoices.
  6. Reconcile, train users and go live.

Bring this to the first meeting

  • The problems you want solved in each module
  • A clean SOP of your current processes, step by step
  • A note of the blocker in each process, in your Tally setup or legacy tools
  • A named internal ERP owner who will work with your implementation partner

With these, both sides see the same picture from the start, and agreeing an action for each issue is easier.

Book a 30-minute call (opens in a new tab) ↗Sunday to Thursday, 3 to 5 pm Dhaka time (GMT+6). Or see MonstarERP.

Frequently asked questions

What is ERPNext?

ERPNext is business software that brings accounting, inventory, sales, purchasing, manufacturing, HR and CRM together in one application. It has no licence fee, but implementation and support cost money.

Is there a tool to migrate from Tally to ERPNext?

ERPNext has its own data import tools. They do not clean your data, so you need to clean and reconcile it first.

Can Tally be integrated with ERPNext?

Migration tools import an exported file once. They do not keep the two systems in sync. If you need both systems during a transition, discuss it separately with your implementation partner.

How do you get started with ERPNext?

Decide what you need, then choose where to run it: Frappe Cloud, a third-party host or your own server. Set up your company, train your staff and start recording, module by module.

Will my accounts team be slower at first?

Yes, for the first few weeks, because keyboard entry in Tally is very fast.