GSTR 2B VS Books ITC Reconciliation Excel Utility

GST TaxPayers are facing difficulty for GSTR 2B ITC Vs Book ITC reconciliation due to Invoice No / Invoice Date / GSTN / Invoice value Clerical mismatches.

Herewith attached the Utility is giving Quick & Perfect Reconciliation results irrespective of Clerical mismatches. This Utility has a Duel Reconciliation method to find the Matches between Unmatched Invoices. For Instance,

1. Invoice No in GSTR 2B is “Inv-123” but in your book mentioned “123” means, the Result is “Matched“

2. If any Error or Mismatch GSTN Provided for an invoice means, that particular invoice is High lighted in GSTR 2B & Book ITC Invoice. Hence We can correct the GSTN and match the Invoice.

3. If There is ITC Difference between same invoices in GSTR 2B Vs Book ITC means, Particular Invoices are shown separately.

4. If Same invoices in Accounted in Book twice means, That particular Invoice is Shown Separately.

5. Summary generated for ITC is Matched (GSTR 2B Vs Book ITC) details in separate sheets.

6. Mismatch ITC Invoices shown separately and It will be Reconciled in Upcoming month GSTR 2B.

If Any Feedback (or) Suggestions Please Let us Know.