Follow Us:

GSTR 2B Matching Excel Utility V.2 (Free)

GST Council Instructed All GST Taxpayers Can Take Input Tax Credit Based on GSTR 2B. GSTR 2B is a Auto Drafted Statement Generated (For Instance) for the month of Aug 2021, a Suppliers filed their GSTR1 on 12th Aug 2021 up to 11th Sep 2021. The statement for Aug 2021 will be generated on 12th Sept 2021.

GST Tax payers get struggling to Match Their Book ITC With Portal Generated GSTR 2B Data. We Introduced “GSTR 2B Matching Utility” is Enable to Match Your ITC With Quick & Perfect.

Now We Introduced Utility Can Match & Reconcile Your B2B Invoices, Debit Notes, Credit Notes, Imports & Amendments. (Our Utility Not Required Invoice No is Similar as per Supplier mentioned in Invoice. For Instance, Supplier Mentioned Invoice no. CBE-32-2020-21 , But You mentioned in your books Invoice No. 32)

From our Utility Matching & Reconciliation Results Based on Your Books ITC Vs As per GSTR 2B are as follows (Invoice Wise),

1. ITC Not Filed (Input Not Available in Portal)

2. ITC Not Taken (Input Available in GSTR 2B But Not taken in Books)

3. Matching ITC (ITC is Available in Both Books & GSTR 2B)

4. Difference ITC (If ITC is Available in Books & Portal With some Difference)

5. Duplication in Book (If ITC is Taken Twice for single Invoice – This Happens due to clerical mistake)

6. Summary Results (Summarised the Above mentioned Results)

7. One Screen Reconciliation Summary (All GSTN Numbers summarised with All ITC between Books vs Portal)

Newly Added Features:

1. GSTN Mismatch Identify (Our Tool Identifies if any clerical mistake made in GSTN Numbers. Like – If any spaces, Pan Numeral or Alpha Character Errors,Etc.,)

2. Now Your As Per Portal Data Your Suppliers Name Automatically Gathered from Book Data. I.e. Proprietor Name to Trade Name. This Will Help Identify Your Suppliers Easily.

3. Customize Report (ITC Not filed & ITC Not Taken): Now Summarised Results Can Generate ITC Not Filed & ITC Not Taken.

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

Access Denied! Only Regstered Users Can Download The File "GSTR 2B Matching Excel Utility". Register Here or Login

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.


  1. Rathan Sherigar says:

    1. Can I upload 1 full year 2A/2B for reconciliation?
    2. What happens when bill number does not match exactly?
    3. My Company issues Debit notes first to square the ledger for vendor payment. Credit note number is not entered in our books. Can this utility reconcile credit note amounts also? Option not available in the upload CN register from books

    1. madhan.krishnan says:

      1. Yes Sir. We can Reconcile Monthly (or) Yearly Data in this Utility.
      2. Our Utility Using Partial Match Option in Invoice No. Hence if any problems in Prefix & Suffix means, No Problem. It will be a match.
      3. Yes sir. Our Utility can reconcile Credit/Debit Note also. Options available in this Latest Version.

      We sent the latest version Utility to your mail ID. Please check.

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Post by Date
July 2024