Free Online Tally.ERP9 Help & Tutorial : www.tallyerp9help.com



Generating GSTR-1 Report in TallyERP9

GSTR-1 includes the details of all Outward Supplies of B2B Invoices, B2C invoices, Adjustments to Sales made in Debit/Credit Notes, Exports, Nil Rated Invoices, Advances Received with Tax Adjustments.

GSTR-1 has to be filed by a taxable person registered under GST. GSTR-1 returns can be generated from Tally.ERP 9 in the JSON format , and uploaded to the portal for Filing Returns.

Form GSTR-1 is a statement in which a regular dealer needs to capture all the outward supplies made during the month. Broadly, the GSTR 1 format requires - all the outward supplies made to registered businesses (B2B) to be captured at invoice level, and supplies made to unregistered business or end consumers to be captured at rate-wise level. However, in certain exceptional scenarios, even B2C transactions are required to be captured at invoice level.

Form GSTR-1 contains 13 Tables in which the outward supplies details needs to be captured. Based on the nature of business and the nature of supplies effected during the month, only the relevant tables are applicable, not all. The GSTR-1 format is as follows:

  • Table 1, 2 & 3: Details of GSTIN and aggregate turnover in preceding year.

  • Table 4: Taxable outward supplies made to registered persons (including UIN-holders) other than Zero rated supplies and Deemed Exports.

  • Table 5: Taxable outward inter-State supplies to un-registered persons where the invoice value is more than INR 2.5 Lakh.

  • Table 6: Details of Zero rate supplies and Deemed Exports.

  • Table 7: Details of Taxable supplies (Net of debit notes and credit notes) to unregistered persons other than the supplies covered in Table 5.

  • Table 8: Details of Nil rated, exempted and non GST outward supplies.

  • Table 9: Details of debit notes, credit notes, refund vouchers issued during current period and any amendments to taxable outward supply details furnished in the GSTR1 returns for earlier tax periods in Table 4, 5 & 6.

  • Table 10: Details of debit note and credit note issued to unregistered person.

  • Table 11: Details of Advances Received/Advance adjusted in the current tax period or Amendments of information furnished in earlier tax period.

  • Table 12: HSN-wise summary of outward supplies.

  • Table 13: Documents issued during the tax period.

GSTE-1 Report has 2 types of Views....

  1. View Return Format (Default View) by Tally.ERP9

  2. View Summary by Tally.ERP9

there are two sections in the report:

  • Particulars - displays the taxable value and tax amount from outward supplies considered in the returns.

  • Returns summary - a snapshot of the business operations in the given period.

1. View Return Format (Default View) of GSTR-1 Report under GST in Tally.ERP9

  • Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR–1 .

The report displays the data for a month or quarter depending on the Periodicity of GSTR-1 set in the Company GST Details screen.

If the report is not appearing in the format shown below, press Alt+V .

View Return Format (Default View) of GSTR-1 Report in TallyERP9
(Fig-201)

Note: You can press Alt+V in GSTR-1 report to change the view from return format to summary view and vice-versa.

Click F12: Configure to change the settings, if required and view the report with the relevant transactions.

F12-Configure to change the settings of View Teurn Format of GSTR-1 Report in TallyERP9
(Fig-202)

  • Specify the required reporting period by pressing F2 .

  • You can generate the report with the line HSN/SAC Summary by enabling the option Show HSN/SAC Summary? .

  • You can generate the HSN/SAC Summary report with only the description or HSN or both, based on the grouping set in the option Group vouchers by .

  • If HSN/SAC description is not specified in the masters, you can set Use stock item/ledger name as HSN/SAC description when not specified? to Yes . The stock item or ledger name will appear as the HSN/SAC description.

By default, the transactions having voucher numbers more than 16 characters, including special characters ("-" and "/") are not exported to the e-return formats.

In the return format view, there are two sections in the report:

  • Returns summary - a snapshot of the business operations in the given period.

  • Particulars - structured as per the offline tool provided by the department.

2. View Summary Report of GSTR-1 under GST in Tally.ERP9

  •   Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR–1 .

If the report is not appearing in the format shown below, press Alt+V . Displays the local and interstate transactions grouped on GST and non-GST outward supplies.

View Summary Report of GSTR-1 in TallyERP9
(Fig-203)

