Bank reconciliation is the process of matching the transactions in your own books against the transactions your bank actually recorded, so that the closing balance in your ledger agrees with your bank statement - or so that every difference between the two is explained. Knowing how to do bank reconciliation properly is one of the most basic but most frequently skipped disciplines in small business accounting, and skipping it is how errors, missed entries and even fraud go unnoticed for months.
This guide covers the mechanics of the process itself - distinct from formatting or cleaning a bank statement file, which we cover separately in our guide to bank statement to Excel best practices.
What Bank Reconciliation Actually Compares
At its core, reconciliation compares two independently maintained records of the same bank account: your internal cash/bank ledger (built from invoices, payments and receipts you have recorded) and the bank's own statement of what actually cleared the account. Both should describe the same underlying reality, but they are updated on different triggers and at different times, which is why they rarely agree on any single day without adjustment.
Why Book Balance and Bank Balance Rarely Match
Outstanding payments
A cheque or payment instruction you have recorded in your books as paid may not yet have been presented to, or cleared by, the bank. Your books show the cash as gone; the bank has not processed it yet.
Deposits in transit
A payment received and recorded on your side - for example, a customer transfer initiated on the last day of the month - may credit your bank account a day or two later, especially over a weekend.
Bank charges, interest and auto-debits not yet recorded
Banks deduct charges (SMS alerts, cheque book fees, minimum balance penalties) or credit interest directly, and these often only appear on the statement - your books will not reflect them until you record them from the statement itself.
Step-by-Step Bank Reconciliation Process
- Start from your book balance for the bank account as of the reconciliation date.
- Get the corresponding bank statement for the same closing date.
- Match each entry line by line - every receipt and payment in your books should have a corresponding line in the bank statement, and vice versa.
- List unmatched items from your books (payments issued but not yet cleared, deposits recorded but not yet credited).
- List unmatched items from the bank statement (bank charges, interest, direct debits or credits you have not yet recorded).
- Post the unmatched bank-side items into your books so your ledger picks up charges, interest and any auto-debits you missed.
- Prepare a reconciliation statement that adjusts your book balance for outstanding items and confirms it agrees with the bank statement balance.
If you receive statements as PDFs and need to work from clean transaction data rather than re-typing entries, the bank statement parser in OneBooks GST converts uploaded PDF or Excel statements into ledger-ready transaction lines with mapping suggestions, which is where most of the manual matching effort in step 3 tends to go.
A Simple Reconciliation Statement Format
| Item | Amount (Rs.) |
|---|---|
| Balance as per bank statement | 2,45,600 |
| Add: Deposits recorded in books, not yet credited by bank | 18,000 |
| Less: Payments recorded in books, not yet cleared by bank | (9,500) |
| Less: Bank charges per statement, not yet recorded in books | (350) |
| Add: Interest credited by bank, not yet recorded in books | 420 |
| Adjusted balance as per books | 2,54,170 |
The adjusted balance should equal your book balance for the bank account once the missing bank-side entries above are posted. If it does not, the remaining difference is an error somewhere in the matching that still needs to be traced.
Bank Reconciliation for Businesses With High Transaction Volume
Manual line-by-line matching works fine for a handful of transactions a month. Once you are dealing with hundreds of receipts and payments - common for sellers running multiple marketplace payouts alongside supplier payments - matching by eye becomes slow and error-prone. In that situation, importing the statement into a structured format and using automatic or rule-based matching against your recorded entries (matching by amount, date range and reference) will save far more time than trying to speed up manual matching. OneBooks GST's bank statement upload maps parsed transactions to your ledger accounts, which is designed for exactly this volume of matching.
Red Flags Reconciliation Can Catch
- A payment recorded twice in your books but only appearing once on the bank statement.
- A cheque that has been outstanding for an unusually long time, which may indicate it was lost, stopped, or never actually issued.
- Unauthorised or unexpected debits that do not correspond to anything in your books at all.
- Recurring bank charges creeping up that would otherwise go unnoticed if the statement is never actually reviewed line by line.
This is why reconciliation should be treated as a control, not just a bookkeeping formality - it is one of the few checks that catches both simple data-entry errors and genuine irregularities in the same pass.
Reconciling More Than One Bank Account
Most small businesses eventually operate more than one bank account - a primary current account, perhaps a separate account for a specific marketplace's payouts, and sometimes a fixed deposit or sweep account. Each account needs to be reconciled on its own; do not net balances across accounts or assume that a shortfall in one account is offset by a surplus in another. Keep a separate reconciliation statement per account per period, even if you review them together, so that any investigation into a specific discrepancy has a clean trail to follow without untangling it from unrelated accounts first.
It also helps to reconcile accounts in a consistent order every period - for example, always starting with the account that has the highest transaction volume - so that a missed reconciliation is easy to spot simply by checking whether every account on your list has a completed statement for the period.
Who Should Perform the Reconciliation
In a small business, reconciliation is often done by the same person who records payments and receipts, which is workable but removes one layer of independent checking. Where possible, have a second person - even just periodically - review the reconciliation statement and spot-check a handful of matched items against source documents. This is not about distrust; it is simply that a second, independent look catches errors that the person who made the original entry is less likely to notice, since they already have a mental model of what the numbers should be.
Frequently asked questions
How often should I do bank reconciliation?
Monthly is the minimum for most small businesses, timed to your accounting close. Businesses with high transaction volumes or multiple accounts often benefit from a weekly reconciliation to keep the list of unmatched items small and manageable.
What is the difference between book balance and bank balance?
Book balance is what your own ledger shows for the account based on transactions you have recorded. Bank balance is what the bank's statement shows based on transactions that have actually cleared. Reconciliation explains the gap between the two.
What are outstanding cheques in bank reconciliation?
Cheques or payments you have issued and recorded as paid in your books, but which have not yet been presented to, or cleared by, the bank as of the reconciliation date.
Why does my bank statement show charges I never recorded?
Banks often deduct charges such as SMS alert fees, minimum balance penalties or cheque book charges automatically, without notifying you in advance. These only surface when you review the statement and need to be posted to your books during reconciliation.
Can bank reconciliation be automated?
Much of it can. Uploading a statement and matching transactions against your ledger by amount, date and reference removes most of the manual line-by-line work, though unmatched or unusual items still need a manual review before the period is closed.
Where software takes over: OneBooks GST
For Indian businesses repeating this each month, OneBooks GST converts bank statements into ledger-mapped transaction rows and exports them as Excel or Tally-compatible output.
Keeping the original source file, the reviewed working copy and the final export together is what makes the same check repeatable next period, and OneBooks GST stores them against the filing period.
