Skip to content

GST reconciliation automation, Bengaluru

Where Tally, bank data and GSTR-2B diverge before the 20 November GSTR-3B date, what a Bengaluru team can automate, and what a CA still has to review.

By · · 8 min read

Software should carry the differences to a chartered accountant. It should not file them away.

This note is for owners and finance teams in Bengaluru, ahead of the October 2026 return. It is not tax advice, not a filing instruction, and not a substitute for your chartered accountant or for the tile on your own GST portal. Due dates move when the government notifies an extension. Confirm the portal on the day you file.

The dates a monthly filer actually has

For a monthly filer, rule 61 of the CGST Rules requires FORM GSTR-3B for each month on or before the twentieth day of the succeeding month. For October 2026 that is Friday, 20 November 2026. The GST portal’s GSTR-3B guide states the same rule and the caveat that matters this week: the date can be extended by notification. Section 39(6) of the CGST Act is that power. As of 12 November 2026 this article relies on the published rule, not on an extension.

Quarterly filers are on another row of the same rule. A business with its principal place of business in Karnataka that files under the quarterly proviso is in the group due on the twenty-second of the month after the quarter. October alone is not their 20 November deadline. If you are unsure which row you are on, the portal tile is the check.

The portal’s GSTR-2B FAQ says a monthly statement is generated on the 14th of the next month. For October that is Saturday, 14 November 2026. The FAQ does not move the day for a weekend. Documents from monthly GSTR-1 and GSTR-1A are those filed from 00:00 on the 12th of the tax month to 23:59 on the 11th of the next month. A supplier invoice filed after 23:59 on Wednesday, 11 November 2026 falls into a later statement.

GSTN’s Invoice Management System advisory changes how you treat the 14th. A draft GSTR-2B is generated that day. Accepted records, and records you have left alone, count as accepted or deemed accepted. Rejected records stay out of the input computation. Pending records stay off that month’s statement. If you act after the 14th, you recompute GSTR-2B before filing GSTR-3B. The advisory also says the next period’s GSTR-2B is not generated until the previous GSTR-3B is filed. A Bengaluru team still sitting on September should not expect October’s draft to appear on its own on Saturday.

GSTR-3B is auto-populated from GSTR-1 or GSTR-1A and from GSTR-2B. The portal guide says the values stay editable, and that some downward edits to outward tables and upward edits to input tables turn the tile red and raise a warning. Both figures are kept. Clearing that warning in silence is the accountant’s job, not a script’s.

Where Tally, the bank, 2B and the portal split

A monthly close in Bengaluru is four lists describing the same rupee on different clocks.

Tally holds the vouchers and the tax they calculated. Its GSTR-2B reconciliation downloads the statement (Exchange, GST returns, type GSTR-2B; the help page’s OTP session lasts six hours) or imports a file you saved. The report sorts lines into reconciled, unreconciled, mismatched, available only in books, available only on the portal, mismatch in return period, excluded but available on the portal, uncertain transactions, and invoices rejected in IMS. Potential matches are the awkward middle: taxable value and tax agree, and the section, GSTIN or document number does not.

The bank holds cash. A supplier payment with no bill, a receipt with no sales voucher, and a gateway file that covers twenty invoices are close items, and they are not automatically input-tax claims. Keep that pass separate from the 2B pass.

GSTR-2B holds what suppliers filed inside the cut-off, after IMS actions and any recompute. It will not include an unfiled bill, and a pending invoice stays out of this month. Tally’s rejected-in-IMS status is only useful if someone remembers whether the reject was deliberate. GSTR-3B then holds the auto-populated summary plus any edit. A gap against Tally’s return view is the red-warning exception: books and 2B never met, a recompute was skipped, or someone overtyped a table. The close is that list, with an owner, because the four sources update on different clocks.

What is safe to automate

Safe work is retrieval, matching and a queue. It does not choose a tax treatment.

