Every month, CAs across India download GSTR-2B, open the client's purchase register in Excel, and begin the tedious process of matching invoices line by line. For a client with 500 purchase invoices per month, this takes 4-6 hours. For larger clients, it can take days.
GST reconciliation is the most time-consuming compliance task in a CA's practice, and yet the process has barely changed since GST was introduced in 2017.
The Process as It Stands
Here is what most CAs do today:
1. Download GSTR-2B from the GST portal as a CSV or Excel file
2. Export the purchase register from the client's accounting software (Tally, Zoho Books, or similar)
3. Open both in Excel, side by side
4. Match invoices by GSTIN + invoice number + invoice date + taxable value
5. Identify mismatches: invoices present in one but not the other, or with different amounts
6. Investigate mismatches: contact suppliers, check for credit/debit notes, verify rounding
7. Prepare the reconciliation statement for the client
8. File GSTR-3B based on the reconciled figures
Steps 4 and 5 are where the time goes. And the mismatches are maddening.
Common Mismatch Types
Invoice Number Formatting: The supplier records the invoice as "INV-2025-0042" while the client's purchase register has "INV/2025/42." Same invoice, different formatting. Excel VLOOKUP cannot match these.
Rounding Differences: The supplier reports taxable value of Rs. 1,00,000 and CGST of Rs. 9,000.00. The client's records show CGST of Rs. 9,000.50, a 50 paisa difference due to rounding at the line-item level vs the invoice level.
Date Mismatches: The supplier reports the invoice in January 2026 (their billing date), but the client recorded it in February 2026 (their receipt date). The GSTR-2B reflects the supplier's filing period.
Missing Invoices: An invoice appears in GSTR-2B but not in the purchase register. Either the client forgot to record it, or the supplier filed an incorrect invoice.
Duplicate Entries: The supplier filed the same invoice twice (in two different months), or the client accidentally recorded the same purchase twice.
Credit Note Adjustments: A credit note issued by the supplier in a later period reduces the ITC, but matching it to the original invoice requires tracking across multiple months.
The Excel Gymnastics
Most CAs have developed elaborate Excel macros or manual processes to handle this:
- VLOOKUP on concatenated keys (GSTIN + Invoice No)
- Fuzzy matching using helper columns with standardised invoice numbers (removing special characters, leading zeros)
- Pivot tables to aggregate by GSTIN and compare totals
- Conditional formatting to highlight differences above Rs. 1
But even with these workarounds, the process is manual, error-prone, and time-consuming. A single formatting inconsistency can cause a mismatch that takes 20 minutes to investigate.
The Time Cost
For a CA firm with 50 GST clients, each requiring monthly reconciliation:
- Average time per client: 4-6 hours
- Monthly total: 200-300 hours
- At Rs. 500/hour (staff cost): Rs. 1-1.5 lakh per month, just on reconciliation
- At billing rates: this time often cannot be fully billed because clients see it as "basic compliance"
This is a significant portion of a mid-sized firm's capacity being consumed by what is essentially a data-matching exercise.
Why Existing Tools Fall Short
Several GST software tools offer "auto-reconciliation," but they typically:
- Require exact matches on invoice numbers (no fuzzy matching)
- Cannot handle the formatting inconsistencies that cause 60-70% of mismatches
- Do not provide explanations for mismatches (just flag them)
- Require manual upload/download cycles from the GST portal
A Better Approach
Effective GST reconciliation needs three things:
1. Fuzzy matching: an algorithm that can recognise "INV-2025-0042" and "INV/2025/42" as the same invoice, with a configurable similarity threshold
2. Tolerance-based amount matching: accepting differences within Rs. 1 as rounding errors, not mismatches
3. Intelligent categorisation: automatically classifying mismatches as formatting issues, rounding differences, missing invoices, or genuine discrepancies
TaxMarg's GST reconciliation does exactly this. Upload your GSTR-2B and purchase register, and get a categorised reconciliation report in minutes instead of hours. Mismatches are explained, not just flagged.