How is opening Work-in-Progress (WIP) stock handled during migration?

Opening WIP stock is one of the most complex aspects of manufacturing migration. PS Digitise handles this via Stock Reconciliation in ERPNext — each semi-finished item at each production stage is entered at its valuation rate (typically raw material cost + processing cost to date). The corresponding accounting entry debits WIP inventory and credits the opening equity/capital account. This must be reconciled against the Tally Trial Balance before go-live.

What data is migrated from Tally to ERPNext for a manufacturing company?

From Tally: Chart of accounts, customer master, supplier master, item master (raw materials, finished goods), warehouse structure, opening stock balances (warehouse-wise, item-wise with valuation), outstanding sales invoices, outstanding purchase invoices, outstanding advance payments. Built fresh in ERPNext (not migrated from Tally): BOM (Tally has no BOM), Work Orders (Tally has no production module), subcontracting structure, GST tax templates, HSN codes, print formats.

What is a Trial Balance reconciliation in Tally to ERPNext migration?

Trial Balance reconciliation is the step where we compare the opening Trial Balance in ERPNext (after all data migration) against the closing Trial Balance in Tally for the same date — line by line, rupee by rupee. Every account must match. If there is any difference, we identify and fix the discrepancy before go-live. PS Digitise does not go live until the Trial Balance matches exactly — zero difference, every time. This is the most critical quality gate in the entire migration process.

Tally to ERPNext Migration for Indian Manufacturers 2026 — Complete Step-by-Step Guide

Q: How long does Tally to ERPNext migration take for a manufacturing company?

For a manufacturing company, Tally to ERPNext migration typically takes 8–12 weeks for Phase 1 (accounting, inventory, purchasing, GST). The manufacturing modules — BOM, Work Orders, MRP, subcontracting — go live 4–6 weeks after Phase 1. This is longer than a trading company migration because of the additional BOM setup, WIP stock valuation, and production workflow configuration. Rushing the migration is the single biggest risk factor — companies that compress timelines almost always face reconciliation problems post-go-live.

Q: Can BOM and production data be migrated from Tally to ERPNext?

Tally does not have a native BOM module — so there is no BOM data to migrate from Tally itself. BOMs are typically maintained in Excel, paper records or the production team's memory. During ERPNext migration, BOMs are built fresh in ERPNext from these source documents. The PS Digitise team assists with BOM structuring — identifying finished goods, sub-assemblies and raw materials, setting quantities and UOM — as part of the manufacturing implementation scope.

Q: When is the best time to migrate from Tally to ERPNext?

The best time is April 1 — the start of the Indian financial year. Your Tally books are fully closed and audited, opening balances are clean, and there are no split-year complications. The second-best option is October 1 (half-year end). Quarter-end (July 1, January 1) is acceptable. Mid-year or mid-quarter migrations are strongly discouraged — partial period data split across two systems creates reconciliation nightmares. Start the implementation 8–10 weeks before your target go-live date.

Quick Answer

Migrating a manufacturing company from Tally to ERPNext is different from migrating a trading or services company.

Manufacturing adds BOM setup, opening WIP stock valuation, subcontracting challan carryover and production workflow configuration that Tally simply does not have. The migration takes 8–12 weeks for Phase 1 (accounting + inventory + GST) and an additional 4–6 weeks for Phase 2 (BOM + Work Orders + MRP + subcontracting). PS Digitise includes Tally migration free in every ERPNext implementation — Trial Balance reconciled to zero before go-live, every time.

₹0Tally migration cost — included free

8–12 wksPhase 1 go-live timeline

ZeroTrial Balance difference — guaranteed

Apr 1Best cutover date — FY start

Why Manufacturing Migration is Different from Trading Migration

Most Tally to ERPNext migration guides are written for trading or services companies — chart of accounts mapping, opening balances, outstanding invoices and you're done. Manufacturing migration has five additional layers that trading migration does not:

BOM setup — Tally has no Bill of Materials module. BOMs live in Excel, paper or the production manager's head. They must be structured and entered fresh in ERPNext.
Opening WIP stock — semi-finished goods at various production stages have to be valued and entered in ERPNext with correct accounting entries
Item master complexity — raw materials need UOM (kg, metre, litre, piece), reorder levels, valuation method (FIFO vs Moving Average) and warehouse assignment configured correctly
Subcontracting challan carryover — material already at job workers at migration date must be entered in ERPNext's subcontracting module with correct dates
Production routing and operations — work centres, operations and production timings need to be configured before Work Orders can be raised

