Reconciliation is the moment of truth: does what the bank says match what your books say? When it works, it is a five-minute formality. When it does not, it can swallow an afternoon as you hunt for a single rupee.
This article lays out a clean reconciliation method and then diagnoses the five usual culprits behind a reconciliation that refuses to tie out - so you can fix the cause, not just chase the symptom.
The goal of reconciliation, stated simply
Reconciliation proves that every transaction on the bank statement appears in Tally exactly once, and that nothing in Tally is missing from or contradicts the statement. The closing balance per the bank, adjusted for timing differences (uncleared cheques, deposits in transit), should equal the closing balance per your books.
If those two numbers agree, you are done. If they do not, the difference is your treasure map.
A clean step-by-step method
Work the statement top to bottom against Tally's bank ledger. Discipline beats cleverness here.
- Set the same date range on both the statement and the Tally bank ledger.
- Confirm the opening balances agree before you start (if not, last period was not closed cleanly).
- Tick off each statement line against its matching Tally entry.
- List statement lines with no match in Tally - these are missing entries to post.
- List Tally entries with no match on the statement - these are errors or uncleared items.
- Reconcile the closing balance, adjusting only for genuine timing differences.
Pro tip
Always reconcile against the running balance column, not just the transactions. The balance is an independent check that catches a missed or duplicated line instantly.
Why reconciliation breaks - the five usual suspects
When the numbers will not agree, it is almost always one of these. Check them in order; the cheapest to fix are first.
1. Contra misclassified as Payment/Receipt
A transfer between the client's own accounts booked as a normal payment or receipt double-counts the money and throws both the bank ledger and the cash position off. This is the number-one cause. See our guide to Tally voucher types for the fix.
2. Duplicate entries
The same transaction entered twice - often when a statement is imported on top of manual entries already made. Your running-balance check is the fastest way to spot it.
3. Wrong dates
A transaction posted to the wrong date lands in the wrong period and silently breaks period-end reconciliation even though the amount is correct.
4. Bank charges and interest not booked
Small amounts the bank debits/credits directly are easy to skip and add up to a stubborn small difference. Build a rule so they are always captured.
5. Sign or amount errors
A debit booked as a credit, or a transposed amount (4,500 entered as 5,400), produces a difference that is often a clean multiple of 9 - a classic transposition tell.
Important
If your difference is divisible by 9, suspect a transposition error before anything else. It is the most common arithmetic mistake in manual entry.
Preventing breaks at the source
Most reconciliation pain is created at entry time, not reconciliation time. If the original bank entries are complete, correctly classified, and dated right, reconciliation becomes the five-minute formality it should be.
This is the strongest argument for automating the entry step: a tool that reads the full statement, classifies Contra correctly, and never duplicates or transposes removes four of the five failure modes above before you ever open the reconciliation screen.
Conclusion
Reconciliation is not hard; it is unforgiving. A disciplined top-to-bottom method against the running balance, plus a quick scan for the five usual suspects, resolves almost every break.
Better still, fix it upstream: when Greenote posts your bank entries it classifies Contra correctly and never duplicates or transposes, so reconciliation just works. Start a free trial and reconcile on the first try.
Read next: what each Tally import error actually means, and why entries end up in Suspense when the ledger name does not match.
Turn bank statements into Tally vouchers offline
Greenote reads 100+ Indian banks and posts clean vouchers straight into Tally, fully on your PC. No uploads, no cloud, no manual entry.
7-day free trial, no card required. Works with Tally Prime & ERP 9.