Bank Reconciliation for Small Business India: Why Your Books and Bank Statement Never Match — And How to Fix It

Last month a client called us in a panic. His Tally showed ₹4,82,000 in his current account. His HDFC bank statement showed ₹4,61,000. Same account, same month, same period. And a difference of ₹21,000 — he had no idea where it went. No fraud. No mistake whatsoever. It was just three cheques he had issued that had not cleared yet, and two bank charges he had forgotten to record. That is a classic bank reconciliation statement problem. And it happens in almost every small business in India — every single month. The bank reconciliation statement is the one document that tells you exactly why your books and your bank do not agree, and what you need to do about it. So this guide explains what it is, why mismatches happen, and exactly how to prepare one — even if you have never done it before.

What Is a Bank Reconciliation Statement?

A bank reconciliation statement is a document that compares your business’s cash book balance with the balance shown on your bank statement — and explains every difference between the two. That is it. Simple concept — but it catches a surprising number of problems. But it catches a surprising number of problems.

Your cash book (or Tally ledger) records transactions when you make them. Banks, however, record them only when they actually clear. And these two things do not always happen on the same day. For example, a cheque you issued on March 28 may only clear on April 3. Similarly, a bank charge applied on March 31 may not be in your books yet. So at any point in time, the two balances will almost never be identical. That is completely normal. So the bank reconciliation statement documents this gap, confirms there is no actual error or fraud, and brings both records into agreement.

Why Your Books and Bank Reconciliation Statement Never Match — 7 Real Reasons

Most small business owners assume a mismatch means something went wrong. Usually it does not — and that is the important thing to understand first. Here are the seven most common reasons your bank reconciliation statement shows a difference — and which ones are normal versus which ones need attention.

1. Cheques Issued But Not Yet Cleared — Bank Reconciliation Timing Difference

Here is a common example. You issued a cheque to your vendor on March 29. You recorded it in Tally immediately. But your vendor deposited it on April 2 — after your bank statement period ended. So your cash book shows the payment. Your bank statement does not. In accounting, this is called an outstanding cheque or unpresented cheque. It is the most common reason for a mismatch. Completely normal. It will appear in the bank statement next month.

2. Deposits Made But Not Yet Credited

Similarly, you deposited cash or a cheque on March 31. You recorded it in your books the same day. But the bank credited it on April 1 — the next working day. Your cash book shows the deposit. But the bank statement does not. Again, this is called a deposit in transit or outstanding deposit. Again — normal. It shows up in April’s statement.

3. Bank Charges Missing From Books — A Common Reconciliation Gap

Also, your bank deducts charges every month — SMS alerts, account maintenance fees, NEFT charges, cheque book fees, GST on bank services. They appear on your bank statement. But nobody entered them in Tally. So your bank balance is lower than your cash book balance — by exactly those charges. This is a bookkeeping gap, not a fraud. But it still needs to be fixed by recording those entries.

4. Interest Credited by Bank

Sometimes your current account earns interest last quarter. The bank credited it directly. Nobody noticed. It is sitting in the bank statement but missing from your cash book. So now your bank balance is higher than your books. Small amount — sometimes ₹200, sometimes ₹2,000. But it still needs to be recorded. Ignoring it means your books are understating income.

5. ECS or Auto-Debit Payments Not Recorded

Then there is the auto-debit situation. You set up auto-debit for your business loan EMI, insurance premium, or software subscription. The bank deducts it automatically every month. But your accountant did not record it — because there was no invoice or manual entry trigger. So these silent deductions cause a recurring mismatch every month until someone catches them during reconciling bank statements.

6. Cash Book Errors That Break Your Bank Reconciliation

And then there are plain errors. A payment of ₹15,400 entered as ₹14,500 in Tally. A transposition error — swapping digits. These happen. Especially when entries are made in a hurry at month end. The bank reconciliation statement catches these because the numbers simply will not add up no matter how you adjust for timing differences.

7. Bounced Cheques — The Reconciliation Catch Most Businesses Miss

Finally, you received a cheque from a customer, deposited it, and recorded the income. But the cheque bounced three days later. The bank reversed the credit. Your books still show the receipt. The bank balance drops by that cheque amount. Without a monthly bank reconciliation statement, this kind of reversal goes unnoticed — and you might even mark the invoice as paid when the money never actually came.

Bank Reconciliation Statement Format — What It Actually Looks Like

Now, there are two formats for a bank reconciliation statement. Most Indian businesses use the balance per bank statement format — starting with the bank balance and working towards the cash book balance. Here is what it looks like:

Particulars	Amount (₹)
Balance as per Bank Statement (31 March 2026)	4,61,000
Add: Deposits in transit (recorded in books, not yet in bank)	18,000
Less: Outstanding cheques (issued but not yet cleared)	(39,000)
Adjusted Bank Balance	4,40,000
Balance as per Cash Book (Tally)	4,82,000
Less: Bank charges not recorded in books	(3,200)
Less: ECS loan EMI not recorded in books	(38,800)
Adjusted Cash Book Balance	4,40,000 ✅

So both adjusted balances match at ₹4,40,000. That is what a correctly prepared bank reconciliation statement looks like. The differences are fully explained. No unexplained gaps remain.

How to Prepare a Bank Reconciliation Statement — Step by Step

Now the bank reconciliation process is the same whether you are doing it manually, in Excel, or in Tally. Follow these steps every month — ideally within the first week of the next month.

Step 1 — Get Both Statements for the Same Period