📌 This blog vs our general migration guide

PS Digitise has a general Tally to ERPNext migration guide at /blogs/tally-erpnext-migration. This blog covers the manufacturing-specific steps that go beyond that general guide — BOM entry, WIP valuation, subcontracting carryover and production workflow setup. Read both if you are a manufacturer.

What Tally Has — and What it Doesn't

Before planning your migration, it's important to understand exactly what data exists in Tally vs what needs to be built fresh in ERPNext:

Data Type	In Tally?	Migration Approach
Chart of accounts / ledger masters	✓ Yes	Map to ERPNext account tree. Export from Tally, restructure, import.
Customer master (name, address, GSTIN)	✓ Yes	Export from Tally, clean duplicates, import via ERPNext Data Import tool.
Supplier master	✓ Yes	Same as customer — export, clean, import.
Item master — finished goods	✓ Partial	Tally has item names and HSN codes. UOM, reorder levels, BOM linkage — add in ERPNext.
Item master — raw materials	✓ Partial	Tally has names and rates. Valuation method, UOM, reorder level, warehouse — configure in ERPNext.
Opening stock balances	✓ Yes	Stock Reconciliation in ERPNext — item-wise, warehouse-wise, with valuation rate.
Outstanding sales invoices	✓ Yes	Opening Invoice Creation Tool in ERPNext. Customer-wise, invoice-wise.
Outstanding purchase invoices	✓ Yes	Opening Invoice Creation Tool — supplier-wise, invoice-wise.
Bill of Materials (BOM)	✗ No	Build fresh in ERPNext from Excel/paper records. Requires production team input.
Work Orders / Production data	✗ No	No historical WO to migrate. Enter opening WIP via Stock Reconciliation.
Subcontracting challans (open)	✗ No	Enter manually in ERPNext Subcontracting module with original challan dates.
Work centres and operations	✗ No	Set up fresh — cutting, welding, assembly, painting etc. with standard times.
GST tax templates / HSN mapping	⚠ Partial	HSN codes in Tally. Tax templates and GST settings must be configured in ERPNext + India Compliance app.

When to Migrate — The Most Important Decision

The single most important decision in the entire migration is when to cut over. For manufacturing companies this is even more critical than for trading companies because of WIP stock:

April 1 — best option. Start of the Indian financial year. Tally books are fully closed and audited. Opening balances are clean. No WIP stock complications if you plan production to clear WIP before cutover.
October 1 — acceptable. Half-year end. Tally half-year closing done. Second best option.
July 1 or January 1 — possible but harder. Quarter-end. WIP stock more likely. Requires careful valuation.
Mid-month or mid-quarter — avoid. Creates split-period reconciliation nightmares.

✅ Pro Tip — Clear WIP Before Cutover

If possible, plan production in the 2–3 weeks before migration cutover to complete or close all open Work Orders. A factory with zero open Work Orders at migration date has a significantly cleaner migration than one with 40 partially-completed jobs. If you cannot clear WIP, value it carefully — see Phase 1, Step 7 below.

Migration Phases — 12-Week Plan for Manufacturers

Weeks 1–2Pre-migration

Data audit, account mapping, BOM collection

Export all Tally data. Build chart of accounts mapping in spreadsheet. Collect BOMs from production team — even if they're in Excel or handwritten. Clean customer/supplier master (remove duplicates, fix GSTINs). This is the foundation — rushed prep = failed migration.

Weeks 3–4ERPNext setup

Company setup, masters, India Compliance app

Create company in ERPNext, configure fiscal year, GST settings, payment terms, warehouses. Import customer and supplier masters. Import item master. Configure India Compliance app — GSTIN, e-invoice settings, HSN codes, tax templates.

Weeks 5–6Opening data

Opening balances, stock, invoices, WIP

Enter opening stock via Stock Reconciliation (raw materials + finished goods + WIP). Enter outstanding sales and purchase invoices via Opening Invoice Creation Tool. Enter opening subcontracting challans. Enter Journal Entry for other opening balances.

Week 7Reconciliation

