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 it 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 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 late fee is charged after the 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 data.
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 data 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 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 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 offline tool from the GST Portal for exporting your data 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
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.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:
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. However, technical content writing is currently her niche with more than 2 years of experience in writing about business software and hardware. She is... Read more