Download or import GSTR-2B on the 14th, and again after any IMS action. Fail loudly if the previous GSTR-3B is unfiled, because the draft may not exist. Let exact matches fall into reconciled: same GSTIN, same document number, same taxable value, same tax. Tally’s help page lets a person mark a configured rounding difference as reconciled after looking. A tax difference is not a round-off. Leave it mismatched.

Match the bank only where the reference and the amount both agree. Everything else is an exception with the statement line attached. Do not let a model explain an unmatched receipt into a sales voucher.

Each row needs the status, party, document number, amount, missing source, age and owner. Books-only lines are a supplier question about the 11 November cut-off. Portal-only lines are a books question. Show any 3B field that differs from the auto-populated value, and leave the red warning for the accountant.

What the chartered accountant still decides

Accept, reject, pending and silence are all decisions. The advisory treats a record left alone as deemed accepted when the draft is generated. The queue can show that an invoice is in the books and on the portal. The accountant chooses the action.

Eligibility stays with them too, including blocked credits and the items the advisory says skip IMS and land in GSTR-3B: inward reverse-charge supplies the supplier reported, and input it describes as ineligible under section 16(4) or the place-of-supply rule. This article does not tell you how to treat an invoice. Editing an auto-populated table, choosing a ledger and filing are the same kind of decision. A workable split is a pack on the morning of the 16th, the accountant’s review on the 18th, and filing only after the portal date is checked that day.

An exception-led close

The rows below are an illustration of a queue. They are not a client file, not a recommended claim and not a filing position.

What disagreedBooksOther sourceWho moves next
In Tally, absent from October 2BBill entered, tax ₹18,000No row in the 14 November draftAsk whether the supplier filed by 11 November. The accountant decides if the claim waits.
Tax does not matchVoucher tax ₹1,8002B tax ₹1,620Leave it mismatched. The accountant opens the PDF.
Only on the portalNo voucherInvoice on this GSTINCheck a missed bill or the wrong registration before silence deems it accepted.
Bank credit, no sales voucherNo receiptUnmatched statement creditClear it in the books. It is separate from input tax and still blocks the close.
Rejected in IMSVoucher shows input taxTally’s rejected-in-IMS statusThe accountant confirms the reject before anyone reverses it.

Review that table, not every reconciled line. On the 18th, recompute 2B if IMS changed, compare 3B with Tally, and file only after that. A row with no owner is the red tile on the 20th.

Aiwah’s finance reconciliation and close case study is the same shape, published as an operating design rather than a measured result. Matches separate from exceptions that carry an amount, a reason and an owner. A journal can be prepared and is not posted without approval and segregation of duties. Tax treatment stays with the accountant. Knowledge and back office is where we build that queue, beside the books and the portal login already in the city. The Bengaluru office is the local door.

Questions before the 20th

Has 20 November 2026 been extended?

Rule 61 and the portal guide still say the 20th, and both allow a notified extension. This page, checked on 12 November 2026, does not cite one for October. Read the dashboard on the day you file.

Can the software file GSTR-3B?

It can prepare the pack: the download, the exact matches, the exceptions, and a side-by-side of auto-populated and edited values. Filing, IMS actions and any edit to a tax table stay with the accountant and the authorised signatory.

What if GSTR-2B is missing on the 14th?

The advisory says the draft waits until the previous GSTR-3B is filed, and that you can generate it from IMS after that. Check September before you troubleshoot October.

Our CA already reconciles in Tally. What is left?

The 14th download, a second pull after each IMS change, exact bank matches, and an owner on every open row. The judgment stays with the accountant.

How Aiwah Labs helps

Aiwah Labs builds that pack for finance teams in Bengaluru. We connect Tally’s reconciliation statuses, the bank lines that match, and the portal exports your accountant already trusts. We do not file the return, we do not take IMS actions, and we do not give tax advice.

If October is still a spreadsheet on the 19th, start with one registration and one month. The Bengaluru page is the local context. You can talk to us before the 20th with the exception list you already have.

Which recurring rule still lives in someone's memory?

Book a meeting