Trial Balance reconciliation — zero difference required

Run Trial Balance in Tally and in ERPNext for the same cutover date. Compare line by line. Every account must match. Fix every difference before proceeding. PS Digitise does not sign off until zero difference is confirmed.

Weeks 8–9BOM & production

BOM entry, work centres, operations, routing

Enter all BOMs in ERPNext — finished goods first, then sub-assemblies, then raw materials. Configure work centres (Cutting, Welding, Assembly, QC) with standard operation times. Set up costing — labour rate per hour, overhead allocation method.

Weeks 10–11Parallel run

Both systems running — daily reconciliation

Enter all new transactions in both Tally and ERPNext simultaneously. Reconcile daily. This catches configuration gaps before full go-live. Most manufacturers find 2–4 issues in this phase that would have been costly to fix after.

Week 12Go-live

Go-live — Tally switched off for new transactions

ERPNext becomes the system of record. Tally kept read-only for historical reference. Full training completed. All users live on ERPNext for sales, purchase, inventory and production.

Phase 1 — Accounting, Inventory and GST (Steps 1–8)

Export Data from Tally Prime / ERP 9

From Tally, export: Chart of Accounts (all groups and ledgers), Customer master, Supplier master, Stock Item master, Closing Stock report (item-wise, warehouse-wise with rates), Outstanding Receivables, Outstanding Payables, Trial Balance as of cutover date. Export format: Excel. If using Tally Prime, use Data Export feature. For Tally ERP 9, export via Tally Data Exchange (TDL).

Build Chart of Accounts Mapping

Tally uses a flat ledger structure under Groups (Capital Account, Current Assets, Current Liabilities, etc.). ERPNext uses a hierarchical 4-level structure: Root (Asset/Liability/Income/Expense) → Account Type → Account → Sub-account. Build a mapping spreadsheet before touching ERPNext. Key mappings:

Tally: Sundry Debtors → ERPNext: Accounts Receivable (individual Customer sub-ledgers auto-created)
Tally: Sundry Creditors → ERPNext: Accounts Payable (individual Supplier sub-ledgers auto-created)
Tally: Stock-in-Hand → ERPNext: Stock Assets (linked to inventory)
Tally: Manufacturing WIP → ERPNext: Work In Progress (Current Asset)

Configure ERPNext Company, Fiscal Year and GST

Create your company in ERPNext. Set fiscal year (April 1 – March 31 for most Indian manufacturers). Configure currency (INR). Then install and configure the India Compliance app — add your GSTIN(s), enable e-invoice for applicable turnover, configure HSN code defaults, set up CGST/SGST/IGST tax templates for your most common tax rates (5%, 12%, 18%, 28%).

Import Item Master — Manufacturing-Specific Fields

Import all items using ERPNext's Data Import tool with the Item CSV template. For manufacturing companies, configure these fields that Tally does not have:

Item Type: Raw Material, Semi-Finished Goods, Finished Goods (critical for BOM and Work Orders)
Default UOM: kg, metre, litre, piece, box — must match how you issue material in production
Valuation Method: FIFO (recommended for most manufacturers) or Moving Average
Default Warehouse: Stores, Production WIP, Finished Goods — assign each item to its default warehouse
Reorder Level and Quantity: triggers purchase requests automatically when stock falls below this level

Import Customer and Supplier Masters

Import via ERPNext Data Import tool. Required fields: name, GSTIN, address (with state code for GST), payment terms, credit limit, price list. Clean duplicates from Tally before importing — duplicate customer records in Tally are common and create reporting problems in ERPNext. For suppliers, add supplier type (Raw Material, Service, Subcontractor) to enable filtered reports.

Enter Opening Stock via Stock Reconciliation

From Tally's Closing Stock report, enter opening stock in ERPNext via Stock → Stock Reconciliation. Enter item, warehouse, quantity and valuation rate for every item. This is item-wise and warehouse-wise — if you have 3 warehouses in Tally, enter stock for each warehouse separately. The Stock Reconciliation creates a stock entry that debits inventory and credits the Opening Balance Equity account.

Enter Opening WIP Stock — Manufacturing-Specific

This is the step that makes manufacturing migration harder than trading migration. For each semi-finished item at each production stage:

