GSTZen

JSON to XLS (JSON to Excel) Converter - Frequently Asked Questions

Overview

What are the JSON to Excel (XLS) Converters currently available at GSTZen?

At present, GSTZen supports the following JSON to XLS Converters.

Where can I find these converters?

Visit my.gstzen.in and click on the menu named "Useful Tools" on the top of the page, in the navigation bar. You will see links to these converters in the drop down menu.

GSTR-2A JSON to XLS

Click on Choose file and upload the JSON file downloaded from Government Portal. Then Click on Convert to Excel.

GSTR-2A JSON to XLS Upload Page

Click on Download GSTR-2A XLS to download and View the Excel data.

GSTR-2A JSON to XLS Main Page

How does the Excel output look like?

Here's a screenshot of the output sample from the GSTR-2A JSON to XLS Converter. The spread sheet has one row per Invoice with columns for the Supplier's GSTIN number, Supplier's name, Supplier's Filing Status, Invoice Date, Invoice Number and Tax Amounts.
GSTR-2A JSON to XLS

Is your conversion software available for download? Can I run it on my computer?

At present, GSTZen's conversion software is an online software. Access it using your Web Browser such as Google Chrome, Mozilla Firefox, or Microsoft Edge. Upload your JSON file and download XLS output. If there is enough demand, we might consider providing a Desktop version.

I used your converter, but the output was limited to 200 Invoices. How do I get the rest of the data?

The free version of the Converter is limited to 200 records (Invoices, Credit Notes, etc.) in a file. To convert larger files, please signup at GSTZen, login into your account, and then convert.

How can I signup and login?

Payment

How to make a payment to your GSTZen Wallet?
What is the price of the conversion software?

GSTZen's JSON to XLS converters are available online and the price is based on usage. The conversion cost is free for the first 200 records (Invoices, Credit Notes, etc.) in a file. Additional records are charged at 1 Paisa per records. For example, to convert a file with 330 records, the cost will be Rupees 2 (Rupees Two).

The approximate conversion cost for various number of records is shown:

Num. RecordsIn WordsConversion Cost()
200Two hundredZero
500Five hundred3.00
1,000One Thousand8.00
5,000Five Thousand50.00
10,000Ten Thousand100.00
50,000Fifty Thousand500.00
1,00,000One Lakh1,000.00
5,00,000Five Lakh5,000.00
10,00,000Ten Lakh10,000.00
Do I have to pay before converting a file?

Yes. GSTZen uses a pre-pay model. Any amount that you pay gets added into your Wallet. Every time you convert, GSTZen deducts from your Wallet balance.

How much should I pay?

The minimum payment amount is Rupee 1 (GST additional). You can add as little or as much as you want based on your expected usage.

GSTR-2A JSON to XLS

Where should I pay?

Firstly, make sure that you have created an account on GSTZen and that you have logged in into your account. After logging in, you will see your name on the top right hand corner of the page. Click on our name, and then click on Billing.

In this page, you will see details about your GSTZen Wallet balance. You can choose an amount and add funds to your Wallet.

GSTR-2A JSON to XLS

What payment methods are supported?

We support all major Credit and Debit cards, Net banking from all Major banks, UPI, and Private Wallets. If you are not able to pay using one of these methods, please get in touch with us. We can accept NEFT/RTGS payments to our bank account.

When will I receive an Invoice for my payment?

Against each payment, we issue a GST Tax Invoice. If you have provided your GSTIN number, we will issue you a B2B Invoice. Otherwise, we will issue you a B2C Invoice. Usually, you should receive the Invoice in your email the same day you make the payment. We guarantee to send out the Invoice within 2 working days.

How long are funds added to the Wallet valid for?

Any amount added to your GSTZen Wallet is valid for 1 year.

Where can I view my GSTZen Wallet Balance?

You can view it in the your Billing page (in the same page from which you made your payment).

Troubleshooting

The output of your converter does not match the output shown in the Government portal. Is your converter wrong?

Our Converter's output is correct. The usual explanation for the difference is that the file you are converting is old. Please check your file name and make sure that the file was generated recently. For example, if your file name starts with returns_26042018_R2A it was generated on 26-Apr-2018. Even though you might have downloaded your file today, it might have been generated a long time ago.

To know about GSTR-2A Reconciliation with GSTZen, please click here
To known about GSTR-1 vs GSTR-2A vs GSTR-3B Consolidated Comparison Report, please click here