Skip to main content
Symptom · 6 min read

Why Is My Trial Balance Not Tallying? Common Causes and How to Find the Difference

A trial balance that does not tally is out by a fixed amount because an entry was posted to one side only, on the wrong side, twice, or with digits swapped. Find the exact difference first, then test it against a few known patterns.

Terra Insight
Terra Insight Editorial Team Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 14 October 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops
Knowledge Card
Problem

Total debits and total credits in the trial balance differ by a fixed amount, and the accountant does not know where to look.

How It's Resolved

Find the exact difference, then test it: halve it for a wrong-side posting, divide by 9 for transposed digits, and search for an entry of that amount posted to one side only.

Configuration

Ledger-wise trial balance, opening balance check, search by amount in the day book, and a suspense account only as a temporary step.

Output

The specific entry that caused the difference, a rectification entry, and a trial balance that tallies with no Difference in Opening Balances line.

A trial balance that does not tally is out by a fixed amount. That amount comes from an entry posted to one side only, posted on the wrong side, posted twice on one side, or written with digits swapped. The fastest way to find it is to work out the exact difference first, then test that number against a few known patterns.

The likely causes

CauseWhat happenedClue in the difference
One-sided postingOnly the debit or only the credit was postedDifference equals the entry
Wrong-side postingA debit was posted as a credit, or the reverseDifference is double the entry
Transposed digits4,100 written as 1,400Difference is divisible by 9
Balance carried or totalled wronglyA ledger total or carried-forward figure miscalculatedOften a round figure such as ₹1,000 or ₹10,000
Opening balances do not net to zeroOpening debits and credits entered unequallyShows as Difference in Opening Balances in Tally

In fully integrated software such as Tally or Zoho Books, every voucher is balanced before it is saved, so the transaction-level causes mostly appear in manual books, Excel trial balances, imported data and opening balances.

Worked example: a ₹2,700 difference

Your trial balance shows debits of ₹14,62,700 and credits of ₹14,60,000. The difference is ₹2,700 on the debit side.

  1. Search for ₹2,700 itself. Look in the day book or ledgers for any entry of exactly ₹2,700 that may have been posted to one side only. Suppose none is found.
  2. Halve it. ₹2,700 divided by 2 is ₹1,350. Look for a ₹1,350 entry posted on the wrong side. A ₹1,350 credit wrongly posted as a debit would push debits up by ₹2,700 relative to credits.
  3. Divide by 9. ₹2,700 divided by 9 is ₹300, a whole number, so a transposition is possible. Swapping two digits that are 3 apart in the thousands and hundreds places produces exactly this gap. For example, a credit of ₹4,100 entered as ₹1,400 understates credits by ₹2,700 (₹4,100 less ₹1,400).
  4. Check each candidate. Compare the ledger postings for ₹1,350 and ₹1,400 entries with their source vouchers until you find the one that does not match.

Once found, pass a rectification entry, not an overwrite, so the correction is traceable.

Why does Tally show a “Difference in Opening Balances” line, and why should it not stay?

When you create ledgers in Tally with opening balances, for example after moving from another software or starting a new company, the opening debits and credits must be equal. If they are not, Tally shows the gap as Difference in Opening Balances on the balance sheet.

Common reasons:

  • A ledger’s opening balance was entered on the wrong side (Dr instead of Cr).
  • Some opening balances, such as closing stock or a loan, were not entered at all.
  • The previous year’s closing figures were copied from an unaudited or wrong trial balance.

The line should be cleared, not left in place. It means last year’s closing balance sheet and this year’s opening books disagree, so the difference must be traced to the source and corrected.

Is it acceptable to park the difference in a suspense account to finish the month?

As a temporary step, yes. Many accountants post the difference to a suspense account so that the month’s reports can be prepared while the search continues. But a suspense account is a holding area, not an answer.

Your auditor will ask what makes up the balance, when each part arose and when it was cleared. A suspense balance still sitting there at 31 March, the year end, is treated as an unexplained difference. Clear it within the month wherever possible.

Even a tallying trial balance can hide errors

A trial balance that tallies is not the end of the check. Omissions, wrong-account postings and duplicates leave it balanced. Many of these come from carelessness rather than lack of knowledge: a slip of the finger, a copied row, a missed bill.

Primary reference: ICAI (The Institute of Chartered Accountants of India) — whose study material covers errors affecting the trial balance and their rectification.

Frequently Asked Questions

Why does my trial balance not tally?
Usually because an entry was posted to one side only, posted on the wrong side, posted with the wrong amount on one side, or a balance was carried forward or totalled wrongly. Opening balances that do not net to zero are another common cause.
What does it mean if the difference is divisible by 9?
A difference divisible by 9 often points to transposed digits, such as 4,100 written as 1,400, or a slide in the decimal place. It is a clue, not proof.
Why should I halve the difference?
If an entry was posted on the wrong side, for example credited when it should have been debited, the trial balance is out by twice the entry. Halving the difference gives the amount to search for.
What is Difference in Opening Balances in Tally?
Tally shows this line when the opening balances entered for ledgers do not have equal debits and credits. It usually means an opening balance is missing, wrong or on the wrong side, and it should be cleared, not left on the balance sheet.
Can I put the difference in a suspense account?
As a short-term step you can park it in a suspense account so work can continue, but it must be investigated and cleared. Auditors will ask what it contains, and a balance left unexplained at the year end is a red flag.

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.