Identify WIP items: List every partially-completed job — item name, quantity, stage of completion (e.g., 200 Gear Blanks at CNC stage, 100 Housings at assembly stage)
Value WIP: Raw material cost + processing cost to date. E.g., Gear Blank Cast Iron @ ₹240 + CNC turning @ ₹85 = ₹325/piece
Enter via Stock Reconciliation: Create a semi-finished goods item in ERPNext for each WIP stage. Enter quantity and WIP valuation rate. Warehouse: Production WIP.
Accounting entry: Debits WIP Inventory (Current Asset), Credits Opening Equity. This must be reconciled against your Tally WIP balance.

Enter Outstanding Invoices and Opening Journal Entries

Outstanding sales invoices (receivables from customers as of cutover date): use Accounts → Opening Invoice Creation Tool → Sales Invoice. Enter each invoice with customer, amount, due date and GST details. Outstanding purchase invoices (payables to suppliers): same tool, Purchase Invoice type. Other outstanding items — advance payments, bank balances, loan accounts, fixed assets — enter via Accounts → Journal Entry with Is Opening: Yes.

ERPNext v16

Accounts › Reports › Trial Balance — Opening as of 01-Apr-2026

Opening Trial Balance — 01 April 2026 Balanced ✓

Total Debit

₹1,84,32,450

Total Credit

₹1,84,32,450

Difference

₹0.00 ✓

Matches Tally TB

Confirmed ✓

Account	Opening Debit	Opening Credit
Raw Material Stock	₹38,42,000	—
Work In Progress	₹12,18,500	—
Finished Goods Stock	₹24,80,000	—
Accounts Receivable	₹62,41,200	—
Accounts Payable	—	₹41,28,600
Bank — HDFC Current	₹18,42,000	—

Download Excel Compare with Tally Print

⚠️ Non-Negotiable — Zero Trial Balance Difference Before Go-Live

After completing Steps 1–8, run the Trial Balance in both Tally and ERPNext for the same cutover date and compare them line by line. Do not proceed to Phase 2 until every account matches exactly — zero difference. PS Digitise does not sign off on any migration until this is confirmed. A ₹1 difference today becomes a ₹10L reconciliation problem in 6 months.

Phase 2 — Manufacturing Modules (Steps 9–13)

Phase 2 begins after Phase 1 is live and the Trial Balance is reconciled. Your accounting, inventory, purchasing and sales are running in ERPNext. Now you add the manufacturing layer.

Set Up Work Centres and Operations

Before entering BOMs, configure your production infrastructure in ERPNext:

Work Centres: each machine or workstation — CNC Machine 1, Welding Bay 2, Assembly Line A, QC Station. Set capacity (hours per day), operating cost per hour, overhead allocation.
Operations: the processes performed at each work centre — CNC Turning, MIG Welding, Final Assembly, Dimensional Check. Set default work centre and standard time per operation.
These are used in BOMs to calculate production cost and in Job Cards to track actual vs standard time.

Enter Bill of Materials — The Most Important Step

BOM entry is the most time-consuming and most important step in Phase 2. There is no Tally data to import — BOMs are built fresh in ERPNext.

Collect source documents: engineering drawings, Excel BOM sheets, product specification sheets, production manager's notes. For each finished goods item:
→ List every raw material / component required, with quantity and UOM
→ List every sub-assembly (and create sub-assembly BOMs first)
→ List every operation at each work centre with standard time
→ Set BOM rate (auto-calculated from raw material rates + operation cost)

Entry sequence: Always enter sub-assembly BOMs before the parent finished goods BOM. ERPNext validates that sub-assembly items have their own BOMs before allowing a multi-level BOM to be saved.

ERPNext v16

Manufacturing › Bill of Materials › BOM-GEAR-ASSY-001

BOM-GEAR-ASSY-001 — Gearbox Assembly Standard Active Multi-Level

Finished Item

Gearbox Assembly — Standard

Quantity / UOM

1 Nos

BOM Cost (RM)

₹4,820 per unit

Operation Cost

₹680 per unit

Item	Type	Qty	UOM	Rate	Amount
Gear Blank Cast Iron	RM	1	Nos	₹240	₹240
CNC Turned Shaft	Sub-Assy	1	Nos	₹1,840	₹1,840
SKF Bearing 6205	RM	2	Nos	₹380	₹760
Gear Housing Casting	RM	1	Nos	₹1,980	₹1,980

