A bank reconciliation statement explains the gap between the balance in your cash book and the balance on your bank statement. You prepare it by adjusting your books for anything the bank knew about first, then listing the timing differences that have not caught up yet.
In the sets of accounts we see, this is the check owners skip for months and then need urgently. It is usually the week an auditor or a lender asks for it. The gap is almost never fraud, and almost always four or five ordinary items nobody posted.
Below are the six steps, a worked example that ties to the rupee, and what to do when the two figures still refuse to agree.
Key Takeaways
- Adjust the cash book first, then bridge only the timing gaps.
- The adjusted cash book balance is what goes into your accounts.
- Unpresented cheques and uncleared deposits cause most of the difference.
- Bank charges, interest and auto-debits are book errors, not timing gaps.
- Reconcile monthly. Yearly means tracing a difference through twelve months.
What a Bank Reconciliation Statement Actually Does
It is a working, not a ledger account. Nothing in it gets posted anywhere. Its only job is to prove that two independently kept records of the same money can be explained against each other.
That independence is what gives it value. Your cash book is written by your own team, while the bank statement is written by somebody with no interest in your figures being right. A bank reconciliation is one of the few checks in bookkeeping that tests your records against an outside source.
The books themselves are not optional. The Companies Act, 2013 requires companies to keep proper books of account on an accrual basis. A cash figure nobody has reconciled is a weak claim to have done that.
Why Your Books and Your Bank Never Match
Five things cause almost every difference you will meet. Knowing which kind you are looking at tells you whether to adjust the books or simply wait.
| What Causes the Gap | Example | Fix |
|---|---|---|
| Timing on payments out | Cheque issued, not yet presented | Wait; show in the reconciliation |
| Timing on payments in | Cheque or transfer deposited, not yet cleared | Wait; show in the reconciliation |
| Bank knew first | Charges, interest, auto-debits, dishonoured cheques | Post to the cash book |
| Someone mis-keyed | Wrong amount or wrong side in either record | Correct the record that is wrong |
| Money that never arrived | Failed transfer, wrong account number | Trace it, then adjust |
The first two sort themselves out. The third is where most small businesses lose the thread. A bank charge of ₹1,062 debited on a Sunday sits unrecorded until somebody reads the statement.
Card and digital collections add a layer of their own, since money often lands a day or two later and net of fees. That is the same mismatch behind card and UPI payment reports that never agree with the day’s sales figure.
A retail counter taking card payments all day sees one lump credit against dozens of separate bills. Reconcile that against the settlement report, not against individual sales, or you will be matching figures that were never meant to line up.
The 6 Steps to Prepare a Bank Reconciliation Statement
Work through these in order. Skipping step two is what turns a twenty-minute job into an afternoon.
- Fix the date and gather both records. Pick a closing date, usually the month end, and take the cash book balance and the bank statement balance on that same date. A reconciliation across two different dates cannot tie.
- Tick off everything that matches. Go line by line through the statement against your general ledger bank account. Mark both sides. What remains unticked on either side is your entire working list, and it is usually shorter than people fear.
- List the bank’s entries that are missing from your books. Charges, interest credited, standing instructions, loan instalments and dishonoured cheques all start life on the statement. So do failed collections that were reversed after you had already recorded the receipt.
- List your entries that are missing from the bank. These are cheques you issued that nobody has presented, and deposits you made that have not cleared. Neither is an error. Both are just the clearing cycle running slower than your bookkeeping.
- Post the step three items to your cash book. This is the part people leave out. Those items are not timing differences at all. They are entries you simply had not made, and each needs a journal entry like any other transaction. After posting, you have an adjusted cash book balance.
- Build the statement and prove it. Start from the adjusted cash book balance, add back unpresented cheques, subtract uncleared deposits, and you should land exactly on the bank statement balance. If you do, the month is reconciled.
One note on step three. If a customer’s transfer failed and the money left their account without reaching yours, their bank has to reverse it without being asked. The RBI’s turnaround time framework sets the deadline and requires ₹100 a day in compensation when the reversal runs late.
A Worked Bank Reconciliation Example
Take a Surat textile wholesaler closing the month on 30 September (an example, using illustrative figures).
| Line in the Reconciliation | Amount (₹) |
|---|---|
| Balance as per cash book | 4,86,300 |
| Less: bank charges not yet recorded | 1,062 |
| Add: interest credited by the bank | 3,847 |
| Adjusted cash book balance | 4,89,085 |
| Add: cheques issued but not presented | 62,400 |
| Less: cheques deposited but not cleared | 1,18,500 |
| Balance as per bank statement | 4,32,985 |
Read the two halves differently. The charges and interest changed the business permanently, so they stay. The unpresented cheques and uncleared deposits will disappear on their own once the clearing cycle catches up.
The same statement runs in reverse if you prefer. Start at the bank balance of ₹4,32,985, add back the ₹1,18,500 of uncleared deposits, then subtract the ₹62,400 of unpresented cheques. You land on ₹4,89,085 again. Textbooks ask for that direction more often than owners ever need it.
What to Do When the Statement Still Will Not Match
If the two sides refuse to agree, the shape of the difference usually points at the cause before you start hunting.
Halve it first. A difference of exactly twice some amount you recognise means an entry went in on the wrong side. Post that ₹3,847 of interest as a debit instead of a credit and you are out by ₹7,694, not ₹3,847.
If the difference divides by nine, two digits were probably transposed. A receipt of ₹4,617 keyed as ₹4,167 leaves you ₹450 adrift, and 450 divides by 9 exactly. That is the same arithmetic trick that helps when a trial balance will not tally.
Then check the opening balance. Say last month reconciled and this one will not, and the difference has been sitting there since day one. That points at a closing figure carried forward wrongly, not at anything that happened during the month.
If it still will not tie and the month has to close, keep the working papers. Carry the unexplained amount forward as a flagged item. Never force the balance by writing off a difference you have not traced, because that number tends to reappear in the cash flow statement as an amount nobody can explain.
How Often to Reconcile, and Doing It in Software
Monthly is the answer for almost every business. Take a Coimbatore machine shop that reconciles once a year. Tracing a ₹3,847 difference through twelve months of entries is a day’s work, when the same check in September would have taken twenty minutes.
Reconcile weekly if you collect largely by card and transfer, since settlement delays and fees create more moving parts. A daily sales report makes the weekly version quick, because the collections side is already summarised.
Software takes the ticking off your hands, not the thinking. Petpooja Invoice records receipts and payments as the invoices are raised. By month end the cash book is already built, and only the bank’s own entries are left to post.
Conclusion
A bank reconciliation is not a monthly formality. It is the one routine check that tests your records against a document written by somebody else. That is how it catches the missing invoice, the duplicate payment and the charge nobody noticed.
Do it in the order above. Adjust the cash book, then bridge the timing gaps, and treat any difference that survives as something to trace rather than something to absorb.
If your receipts and payments are still spread across a passbook, a diary and a spreadsheet, that is the part worth fixing first. Petpooja Invoice keeps them in one place, which is what makes the reconciliation short.
Frequently Asked Questions
The adjusted cash book balance. Once you have posted the charges, interest and auto-debits the bank knew about and you did not, that corrected figure is your real bank balance. The statement balance is only evidence, and the reconciliation is the working that proves the two agree.
A cheque stays valid for three months from its date, so anything older will not clear. Reverse the entry in your books, put the amount back into the supplier’s account, and issue a fresh cheque if the payment is still owed. Leaving stale cheques in the reconciliation hides a real liability.
Yes. An import matches what it can and leaves the rest, and the leftovers are the whole point. Software removes the ticking work, not the judgement about why a payment is missing or why the customer thinks they paid you twice.
Ask for the UTR or transaction reference before anything else, then check whether the transfer failed at their end. If money left their account and never reached yours, their bank must reverse it on its own, and RBI rules require compensation when the reversal runs late. Chase it against the outstanding invoice rather than the conversation.
Keep them with the books for the same period your accounts are retained, which for companies is eight financial years. An annual financial summary is a useful place to hold the twelve closing balances together.
