The bank checks worth doing before you file GSTR-3B

Every filing week produces the same request to an article: “reconcile the bank with the GST return.” It is worth being precise about what that can and cannot mean, because the version most people attempt does not work and cannot be made to work.

Why the two will never match

Credits in the bank are not outward supplies. They differ for reasons that are entirely correct:

• Invoices raised this month are taxable now but may be collected next month, or not at all.
• Collections this month include invoices from earlier months.
• A credit includes GST; the return reports taxable value and tax separately.
• Loans, capital introduced, refunds and inter-account transfers are credits and not supplies.
• Exempt and non-GST receipts sit in the same account as taxable ones.
• TDS deducted by the customer means the credit is short of the invoice.

So a reconciliation that tries to tie bank credits to GSTR-3B turnover will always end in a reconciling list as long as the statement. That is not a failure of the reconciliation; it is a sign it was the wrong comparison. Turnover reconciles to the books and to GSTR-1, and the books reconcile to the bank. Skipping the middle step is what produces the unanswerable difference.

What the bank statement is actually for

Four things, all of which are worth the half hour:

A routine that fits in the filing week

• Get every statement in one format first. Chasing PDFs from three banks on the 18th is what makes this feel impossible. Convert them all at once, early.
• Check the statement adds up before you post anything from it. A missing page in a client's PDF becomes a missing entry, and you will find it at year end instead.
• Sort by amount, descending. The entries that matter for a return are almost always the large ones. Ten minutes at the top of that list catches most of what is worth catching.
• Filter for the RCM words in the narration — freight, transport, legal, professional, director, remittance, SWIFT.
• Confirm last month's challan cleared, for the right amount.

Reading the narration properly

Most of the above is a narration-reading exercise, which is why it is so often skipped: nobody wants to read eight hundred lines of UPI references. Assigning a ledger head to each line turns it into a sortable column instead, and then “show me everything posted to Freight” is one filter rather than an afternoon.

BankXL does that assignment as part of the conversion — see how the ledger mapping works — and your firm's own mapping takes precedence over the built-in rules on paid plans. The same ledgers carry through to the Tally XML export, so the work is not done twice.

Why this matters again at GSTR-9 time

The annual return asks you to reconcile turnover declared in returns with turnover in the audited accounts. Every month you skipped the books-to-bank step is a month of that difference you now have to reconstruct from memory, usually in December with a deadline approaching.

Doing it monthly is not extra work. It is the same work, done while the answer is still knowable.