Explode Multi-Level Create Work Order Print BOM

Enter Open Subcontracting Challans

Material already at job workers on your migration cutover date must be entered in ERPNext's subcontracting module. For each open challan:

Create a Subcontracting Order in ERPNext with the original PO date.
Create a Stock Entry (Send to Subcontractor) with the original challan date — this moves material from your store to the job worker's virtual warehouse in ERPNext's stock ledger.
The challan number is entered in the stock entry reference field.

This step is essential for ITC-04 compliance — your quarterly return will be incorrect if open challans are not entered with their original dates and values.

Configure MRP and Production Planning Settings

Configure ERPNext's MRP and production planning before your first Work Order:

Delivery lead time per item: how many days before delivery date should production start
Safety stock: minimum stock level for finished goods and key raw materials
Supplier lead time: how many days each supplier typically takes — used by MRP to set PO date
Production capacity: available hours per day per work centre

These settings drive the MRP engine — without them, the Material Requirements Planning report generates incorrect procurement suggestions.

Training — Production Team, Stores, Accounts

Manufacturing migration requires more training than trading migration — more roles, more workflows. PS Digitise's standard training for manufacturers:

Day 1 — Accounts team: Sales invoicing, purchase bills, GST e-invoice, GSTR-1, bank reconciliation, financial reports
Day 2 — Stores team: Material receipt (GRN), stock transfer, stock reconciliation, reorder alerts, warehouse reports
Day 3 — Production team: Work Orders, Job Cards, material issue to production, subcontracting PO and receipt, quality inspection
Day 4 — Management: Dashboards, MRP report, profitability by item, receivables ageing, production variance report

Tally Manufacturing Journal vs ERPNext Work Order

Most manufacturing teams that use Tally track production through Manual Vouchers or Manufacturing Journals in Tally. Here is how those concepts map to ERPNext:

Tally Concept	ERPNext Equivalent	What Changes
Manufacturing Journal (RM issue)	Work Order → Material Transfer	ERPNext creates a Stock Entry automatically — no manual journal needed
Manufacturing Journal (FG receipt)	Work Order → Finish Production	ERPNext receives finished goods into stock and auto-posts COGM to accounts
Delivery Challan (to job worker)	Subcontracting Order → Stock Entry: Send to Subcontractor	ERPNext also auto-generates the Delivery Challan and e-Way Bill
Production cost journal entry	Work Order close → COGM auto-posted	No manual journal — ERPNext calculates and posts actual vs standard cost automatically
Stock Journal (adjustments)	Stock Reconciliation or Stock Entry	ERPNext tracks every adjustment with reason code — full audit trail
Godown transfer entry	Stock Entry: Material Transfer	Same concept — from warehouse to warehouse with stock ledger update

Common Manufacturing Migration Mistakes — And How to Avoid Them

Mistake 1: Starting BOM entry before item master is complete

BOMs reference raw material and finished goods items. If the item master is incomplete or has incorrect UOMs, the BOM will save incorrectly and cause material issue errors later. Always complete and verify the item master before starting BOM entry.

Mistake 2: Entering all opening stock in one warehouse

If you have a Stores warehouse, Production WIP warehouse and Finished Goods warehouse, opening stock must be entered in each warehouse separately. A common mistake is entering everything in "Stores" — which then shows wrong reorder calculations and incorrect production reports from day one.

Mistake 3: Not entering open subcontracting challans

If you skip entering open challans at migration, your ITC-04 for the first quarter after migration will be wrong — materials that were already sent to job workers won't appear in Table 4. This can cause a GST mismatch that is painful to rectify after filing.

Mistake 4: Going live before the parallel run

The 2-week parallel run where both Tally and ERPNext run simultaneously is not optional. Every manufacturing client who has skipped the parallel run has found a configuration error within the first month of live operation that took significantly longer to fix than the 2 weeks they saved. Do the parallel run.

Mistake 5: Training only accounts — not production team

In Tally, only the accounts team uses the system. In ERPNext, the stores team, production supervisors, quality inspectors and purchase managers all use ERPNext daily. Training only accounts and expecting production to learn on the job leads to incorrect Work Orders, wrong material issues and stock discrepancies from week one.

Case Study · Process Manufacturer

