How to File GSTR 1 Using Tally.ERP 9 – A Step By Step Guide

The Goods and Services Tax Return 1 form is an official document that every registered tax payer has to file monthly quarterly. All the tax payers have to enter their details about their sales & supplies in this form. It should contain the details of all the sales done and the supply of goods and services made by the taxpayer during the tax period.

GSTR 1 is filed by every GST registered person. Any regular dealer has to file the GSTR 1 form. It’s a statement which captures all the supplies that are done in a month. GSTR 1 should include two things. It should state the outward supplies that are made to registered B2B businesses at invoice level and the supplies that are made to B2C consumers. It may be possible that some B2C transactions are also needed to be noted at invoice level.

Who Should File GSTR 1

One thing should be kept in mind that this return is not applicable to non-resident taxpayers, composition vendors, and people with a unique identification number. All registered people have to file GSTR 1 irrespective of the fact that they have done any transactions in the month or not.

The following registered people are not required to fill the GSTR1 form:

  • Composition Dealers
  • Non-resident tax payer
  • Suppliers of online information and database access
  • Suppliers of retrieval services who have to pay tax themselves
  • Taxpayer liable to collect TCS
  • Input Service Distributors
  • Taxpayer liable to deduct TDS

Deadline for Filing GSTR 1 Return

The GSTR 1 form has to be filed monthly or quarterly. If you are filing it quarterly, for example, for the Oct – Nov – Dec 2019, you have to file it by 31st Jan 2020. Earlier, a late fee for not filing a GSTR 1 form was INR 200 per day of delay (INR 100 as per the CGST Act and the GSTR 1 penalty is INR 100 as per the SGST Act).

Now, the late fee for GSTR 1 has been reduced to INR 50 per day of delay. The late fee for GSTR 1 for July 2019 has been waived off for the businesses owners in certain flood affected states of Kerala, Karnataka, Bihar, Gujarat, Maharashtra, Uttarakhand, Odisha, and J&K.

The GSTR 1 late fee is charged after the GSTR 1 due date. You cannot revise a return after you have filed it. If you make a mistake while filing, you can correct it in the next month or quarter while filing again. For example, if you make a mistake in October GSTR 1, you can rectify your mistake in November’s GSTR 1.

Steps to File GSTR 1 from Tally.ERP 9

There are three basic processes involved while filing the GSTR-1 with Tally ERP 9. They include exporting the data of the form from Tally to an excel file, converting that excel file to a JSON file using the offline tool available for, and then uploading that JSON file on the GST portal.

Let’s have a look at the step -by -step procedure of filing the GSTR-1 with the help of Tally.ERP 9.

Step 1: Viewing your GSTR 1 report in Tally.ERP 9

For viewing the report generated by Tally.ERP, you have to go to Display > Statutory reports > GST > GSTR 1. You have the facility to view the GSTR 1 report in a table – wise format with all the details captured under different table heads similar which are the same as the actual form. You can also opt for the default view which provides the tax computation information for the outward supplies or sales.

Step 2: Exporting your GSTR 1 report to Excel File

Before this step of exporting your GSTR 1 report in excel file, be very sure that all your sales are included in your GSTR 1 report. For any adjustments that are needed to be done, click on the Stat Adjustment button on the right side or simply press CTRL + J, and pass the adjustment voucher entry to include it in your GSTR-1 report. Just click on the e-return button on the GSTR 1 report for exporting your report.

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

For this step, you have to first install the GST return offline tool which is available on the GST portal on the internet. This will help you create the JSON file from the excel file which is generated from Tally.ERP 9.

Step 4: Uploading the JSON file on the GST portal

After creating the JSON file, now you have to upload the file. For uploading the JSON file on the GST portal, first login to the GST portal. Go to Services > Returns > Returns Dashboard and upload your JSON file. The last step would be to submit the return by clicking on the submit button.

How Tally.ERP 9 Release 6 Makes GSTR 1 Filing Easier

With Tally.ERP 9, it becomes easier to file the GSTR 1 form. It has advanced features for error detection, multiple processes for exporting and real-time tracking of the transactions. Let’s have a detailed look below:

  • Advanced Error Detection and Correction:

