Matching of claimed ITC | GSTR-2A/B vs GSTR-3B

GST Doctor Pro Version is on sale. Purchase once and enjoy lifetime access with free updates, click topurchase

GSTIN Validator (Registration Status for Multiple GSTINs) is back...

Home » Articles » Matching of claimed ITC | GSTR-2A/B vs GSTR-3B
GST Doctor

GST Doctor on Sun May 28 2023

1857

ITC Claimed by the taxpayer has 3 major components i.e. Imports, RCM and All other ITC. Imports can be matched with Bill of Entry document issued by customs and RCM Credit can be matched with the RCM payments made by the taxpayer in GSTR 3B. “All Other ITC” can be matched with GSTR-2A/2B.

Relevant Section: Section 16(2)(c) of CGST Act 2017

Relevant Section: Section 16(2)(aa) of CGST Act 2017 inserted by Finance Bill 2021

Relevant Section: Section 42 of CGST Act 2017

Relevant Rule: Rule 36(4) of CGST Rules 2017

For the verification of “All other ITC”, we need the following documents:

  1. GSTR 2A (B2B and CDN) and for large units also check (B2BA and CDNA) – Officers must download this data from GSTIN Portal using SSO ID and password for authenticity.
  2. Invoice wise breakup of “All other ITC” reported in GSTR 3B-Table 4(5). Data must include certain basic details:

Supplier Name | GSTIN of Supplier | Invoice No. | Invoice Date | Taxable value | IGST | CGST | SGST | Month of taking credit

First thing you should do after getting the data from the taxpayer is create a pivot table in excel (or use filter) and check that the breakup provided by the taxpayer matches the total “All other ITC” reported in GSTR-3B for that month. If it does not match, ask the data again and if it matches do the following steps:

  1. Matching of ITC invoices (3B breakup) with the invoices reflecting in GSTR 2A
  2. Ineligible/blocked credit (even if it is reflecting in GSTR 2A)
  3. Whether full payment of ITC invoices has been made within 180 days to the supplier. (CGST Rule 37)
  4. Credit Notes reversal (reflecting in GSTR 2A CDN and CDNA)

In this article, we will focus only on step 1. For information on other steps, click the respective links.

Matching of claimed ITC with GSTR-2A

We will be matching the ITC invoices with GSTR-2A invoices on the basis of 6 columns:

GSTIN of Supplier | Invoice No. | Invoice Date | IGST | CGST | SGST

We will be using GST Doctor ITC Matching Software which is available on Microsoft Store for windows 10. The benefit of using this software is that unlike excel, it is specifically designed for the purpose of matching ITC. So, it understands the requirements and matches the invoices even after common typing mistakes and also takes care of other issues such as duplicate invoices. After matching the summery of the matching result will look something like this:

CategoryNo
Fully Matched93063
GSTIN Mismatch2783
Invoice No Mismatch6399
Invoice Date Mismatch656
Tax Mismatch3125
Weak Match11593
Debit Entry1436
Duplicate Invoices861
Negligible5
Not in 2A100

To see detailed information about these heads, you can go to the sheet “ITC vs 2A” and filter any of the heads. We are mainly concerned about the invoices “Not in 2A”, “Tax Mismatch” and “Duplicate”.

How to use GST Doctor ITC Matching Software

Step 1) Download and launch the Software.

gst doctor app

Step 2) Upload ITC Excel File and GSTR-2A Excel file using the respective buttons.

Step 3) Click Start Input Matching button and wait for the program to complete.

Step 4) Download the Result Excel File which includes 5 Sheets:

  1. ITC vs GSTR 2A side by side comparison. (Use Filter on this sheet)
  2. GSTR-2A uploaded by the user (with information on what ITC is not taken)
  3. GSTIN wise Matching
  4. Abstract of the comparison
  5. Details of book adjustments (reversals made)

Disclaimer: All the information on this website is published in good faith and for general information purpose only. Any action you take upon the information you find on this website (gstdoctor.com), is strictly at your own risk.

Comments

Milan Tiwari

Milan Tiwari on Mon Jul 17 2023

Now you can also use ITC Matching Tool online on https://gstdoctor.com/tools/gst-itc-matching

10
Ravindra Soni

Ravindra Soni on Wed Jan 03 2024

i want to use ITC Matching Tools but it's not work

1
GST Doctor

GST Doctor on Sun Mar 10 2024

Please contact on [email protected] with screenshot of the error.

10