Log In Sign Up

GSTR-1  is a monthly or quarterly return that should be filed by every registered dealer. It contains details of all outward supplies i.e. sales.

Use Tally for Accounting, ClearTax for GST

 

Download Tally Patch

 

In this article, we will explain to you how to file GSTR-1 from Tally 9 ERP 6.

The process of  filing the GSTR-1 from Tally ERP 9 on the GST portal can be divided into three steps :

Step 1: Exporting the data of GSTR-1 from tally to excel file.

Step 2: Converting the excel file to JSON file using GST offline tool available on GST portal.

Step 3: Uploading the JSON file on GST portal.

Detailed Steps to file GSTR-1  using Tally ERP 9 Release 6

Step 1: View the GSTR-1 report in Tally

First, view the GSTR-1 report generated by Tally.

For this go to Display > Statutory reports > GST > GSTR-1.

GSTR 1 Report

 

You can view the GSTR-1 report in the table wise format with the details captured under different table heads similar to the actual form.

Alternatively, you can also select Default View which provides the tax computation information for all the sales or outward supplies.

Step 2: Exporting the GSTR-1 report to Excel file

You can export the GSTR-1 details in excel file.

But before exporting the GSTR-1, make sure that all the sales are included in GSTR-1 report.

Export GSTR 1 to Excel File

 

If any adjustments are required for instance advance receipts etc, press CTRL + J or click the Stat Adjustment button on the right side and pass the adjustment voucher entry so that it gets included in GSTR-1 report.

To export the return, click the e-return button on the GSTR-1 report.

GSTR E-Return

 

Step 3: Create JSON file of the excel file using GST offline tool

Extract and install the GST return offline tool available on the GST portal.

It will help you to create the JSON file from the excel generated from Tally.

Step 4: Upload the JSON file on GST portal

Once you have created the JSON file, you need to upload this file.

For this login to the GST portal. Go to Services > Returns  > Returns Dashboard. Now upload the JSON file prepared by you and submit the return.

GST Portal

 

How does ClearTax GST Software simplify filing GSTR-1?

  • Easy import of sales invoice to software.
  • Auto-populate data to make sure that the return is error free.
  • Update of return on GST Portal without the need to login.
  • No need to convert Excel to JSON file. Just upload on ClearTax to update details on GST Portal.
  • Import of sales details from Tally/Busy or Government Software.
  • Bulk updating of invoices.

Use ClearTax Billbook to create an invoice in a hassle free and easy manner.

To understand how to create sales invoice in ClearTax GST software, refer to the guide on Creation of Invoices.

For further reading: