Request a demo

Thank you for your response

Our representative will get in touch with you shortly.

Please Fill the Details to download

Thank you for your response

GSTR-2A: Convert JSON to Excel Format

Updated on:  

08 min read

All purchases made by a business reflect in the GSTR-2A generated on the GST Portal. The details in this return are captured from the GSTR-1 filed by your sellers. A registered taxpayer is required to reconcile this GSTR-2A with their purchase invoices.

However, GSTR-2A can be downloaded from GST Portal only in JSON format. 

Latest Update

28th May 2021
CGST Rule 36(4) to cumulatively apply for April, May and June 2021 while filing GSTR-3B of June 2021.

1st May 2021
The CGST Rule 36(4) restricting provisional ITC claims to 5% of GSTR-2B in GSTR-3B is relaxed for April 2021. The taxpayer can apply this rule cumulatively for both April and May while GSTR-3B for May 2021.

1st February 2021
Budget 2021 update: Section 16 amended to allow taxpayers’ claim of the input tax credit based on GSTR-2A and GSTR-2B. Henceforth, the input tax credit on invoice or debit note may be availed only when the details of such invoice or debit note have been furnished by the supplier in the statement of outward supplies and such details have been communicated to the recipient of such invoice or debit note.

15th July 2020
The taxpayers must henceforth use GSTR-2B instead of GSTR-2A from the tax period of August 2020 onwards, for ITC claims in GSTR-3B.

3rd April 2020
The CBIC has notified that taxpayers can claim input tax credit in the GSTR-3B return from February 2020 to August 2020, without applying the rule of capping provisional ITC claims at 10% of the eligible ITC as per GSTR-2A.

While filing the GSTR-3B of September 2020, the taxpayers must cumulatively adjust ITC as per the above rule from February 2020.

The conversion of JSON file into Excel to be able to match and reconcile invoices with GSTR-2A is not required if you are using the ClearTax GST Software. The matching and reconciling is inbuilt in the software that makes your return filing process easier.

When using the GST Portal, here is a step-by-step guide to convert JSON to Excel

GSTR-2A JSON to Excel
3
4
5

Step 1 – Login to the GST Portal  

Step 2 – Go to ‘Services’ > ‘Returns’ > ‘Returns Dashboard’    

Step 3 – Select the ‘Financial Year’ and ‘Return Filing Period’ from the drop-down    

Step 4 – Click on ‘DOWNLOAD’ button under GSTR 2A.    

Step 5 – Click on ‘GENERATE FILE’ and download the JSON file.    

Step 6 – Upload the JSON file and convert it to Excel format using a JSON to Excel converter available online.  

There you have it. Excel file ready for matching with purchase invoices.

Easy Matching and Reconciliation on ClearTax GST without any format change

You do not have to follow the six tedious steps mentioned above to convert JSON to Excel and then reconcile if you using the ClearTax GST Software. All you have to do is:

  1. Download suppliers invoices from GSTN with a single click
  2. Upload all your purchase invoices

ClearTax GST Software will automatically compare the data and prepare the mismatch report.

Once this is done the software will show you a summary of the matched status as shown below:    

pastedImage0

The possible outcomes are:

  1. Matched – Invoices uploaded by you that match with the details uploaded by the suppliers can be seen here.
  2. Mismatch in Values – When you and your supplier both have provided the invoice details in the GST return but there is a difference in date, taxable value, tax amount, total invoice amount.
  3. Missing my Side OR Supplier Side -If the supplier has filed invoice and you have not included it in the return or vice-versa the mismatches are shown here. Also, any difference due to GSTIN mismatch, Invoice number mismatch is listed in this row.

You need to take appropriate action at this stage to avail ITC on the purchases:

  1. Matched invoices – You need to accept the values to claim ITC in your GSTR 2 return.
  2. Mismatched invoices – If you ‘Keep your values’ you will get provisional ITC. Full ITC is received if the Vendors values are accepted.

ITC will not be claimed in the return if no action is taken in the reconciliation process. You can also reset the reconciliation changes if you think you have made a mistake. Here is a video of the entire matching and reconciliation process on ClearTax GST software:

This is how you can use ClearTax GST software to easily reconcile and match invoices without having to download and convert the JSON file. ClearTax GST offers many such features that simplify your GST Billing and Filing process!

inline CTA
India’s Fastest and Most Advanced 2B Matching
Maximise ITC claims, use smart validations to correct your data and complete 2B matching in <1 minute