Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
Several months of bank statements have not been reconciled, and the business does not know where to begin.
Confirm the last good closing balance, reconcile the oldest month first, carry open items forward month by month, book recurring bank charges and interest together, and decide stale items only after reaching the current month.
All bank statements and ledgers for the backlog period, the last audited or reconciled balance, and an open-items list carried from month to month.
A reconciled bank account up to the current month and a short list of stale items with an agreed action for each.
Do not start with this month’s statement. First fix a verified starting point: a month-end where you know the book balance agreed with the bank. Then reconcile month by month forward, carrying open items with you. Only after you reach the current month should you decide what to do with the oldest exceptions.
What is the catch-up plan?
| Step | What you do | Typical time for a small business |
|---|---|---|
| 1. Collect | Download every bank statement and export the bank ledger for each month of the backlog | Half a day |
| 2. Confirm the start | Find the last month whose closing balance you can confirm against the bank | One to two hours |
| 3. Reconcile oldest first | Reconcile that next month fully, then the one after | A few hours per month |
| 4. Carry open items | Move unmatched items to an open-items list that rolls into the next month | Part of step 3 |
| 5. Bulk-book recurring items | Enter bank charges, GST on charges and interest for all months together | One to two hours |
Times are only a guide. They depend on how many lines you have each month.
Should you reconcile the oldest month first or the latest first?
Oldest first. Each month’s closing balance is the next month’s opening balance. If April is wrong, May, June and every month after will be wrong by at least the same amount.
Many items also clear themselves as you move forward. A cheque you issued in April that was presented in May will match when you reach May. If you start with the latest month, you will not know which old items have already cleared.
Worked example
A trading business has not reconciled its current account for six months, from April to September. When the owner first compares the books with the bank, ₹9,86,300 of lines on one side or the other have no match.
The accountant confirms that the March closing balance agreed with the audited accounts. Starting there, they reconcile April, then May, and so on, carrying open items forward.
As they work through the months:
| What cleared | Amount |
|---|---|
| Timing items that matched in a later month | ₹5,42,600 |
| Bank charges, GST on charges and interest booked | ₹38,700 |
| Book errors corrected (wrong amounts, wrong bank, duplicates) | ₹2,86,600 |
| Total cleared | ₹8,67,900 |
₹9,86,300 less ₹8,67,900 leaves ₹1,18,400. These are stale items: old cheques never presented and a few credits from unknown senders. Each now needs a decision: reissue the cheque, write it back, or trace the sender.
What if the opening balances never agree on the oldest month?
Then you do not have a verified starting point yet. Try these, in order:
- Use the last audited balance sheet date as the start.
- Ask your bank for a balance confirmation as at a past date.
- If neither works, record the unexplained difference openly as an opening difference, with a note, and agree its treatment with your accountant.
Do not adjust random entries to make the opening agree. That hides the problem. The opening balance reconciliation guide explains each approach. A backlog is also a common reason for a negative bank balance in your books.
What mistakes should you avoid?
- Reconciling only the latest month and adjusting the difference into an opening entry.
- Removing old entries you cannot match. Old items need a decision and an approval, not removal.
- Working without the full set of statements. One missing month breaks the chain of balances.
How long is a cheque valid in India?
Under the RBI circular of 4 November 2011, cheques, drafts, pay orders and banker’s cheques are valid for three months from the date on the instrument, down from six months. The rule applies to instruments dated on or after 1 April 2012. So in a six-month backlog from April to September, a cheque issued on 10 April and never presented became stale after 10 July. After that the bank will not pay it, so an unpresented cheque past that date is stale and should be reversed in the books, not carried forward. If a cheque you deposited is returned unpaid, the bank’s return memo is your evidence; a dishonoured cheque can also give rise to a claim under Section 138 of the Negotiable Instruments Act, which is a matter for your lawyer, not the reconciliation.
What to read next
Next, read the opening balance reconciliation guide, then the Days 1 to 5 runbook, which gives a monthly routine that stops the backlog returning. For the stale items left at the end, see why some items stay unreconciled for months.
TransactIG can work through a backlog by matching bank statement lines to the books and listing what is left in an exception queue, with audit-ready exports; see bank reconciliation software for India.