Sending raw Excel comparison sheets to clients leads to confusion, delayed return approvals, and unexpected tax demand notices. When tax consultants share a structured monthly report instead of messy worksheets, business owners can quickly verify eligible credit, spot defaulting vendors, and sign off on GSTR-3B figures with confidence.
Core components of a client reconciliation report
Under Section 16(2)(aa) of the CGST Act, a taxpayer can claim input tax credit only when invoice details are furnished by the supplier in GSTR-1 and communicated in Form GSTR-2B. A client-ready report must convert raw matching data into four clear sections: executive summary, mismatch categories, vendor follow-up list, and client sign-off statement.
A comprehensive report format covers the following sections:
- Executive summary: Total input tax credit per books, total ITC reflected in GSTR-2B, eligible ITC claimed, and blocked or withheld amounts.
- Category breakdown: Matched invoices, invoices missing in GSTR-2B, invoices found only in GSTR-2B, and tax value differences.
- Vendor action list: Name, GSTIN, invoice reference, and tax amount for vendors who have not filed their GSTR-1.
- Sign-off block: A formal confirmation sheet for the client to approve numbers before GSTR-3B submission.
Common mistake: Claiming credit for invoices missing from GSTR-2B based on physical bills triggers system scrutiny. Under Rule 88D and Form DRC-01C, claiming excess ITC in GSTR-3B over GSTR-2B generates an automated intimation demanding tax payment or an explanation within seven days.
Standard report structure and layout
To keep the report readable, structure the document into an executive front sheet followed by detailed annexures. For full matching logic, refer to our GSTR-2B reconciliation and ITC matching guide.
1. Executive summary sheet
This sheet gives the finance team an instant view of their tax position and net cash payout for the month.
| Particulars | CGST (₹) | SGST (₹) | IGST (₹) | Total Tax (₹) |
|---|---|---|---|---|
| Total purchase register ITC | 60,000 | 60,000 | 30,000 | 1,50,000 |
| Eligible ITC per GSTR-2B (Claimed in 3B) | 48,000 | 48,000 | 24,000 | 1,20,000 |
| Invoices missing in 2B (Withheld credit) | 10,000 | 10,000 | 4,000 | 24,000 |
| Invoices in 2B only (Pending book entry) | 2,000 | 2,000 | 2,000 | 6,000 |
2. Vendor action annexure
Provide the purchasing department with an actionable list of defaulting vendors so they can pause balance payments until GSTR-1 returns are filed.
| Vendor Name | GSTIN | Invoice No | Invoice Date | Tax Amount (₹) | Recommended Action |
|---|---|---|---|---|---|
| Apex Industrial Supplies | 27AAACA1234A1Z1 | INV-108 | 12 Sep 2026 | 16,000 | Hold payment; follow up for GSTR-1 |
| Zenith Logistics Ltd | 27AAACZ5678B1Z2 | ZN-942 | 18 Sep 2026 | 8,000 | Hold payment; verify quarterly status |
Worked example: reconciliation calculation
Consider Om Enterprises, a wholesale distributor in Maharashtra. During September 2026, their purchase register recorded total ITC of ₹1,50,000. Matching against Form GSTR-2B revealed the following reconciliation results:
| Category | Invoice Count | CGST (₹) | SGST (₹) | Total ITC (₹) | Treatment in GSTR-3B |
|---|---|---|---|---|---|
| Fully matched | 28 | 48,000 | 48,000 | 96,000 | Avail in Table 4(A)(5) |
| Values matched within tolerance | 4 | 12,000 | 12,000 | 24,000 | Avail in Table 4(A)(5) |
| Missing in GSTR-2B | 5 | 10,000 | 10,000 | 20,000 | Withhold; do not claim |
| Tax rate or value difference | 2 | 2,000 | 2,000 | 4,000 | Claim GSTR-2B amount; hold balance |
| In GSTR-2B but not in books | 1 | 3,000 | 3,000 | 6,000 | Verify goods receipt before entry |
The mathematical verification for Om Enterprises is calculated as follows:
Total book ITC recorded = Matched credit (₹96,000) + Matched within tolerance (₹24,000) + Missing in 2B (₹20,000) + Excess book tax (₹4,000) + Baseline matched tax in partial rows (₹6,000) = ₹1,50,000.
Eligible credit to report in GSTR-3B Table 4(A)(5) = Fully matched (₹96,000) + Matched within tolerance (₹24,000) = ₹1,20,000.
Total credit withheld to avoid DRC-01C risk = Missing in 2B (₹20,000) + Difference held (₹4,000) = ₹24,000.
Client communication email template
When sharing this monthly reconciliation format with your client, include a concise note highlighting the withheld tax amounts:
Client sign-off confirmation sheet
Always maintain a signed or emailed confirmation from the client prior to filing GSTR-3B to avoid disputes regarding disallowed credits:
Frequently asked questions
Why should a GST reconciliation report have an executive summary?
Business owners and directors need to see the exact cash tax liability impact before approving the monthly GSTR-3B filing. An executive summary highlights total eligible ITC, withheld credit, and upcoming vendor payment holds without requiring them to sift through thousands of invoice rows.
How does this monthly client report differ from an annual GSTR-9 reconciliation?
An annual GSTR-9 reconciliation deals with retrospective financial year audits and Table 8 differences. A monthly client reconciliation report is an operational compliance tool designed to prevent Rule 88D DRC-01C notices and prompt immediate vendor follow-ups before filing GSTR-3B.
Check your own GSTR-2B
Reconcile your purchase register against GSTR-2B in seconds with instant mismatch categorisation and export-ready reports. Your GSTR-2B and purchase register files are read in your browser and never uploaded to any server.
Last checked: 27 October 2026. Sources: CBIC Tax Information Portal (Section 16, CGST Act), GST Portal DRC-01C Intimation Advisory.