How to Reconcile Your Bank Statement — A Practical Monthly Checklist

By IntimeBooks Team · · 5 min read
bank reconciliation bookkeeping monthly close india

Ask any experienced Chartered Accountant which single control catches the
most bookkeeping errors and you'll get the same answer every time — a
disciplined monthly bank reconciliation. It sounds boring. It is
boring. And it will save your business from problems you don't yet know
you have.

This article walks through the exact process we recommend to every
IntimeBooks user.

What bank reconciliation actually is

A bank reconciliation is a line-by-line comparison of two documents:

  1. Your bank statement — what the bank thinks happened to your money.
  2. Your cash-book / bank ledger — what your accounting software
    thinks happened to your money.

If the closing balances on both agree to the paisa, you are reconciled.
If they don't, every difference is either a timing gap (a cheque you
issued but the payee hasn't deposited yet) or an error (a duplicate
voucher, a missing voucher, a wrong amount, or — in the worst case —
fraud).

Why "the balance looks right" is not enough

Two errors of equal size in opposite directions can leave the closing
balance perfectly correct while both entries remain wrong. This is why a
proper reconciliation ticks off every line individually, not just
the totals.

The monthly reconciliation checklist

Step 1: Download the statement

Log into your net banking on the first working day of the month and
download the previous month's statement as a PDF or Excel. Save it
to a folder named Bank Statements / <Bank Name> / <YYYY-MM> — future
audits will need it.

Step 2: Import into your software

In IntimeBooks, the Bank Statement Analyser accepts the PDF directly
and produces a clean line-by-line table of every credit and debit,
already classified by narration. You can then bulk-post the entries as
Receipt or Payment vouchers with two clicks.

If you're on another system, at minimum export the statement to Excel so
you can sort, filter and colour-code as you go.

Step 3: Tick off matched entries

Open the bank ledger in your software side-by-side with the statement.
Go top to bottom on the statement. For each line:

  • Find the matching voucher in the ledger.
  • Confirm the date, amount and direction (debit/credit).
  • Mark the line "matched" — colour, tick, or reconciliation flag.

Do not re-order the statement first. Reconciling in date order is
what surfaces duplicate entries and off-by-a-day timing gaps.

Step 4: Investigate unmatched items

After the pass, you will typically have four small buckets:

  • In statement, not in books — a receipt or payment your bank
    processed that you forgot to post. Post it now.
  • In books, not in statement — usually a cheque issued but not yet
    presented. Note it as an "outstanding cheque".
  • Amount mismatch — bank charged you differently. Common causes:
    GST on bank charges, foreign-exchange spread, cheque bounce fees.
  • Duplicate voucher — posted the same transaction twice. Reverse
    one; never delete.

Step 5: Build the reconciliation statement

The reconciliation statement is a short document that mathematically
proves the gap between the two balances:

Balance as per bank statement           :  12,45,600.00
Less: Cheques issued but not presented  :    -85,400.00
Add : Deposits in transit               :     22,000.00
Add : Bank charges recorded in ledger,
	  still pending in statement        :        450.00
										  ------------
Balance as per bank ledger              :  11,82,650.00

If those two match — you are reconciled.

Step 6: Post pending journal entries

Anything the bank has already posted that you hadn't recorded (bank
charges, interest credited, cheque bounce fee, GST on bank charges) must
now be posted as new vouchers, dated to the actual bank date.

Step 7: Lock the period

Once reconciled, lock the previous month so nobody — including you —
can back-post a voucher into a closed period. IntimeBooks lets you set
a period lock date; use it.

How often should you reconcile?

  • Monthly is the legal minimum for any business filing GST.
  • Weekly is what we recommend for any business with more than 200
    transactions a month. The exercise takes 15 minutes on a weekly
    cadence and 3 hours on a monthly one — because your memory of each
    transaction is fresher.
  • Daily for cash-heavy businesses (retail, restaurants) — reconcile
    the till against the cash book at end of day, every day.

Red flags to watch for

  • Round-figure withdrawals in the statement you don't recognise.
  • Payments to unfamiliar payees, especially on weekends.
  • Sudden jumps in "bank charges" — could be legitimate GST changes,
    could be a compromised beneficiary added to your net banking.
  • Any statement line you cannot categorically explain. Ring the
    bank; do not wait for month-end.

The IntimeBooks shortcut

The Bank Statement Analyser inside IntimeBooks:

  • Accepts PDF statements from every major Indian bank (HDFC, ICICI,
    SBI, Axis, Kotak, Yes, IDFC First and more).
  • Auto-classifies each line based on narration (salary, GST payment,
    supplier payment, customer receipt, bank charges, interest).
  • Produces the reconciliation statement automatically.
  • Highlights amount mismatches and duplicate suspects in red.

A monthly reconciliation that used to take 3 hours in Excel now takes
about 20 minutes.

Ready to try it? Create a free account and
upload your first bank statement — you'll see the reconciliation in
under a minute.