Step By Step Guide to file GSTR-1 from Tally Prime

Tally Prime is the successor of Tally ERP 9. A majority of SME are using Tally to maintain their books of accounts. Tally Prime is a free upgrade for Tally ERP 9 customers having a valid TSS. With the launch of Tally Prime, many Tally users have migrated from Tally ERP 9 to Tally Prime or are in the process of doing so. Generating GST returns from Tally Prime is as simple as it used to be from Tally ERP9 if not simpler. This is a step by guide on how to file your GSTR-1 from Tally Prime.

Tally’s renowned ‘Prevention – Detection – Correction’ technology capability helps it to generate 100% accurate returns and that too with minimal efforts. Tally is able to detect transactions with incomplete information or errors and allows for an easy system assisted correction. With this capability, you are sure that 100% of your recorded transactions have been analyzed and only the right ones have been included in the returns filed. Now let us go to the GSTR-1 filing process from Tally Prime. In case you are still using Tally ERP 9, you could visit our guide to filing GSTR-1 from Tally ERP 9.

You can file your GSTR-1 from Tally Prime by either exporting a JSON file and importing it directly into the GST portal or generate the GSTR-1 in excel format and import that file into the GST offline utility. The utility will then generate the JSON that will be imported into the GST portal. In this guide, we will see how to use Tally Prime to generate a JSON file. As you will see, it is super easy to generate your GSTR-1 from Tally Prime. Some parts of this guide might not be applicable to you and can be safely skipped.

Step 1. Check the GSTR-1 Report

The beginning of the process to file your GSTR-1 with Tally Prime begins with checking the GSTR-1 report of Tally Prime. Lets us make use of the new Go To button. From whichever screen you are in Tally, press Alt+G and type GST. Then select GSTR-1 from the list shown. Bingo! You are now in the GSTR-1 report of Tally Prime!

You can press F5 in the GSTR-1 report to toggle the view between Return View and Nature View. The report opens in Nature View by default and consists of two sections as seen in the below image

1. Upper Section provides a summary of all transactions recorded in the reporting period. You can drill down on each row to view the details.
2. Lower Section displays the taxable value and tax amount from outward supplies considered in the returns.

1. Upper Section

This section consists of the following sub sections

• Total Vouchers: Entering this shows a statistics report, listing all the vouchers participating in the particular GST return
• Included in Return: On entering this sub-section, you can view the ‘Summary of Included Vouchers’ report having the list of voucher-types with voucher count that have an effect on the return such as sales.
• Included in HSN/SAC Summary: Against this sub-section, you will see a count of vouchers that have been considered for HSN/SAC related calculations. On entering this sub-section, you will see a register of all the vouchers which count to the figure in the main report
• Incomplete Information in HSN/SAC Summary (Corrections needed): Against this sub-section, you will see a count of vouchers that have been ignored for HSN/SAC related calculations. When you drill-down, you will see a register of all the vouchers which count to the figure in the main report
• Not relevant in this return: When you drill down from this row, you can view the ‘Summary of Excluded Vouchers’ report. This shows the transaction type-wise voucher count of vouchers not included in the particular return. These could include purchase vouchers etc
• Uncertain Transaction (Corrections needed): You will see the count of all vouchers with insufficient GST-related information on drilling down in this sub-section. You have to correct all exceptions in the vouchers appearing in this list before exporting GST returns. If the computed tax is not equal to the tax entered in the invoice, the transaction appears under Incomplete/Mismatch in information (to be resolved). You need to update the missing information and resolve the mismatches to include these in the returns. If the number of vouchers under this sub-section is zero, then in all probability, your return is ready. This is the most important sub-section among all four sections. Now, if this is showing some vouchers, then you need to correct them. Press Enter on No. of vouchers with incomplete/mismatch in information. You won’t require to spend much time in this section if you properly configure GST in Tally and pass your sales vouchers with some care. We have explained the various errors below.
  • Click X: This is to exclude from Summary in the Exception Resolution screen to exclude a voucher from the GSTR-1 return.
  • UoM not mapped to Unit Quantity Code (UQC): You can use only a fixed list of units of measurements specified by the government while filing GST returns. It is mandatory to map all your units in Tally, to one from the official list. You can drill down from this line to see the units that are are yet to get map to UQC.
  • Reporting Unit Quantity Code (UQC) not selected for stock items with multiple UQC: It is similar to the above error. This is to drill down to view the units for which alternate units have been defined, but not mapped to a reporting UQC.
  • Country, state and dealer type not specified: This indicates that you didn’t specify the country, state, dealer type or GSTIN of a ledger for which you have passed the sales entry.
  • Tax rate/tax type not specified: Drill down to view vouchers where you have missed setting the tax type or rate of tax.
  • Nature of transaction, Taxable value, rate of tax modified in voucher: This indicates that you have manually modified the nature of transaction, assessable value or rate of tax defined in the ledger master during sales voucher entry which was not done correctly.
  • Incorrect tax type selected in tax ledger: In this option, you can drill down to view vouchers in which you have not selected tax ledgers or they are incorrectly selected.
  • Vouchers having conflicting nature of transactions: This means that the voucher has two or more nature of transactions. Basically it means that interstate and intrastate natures of transactions are selected in the same voucher.
  • Mismatch in Nature of transaction and Place of supply, Party’s country: There is a mismatch in the nature of transaction, place of supply and party’s country.
  • Mismatch due to tax amount modified in voucher: There is a difference between the tax amount you have entered and the one calculated by Tally.
  • Vouchers with incomplete/incorrect adjustment details: Drill down from this line to view the journal vouchers with incorrect or incomplete adjustment details.
  • Vouchers having Reverse Charge and Other than Reverse Charge Supplies: You have passed vouchers containing both reverse charge and regular supplies. It displays the count of transactions that have stock items that attract regular tax rates and are taxed under reverse charge.
  • Information required for generating table-wise details not provided: Shows a count of transactions that are excluded from table-wise format of GSTR-1 due to incomplete information. The Exception Types button is provided to resolve all party ledger level or voucher level corrections from a single screen.

