ERPNext Accounting Consultant, India

From Tally groups and cost categories to an ERPNext account tree

Tally organizes accounts into groups and ledgers, with cost categories and cost centers for analysis, and Indian finance teams usually have years of habits built around them. ERPNext's structure is similar enough to make mapping natural, but different enough that copying Tally line by line wastes the opportunity.

My design keeps three layers distinct:

• The account tree follows the statutory balance sheet and profit and loss format your CA uses, so the financial statements need little regrouping at year end. Sundry debtors and creditors become customers and suppliers, with control accounts in the tree.
• Cost centers carry plants, branches, divisions or projects that management holds to budget. Tally cost categories often map here.
• Accounting dimensions carry extra analysis such as product line, sales region or channel, and can be made mandatory on income and expense accounts.

Ledgers created in Tally only to separate party types or locations usually collapse into fewer accounts with a cost center or dimension, which makes reports easier to read. I document each old group and ledger against its new account, cost center or dimension in a mapping sheet your CA reviews before setup. The general mechanics are on the ERPNext accounting page, and the requirement work behind it follows my business analysis approach.

GST accounts, input credit matching and the review with your CA

In current ERPNext releases, India-specific GST features come from a separate compliance app, as my ERPNext page for India explains. Whichever version you run, the ledger design is the part that decides whether returns and set-offs can be traced.

I set up, for each GSTIN, separate accounts for central, state and integrated tax on outputs and inputs, plus accounts for reverse charge liabilities and any cess that applies. Tax templates and tax categories then choose intra-state or inter-state treatment from the place of supply. Item tax templates hold rates by HSN or SAC group, so users rarely pick tax manually.

Each month, with your CA or accounts team, I recommend a fixed review:

1. Compare outward supplies in ERPNext with the return data prepared from it, including credit notes and amendments.
2. Reconcile purchase invoices with the data suppliers have reported, using the compliance app's reconciliation tools where your version provides them, and follow up mismatches before claiming credit.
3. Check that reverse charge entries carry both liability and credit.
4. Agree GST ledger balances with the electronic ledgers on the portal before the payment is made.

Credit that has to be reversed or blocked is posted to its own account, so the trail is clear. The rules on eligibility and timing belong to your CA; the ledger simply makes every figure verifiable.

TDS, TCS, UPI receipts and bank reconciliation

Indian payables carry withholding on almost every contractor, professional and rent payment. ERPNext handles TDS through tax withholding categories linked to suppliers. Each category holds the applicable rate and threshold, and deductions post to a liability account on the purchase invoice or payment. With your CA, I confirm which categories you need, how lower deduction certificates and supplier PAN status are recorded, and how the liability is reconciled before each deposit. TCS on sales, where it applies, is set up the same way on the customer side.

Receipts in India arrive through many channels: UPI, NEFT and RTGS transfers, checks, and payment gateways that settle in batches net of charges. For gateway and UPI aggregator settlements, I route receipts through a clearing account per provider, so each settlement and its charges clear that account and anything left over shows a missing refund or fee.

Statement files from Indian banks are imported and cleared line by line against receipts, payments and journals. Live bank feeds depend on an integration for your bank, which I test rather than assume. Payment reconciliation clears customer advances against invoices, and process statement of accounts can send customers their ledger statements on a schedule. My finance automation page explains how these routines fit together.

Multi-state branches, plants and group companies

Indian businesses often combine a head office, plants and depots in several states and a few related companies. ERPNext can hold all of this, but the structure has to follow legal and GST reality.

• Several GSTINs under one legal entity usually sit in one ERPNext company, with each registration as a company address, its own naming series and its own GST accounts. Plants and depots become cost centers and warehouses.
• Separate legal entities become separate companies on the same site, each with its own account tree and statutory reports.
• Transfers between branches in different states are taxable supplies, so they run as invoices between the registrations rather than as plain stock transfers, with the matching input credit on the receiving side.
• Group companies trading with each other use internal customer and supplier records, so one entity's sale produces the other's purchase, with loans and recharges posted as inter-company journals.

Related-party transactions deserve their own tagging, because your auditor will ask for them. ERPNext can produce a consolidated statement across companies for management; statutory consolidation, where required, is normally prepared by your CA from entity trial balances. The multi-company ERP page explains the structural choices, and ERPNext manufacturing in India covers how plant costing feeds these books.

Tally opening balances, period locks and the audit file

The cleanest move from Tally starts at the beginning of a month, ideally after a GST return has been filed, and often at the start of the financial year so the full year sits in one system. The loading sequence I use:

1. Translate each Tally group and ledger into its new home, then post the last Tally trial balance as one opening journal.
2. Load bill-wise outstanding balances as individual opening invoices for customers and suppliers, so aging and payment matching continue.
3. Bring across fixed assets with gross block, accumulated depreciation and remaining life.
4. Load opening stock by godown, now warehouse, through stock reconciliation, and agree it to the stock ledger.
5. Check that the temporary opening account is empty and that GST and TDS liabilities match the last returns filed.

After each GST period is filed, I lock it through an accounting period or the frozen accounts date. Indian companies also face audit trail expectations for their accounting software, so I check with your CA how ERPNext's document version history and your role settings meet them.

At year end, a period closing voucher closes profit and loss to reserves. The audit file typically includes the trial balance, ledger detail, aged balances, the fixed asset register, GST and TDS reconciliations, related-party listings and inter-company confirmations. The legacy software migration page describes the wider method.

When ERPNext Accounting is not enough in India

ERPNext accounting suits many Indian businesses, but these situations usually lead me elsewhere:

• Accounting-only needs. A small trader that mainly needs GST billing and books may be better staying on Tally or using a lighter accounting product.
• No owner for the compliance app. ERPNext and the GST compliance app have to be updated and tested together. Without someone responsible, returns can break quietly.
• Listed or large groups with heavy reporting. Formal consolidation, segment reporting and demanding audit committee requirements often suit a finance-led ERP.
• A CA firm that only works inside Tally. If your auditors and accountants will not work from ERPNext reports, the change cost is real.
• Payroll at large scale across states. Statutory payroll for big workforces often stays on a specialist product linked to ERPNext by journal.

For businesses in these situations, I would rather recommend staying put or choosing another product than force a fit. The GST, TDS and Tally migration scenarios can be tested on Odoo Accounting in India or Zoho Books for Indian companies just as easily. The ERP consultant page for India explains how that evaluation stays neutral, and the India hub describes remote engagement.