In this guide · 9 sections
- When the balance sheet does not tally after mapping, the difference almost always comes from one of six places: the TB itself, the mapping, the profit transfer, closing stock, debit / credit signs, or rounding.
- First prove the trial balance: total debits equal total credits, with no "Difference in opening balances" or suspense ledger quietly absorbing the gap.
- A difference equal to the year's profit or to the closing stock points straight at the cause. A difference that is twice an amount usually means one item sits on the wrong side.
- Negative balances need judgement, not just a sign: a bank overdraft is a short-term borrowing, a creditor in debit is an advance — classify them by nature under the Schedule III heads rather than leaving them as negative assets or liabilities.
- Under Schedule III (as amended by G.S.R. 207(E)), rounding is compulsory and depends on total income; round line by line and the casting can be out by a few units — fix it deliberately, not with a plug.
Try SignReady: Map the TB through the client's Tally groups — and see only the ledgers that need a decision.
Start freeYou have the trial balance from Tally, every ledger is mapped to a Schedule III head, the draft is ready — and the balance sheet is out by ₹3,46,218. Or it balances, but the total assets do not agree with anything in the TB. Finding a difference like this by scrolling through four hundred ledgers wastes an evening. In practice the difference nearly always hides in one of six places, and the amount of the difference itself is often the best clue to which one. Here is where to look, in the order that finds it fastest.
1. The trial balance itself is not balanced
Mapping cannot create a balanced balance sheet from an unbalanced trial balance. Before looking at the mapping, prove the TB:
- Total debits equal total credits in the file you actually uploaded — not in the TB you saw on screen in Tally. Exports can drop rows, merge cells or lose the Dr / Cr side when they pass through CSV.
- Difference in opening balances. Tally shows a "Difference in opening balances" line when the opening balances entered in the company do not agree — common after a data split, a migration or a manual opening entry. That line is a real number in the TB and has to be traced, not mapped to "Other current liabilities".
- Suspense ledgers. A suspense or "difference" ledger with a balance is the same problem, renamed. Ask the client what it holds before you map it anywhere.
- Opening balances against last year's closing. If this year's opening does not agree with last year's signed balance sheet, ledger by ledger, the difference flows straight into this year's statements.
2. Ledgers unmapped, or mapped twice
Once the TB balances, every rupee in it must land in exactly one line of the statements. Two things break that:
- Unmapped ledgers — usually new ledgers created during the year, ledgers renamed since last year, or ledgers under a group the client created ("Debtors - Pune", "Misc Exp 2025-26"). A tool or a spreadsheet that silently drops anything it does not recognise will leave the balance sheet short by exactly those balances.
- Double counting — a group total and the ledgers under it both picked up, which happens when a TB is exported with both group subtotals and ledgers and the subtotal rows are not removed. The statements are then overstated by the group's balance.
The fastest test: total the mapped amounts by Schedule III head and compare the grand total with the TB total. If the mapped total is less than the TB, look for unmapped ledgers; if it is more, look for subtotal rows.
3. Profit not carried to Reserves and Surplus
The trial balance contains last year's closing surplus as the opening balance of the Profit and Loss account — not this year's profit. This year's profit exists only once the income and expense ledgers are closed off. If the draft picks up the P&L ledger's opening balance but not the profit for the year, the balance sheet will be out by exactly the profit (or loss) for the year.
Check that the movement in surplus in the Reserves and Surplus note equals the profit in the Statement of Profit and Loss, after any appropriations. Where there are accumulated losses, Schedule III requires the debit balance of the Statement of Profit and Loss to be shown as a negative figure under "Surplus", and the total of Reserves and Surplus to be shown even if the result is negative — not moved across to the assets side as the old Schedule VI required.
SignReady places every ledger through the client's own Tally groups, lists only the ledgers it placed by default or guessed from the name, and FinalCheck compares the finished statements with the trial balance — balancing, note totals and key figures.
4. Closing stock entered outside the books
In many Tally companies, closing stock is not a ledger balance in the trial balance. The TB carries the opening stock (a debit, part of last year's figures), while closing stock is either computed from inventory or entered as a figure that appears in Tally's Profit and Loss account and Balance Sheet, not in the ledgers you export.
Closing stock has two sides: an asset (Inventories) and a credit in the Statement of Profit and Loss (through changes in inventories). If the figure is added to one side only, the balance sheet will be out by exactly the closing stock. If it is added to both, check that it is the same figure as the Tally Balance Sheet or the stock statement the client signed — and that next year's opening stock will agree with it.
5. Debit and credit signs, and contra items
Mapping by group places a ledger by where it sits in Tally, not by the side of its balance. So a ledger can end up with a sign its head does not expect:
| Ledger | What happens if it is mapped by group | Where it usually belongs |
|---|---|---|
| Bank account in credit (overdraft or cash credit) | A negative figure inside Cash and cash equivalents | Short-term borrowings — loans repayable on demand from banks |
| Creditor in debit (advance paid, excess payment) | Trade payables reduced by the debit | An advance to a supplier — under loans and advances or other current assets |
| Debtor in credit (advance received) | Trade receivables reduced by the credit | An advance from a customer — under other current liabilities |
| Tax ledgers (GST input / output, TDS) with opposite balances | Netted inside one head | Recoverable balances as assets, payable balances as liabilities |
Two things go wrong here. First, if the mapping treats every balance in a head as the same sign — for example, adding a bank overdraft's credit to the asset side as a positive amount — the balance sheet goes out by twice that balance. That is why half the difference is worth searching for. Second, even when the sign is right and the balance sheet tallies, netting a debit creditor against trade payables understates both assets and liabilities and distorts the trade payables ageing and the MSME disclosure. It is worth regrouping these balances to the right side, at least where they are material.
Contra items — netted or shown gross
A related but separate question: should two balances be shown net at all? Common examples in small-company files are a party who is both a customer and a supplier, a loan to and from the same director, or the GST input and output ledgers. The balance sheet tallies either way — netting changes both sides by the same amount — but the totals by head will not agree to a TB that you or the client have analysed gross. When a head total does not agree with the TB and the balance sheet still balances, look for netting before anything else. Division I has no general offsetting rule of the kind in Ind AS 1, but the safer presentation is gross — the receivable and the payable under their own heads, as the Schedule III heads and the ageing schedules expect — unless there is a legal right of set-off, with a note in the file of any balance you did net, and why.
6. Rounding and units
Since the 2021 amendment to Schedule III (G.S.R. 207(E)), rounding is compulsory in Division I — the word "may" became "shall" — and the unit depends on total income, not turnover:
| Total income | Round off to the nearest |
|---|---|
| Less than ₹100 crore | Hundreds, thousands, lakhs or millions, or decimals thereof |
| ₹100 crore or more | Lakhs, millions or crores, or decimals thereof |
Once a unit is chosen, it must be used uniformly across the statements and notes. Rounding each line separately means the rounded lines will not always add to the rounded total — a difference of one or two units in ₹ lakhs is a rounding difference, not an error. Two practical habits: do the arithmetic in rupees and round only at the presentation stage, and adjust any casting difference into the largest figure in the note rather than adding a "rounding" line. If one figure is 10, 100 or 1,000 times what it should be (a difference of 9, 99 or 999 times the correct figure), a unit has been mixed — for example, one note in thousands while the rest are in lakhs.
How to find the difference fast
Before opening individual ledgers, let the amount of the difference tell you where to look:
| If the difference is… | Look first at… |
|---|---|
| Equal to the Difference in opening balances or a suspense ledger | The TB itself (section 1) |
| Equal to the profit or loss for the year | The transfer to Reserves and Surplus (section 3) |
| Equal to closing stock | Inventories and changes in inventories (section 4) |
| Half of it equals a single ledger balance | That ledger on the wrong side (section 5) |
| Equal to one ledger or one Tally group | Unmapped or double-mapped ledgers (section 2) |
| Exactly divisible by 9 | A transposed figure (₹54,320 typed as ₹45,320) or a figure with a digit slipped (₹4,500 as ₹45,000) — typical of manual adjustments added to the draft |
| A few units in the last digit | Rounding (section 6) |
If none of these matches, compare totals by head: put the mapped TB total for each Schedule III head next to the figure on the face of the statements. The head that does not agree is where the difference lives, and you are now searching twenty ledgers instead of four hundred. Then, before signing, re-run the comparison on the final TB: the client's last few entries are the usual reason a draft that balanced in May is out in September.
Try SignReady: FinalCheck the statements against the trial balance before signing.
Start freeFrequently asked questions
Why does my balance sheet not tally after mapping the trial balance?
Usually because of one of six things: the trial balance itself is not balanced (a difference in opening balances or a suspense ledger), ledgers are unmapped or counted twice, the profit for the year has not been carried to Reserves and Surplus, closing stock has been added on one side only, a negative balance is on the wrong side, or rounding and units are inconsistent.
What does it mean if the difference is divisible by 9?
A difference that is exactly divisible by 9 is typical of a transposition (two digits swapped, such as 54 typed as 45) or a slide (a figure entered with a digit too many or too few). Look at amounts typed by hand — adjustments, closing stock, provisions — before anything else.
Should a bank overdraft be shown as a negative bank balance?
No. Under Schedule III, Division I, short-term borrowings include loans repayable on demand from banks. A bank account with a credit balance under an overdraft or cash credit facility is a borrowing and is shown under that head, not as a negative figure in cash and cash equivalents.
Is rounding off compulsory under Schedule III?
Yes, for Division I since the amendment by G.S.R. 207(E) with effect from 1 April 2021. With total income below ₹100 crore, figures are rounded to the nearest hundreds, thousands, lakhs or millions (or decimals thereof); at ₹100 crore or more, to the nearest lakhs, millions or crores (or decimals thereof). The same unit must be used throughout.
Where is a debit balance in the Profit and Loss account shown?
Schedule III requires the debit balance of the Statement of Profit and Loss to be shown as a negative figure under "Surplus" in Reserves and Surplus, and the total of Reserves and Surplus to be shown even if it is negative.
Sources
- Schedule III amendment — G.S.R. 207(E), 24 March 2021 (Gazette)
- ICAI — Guidance Note on Division I – Non Ind AS Schedule III to the Companies Act, 2013 (Revised January 2022)
In SignReady, the mapping is remembered for the client, the revised TB compare shows only what changed, and FinalCheck reads the final Excel statements against the TB before the Partner signs off. First 3 finalisations free.
Version history: 7 Oct 2026 — first published.
