The monthly bank reconciliation routine that saves your CA three days in July

Title: The monthly bank reconciliation routine that saves your CA three days in July

Updated for FY 2026-27 (AY 2027-28).

Most small businesses in India treat the bank statement as something the CA will "sort out later". Later turns out to be the third week of July, when nobody remembers what the ₹1,80,000 debit in October was for, and the profit figure moves by a lakh two days before the return is filed. A reconciliation done on the 5th of every month takes about thirty minutes and removes almost all of that pain.

Fix the date: reconcile between the 1st and the 7th

Pick a fixed day. The first working week of the month is the right window because everything else downstream depends on it: GSTR-1 is due by the 11th and GSTR-3B by the 20th, so if your bank is reconciled by the 7th you still have time to spot a sale you never invoiced or an input tax credit you cannot find in GSTR-2B.

Download the statement for the complete month — 1st to last date, no partial periods — as PDF, CSV or Excel. Note two numbers before you start: the opening balance and the closing balance on the statement. Your reconciliation is finished only when the books agree with that closing balance after a short, explainable list of differences. Do this for every account: current accounts, the OD/CC account, the credit card, and the payment gateway settlement account if you have one.

Tick off the statement line by line, biggest first

Sort the month's entries by amount, descending, and work down. Large items are few and they carry most of the risk; the ₹118 UPI debits can be handled in a batch at the end.

For each line, one of four things is true:

1. It is already in the books and matches — tick it.
2. It is in the books with a different amount or date — usually a cheque entered on the date written and cleared three days later, or a foreign receipt booked at a different rate. Match it and note the difference.
3. It is in the books twice — a supplier bill paid once but entered from both the bill and the bank side. Delete one.
4. It is not in the books at all — bank charges, processing fees, auto-debited insurance, FD interest, a direct customer credit, a penalty, a card payment made by a family member.

Category four is where the money is. Keep a running list; you will post it as one journal entry at the end rather than fifty small ones.

Know the four differences that are allowed to remain

A reconciliation never ends in zero difference, and it does not need to. These four are legitimate:

• Cheques issued but not presented. Your books show the payment, the bank does not.
• Deposits in transit. A cheque banked on the 31st that cleared on the 2nd.
• Bank charges and interest the bank has debited but you have not yet booked. These should be booked, not carried forward.
• Items credited by the bank that you cannot identify. Park them in a suspense account and chase them — do not call them sales until someone confirms it.

Write the statement out in this shape every month and keep it with the working papers:

Balance as per bank statement, 31 October: ₹8,42,310 Less: cheques issued, not presented: ₹1,12,400 Add: deposit in transit: ₹45,000 Balance as per books: ₹7,74,910

If anything sits in "cheques not presented" for more than three months, stale it and write it back. Your CA will ask about it otherwise.

A worked example: what one month of ticking actually found

Take a proprietary trading firm, books showing a profit of ₹16,00,000 for FY 2026-27 before the year-end reconciliation. Three months of bank statements were ticked properly for the first time and threw up:

• ₹1,80,000 of household and travel spends on the business account, posted to "office expenses" by habit;
• ₹34,500 of bank charges, processing fees and cheque return charges never booked at all;
• a term loan EMI of ₹1,44,000 a quarter posted entirely against loan principal, when ₹86,400 of it for the year was interest.

The correcting entry:

Net effect on profit: plus ₹59,100. Revised profit ₹16,59,100.

Under the new regime for FY 2026-27, tax on ₹16,59,100 for an individual with no salary income (so no standard deduction) works out as: nil up to ₹4,00,000; ₹20,000 on the ₹4–8 lakh slab; ₹40,000 on ₹8–12 lakh; ₹60,000 on ₹12–16 lakh; and 20% on the remaining ₹59,100, which is ₹11,820. Total ₹1,31,820, plus 4% cess, equals ₹1,37,093.

On the un-reconciled profit of ₹16,00,000 the figure would have been ₹1,20,000 plus cess, or ₹1,24,800. The 15 December advance tax instalment is 75% of the liability: ₹1,02,820 on the correct figure, ₹93,600 on the wrong one. That ₹9,220 shortfall carries interest under section 234C, and the same gap repeats at each instalment. Reconciling monthly is how you get the instalment right the first time.

