GSTR-2A: Convert JSON to Excel Format

If you are a Small or Medium Business owner or a startup founder in India, chances are you must have come across the concept of GSTR-2A. GSTR-2A is a document that is generated on the GST portal for every registered business in India that files GST returns. The document contains all the details of the invoices that are uploaded by the suppliers of the business in question on the GST portal.

The GSTR-2A document is generated in JSON format and can be quite difficult to read and understand for someone who is not familiar with the format. To make things easier, it is highly recommended that you convert the JSON format to Excel format. In this article, we will guide you through the step-by-step process of converting JSON to Excel format on the GST Portal.

Step 1: Login to the GST Portal

The first thing that you need to do is to log in to the GST portal. If you are not registered on the GST portal, you will need to register by following the registration process which can be found on the GST portal.

Once you have logged in to the GST portal, you will need to navigate to the “services” tab and select “returns” from the drop-down menu.

Step 2: Accessing the GSTR-2A document

In the returns section, you will see a list of all the returns that you have filed in the past. You will need to select the option for “view/download” for the GSTR-2A document.

Once you have selected the option for “view/download” you will be able to see the GSTR-2A document in JSON format.

Step 3: Converting JSON to Excel format

Now that you have the GSTR-2A document in JSON format, you will need to convert it to Excel format. To do this, you will need to use a JSON to Excel converter tool.

There are many free JSON to Excel converter tools available online. Simply search for “JSON to Excel converter” on your favorite search engine and you will be able to find a tool that suits your needs.

Once you have found a tool that you want to use, you will need to upload the JSON file that you downloaded from the GST portal. The tool will then convert the JSON file to Excel format.

Step 4: Downloading the Excel file

Once the JSON file has been converted to Excel format, you will be able to download the Excel file from the tool that you are using. Simply click on the “download” button and the Excel file will be downloaded to your computer.

Step 5: Reading the Excel file

Now that you have the GSTR-2A document in Excel format, you will be able to easily read and understand the document. The Excel file will contain all the details of the invoices that were uploaded by your suppliers on the GST portal. You will be able to see the date of the invoice, the name of the supplier, the amount of the invoice, and much more.

Conclusion

Converting GSTR-2A documents from JSON to Excel format is a simple process that can save you a lot of time and effort. By following the step-by-step guide that we have provided in this article, you will be able to easily convert the JSON file to Excel format and read the document with ease.