Running GST reconciliation for 50 clients a month: a CA firm workflow
A monthly calendar, file standards, roles and review steps for CA firms reconciling GSTR-2B, GSTR-1 and GSTR-3B for many clients at once.
For a firm with fifty GST clients, the hard part of reconciliation is not the matching. It is the six working days between the 14th, when GSTR-2B appears, and the 20th, when monthly GSTR-3B is due. In that window the firm has to collect fifty purchase registers, reconcile them, chase suppliers, get answers from clients and file. This post sets out a workflow that holds up under that pressure. It is written for partners and managers who run GST practices and for the article assistants who do the work.
The month on one page
The portal calendar fixes most of the shape. For monthly filers:
| Date | Portal event | Firm work |
|---|---|---|
| 1st to 5th | Collect sales registers and e-invoice reports; start the outward side | |
| 11th | GSTR-1 due | Sales register vs GSTR-1 and e-invoices done before filing |
| 13th | IFF due for QRMP clients (first two months of a quarter) | Same check for QRMP clients who use IFF |
| 14th | GSTR-2B generated | Download 2B for every client; run all 2B reconciliations the same day |
| 15th to 17th | Review breaks, email suppliers, send queries to clients, take IMS actions | |
| 18th to 19th | Manager review; recompute 2B where IMS actions changed; prepare GSTR-3B | |
| 20th | GSTR-3B due | File; GSTR-3B vs GSTR-2B check as part of the review |
QRMP clients file GSTR-3B on the 22nd or 24th after the quarter depending on their state, which gives a second, smaller peak. Put both peaks on one calendar so the team sees them together.
The outward side matters more since July 2025. From that tax period, the liability auto-populated in GSTR-3B from GSTR-1 can no longer be edited in GSTR-3B; corrections go through GSTR-1A before GSTR-3B is filed. An error caught after GSTR-1 is filed costs an extra form. An error caught after GSTR-3B is filed costs an amendment in a later return. So the sales checks belong before the 11th, not after.
Standardise the inputs before you standardise anything else
Most of the hours lost in a GST practice go into reshaping client files. Fix this once, at onboarding:
- One export per accounting package. Write down, for Tally, Zoho Books, Busy and whatever else your clients use, the exact report and columns you need. For a purchase register: supplier GSTIN, supplier name, supplier invoice number, supplier invoice date, voucher type, taxable value, IGST, CGST, SGST, cess, reverse charge flag, ledger name, and payment date if available.
- The supplier's invoice number, not the voucher number. This one column decides whether matching works. In Tally it means the supplier invoice number field on the purchase voucher is filled in.
- A file naming rule.
<client code>_<GSTIN>_<return>_<YYYY-MM>.xlsx, for exampleRAVI_29AABCR1234K1ZD_PR_2026-10.xlsx. With fifty clients, files named "purchase final new.xlsx" cost real time. - A drop location per client. A shared folder, an email address, whatever the client will actually use. One place, not WhatsApp plus email plus pen drive.
- A cut-off date for books. Ask clients to send the month's purchase register by the 10th. Late registers go to the back of the queue.
Organise the work by client, then by GSTIN
Keep a client master with the PAN, every GSTIN under it, the state of each, the filing frequency (monthly or QRMP), the accounting package and the staff member responsible. A client with GSTINs in three states is three sets of returns, not one; see clients with multiple GSTINs.
Then sort clients into tiers for the 14th to 20th window:
| Tier | Example | Handling |
|---|---|---|
| A | Many suppliers, high credit, monthly filer | Reconcile on the 14th; manager reviews every break above a set amount |
| B | Moderate volume, steady suppliers | Reconcile on the 14th or 15th; manager reviews the summary |
| C | Few invoices, QRMP | Reconcile in the quarter's last month; batch review |
Tiers decide order, not quality. Every client gets the same checks.
Roles: maker and checker
A two-level split works well:
- Article assistant (maker). Downloads files, runs the reconciliation, works each break to a reason, drafts supplier emails and client queries.
- Manager or senior (checker). Reviews the summary and the breaks above a threshold, approves the IMS actions and the GSTR-3B figures.
- Partner. Sees exceptions only: clients where credit held back is large, notices, and disputes with suppliers.
Write the threshold down. "Every break above ₹10,000, and every rejection in IMS" is the kind of rule a manager can apply in a hurry. The maker should not approve their own work.
Use one list of reasons across the firm
When fifty reconciliations come back with breaks, the manager needs to read them fast. That only works if everyone labels breaks the same way. A short list covers almost everything:
| Reason | Next step |
|---|---|
| Not in 2B: supplier not filed | Supplier email; hold credit |
| Not in 2B: wrong buyer GSTIN | Supplier email; credit note and fresh invoice |
| Not in books | Client query: book it or reject in IMS |
| Tax head or rate differs | Check invoice copy; supplier or client correction |
| Credit or debit note | Client query; decide reversal |
| Amendment | Compare with original |
| Timing: will clear next month | Carry forward; no action |
The twelve common causes map onto these reasons. A reason list also makes supplier chasing efficient: sort every client's "supplier not filed" lines by supplier GSTIN, and one email to a supplier can cover several of your clients' invoices if they share a supplier.
Supplier and client communication
Two templates save hours:
To the supplier: "Your invoices below, issued to [client] (GSTIN …), do not appear in our GSTR-2B for October 2026. Please file or correct your GSTR-1." Attach the list: invoice number, date, taxable value, tax.
To the client: a single sheet per client listing what you need from them: purchases in 2B not in their books, notes to book, payments older than 180 days, and blocked credit you propose to reverse. One sheet, one reply.
The monthly review pack
For each client, the file the manager signs should contain:
- GSTR-2B vs purchase register summary: credit supported, credit held back, by reason.
- IMS actions taken: accepted, rejected, pending, with reasons for rejections.
- GSTR-3B table 4 figures against 2B, by tax head (how to check).
- Sales register vs GSTR-1, and GSTR-1 vs e-invoices for e-invoicing clients (how to check).
- Items carried forward from earlier months and their age.
- Sign-off: maker, checker, date.
Section 36 of the CGST Act requires accounts and records to be kept until 72 months from the due date of the annual return for the year, and this pack is what you will reach for when a notice comes, including a DRC-01B or DRC-01C intimation about differences between returns.
Annual work gets easier if monthly work is clean
GSTR-9 and the year-end ITC review draw on the same data. If every month's open items are carried forward and resolved, the year-end is a summary of twelve reconciliations rather than a fresh exercise. Two dates to keep in the annual calendar: credit for a financial year must be claimed by 30 November following the year (or the annual return date, if earlier) under section 16(4), and rule 37A reversals for suppliers who did not file GSTR-3B are due by the same 30 November.
Sources
- GSTN FAQ, Viewing Form GSTR-2B (generation on the 14th): https://tutorial.gst.gov.in/userguide/returns/FAQ_gstr2b.htm
- GSTN advisory on non-editable auto-populated liability in GSTR-3B from the July 2025 tax period: https://www.taxscan.in/top-stories/gstn-advisory-auto-populated-liability-in-gstr-3b-to-become-non-editable-from-july-2025-1421228
- GSTR-1A, introduced by Notification 12/2024-CT: https://cleartax.in/s/gstr-1a
- CGST Act, 2017, sections 16(4) and 36, CBIC tax information portal: https://taxinformation.cbic.gov.in/
- Rule 37A: https://taxguru.in/goods-and-service-tax/rule-37a-cgst-rules-reversal-re-availment-input-tax-credit-itc.html
- Rule 88C and DRC-01B: https://cleartax.in/s/rule-88c-differences-between-gstr-1-and-gstr-3b
How RefinePoint does it
RefinePoint is built for this kind of practice. A firm works in one workspace with a Clients list, where each client carries its name, PAN and GSTINs, and every reconciliation belongs to one client. The Reconciliations, Breaks and Results pages filter by client, and you can name the group that works on a client so only they see its reconciliations. The GST templates (GSTR-2B, GSTR-2A, GSTR-1, e-invoices, GSTR-3B, the ITC eligibility check and Form 26AS) label open items with a shared set of reasons (Not in portal, Not in books, Rate or tax head, Credit note, Amendment and so on), so a manager reads every client's breaks the same way. Breaks can be assigned, commented on and approved maker-checker style, open items carry forward month to month, and there is an audit trail of who did what. Request a demo at refinepoint.com, or start free at app.refinepoint.com.