1. The 1-to-N Multi-Rate Mismatch Problem
Consider a practical scenario: You purchase office supplies consisting of hardware (taxed at 18%) and books/stationery (taxed at 12%) under single Invoice No. INV-880.
- In Your ERP (Purchase Register): The invoice appears across 2 rows (Row 1: ₹10,000 @ 18% = ₹1,800 tax; Row 2: ₹5,000 @ 12% = ₹600 tax).
- In GSTR-2B (Portal Return): The portal may group them into one total invoice row (Taxable: ₹15,000; Tax: ₹2,400) or report them under itemized tax slabs.
If you run a manual Excel VLOOKUP on invoice number, VLOOKUP matches only the first row and ignores the second, triggering huge artificial tax discrepancies!
2. How GST-Hawk Consolidates Multi-Rate Invoices
GST-Hawk solves the 1-to-N matching dilemma automatically:
- Group by GSTIN + Invoice Number: The engine identifies all rows sharing the same supplier GSTIN and invoice number.
- Sum Taxable & Tax Bifurcations: Mathematical summation calculates the net taxable value, IGST, CGST, and SGST.
- Bi-directional Matching: Matches consolidated sums against GSTR-2B records while preserving the underlying line-item details in the 19-sheet Excel workbook.