First, download your bank statement for the month — most banks allow PDF or Excel download from net banking. Open your cash book or Tally bank ledger for the same period. Both must cover exactly the same dates — no exceptions. If your accounting period is April to March, do the reconciliation month by month — not at year end. Doing it annually is a bookkeeping disaster waiting to happen.

Step 2 — Match Transactions One by One

Next, go through both statements side by side. Tick off every transaction that appears in both — same date, same amount, same description. What remains unticked after this exercise becomes your reconciling item list. These are the differences you need to explain. Specifically, nothing on this list should stay unexplained. Most businesses use a printed bank statement and tick off matching entries with a pen — old method, but it works perfectly.

Step 3 — Classify Each Difference

Then for each unticked item, decide which category it falls into. Is it a timing difference — a cheque issued but not cleared, or a deposit not yet credited? These are normal timing differences and require no immediate action. Or is it a missing entry — a bank charge, interest, or ECS payment not in your books? These need to be recorded in Tally immediately. Or is it an error — a wrong amount entered somewhere? These need correction entries.

Step 4 — Record Missing Entries to Fix Your Reconciliation

Now, every item that appears on the bank statement but is missing from your books needs a journal entry in Tally. Bank charges — debit bank charges account, credit bank account. Interest received — debit bank account, credit interest income. ECS payments — debit the relevant expense or liability, credit bank account. So do not skip this step. These are real transactions that have already happened — your books are incomplete without them.

Step 5 — Prepare the Bank Reconciliation Statement

After that, prepare the formal bank reconciliation statement. Start with the bank statement closing balance. Add deposits in transit. Subtract outstanding cheques. That gives you the adjusted bank balance. Then start with your cash book closing balance, add or subtract any remaining adjustments, and arrive at the adjusted cash book balance. Both should match. If they do not, go back and find what was missed. Do not move forward until the numbers agree completely. If they do not match, something is still missing.

Step 6 — File and Follow Up

Finally, save the completed bank reconciliation statement — physically or digitally — as part of your monthly closing records. Follow up on old outstanding cheques. If a cheque you issued three months ago still has not cleared, call the vendor. It may be lost or the vendor may have an issue. Similarly, if a cheque you deposited two months ago never hit your bank account, follow up with your bank immediately. Old uncleared items on a reconciliation are red flags.

Bank Reconciliation Statement in Tally — How It Works

Interestingly, Tally has a built-in bank reconciliation feature that most small businesses in India completely ignore. Here is how to use it. Go to Gateway of Tally → Banking → Bank Reconciliation. Select your bank account and the date range. Tally shows you all entries in your bank ledger on one side. Against each entry, enter the date it appears on your bank statement. After that, Tally automatically calculates outstanding cheques and deposits in transit and generates the bank reconciliation statement for you.

Moreover, Tally Prime allows you to import bank statements directly — download the statement from net banking in Excel or CSV format, import it into Tally, and the software auto-matches transactions. What once took two hours manually now takes under 20 minutes. If you are still doing bank reconciliation manually in Excel, upgrading to Tally Prime’s auto-import feature is worth the time investment to set up.

How Often Should You Prepare a Bank Reconciliation Statement?

Monthly. Non-negotiable — and that is the short answer. For businesses with high transaction volumes — retail, e-commerce, trading — weekly reconciliation is better. Daily reconciliation is ideal if your business processes more than 20 to 30 bank transactions per day.

Unfortunately, many small business owners do bank reconciliation only at year end — during the audit. That is a mistake and a costly one. By then you have 12 months of transactions to sort through. Old outstanding cheques that have expired. Months of unrecorded bank charges piling up. Errors that have compounded. What takes 30 minutes monthly takes three days at year end. And it still might not be accurate.

Also, monthly bank reconciliation protects you from fraud. If an employee is diverting payments or making unauthorised transactions, monthly reconciliation catches it within 30 days. But annual reconciliation catches it after 365 days — by which time the damage is much larger.

Bank Reconciliation Statement vs Passbook — What Is the Difference?

A passbook or bank statement is just the bank’s record of your account — what went in, what went out, the closing balance. It is a one-sided view. The bank reconciliation statement is the bridge between your own records (cash book or Tally) and the bank’s records — it shows both sides and explains the difference. You cannot do a reconciliation using only the bank statement. You need both the bank statement and your own books.

When the Bank Reconciliation Statement Shows a Difference That Will Not Resolve

Sometimes both adjusted balances simply will not match — no matter what you do. That usually means one of three things. First, a transaction is missing from one side entirely — not just timing, but completely absent. Second, a duplicate entry exists — the same payment recorded twice in Tally. Third, there is a bank error — the bank debited or credited your account incorrectly.

Bank errors are rare but real — and they do happen. So if you find a transaction on your bank statement that you did not authorise and cannot explain — raise a dispute with the bank immediately. Most banks have a 30 to 90 day window to investigate and reverse unauthorised transactions. Beyond that window, recovering the money becomes very difficult. Monthly bank reconciliation protects you by catching these issues well within the dispute window.

Should You Outsource Your Bank Reconciliation Statement?

If your business has multiple bank accounts, high transaction volumes, high transaction volumes, or an in-house accountant who is stretched thin — yes, outsourcing monthly bookkeeping bank reconciliation makes sense. In fact, a professional bookkeeper does reconciliation faster, catches issues a busy in-house team might miss, and provides clean monthly closing reports that you can actually use to make business decisions.

In fact, the cost of outsourcing monthly bookkeeping — including bank reconciliation — is almost always lower than the cost of one undetected fraud, one missed payment, or one incorrect GST return filed based on wrong books. Clean, reconciled books every month also make your year-end audit dramatically faster and cheaper.