MillMargin / Guides / Bank reconciliation

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.

Bank balance + deposits in transit − cheques not presented = books balanceBooks balance after entering bank-only lines: charges, profit, tax deducted, returned cheques.

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:

LineWhere it appearsAmount, Rs
Cheque 004518 to Bhatti Paddy Co., 30 OctBooks only350,000
Haji Rafiq & Sons cheque deposited 31 OctBooks only500,000
Usman Traders cheque returned unpaidBank only−120,000
Profit credited for OctoberBank only4,410
Tax deducted on profitBank only−662
SMS alert chargesBank 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 2026Rs
Balance as per bank statement1,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 books1,167,558

Invented business and figures. Difference after reconciling: zero.

Entries to post

EntryDebitCreditRs
Returned chequeUsman TradersBank120,000
ProfitBankProfit on bank deposits4,410
Tax on profitIncome tax deducted at sourceBank662
SMS chargesBank chargesBank250

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.

Do not post the cheque not presented or the deposit in transit. They are already in your books; they will appear on November's statement. Post them again and the books are wrong twice.

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

  1. Download the statement as Excel or CSV, not only PDF.
  2. Tick every line that matches an entry by amount and date.
  3. Post the bank-only lines.
  4. List what is left on the books side: those are your timing items.
  5. Check that bank + deposits in transit − cheques not presented = books. If not, look for a mistake in the amounts.
  6. 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.

MillMargin Ledger does this for you

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