2. Lower Section

There are two different views viz Nature View and Return View. The report by default displays the Return View as shown above. You can press Ctrl+H to toggle between both views.

1. B2B Invoices – 4A, 4B, 4C, 6B, 6C: This section, captures the taxable sales made to regular (registered) and composite dealers. Here you can see the total invoice value of your exempt and nil rated items along with taxable items.
2. B2C(Large) Invoices – 5A, 5B: B2C Large Invoice means Business to Large Customer Invoice. This includes Unregistered Interstate sale more than Rs. 2.50 Lacs.
3. B2C(Small) Invoices – 7: It means Business to Small Customer Invoice. Sales is Central Unregistered person and Amount is upto 250000. Sale is Local to Unregistered person (Even amount greater than 250000 to be entered here if it is local).
4. Credit/Debit Notes (Registered) – 9B: Displays the values of credit and debit notes (Registered), recorded in the reporting period.
5. Credit/Debit Notes (Unregistered) – 9B: Displays the values of credit and debit notes (Unregistered), recorded in the reporting period.
6. Exports Invoices – 6A: Displays the values of export sales recorded in the reporting period.
7. Tax Liability (Advances Received) – 11A(1), 11A(2): This section shows all the supplies for which an advance was received from the receiver of supplies but invoice was not raised.
8. Adjustment of Advances – 11B(1), 11B(2): The details of tax already paid on invoices issued in the current period against Advance Received and displays details for invoices issued in the current period on which tax has already been paid.
9. Nil Rated Invoices: Displays the net values of nil rated, exempt, and non-GST outward supplies made to registered and unregistered dealers, within and outside the state.

HSN/SAC Summary – 12: HSN/SAC Summary report contains the details of HSN/SAC-wise taxable value and tax amount.
Document Summary – 13: Provides the details of transaction count based on the nature of the document.

You can press Alt+F1 or Alt+F5 to display detailed view to show Reverse Charge Supplies (if any).

Click on Exception Reports (Ctrl+J) to view the report showing Vouchers Accepted as Valid report as shown below:

Press Ctrl+B (Basis of Values) to accept those vouchers normally flagged as not OK for filing. This is to be very judiciously done and to be used in exceptions or in rare scenarios only.

Press Ctrl+H and select Status Reconciliation to show reconciliation status of the vouchers vis a vis the GST portal.

Looks like Tally has developed the last report keeping the future in mind when you will be able to file returns directly from within Tally. Since this view has already come in, it looks likely that this functionality is just around the corner !

Step 2. Export your GSTR-1

You have to export the GSTR-1 Report from Tally Prime in JSON format by clicking on the Export button or press Ctrl+E. Next select E-Return.

• Select JSON (Data Interchange) as the Format. (You can also choose Excel or CSV if you wish to verify manually or use the GST offline utility or send it to your consultant.
• Select the folder where you wish to export your GSTR-1 return from Tally Prime.
• Set Export document summary to Yes. If you export the data without Export document summary in the export configuration screen of the GSTR-1 report, you have to enter this data directly on the portal manually.
• Next press Enter or click on Send to export the return. You can ignore the Configure button as we are exporting in JSON format.

Tally Prime’s part of the process to file your GSTR-1 from Tally end here. Now we move to the GST portal. This process is same as was being followed earlier in Tally ERP 9.

Step 3. Upload your JSON file to the GST portal

Now we are in the last leg of the process to file GSTR-1 from Tally Prime.

Log in to the GST portal and click Services > Returns > Returns Dashboard .

Select the Return Filing Period , and click Search .

Click PREPARE OFFLINE .

Click Choose File to import the JSON file generated from Tally Prime.

Once your JSON file upload is successful, you will be notified by a message.

Verify the uploaded details after the time specified in the GSTR screen.

Then go to Services > Returns > Returns Dashboard, and click Prepare Online. Check all the tables once and verify if the uploaded data is correct. This is not mandatory but is a good practice to follow.

Now submit your returns and e-sign.

Conclusion

In brief, we can break the entire process in three simple steps.

• Create GSTR-1 in Tally Prime (Actually, Tally Prime creates it automatically. You just need to check it once and rectify errors if any)
• Exporting the GSTR-1 return from Tally Prime in JSON, CSV or Excel file format as required.
• Uploading your GSTR-1 return on the GST portal and filing your return after verifying the information.

As you can see, it is a very simple process to file your GTR-1 with Tally Prime. Once you get the hang of it, you should be able to completely file your GSTR-1 returns from Tally Prime in minutes and not hours if you pass entries in Tally with due care. Generating GSTR-1 in Tally has only one requirement; pass correct and error-free vouchers.

We have seen the entire process of how to file GSTR-1 from Tally Prime till the actual filing on the GST portal. Hope this post has helped clear any confusions on how you can file your GSTR-1 with Tally Prime. You can contact us in case you require any more information. Alternatively, you could also send us a message on WhatsApp by clicking here.