A bank reconciliation statement is a short list that explains why the bank balance in your books and the balance in your passbook or statement are different on the same date, and shows that the difference is fully accounted for. You start from one balance, add or subtract the known differences, and arrive at the other. If the two end up equal, the books and the bank agree.
Why do the two balances differ at all?
Your books record a payment the day you decide to make it, such as writing a cheque. The bank records it only when the cheque is presented and cleared. The bank also adds charges and interest without telling your accountant, and customers sometimes pay straight into the account without you noticing. None of this means anyone has made a mistake; the two records simply see events at different times.
What are the usual differences?
- Cheques issued but not yet presented: your books show the money gone, the bank does not yet.
- Cheques deposited but not yet credited: your books show the money in, the bank has not credited it.
- Bank charges not yet in your books.
- Interest credited by the bank that you have not entered.
- Direct credits such as a UPI or NEFT receipt from a customer that you have not recorded.
- Mistakes, such as a transposed digit in your entry. These are fixed, not listed.
A plain example, step by step
Say, hypothetically, your books show a bank balance of ₹84,500 at month end, and your passbook shows ₹91,200. The gap is ₹6,700. Here is what you find when you compare the two line by line.
| Difference found | Amount | Which side must change |
|---|---|---|
| Cheque issued to a supplier, not yet presented | ₹12,000 | Bank side, subtract |
| Cheque deposited, not yet credited | ₹8,500 | Bank side, add |
| Bank charges, not in books | ₹420 | Books side, subtract |
| Interest credited, not in books | ₹1,120 | Books side, add |
| UPI receipt from a customer, not in books | ₹2,500 | Books side, add |
How do I build the statement?
- Start with the books: ₹84,500.
- Add the interest and the UPI receipt, and subtract the charges: ₹84,500 + ₹1,120 + ₹2,500 − ₹420 = ₹87,700. This is the corrected books balance.
- Start with the passbook: ₹91,200.
- Subtract the cheque not presented and add the cheque not credited: ₹91,200 − ₹12,000 + ₹8,500 = ₹87,700.
- Both routes reach ₹87,700, so the statement is complete.
As a check, the original gap of ₹6,700 equals ₹12,000 − ₹8,500 + ₹3,200, where ₹3,200 is the net of the three books-side items (₹1,120 + ₹2,500 − ₹420). If your two figures do not meet, there is still an unfound item or an error, and the arithmetic above tells you roughly how big it is.
What do I do with the books-side items?
The three items on the books side are your to-do list. Enter the bank charge, the interest and the UPI receipt in your books so the books balance becomes ₹87,700. The cheque items need no entry, because your books already show them; they clear by themselves when the bank catches up.
How often should I do this?
Monthly is a reasonable habit for a small business, and weekly if you write many cheques. A reconciliation done long after the month closed becomes a detective job. If your CA wants a particular format, such as listing items under headings, follow theirs.
Where does SpendixAI fit?
When you upload a bank statement in PDF, CSV or Excel to SpendixAI, the passbook side becomes a list of rows you can review before saving, which makes the bank charges and interest lines easy to spot. The reconciliation statement itself is something you still build in a sheet, because the app does not prepare one.
A short checklist
- Same date for both balances.
- Every difference is named and has an amount.
- Both routes reach the same figure.
- Books-side items are entered, bank-side items are watched until they clear.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