200 Employees Live on ERPNext in 10 Weeks — Trial Balance Matched Tally to the Rupee

10 wks

Tally to ERPNext go-live — 200 employees

₹0

Trial Balance difference at go-live

4 days

Month-end close time (was 18 days)

"PS Digitise ran a full Trial Balance reconciliation — every figure matched Tally before they handed over. 200 employees were live on ERPNext in 10 weeks. Zero data loss. Month-end closing went from 18 days to 4 days in the first cycle. We had no idea the system could be this complete."

Venkat · Finance Director · Process Manufacturer, India · 200 employees

Frequently Asked Questions

How long does Tally to ERPNext migration take for a manufacturing company? +

For a manufacturing company, Phase 1 (accounting, inventory, GST, purchasing, sales) takes 8–12 weeks. Phase 2 (BOM, Work Orders, MRP, subcontracting, quality control) goes live 4–6 weeks after Phase 1. Total: 12–18 weeks for a complete manufacturing ERP including parallel run and training. Rushing the migration is the single biggest risk factor.

Can BOM and production data be migrated from Tally? +

Tally does not have a BOM module — so there is no BOM data to migrate from Tally. BOMs are typically maintained in Excel, paper records or the production team's memory. During ERPNext migration, BOMs are built fresh in ERPNext from these source documents. PS Digitise assists with BOM structuring — finished goods, sub-assemblies and raw materials — as part of the manufacturing implementation scope.

How is opening WIP stock handled during migration? +

Opening WIP is entered via Stock Reconciliation in ERPNext — each semi-finished item at each production stage entered at its valuation rate (raw material cost + processing cost to date). The accounting entry debits WIP Inventory and credits Opening Equity. This must be reconciled against the Tally WIP balance before go-live. Best practice: plan production to complete or minimise WIP before migration cutover date.

Is Tally migration included free in PS Digitise's ERPNext implementation? +

Yes. Tally migration — chart of accounts, customer/supplier masters, item master, opening balances, outstanding invoices and Trial Balance reconciliation — is included at no extra cost in every PS Digitise ERPNext implementation. Historical transactions beyond 1 year and data cleansing for inconsistent Tally data may attract a small additional charge discussed upfront in the scope document.

When is the best time to migrate from Tally to ERPNext? +

April 1 is the best cutover date — start of the Indian financial year. Tally books are fully closed, opening balances are clean. October 1 (half-year end) is the second-best option. Mid-year or mid-quarter migrations are strongly discouraged — partial period data split across two systems creates reconciliation problems. Start the implementation 8–10 weeks before your target April 1 go-live.

What is Trial Balance reconciliation in Tally migration? +

Trial Balance reconciliation is the step where we compare the opening Trial Balance in ERPNext against the closing Trial Balance in Tally for the same cutover date — line by line, rupee by rupee. Every account must match. PS Digitise does not go live until zero difference is confirmed. A small difference at go-live compounds into major reconciliation problems within months.

What does ERPNext give a manufacturer that Tally cannot? +

Tally is an excellent accounting tool. ERPNext adds the manufacturing layer Tally cannot provide: multi-level BOM with Phantom BOM support, MRP (demand-driven purchase planning from Sales Orders), Work Orders with Job Cards and actual vs standard cost tracking, Subcontracting module with ITC-04 auto-preparation, Quality Control with 3-stage inspection, real-time production dashboards. All integrated with the same accounting, inventory and GST — one system, zero re-entry.

Planning to migrate from Tally to ERPNext for your manufacturing company?

PS Digitise includes Tally migration free in every ERPNext manufacturing implementation — chart of accounts, item master, opening stock, WIP valuation, outstanding invoices and Trial Balance reconciled to zero. Fixed price from ₹1,75,000. 8-week Phase 1 go-live. No surprises.

Fixed price · Tally migration included · 8-week Phase 1 go-live · ERPNext software ₹0

PS Digitise LLP — Certified Frappe Partner

This guide is written by the PS Digitise implementation team based on real Tally to ERPNext migrations for manufacturing companies across India. Every migration we complete includes a Trial Balance reconciliation signed off before go-live.
Contact: sales@psdigitise.com · +91 9677 174 743

Tally to ERPNext Migration —Step-by-Step Guide forIndian Manufacturers 2026