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



View, Generate and File GSTR-3B Report using Tally.ERP9

Form GSTR-3B is an interim return form the GST dealers with regular registration should use, to file monthly returns.

Form GSTR-3B consists of 6 tables in all, each requiring a specific detail.

Table 1: Details of outward supplies and inward supplies liable to reverse charge

Table 2: Details of Interstate supplies made to unregistered persons, composition dealers and UIN holders

Table 3: Details of eligible Input Tax Credit

Table 4: Details of exempt, nil-rated and non-GST inward supplies

Table 5: Payment of Tax

Table 6: TDS / TCS Credit

From Tally.ERP 9, you can generate GSTR-3B, export the data in the JSON format, and upload it to the portal to file the returns.

In Tally.ERP 9, you can view GSTR-3B in the report format with tax computation details. This report can be changed to the return format view (specified/prescribed by the department) with the click of a button.

1. View the GSTR-3B Report using Tally.ERP9

Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-3B .

(A) Return Format View of GSTR-3B in Tally.ERP9

Click : View Return Format . The Return Format View displays the values in the actual Form GSTR-3B format. The values are captured under different sections of the form.

Return Format View of GSTR-3B Report in TallyERP9
(Fig-227)

Return Format View of GSTR-3B Report in TallyERP9
(Fig-228)

Return Format View of GSTR-3B Report in TallyERP9
(Fig-229)

Click F12: Configure .

  • Show tax types in separate columns? - Enable it to view the breakup of tax amount.

  • 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 : 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.

(B) Summary View of GSTR-3B in Tally.ERP9

Click : View Summary . The Summary View provides the tax computation details with the taxable value and tax break-up for local and interstate supplies under taxable, exempt, and nil-rated categories.

Summary View of GSTR-3B Report in TallyERP9
(Fig-230)

Summary View of GSTR-3B Report in TallyERP9
(Fig-231)

The section Ineligible Supplies displays the taxable purchases of within or outside the state, which are ineligible for claiming tax credit. Press Enter to view the Voucher Register .

Voucher Register of Summary View of GSTR-3B Report in TallyERP9
(Fig-232)

Click F12: Configure and enable the option Show details of eligible credit? to view the breakup of eligible and ineligible tax values. The party-wise view (press Alt+A ) appears as shown below:

Party-wise View under Summary View of GSTR-3B Report in TallyERP9
(Fig-233)

The different sections of the report are:

Returns Summary : This section displays a snapshot of business operations in the given period.

  • Total number of vouchers for the period - Displays the total number of vouchers. Drill down to view the Statistics report.

  • Included in returns - Displays the number of vouchers that are:

    • Participating in the returns : Displays the number of vouchers that are part of the return tables. Drill down to view the Summary of Included Vouchers .

Summary of Included Voucher in Return under Summary View of GSTR-3B Report in TallyERP9
(Fig-234)

    • No direct implication in return tables : Displays the number of vouchers recorded as book entries that do not have an impact on the GSTR-3B returns. Drill down to view the Summary of Included Vouchers .

Summary of Included Voucher in Return under Summary View of GSTR-3B Report in TallyERP9
(Fig-235)

  • Not relevant for returns : Displays the number of transactions that are excluded from the returns. Drill down to view the Summary of Excluded Vouchers .

Summary of Excluded Vouchers in Return under Summary View of GSTR-3B Report in TallyERP9
(Fig-236)

  • Vouchers with Incomplete/Mismatch in information (to be resolved) for the reporting period.

Drill down from any row to view the list of vouchers under the respective category. You can resolve the exceptions for vouchers under Incomplete/Mismatch in information (to be resolved) to include them in the 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 .

Particulars (computation details) : This section displays the taxable value and tax amount from outward supplies and inward supplies considered in the returns. The format of this section can be changed from Summary View to Return Format View and vice versa.

 

2. File GSTR-3B Report in GST Portal by generating the JSON file using Tally.ERP9

In Tally.ERP 9, you can export data in the JSON format and upload it to the portal for filing the returns.

Ensure that all exceptions regarding incomplete/mismatch in information are resolved before printing or exporting the GSTR-3B report.

(A) To Generate GSTR-3B Returns in the JSON format in Tally.ERP9

1.  Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-3B .

2.  F2: Period - select the period for which returns need to be filed.

3.  Press Ctrl+E .

Exporting GSTR-3B Report in JSON Format using TallyERP9
(Fig-237)

4.  Select JSON (Data Interchange) as the Format .

5.  Press Enter to export. The negative net values will be exported with a negative sign, as per the e-filing requirements.

Upload the JSON file to the portal for filing returns.

 

(B) To Submit and File GSTR-3B Returns in GST Portal through JSON File Using Tally.ERP9

1.  Press Ctrl+O from GSTR-3B report, to log in to the GST portal .

Submit and File GSTR-3B Returns through JSON File in GST Portal using TallyERP9
(Fig-238)

2.  Go to Dashboard > RETURN DASHBOARD .

Submit and File GSTR-3B Returns through JSON File in GST Portal using TallyERP9
(Fig-239)

3.  Select the Return Filing Period , and click Search .

Submit and File GSTR-3B Returns through JSON File in GST Portal using TallyERP9
(Fig-240)

4.  Under Monthly Return GSTR3B , click PREPARE OFFLINE > UPLOAD tab > click CHOOSE FILE to import the GSTR-3B JSON file generated from Tally.ERP 9. Once your JSON files are uploaded successfully, you will be notified with a message. Once the file is successfully uploaded theError Report displays NA .

Submit and File GSTR-3B Returns through JSON File in GST Portal using TallyERP9
(Fig-241)

5.  Click BACK > Monthly Return GSTR3B , click PREPARE ONLINE . The values get posted in the relevant tables of GSTR-3B.

Submit and File GSTR-3B Returns through JSON File in GST Portal using TallyERP9
(Fig-242)

6.  Click SAVE GSTR3B to save the details.

7.  Click PREVIEW DRAFT GSTR-3B to preview or download the form, check the details, and correct it if required.

8.  Click PROCEED TO PAYMENT to view the available input tax credit. You can modify the values if required.

9.  Confirm the input tax credit, to offset against the payable value. For the balance amount payable, challan gets generated automatically with the relevant details, and payment options appear.

10.  Once you make the online payment, the payments table appears.

11.  Click PROCEED TO FILE , select the authorised signatory and SUBMIT with EVC or DSC.

Note: Once you click the SUBMIT button, GSTR-3B cannot be revised.

 
Generating GSTR-2 Report using Tally.ERP9 GST Using Tally.ERP9 View, Generate and File GSTR-9 using Tally.ERP9


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