How to reconcile your bank statement with your books
Your books say one balance, the bank says another. A month-end bank reconciliation shows exactly why — and finds the returned cheque or the charges nobody entered. A worked example with a trader’s current account, and the lines you will meet on a Pakistani statement.
By the MillMargin team · Updated 19 Nov 2026 · 4 min read
The short answer
Start from the bank statement's closing balance. Add deposits you have banked that the bank has not credited yet, and take off cheques you have issued that have not been presented yet. The result must equal your books — after you have entered everything the bank did on its own.
Why the two balances differ
Every difference falls into one of three groups. Sort each line into one and the reconciliation does itself.
- Timing. You entered it, the bank hasn't yet: a cheque you gave a supplier on the 30th, a cheque you deposited on the last day. These clear next month; you post nothing.
- Bank-only. The bank did it, you didn't know: SMS and transfer charges, profit on a profit-bearing account, tax deducted on that profit, a customer's cheque returned unpaid. You post these.
- Mistakes. A cheque entered as 35,000 that cleared at 53,000, a receipt posted to the wrong bank. You correct these.
Worked example: Al Noor Rice Traders, October
The books show the bank at Rs 1,284,060 on 31 October. The bank statement shows Rs 1,017,558. A difference of Rs 266,502. Ticking the statement against the books leaves these lines:
| Line | Where it appears | Amount, Rs |
|---|---|---|
| Cheque 004518 to Bhatti Paddy Co., 30 Oct | Books only | 350,000 |
| Haji Rafiq & Sons cheque deposited 31 Oct | Books only | 500,000 |
| Usman Traders cheque returned unpaid | Bank only | −120,000 |
| Profit credited for October | Bank only | 4,410 |
| Tax deducted on profit | Bank only | −662 |
| SMS alert charges | Bank only | −250 |
First bring the books up to date with the four bank-only lines: 1,284,060 − 120,000 + 4,410 − 662 − 250 = Rs 1,167,558. Then reconcile from the bank side:
| Bank reconciliation statement, 31 Oct 2026 | Rs |
|---|---|
| Balance as per bank statement | 1,017,558 |
| Add: deposit not yet credited (Haji Rafiq & Sons) | 500,000 |
| Less: cheque not yet presented (004518, Bhatti Paddy Co.) | −350,000 |
| Balance as per books | 1,167,558 |
Invented business and figures. Difference after reconciling: zero.
Entries to post
| Entry | Debit | Credit | Rs |
|---|---|---|---|
| Returned cheque | Usman Traders | Bank | 120,000 |
| Profit | Bank | Profit on bank deposits | 4,410 |
| Tax on profit | Income tax deducted at source | Bank | 662 |
| SMS charges | Bank charges | Bank | 250 |
The returned cheque goes back onto the party's account, so their invoice shows unpaid again. The tax deducted goes to its own account, so you can claim it in your return instead of losing it in bank charges.
Lines you will meet on a Pakistani statement
- IBFT / Raast transfers — match to the payment or receipt by amount and date; the narration often carries the other bank's reference only.
- Transfer, SMS and card charges — small, frequent, and easiest to post in one go at month end.
- Profit and tax on profit — on profit-bearing accounts, credited monthly or half-yearly with the tax shown on its own line.
- Returned or dishonoured cheque — the deposit and a reversal on the same or the next day; the reversal is the one you post.
- Cash withdrawals — match to the cash book entry, not to an expense.
A monthly routine that takes minutes
- Download the statement as Excel or CSV, not only PDF.
- Tick every line that matches an entry by amount and date.
- Post the bank-only lines.
- List what is left on the books side: those are your timing items.
- Check that bank + deposits in transit − cheques not presented = books. If not, look for a mistake in the amounts.
- Keep the reconciliation with the statement, and start next month with last month's timing items.
Questions traders ask
How often should I reconcile?
Every month, as soon as the statement is out. A month is short enough to remember each cheque, and a returned cheque found in month three is much harder to recover.
The difference won't clear. Where do I look?
Divide the difference by 9. If it divides exactly, two digits are probably swapped somewhere, such as 35,000 typed as 53,000. Otherwise look for a receipt posted to the wrong bank, or an entry posted twice.
A difference of one or two units keeps appearing.
Usually an entry typed in whole units while the bank shows the decimals. Correct the entry to the exact amount rather than posting the difference to charges.
I have two accounts with the same bank.
Reconcile each account on its own. If both sit in one account in your books, split them — otherwise a transfer between them looks like money in and money out.
Import the statement as CSV or Excel. Ledger matches each line to an entry, creates charges, profit, tax and returned cheques in one tap, and closes the month only when the difference is zero — with the reconciliation as a PDF.
Start your Ledger books free