GSTR-2B Reconciliation: Moving Beyond VLOOKUP to Fuzzy Matching Algorithms
Eliminate manual VLOOKUP errors in GST reconciliation: how fuzzy matching handles invoice formatting, leading zeros, and tax rounding variations.
Abhishek Kumar
The financial risk of accepting vendor invoices without valid IRNs — how Rule 48(4) invalidates documents and exposes buyers to tax clawbacks.
Abhishek Kumar
Senior Finance & ERP Systems Architect, Werkora

Under Rule 48(4) of the CGST Rules, an invoice issued by an e-invoicing-mandated supplier without a valid 64-character Invoice Reference Number (IRN) and signed QR code is legally non-existent. Buyers who accept and pay GST on such invoices cannot claim Input Tax Credit under Section 16(2)(a) and face departmental recovery notices with 18% interest.
Rule 48(5) explicitly states that any invoice issued in any manner other than the manner specified in Rule 48(4) shall not be treated as an invoice. This means an attractive PDF with GST registration numbers and bank details is legally equivalent to blank paper if the supplier exceeded the ₹5 crore threshold and failed to generate an IRN.
When a manufacturer accepts ₹1 crore worth of raw materials with 18% GST (₹18,00,000 tax) on an invalid invoice, the exposure is twofold: the ₹18 lakh credit is disallowed, and the tax department issues a demand notice under Section 73 or 74 demanding 18% annual interest from the date the credit was utilized.
Werkora incorporates structured receiving controls at the warehouse receiving dock. When staff enter vendor bills, the ERP cross-references the supplier GSTIN, purchase order terms, accepted GRN weights, and invoice values, ensuring zero unverified invoices enter the accounts payable ledger.
Werkora equips every shop-floor supervisor, line operator, storekeeper, and accountant with their own dedicated login with plans sized for your operation.
No. If the supplier is mandated to generate e-invoices, credit is only valid upon possession of the tax invoice containing the valid IRN and QR code at the time of claim.
Werkora verifies inward shipments against authorized purchase orders with strict 3-way matching to prevent overbilling or unauthorized stock.
Senior Finance & ERP Systems Architect, Werkora
Senior accountant and enterprise systems specialist with 9+ years of experience across Indian GST/TDS compliance, SAP S/4HANA, Tally Prime, and finance automation. Direct operational background in precision instruments manufacturing and multi-jurisdictional statutory compliance with a zero-penalty record.
Copy a citation to include this guide in your article or report.
Benchmark your current software bills against Werkora's unit-based pricing (10 users/unit · min 3 units).
Projected 3-Year Savings for Your Operation (3 Factory Units · 30 Users)
Save up to ₹6.8 Lakhs over 3 years
Compared to standard per-user seat pricing models like ERPNext ($13.50/user/mo).
Each unit includes 10 active user seats (Operations, Store, Accounts, Planning).
Base commitment minimum is 3 units (30 user seats total).
Commitment Term:
₹14,997/mo (3 Units · 30 Seats)
Annual Cost
₹1,79,964
3-Year TCO
₹5,39,892
$13.50 / user / mo
Annual Cost (30 Users)
₹4,05,816
3-Year TCO
₹12,17,448
₹499 / user / mo (~$6)
Annual Cost (30 Users)
₹1,79,640
3-Year TCO
₹5,38,920
$8 / user / mo
Annual Cost (30 Users)
₹2,40,480
3-Year TCO
₹7,21,440
$50+ / user / mo
Annual Cost (30 Users)
₹15,03,000
3-Year TCO
₹45,09,000
Review the ERP buying guide or contact us to discuss the units, users, and deployment options your factory needs.
Explore adjacent topics in factory operations, costing, and statutory GST compliance.
Eliminate manual VLOOKUP errors in GST reconciliation: how fuzzy matching handles invoice formatting, leading zeros, and tax rounding variations.
Abhishek Kumar
Learn how to build dynamic vendor compliance scorecards that track GSTR-1 filing punctuality, identify high-risk suppliers, and protect cash flow.
Abhishek Kumar