With Tally.ERP 9 bifurcates transactions that are important for GSTR-1 but are not included in the form because of manual errors. This helps users to correct their mistakes in the transaction easily.

  • Export Your GSTR 1 in Multiple Formats:

GSTR-1 form can be exported from Tally.ERP 9 in two different formats: MS-Excel and JSON. You have to download the GSTR-1 Offline tool from the GST Portal for exporting your GSTR 1 in MS Excel format. You have to provide the location of the tool, and the GST software can export your GSTR 1 form in the offline tool. Tally.ERP 9 also checks the values before converting the form into JSON format. Then this form is uploaded on the GST portal.

  • Bifurcation of Transactions as Per GSTR 1 Format:

Tally.ERP 9 can automatically bifurcate invoices from B2B, B2C, exports and nil rated invoices as per the GSTR 1 format. Other transactions like credit notes, advances, and debit notes get included automatically in GSTR-1 form.

  • Export Document Summary Sheet Along with GSTR 1 Form:

You can export the document summary sheet as well. The document summary contains details about the total number of transactions which are further divided based on their type. They can be exported from Tally.ERP 9.

  • Track the Status 0f Your Transactions:

You can also update the status of your transaction in Tally.ERP 9. You can find out how many transactions were uploaded, and how many were accepted in the GST portal. You can also view all these transactions as well. All you have to do is open the GST portal from GSTR-1 in Tally.ERP 9.

  • Multiple Views of GSTR 1:

You can view all your transactions. If you want to know the total sales with division based on the tax percentages, then you can view the summary level report. If you want to view data as per the GSTR 1 format, then you can view the report as per the format you wanted.

FAQs

Q. What are the common errors while filing GSTR 1?

The common errors while filing GSTR 1 are:

RET191113 – The GSTIN is invalid.

RET191114 – Date is Invalid. The invoice date cannot be before registration date.

RET191115 – Invoice number does not exist.

RET191124 – Original invoice is Invalid. The original invoice cannot be tracked.

RET191133 – Invoice already exists with same or different CTIN.

RET191150 – IGST is mandatory for interstate supply and CGST & SGST should not be present.

RET191176 – Incorrect shipping bill date.

RET291109 – The GSTIN of the supplier is invalid.

RET191205 – Tax amounts are not in line with the taxable value. Edit tax amount or taxable value.

Q. What’s the penalty on missing GST Return Due Date?

The GSTR 1 form has to be filed monthly or quarterly. The GSTR penalty has changed recently. Earlier, a late fee for not filing a GSTR 1 form was INR 200 per day of delay (INR 100 as per the CGST Act and the GSTR 1 penalty is INR 100 as per the SGST Act). Now, the late fee for GSTR 1 has been reduced to INR 50 per day of delay.

More Use Full links:

Tally erp 9 free download

How to Get GSTIN Number in India

Riya Basu

Riya Basu, a core member of the content team at Techjockey.com, has previously worked with several brands related to lifestyle, travel, education and f&b. She is a YouTuber who creates videos around fashion, food and fitness. A photography enthusiast, she loves to write stories around people and places.

Share
Published by
Riya Basu

Recent Posts

Customer Loyalty Programs: 10 Top Tips for best Customer Retention in 2020

Customers are the backbone of any business. Without customers, there is no demand, no sale, and no business. If we…

December 12, 2019

Create Digital Signature Electronically in 6 Simple Steps

With businesses going global, and exploring new horizons, digital signatures become even more important. eSignature is required by every business…

December 11, 2019

10 Best Books for Business Owners to be Successful in 2020

Whether you are an aspiring entrepreneur or a seasoned one, you have started your entrepreneurial journey with ambition and a…

December 7, 2019

Top Ten Money Making Apps That Will Help Earn Up To 2 Lacs

Who doesn’t want extra money? Our primary source of income is often not enough. But, how can we earn more…

December 6, 2019

Autodesk Maya vs Blender: A Comparative Study of Popular 3D Software

What is Blender 3D Software? Blender is a computer graphics software that is used to develop 2D and 3D animated…

December 3, 2019

8 Best AI Chatbot for Enhancing Business Growth in 2020

What is AI Chatbot? Let’s Find Out AI chatbot is a software program that uses artificial intelligence to come up with…

December 2, 2019