Every month, between the 14th and the 20th, accounting teams face one of their most stressful compliance tasks: reconciling the purchase register against the GSTR-2B statement. With the introduction of stringent rules blocking provisional Input Tax Credit (ITC) and the implementation of automated portal notices for mismatches, relying on manual Excel VLOOKUPs is no longer a viable option. Human error during these six days can lead to severe working capital blocks or costly penalty notices.
This guide explains how accountants and tax practitioners can move away from manual, line-by-line checking and implement an automated GSTR-2B reconciliation workflow that ensures 100% accuracy, mitigates compliance risks, and efficiently handles new portal mechanisms like the Invoice Management System (IMS).
The 6-day reconciliation scramble: why manual checks fail
The GST portal generates the GSTR-2B statement for a given month on the 14th of the following month. For monthly filers, the due date for filing of Form GSTR-3B is the 20th day of the month following the tax period. For quarterly filers under the QRMP scheme, the due date as notified for different states is the 22nd and 24th day of the month following the quarter.
This tight window leaves accountants with exactly six days to download the portal data, clean it, compare it against their internal ERP or accounting software records, identify discrepancies, follow up with non-compliant suppliers, and finalise the eligible ITC figure for the GSTR-3B return.
The manual bottleneck: Attempting to reconcile hundreds or thousands of invoices using manual Excel formulas like VLOOKUP often fails because suppliers use different invoice numbering formats, leading to false mismatches that consume hours of manual review time.
The sheer volume of transactions in a typical mid-sized business makes manual reconciliation an incredibly high-risk endeavour. An accountant might be dealing with invoices from hundreds of different vendors, each employing varied data entry practices. One vendor might prefix their invoice number with the financial year (e.g., 26-27/INV-0142), while another might use special characters differently. When these records hit the GST portal and are subsequently downloaded in the GSTR-2B Excel file, simple spreadsheet functions inevitably fail to draw the connections.
When VLOOKUP fails, the accountant is forced to visually scan the data, comparing GSTINs and invoice dates to deduce whether a missing invoice is genuinely absent or merely formatted differently. This visual scanning is prone to exhaustion-induced errors. A missed mismatch means either losing out on legitimate working capital by under-claiming ITC, or facing severe penal consequences by over-claiming ITC that the portal's algorithms will immediately detect.
The legal baseline: why 100% matching is mandatory
The era of claiming provisional ITC and reconciling later is permanently over. The GST Council has systematically tightened the rules around ITC claims, making exact matching a mandatory prerequisite.
Under Section 16(2)(aa) of the CGST Act, effective from 1 January 2022, ITC can be claimed only if the details of the invoice or debit note have been furnished by the supplier in the statement of outward supplies (GSTR-1) and such details have been communicated to the recipient in their GSTR-2B.
“the details of the invoice or debit note referred to in clause (a) has been furnished by the supplier in the statement of outward supplies and such details have been communicated to the recipient of such invoice or debit note in the manner specified under section 37” Source: Section 16(2)(aa), CGST Act
Simultaneously, Rule 36(4) of the CGST Rules was amended to completely remove the old provisional ITC buffer. Before 1 January 2022, there was a provisional ITC buffer of initially 20%, then 10%, and finally 5%. Today, no input tax credit shall be availed by a registered person in respect of invoices or debit notes unless the details have been communicated to the registered person in Form GSTR-2B.
Additionally, merely finding the invoice in your GSTR-2B is not sufficient for claiming the credit. Under Section 16(2)(b) of the CGST Act, a registered person is not entitled to credit of input tax unless he has actually received the goods or services. Automation helps you flag invoices that appear in the portal but for which the goods are still in transit, allowing you to correctly defer the ITC claim by using the 'Pending' action in the new IMS.
The cost of claiming unmatched ITC
If you fail to reconcile properly and claim more ITC in your GSTR-3B than what is available in your GSTR-2B, the portal's automated systems will flag the discrepancy. Under Rule 88D, taxpayers receive an intimation in Form DRC-01C when the ITC claimed in GSTR-3B exceeds the GSTR-2B figure beyond a pre-defined limit.
Once you receive this intimation, you are placed under immediate pressure. The rule allows a period of only seven days to pay the excess ITC along with interest or explain the reasons for the difference. It is mandatory to file Form DRC-01C Part B to provide the necessary details and reconcile the difference.
Interest risk: If you wrongly avail and utilise ITC, you are liable to pay interest at 18% per annum under Section 50(3) of the CGST Act. Accurate reconciliation is your only defence against these penal provisions.
How to automate your GSTR-2B matching process
Automation eliminates the drudgery of data formatting and manual formula creation. A proper automated workflow involves three distinct steps that can be executed in minutes rather than hours.
Step 1: Download your GSTR-2B data
Log in to the GST Portal and navigate to the returns dashboard. Download the GSTR-2B for the relevant period. The GSTR-2B Excel downloaded from the GST portal contains B2B, B2BA, CDNR, and CDNRA tables. Alternatively, downloading the JSON file often provides cleaner data for software tools to process instantly.
Step 2: Export your purchase register
Export your inward supplies data from Tally, Zoho Books, or your custom ERP. Ensure that your internal data capture complies with Rule 46(b) of the CGST Rules, which states that an invoice number must be a consecutive serial number not exceeding sixteen characters, containing only alphabets, numerals, and special characters (hyphen or dash and slash).
Step 3: Run the automated match
Instead of building VLOOKUPs, feed both the portal file and your purchase register into a reconciliation engine. An automated tool will instantly categorise every invoice into specific buckets:
- Exact Matches: Invoices where the GSTIN, invoice number, and tax amounts match perfectly between your books and the portal.
- Missing in Portal: Invoices you have accounted for, but your supplier has failed to upload in their GSTR-1.
- Missing in Books: Invoices appearing in GSTR-2B that you have not accounted for. This could indicate missed internal data entry or an incorrect GSTIN used by a supplier.
- Value Mismatches: Invoices where the amounts differ. These often occur due to data entry errors or differing approaches to rounding off. Under Section 170 of the CGST Act, the amount of tax, interest, penalty, fine or any other sum payable must be rounded off to the nearest rupee. If the part is fifty paise or more, it is increased to one rupee, and if it is less, it is ignored. Automated tools often handle these minor discrepancies gracefully.
Handling the Invoice Management System (IMS) in your workflow
Automation becomes even more critical with the introduction of the Invoice Management System (IMS). Live on the GST portal since 1 October 2024, IMS is a facility where the invoices saved or filed by the supplier in GSTR-1, 1A, or IFF can be accepted, rejected, or kept pending by recipients in order to correctly avail ITC.
Pending invoices: Invoices kept pending in IMS are not included in that period's GSTR-2B or GSTR-3B. The recipient can change the action from rejected to accepted in IMS, recompute GSTR-2B at the time of filing GSTR-3B, and take corresponding ITC.
An automated reconciliation tool tells you exactly which invoices to accept (the exact matches), which ones to keep pending (goods in transit or invoices under dispute), and which ones to reject (invoices belonging to another taxpayer wrongly uploaded to your GSTIN). Without an automated match, managing IMS across hundreds of invoices is incredibly risky, as accepting a fraudulent invoice could lead to scrutiny, while blindly rejecting might cause you to lose eligible credit.
The workflow changes significantly under IMS. Prior to its introduction, reconciliation was a post-facto verification exercise. You checked what was in GSTR-2B, claimed what was eligible, and carried forward the rest. With IMS, the process requires proactive decision-making before the final GSTR-2B is even locked in for the month. Because invoices kept pending in IMS will not become part of GSTR-2B, the accuracy of your action directly impacts your immediate cash flow.
Resolving common mismatches with your suppliers
Once your automated tool highlights the mismatches, your next step is resolution. The most critical category is "missing in Portal": these are invoices where you have paid the supplier, including the tax component, but cannot claim the ITC because it is absent from your GSTR-2B.
The GSTR-1A amendment
If your supplier simply forgot to add the invoice, they have a window to fix it immediately. A taxpayer who needs to amend any supply record furnished in GSTR-1 or needs to add any supply record of the same tax period can do so through GSTR-1A in the same month after filing of GSTR-1 and before filing of GSTR-3B.
Understanding time limits and payment rules
When pursuing suppliers for missing invoices, keep the statutory time limits in mind. Under Section 16(4) of the CGST Act, a registered person shall not be entitled to take input tax credit in respect of any invoice after the thirtieth day of November following the end of the financial year to which such invoice pertains, or furnishing of the relevant annual return, whichever is earlier.
Additionally, automation helps you track your own compliance regarding vendor payments. Rule 37 states that a registered person who has availed of input tax credit but fails to pay to the supplier the amount towards the value of such supply along with the tax payable within 180 days from the date of the issue of the invoice, shall pay an amount equal to the ITC availed along with interest. Once you subsequently make the payment, you are entitled to re-avail the input tax credit.
Finalising your GSTR-3B return
The ultimate goal of this entire reconciliation exercise is to populate your Form GSTR-3B accurately. The GST portal has evolved to heavily rely on auto-population to enforce compliance. Specifically, Table 4(A)(5) of GSTR-3B, designated for "All other ITC", is auto-populated on a net basis from the system generated Form GSTR-2B.
While the portal allows you to edit these auto-populated figures, doing so triggers immediate red flags in the GSTN backend, especially if the edited figure exceeds the GSTR-2B value. By adopting an automated reconciliation process, your accounting team ensures that the figures residing in your purchase ledger completely support the unedited, auto-populated values in Table 4(A)(5). If a discrepancy must be reported (perhaps due to reversing ITC for an unpaid vendor under Rule 37,your automated tool provides the exact audit trail required to justify that reversal to a tax officer.
The year-end impact: GSTR-9 annual return
Automating your monthly GSTR-2B reconciliation is not just about avoiding immediate DRC-01C notices; it plays a critical role in your year-end compliance. During the annual return filing (GSTR-9), Table 8A auto-populates directly from the GSTR-2B data (from FY 2023-24 onwards) and this field is non-editable.
If you fail to reconcile your ITC continuously throughout the year, resolving massive discrepancies at the time of filing GSTR-9 becomes an insurmountable challenge. By enforcing a strict, automated month-on-month matching discipline, you ensure that the auto-populated figures in Table 8A of your GSTR-9 align perfectly with your audited financials, paving the way for a smooth annual audit process.
A worked example of automated reconciliation outcomes
Consider an accounting team processing the September 2026 data. They export their purchase register containing 450 invoices and download the GSTR-2B Excel file.
Within seconds, the reconciliation tool provides the following output:
| Invoice No. | In Books ITC | In GSTR-2B ITC | Action Required |
|---|---|---|---|
| INV-0142 | ₹18,000 | Nil | Supplier follow-up |
| INV-0143 | ₹9,000 | ₹9,000 | Accept in IMS |
| INV-0144 | ₹12,500 | ₹1,250 | Check value mismatch |
The team can immediately focus their efforts on contacting the supplier for INV-0142 and investigating the data entry error on INV-0144, rather than wasting hours confirming that INV-0143 matches perfectly.
Related guides
- GSTR-2B vendor wise reconciliation guide
- GSTR-2B reconciliation for large businesses
- How to use a GSTR-2B reconciliation tool
- GSTR-2B reconciliation checklist: monthly process for accountants
Frequently asked questions
Can I claim provisional ITC if an invoice is missing in GSTR-2B?
No. Since 1 January 2022, the 5% provisional ITC buffer has been removed under Rule 36(4). You cannot claim provisional ITC beyond what appears in your GSTR-2B.
When is GSTR-2B generated for a month?
GSTR-2B is generated on the 14th of the following month. For example, GSTR-2B for September is generated on 14th October.
What happens if I claim more ITC in GSTR-3B than what is in GSTR-2B?
If the ITC claimed in your GSTR-3B exceeds the ITC available in GSTR-2B beyond the pre-defined limit, you will receive an intimation in Form DRC-01C under Rule 88D. You then have seven days to either pay the excess ITC or explain the difference.
How does IMS affect GSTR-2B reconciliation?
With the Invoice Management System (IMS), invoices you keep as 'Pending' will not be included in that period's GSTR-2B. You can later change the action to 'Accepted', recompute your GSTR-2B, and claim the ITC in the respective GSTR-3B.
Stop matching invoices line by line
Upload your purchase register and your GSTR-2B JSON or Excel to instantly identify missing and mismatched invoices. We respect your privacy: your GSTR-2B and purchase register files are read in your browser and never uploaded to any server.
Last checked: 30 September 2026. Sources: CGST Act s.16, CGST Rules r.36(4), GSTN Advisory on DRC-01C, GSTN IMS FAQ.