How to Classify Ledgers in Tally for ICAI-Compliant Financial Statements
Map Tally's 28 default groups to the ICAI prescribed heads - Capital, Borrowings, Trade Payables, PPE - plus the edge cases teams get wrong.
Why mapping is the whole job
Tally does not know about the ICAI Guidance Note. It organises every ledger under one of its predefined groups — there are 28 of them, 15 primary and 13 sub-groups — and those groups were designed for bookkeeping, not for presentation. Producing a compliant financial statement is therefore, at its core, a translation exercise: taking each Tally group and deciding which prescribed head it belongs under. Get the mapping right once and the statement builds itself; get it wrong and no amount of formatting will fix a misclassified ledger.
The liability side
Tally's Capital Account maps to Owners' funds — but partner current accounts, often parked here, may need to be shown separately depending on whether the firm uses the fixed or fluctuating capital method. Loans (Liability) splits in two: secured and unsecured term loans become Long-term Borrowings, while the portion repayable within twelve months moves to Current Liabilities as the current maturity. Current Liabilities in Tally is a catch-all that has to be decomposed — Sundry Creditors become Trade Payables, Duties & Taxes become Statutory Dues under Other Current Liabilities, and any Provisions are presented on their own line.
The asset side
Fixed Assets maps to Property, Plant and Equipment, with the depreciation block disclosed in a movement schedule. Investments splits into non-current and current depending on intent and tenure. Current Assets decomposes into Inventories, Trade Receivables, Cash and Cash Equivalents, and Short-term Loans and Advances. Misc. Expenses (Asset) — the old deferred-revenue-expenditure bucket — is largely disallowed under current accounting standards and usually has to be written off rather than carried.
The edge cases that actually bite
- Sundry Creditors are not all trade payables. Creditors for capital goods belong under Other Current Liabilities, and creditors for expenses are separated from creditors for goods. Lumping all three together overstates trade payables and distorts working-capital ratios.
- Loans & Advances (Asset) must be split into current and non-current, and advances to suppliers separated from staff advances and statutory balances like GST input credit.
- Bank Overdraft / Cash Credit sits under Current Assets in many Tally files because the account is operated like a bank account. It is a short-term borrowing, not cash, and showing it as a negative bank balance understates both borrowings and cash.
- Duties & Taxes can be a net debit (input credit receivable) or net credit (output payable). The sign decides whether it lands on the asset or liability side — never assume.
- Suspense and unadjusted entries must be cleared before finalisation, not mapped. A balance in Suspense is a sign the books are not closed.
Let the mapping learn
The single biggest time saver is to stop re-deciding the same ledger every year. Once your firm confirms that "ICICI OD A/c" is a short-term borrowing for a given client, that decision should carry forward automatically to the next period and inform similar ledger names across other clients. This is exactly the kind of repetitive, rules-plus-judgement classification that an AI-assisted workflow handles well: it proposes the mapping from history and the prescribed heads, flags only the genuinely ambiguous ledgers for review, and leaves the final call with the chartered accountant. The result is a Balance Sheet that ties on the first attempt instead of after three rounds of chasing a rounding difference.