In the summary view, there are two sections in the report:

  • Returns summary - a snapshot of the business operations in the given period.

  • Particulars - displays the taxable value and tax amount from outward supplies considered in the returns.

F12: Configure

F12-Configure to change the settings of View Summary Report of GSTR-1 in TallyERP9
(Fig-204)

Show break-up of nett values? : Enable this option to display Gross Value, Returns, and Addition/Deduction values in detailed mode of the report. This option is disabled by default.

Show tax types in separate columns? : Enable this option to view all GST tax types in separate columns. This option is enabled by default. When this option is displayed, tax amount is displayed in a single column without the Central Tax, state tax and integrated tax break-up.

Export vouchers with voucher number more than 16 characters? : Enable this option to export the transactions having more than 16 characters, including special characters ("-" and "/") to the template.

Allow tax difference up to : It is set to 0. You can change it as required to ensure the relevant transactions are included in the returns.

Actual Tax versus Computed Tax is : Based on the tax difference value allowed, you can include the relevant vouchers.

  • Greater : Vouchers with actual (transaction) value greater than the computed value are included in the returns.
  • Greater or lesser : Vouchers with actual (transaction) value greater or lesser than the computed value are included in the returns.
  • Lesser : Vouchers with actual (transaction) value lesser than the computed value are included in the returns.

3. Return Summary of GSTR-1 Report in Tally.ERP9 (a snapshot of the Business Operations in the given period.)

This section provides a summary of all transactions recorded in the reporting period. You can drill down on each row to view the details.

Return Summary of GSTR-1 Report in TallyERP9
(Fig-205)

(A) Total number of vouchers for the period

Drill-down shows the Statistics report, listing the vouchers participating in the GST return.

Total No of Voucher Report of Return Summary of GSTR-1 Report in TallyERP9
(Fig-206)

(B) Included in Returns

Drill down from this row to view the Summary of Included Vouchers report, with the list of voucher-types with voucher count.

Included in Return Report in GSTR-1 View Summary Report in TallyERP9
(Fig-207)

(C) Not relevant for Returns

Drill down from this row to view the Summary of Excluded Vouchers report, with the transaction type-wise voucher count.

No relevant for Returns Report in GSTR-1 View Summary Report in TallyERP9
(Fig-208)

Other transaction types that can appear under excluded vouchers:

  • Excluded by User : Manually excluded by you from the list of included or uncertain transactions. Drill down and use : Include Vouchers , if required . Based on the information in the voucher it will move to either included or uncertain.

  • Contra Vouchers : The count of contra entries which involve only bank and cash ledgers.

  • Order Vouchers : The count of sales order, purchase order, job work in order, and job work out order vouchers.

  • Inventory Vouchers : The count of receipt note, stock journal, delivery note, material in, material out, rejections in, rejections out, and physical stock vouchers as they are purely inventory in nature and do not attract GST.

  • Payroll Vouchers : The count of transactions recorded using payroll and attendance vouchers. GST does not apply to these transactions.

  • No GST Implications : The count of receipts, payments, and journal vouchers that do not have any GST implication.

  • Other voucher : The count of memorandum and reversing journal vouchers.

  • Non GSTR-1 Transactions : The transactions which are part of other returns, for example: GSTR – 2, and hence will not have any implication on GSTR–1.

All the transaction types are not displayed by default. Based on the voucher type used and the exclusions done by you, the relevant categories appear with the voucher count.

(D) Incomplete/mismatch in information (to be resolved)

Displays the count of all vouchers with insufficient GST-related information. You can correct exceptions in the vouchers 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) . To set the tax difference that you want to allow, to include the vouchers in the returns:

  • Click F12: Configure .
  • Enter the value in the field Allow tax difference up to .

The exceptions are listed in the order of priority, based on the importance of the information for generating returns. You need to update the missing information and resolve the mismatches to include these in the returns.

 
Journal Voucher for Refund of Tax, Interest, Penalty, Late Fee or Other Dues under GST in TallyERP9 GST Using Tally.ERP9 File GSTR-1 Return by Generating JSON Format using TallyERP9


Get...Tally.ERP9 Book + GST Assignment (2 Set) @ Rs.550


 
Disclaimer :

Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.

The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademarks :
Tally,Tally GST,TallyERP9 GST, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website
About | Privacy Policy |
© 2019 : www.tallyerp9help.com