Complete your first bank reconciliation by confirming the account and period, establishing the opening position, matching transactions in both directions, recording supported book corrections and explaining the remaining timing items. Finish by checking that the reconciliation reaches the adjusted ledger balance exactly and that every outstanding item has evidence.
Start with one account and a manageable period. Do not begin by changing the opening balance or entering a miscellaneous receipt equal to the difference. A first reconciliation is valuable because it establishes a reliable trail for later periods.
Gather the evidence before matching
An illustrative Pune repair shop is reconciling its current account for September. It obtains the full statement, the bank ledger, receipt and payment records, cheque details and deposit evidence. Where earlier periods exist, it also obtains the previous signed reconciliation and outstanding list.
The ledger opening balance should connect with the prior closing ledger. The statement opening balance should connect with the previous statement. Those two opening figures need not be identical if documented outstanding items explain their difference.
ICAI's bank-reconciliation material explains the relationship between the bank column of the cash book and the bank statement. Use the actual bank ledger in your records; the physical cash-in-hand account is a different balance and should not be substituted.
Check the period totals
The shop's illustrative ledger starts at ₹80,000, records ₹60,000 receipts and ₹45,000 payments, and closes at ₹95,000. The statement starts at ₹80,000, shows ₹52,300 credits and ₹39,300 debits, and closes at ₹93,000.
These totals confirm each record's arithmetic, but do not yet explain the ₹2,000 closing difference. Two wrong entries can offset each other, so matching only the net balance is insufficient.
Check whether the statement download contains all pages or rows and whether an export filter excluded a day. Retain the unedited original so a missing transaction can be traced back to the source rather than only to a working spreadsheet.
Match obvious pairs, then examine exceptions
Match unique references and amounts first, supported by the date and counterparty. Review near-date items carefully where transactions were recorded before appearing at the bank. Keep the book date and bank posting date separately rather than altering one merely to force a same-date match.
Set aside combined or partial settlements for a separate allocation review. A ₹30,000 transfer might settle two bills and should not be matched to whichever single invoice happens to be nearest in amount.
After the first pass, create a short exception list showing which side contains each unmatched item, its amount, date, reference and proposed explanation. This is more useful than leaving unexplained ticks and coloured cells across the source files.
Post genuine missing book entries
The shop finds ₹300 bank charges and ₹300 bank interest on the statement, both absent from the ledger. After checking the bank advice, it records the charges as an appropriate expense and the interest as the appropriate income, with the bank ledger affected on the opposite side.
The two entries offset in this example, leaving adjusted book cash at ₹95,000. They still need to be recorded individually. Netting them to zero would omit the expense and income and weaken the transaction trail.
Account for any tax detail according to the actual documentation and applicable facts. Do not assume every statement deduction is a charge with an identical tax split.
Prepare the remaining timing bridge
A documented ₹8,000 deposit is in the books but not yet credited on the statement. A ₹6,000 issued cheque is recorded but not yet presented. The final bridge is:
| Illustrative closing check | Amount |
|---|---|
| Statement closing balance | ₹93,000 |
| Add deposit awaiting bank credit | ₹8,000 |
| Less cheque awaiting presentation | ₹6,000 |
| Reconciled balance | ₹95,000 |
| Adjusted ledger balance | ₹95,000 |
| Remaining unexplained amount | Nil |
The raw receipt totals also reconcile: ₹60,000 book receipts less ₹8,000 deposit timing plus ₹300 bank interest equal ₹52,300 statement credits. Book payments of ₹45,000 less ₹6,000 outstanding cheque plus ₹300 charges equal ₹39,300 statement debits.
Verify clearing after the period end
Look at the next statement for the ₹8,000 deposit and ₹6,000 cheque. Record whether and when they clear. A later clearing supports their status at September end, but does not remove them from the September historical schedule.
If an item fails or is cancelled, obtain the evidence and process the appropriate correction. Do not continue carrying it as timing indefinitely. Keep the original entry linked to its resolution so the same item does not return next month.
Keep the first working trail intact
Retain matched references and a list of corrections made during preparation. Another person should be able to distinguish the ledger originally reviewed from its adjusted version. That makes the next opening check easier and prevents an already corrected item being posted again.
Arrange a focused review
A reviewer should confirm the closing date, source balances, arithmetic, support for corrections and the outstanding list. If the owner prepares the reconciliation personally, a periodic independent check can still focus on the largest or oldest items.
Keep preparation and review dates and identify unresolved questions explicitly. A zero unexplained difference is necessary, but it does not establish that every transaction has been assigned to the correct customer, supplier or expense.
Your first reconciliation is complete when another person can reproduce the bridge and locate its evidence. Use its closing outstanding list as the next period's starting point. Repeating that disciplined sequence makes later reconciliations faster because each new difference has a known place in the process.