Log In Sign Up

Do Error-free & Fast GST Return Filing & Invoicing

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. In this article, we will cover the following:

  1. How to convert GSTR-2A from JSON to Excel
  2. Easy Matching and Reconciliation on ClearTax GST without any format change

 

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.

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

Step 1 – Login to the GST Portal

 

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

 

GSTR-2A JSON to Excel

 

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

 

3

 

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

 

4

 

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

 

5

 

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.

2. 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!

File GST returns under 15 mins

  • Know tax payable before uploading to GSTN
  • Prepare GSTR – 4, 3B & 1 for all your GSTINs in a single login
Start 30 Days FREE Trial