There is a GST consequence too. The ₹1,80,000 of personal spends almost certainly had input tax credit claimed on part of it; that credit has to be reversed, and the reversal is far cheaper in the month it happened than in an audit three years later. If the firm is on presumptive taxation under 44AD, the bank still matters: the 6% rate applies only to digital receipts and 8% to the rest, and that split comes straight off the statement.

Give each unmatched payment a TDS check

While you are looking at outgoing payments, the bank statement is the best TDS checklist you will ever get, because it shows gross amounts regardless of what the books say.

Watch for these thresholds for FY 2026-27: contractors and job work under 194C at 1% (individual/HUF) or 2% (others) once a single payment crosses ₹30,000 or the year's aggregate crosses ₹1,00,000; professional fees under 194J at 10%, or 2% for technical services, above ₹50,000; rent under 194I at 10% once the year crosses ₹6,00,000; commission under 194H at 2% above ₹20,000. Office rent of ₹55,000 a month is ₹6,60,000 for the year and is squarely inside 194I, even though no single payment looks large. Catching it in May rather than in the 26Q filing for Q4 is the difference between a clean quarter and a correction statement.

What the CA actually wants in July

Ask any practitioner what slows down a return and it is rarely the computation. It is the ₹3,20,000 of "cash withdrawn" with no narration, the suspense account carrying eleven entries, and a bank balance in the books that differs from the bank certificate by ₹47,000 with no explanation.

Hand over instead: a reconciliation statement for each account for each month, a general ledger where every bank line has a narration and a counterparty, a suspense account with a nil balance, and a short note on anything unusual. Firms that work this way generally finish a small-business return in a day. If you work with a CA, it is worth agreeing the chart of accounts with them once at the start of the year — our note for CA firms covers how that handover usually runs.

What to do this week

• Choose a fixed day between the 1st and 7th of the month for your reconciliation routine.
• Download last month's complete bank statement for every account (current, CC, OD, payment gateway).
• In your accounting software, start a new bank reconciliation, entering the statement's closing balance.
• Work through the largest transactions first, matching them to entries in your books.
• Create entries for any missing items like bank charges or direct customer payments.
• Finalise the reconciliation report, ensuring any remaining differences are explained (e.g., cheques not yet cleared).

Doing this in FlipAccounts

Upload the month's statement under Bank reconciliation as PDF, CSV or Excel; HDFC, IDFC FIRST and Aspire formats are read directly, and other banks work from CSV or Excel. Unmatched lines are listed for you to categorise, and the rules you create for this (e.g., that an NEFT from "Sharma Traders" is a sales receipt) are learnt to automate the process for next month.

Frequently asked questions (FAQs)

What if I use a payment gateway like Razorpay or Stripe?

Treat the gateway settlement account like another bank account. Reconcile the gross sale amounts in the gateway to your invoices, and then reconcile the net settlement amount transferred from the gateway to your actual bank account. The difference is the gateway's fees, which you must book as an expense.

Why can't I just do this once a year in July?

You can, but it leads to errors. After several months, you will not remember what a particular payment was for, increasing the risk of misclassifying expenses (like personal spends) or missing income. Monthly reconciliation ensures your advance tax instalments and GST returns are accurate, saving you interest and penalties.

What is a suspense account and why is it important?

A suspense account is a temporary holding account for transactions you cannot yet identify. For example, if a customer deposits money directly without telling you. Instead of guessing and wrongly marking it as a sale, you post it to Suspense. This keeps your main accounts clean. Your goal should be to clear the suspense account to zero by the end of every month by investigating each entry.

I am a salaried individual. Does any of this apply to me?

While you may not need to do a formal business reconciliation, reviewing your bank statement monthly is still good practice. It helps you track your spending, verify that your salary credits are correct, spot any fraudulent transactions early, and identify tax-saving investments or expenses that you might otherwise forget when filing your return.

More guides