What is Form GSTR-3B ,How to generate GSTR-3B and file return in Tally erp 9

Form GSTR-3B  is an interim return form to be used by GST dealers with regular registration for filing returns for the month of July and August. GSTR-3B is an online form where dealers will enter details directly on the GST portal. This report can be printed from Tally.ERP 9 with all transaction details in the required format. The details from the printed report can be used to fill in the online form on the GST portal.

In Tally.ERP 9, GSTR-3B can be viewed in the report format with tax computation details. This report can be changed to the table-wise format (department format) with the click of a button.

To view GSTR-3B

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

The GSTR-3B report appears as shown:

Form -3B

The different sections of the report are:

Returns Summary: This section displays a snapshot of business operations in the given period. Displays the Total number of vouchers for the period, vouchers Included in returns, vouchers Not relevant for returns and 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 voucher under Incomplete/Mismatch in information (to be resolved) to include them in the returns.

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 Default View to Table-wise View and vice versa.

Default View

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

Table-wise View

The Table-wise View displays the values using the actual Form GSTR-3B format. The values are captured under different sections of the form.

Generate GSTR-3B and File Returns

Ensure that all exceptions regarding incomplete/mismatch in information are resolved before filing and submit return.

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

File GSTR-3B

Ensure that all exceptions regarding incomplete/mismatch in information are resolved before printing or exporting the GSTR-3B report. File GSTR-3B in either of the following methods:

Method 1: By Generating the JSON file from Tally.ERP 9

To generate GSTR-3B returns in the JSON format

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.

  How to enter GST sales with nil rates,exempt,sez,deemed export, and consumer sales

3.    Press Ctrl+E.

exporting gstr-3b

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

5.    Press Enter to export.

Note: If you have made purchases attracting reverse charge from registered dealers outside the state, enter the values mentioned below in the JSON file:

   In 3.1.d of JSON file, under “isup_rev”: { enter the taxable amount in “txval” and integrated tax amount in “iamt”.

   In 4 a 3 of JSON file, under “ty”: “ISRC”, enter the integrated tax amount in “iamt”.

For further details, refer to calculating integrated tax on reverse charge purchases from registered dealers.

Upload the JSON file to the portal for filing returns.

To submit and file GSTR-3B returns

1.    Log in to the GST portal.

login page of gst portal

2.    Go to Dashboard > RETURN DASHBOARD.

gst portal dashboard

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

return filing period selection

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 the Error Report displays NA.

offline upload for gstr 3b

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

6.    Click the declaration check box and click SAVE GSTR3B.

save offline data to gstr 3b

7.    Make payments towards GSTR-3B to file your GSTR-3B returns.

8.    Click PREVIEW AND SUBMIT GSTR3B to submit GSTR-3B returns.

9.    Click FILE GSTR-3B WITH DSC or FILE GSTR-3B WITH EVC based on the mode you prefer to sign the returns.

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

Method 2: By using the GSTR3B Excel Offline Utility Tool

To download the tool

1.    Go to the GST portal.

2.    Click Downloads > Offline Tools > GSTR3B Offline Utility.

Download link of gstr-3b

3.    Click Download.

4.    Click PROCEED. A .zip file containing the GST Excel Utility will be downloaded. Some important information about the tool, and the system requirements for using the tool are also available on the download page.

5.    Extract the file GSTR3B_Excel_Utility_V3.0.xlsm from the .zip file and copy it to the location where Tally.ERP 9 is installed.

To export GSTR-3B returns to the MS Excel template

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

Note: Ensure to use a fresh template each time before exporting the GSTR-3B data.

2.    F2: Period – Select the period for which returns need to be filed.

3.    Press Ctrl+E.

4.    Select Excel (Spreadsheet) as the Format. If the template GSTR3B_Excel_Utility_V3.0.xlsm is not available in the Export Location, the message appears as shown:

5. Ensure the template GSTR3B_Excel_Utility_V3.0.xlsm is available in the Export Location. Press Enter to export the data.

The Microsoft Excel template opens with the data updated in the relevant fields.

gstr data in excel

Note: If you have made purchases attracting reverse charge from registered dealers outside the state, refer to calculating integrated tax on reverse charge purchases from registered dealers.

6.    In the template:

     Click Validate to view the status of the sheet.

     Click Generate File. The JSON file gets generated in the folder GSTR on the desktop.

  How to record a GST Purchase from unregistered dealer?

7.    Upload this JSON file on the GST portal. Click here for the procedure of submitting and filing GSTR-3B.

Note: If the status is Validation Failed, correct the errors mentioned in the template, and then click Validate.

For more details on the information captured in each column of the e-return template, click here.

Method 3: By filing your returns directly on the GST portal

To print GSTR-3B

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

2.    Press Ctrl+P to print the form.

Note: Ensure the MS Word application is available in your computer to view the form.

3.    In the Print Report screen, press Enter. GSTR-3B is created in the word format.

4.    Press Ctrl+S to save the word file.

You can print the word file and use the hard copy to fill information online or directly copy and paste the values from the MS Word file to the online form.

To file GSTR-3B

1.    Log in to the GST portal.

login page of gst portal

2.    Go to Dashboard > RETURN DASHBOARD.

gst portal dashboard

3.    Under Monthly Return GSTR-3B, click PREPARE ONLINE.

4.    Select the required options in the GSTR-3B dashboard to view the relevant sections of GSTR-3B in the next screen. Click NEXT to proceed.

5.    Click each table and manually fill the details by referring to the GSTR-3B printed from Tally.ERP 9 in the MS Word format. Click CONFIRM in each table after providing the details.

6.    Click the declaration check box and click SAVE GSTR3B.

7.    Make payments towards GSTR-3B to file your GSTR-3B returns.

8.    Click PREVIEW AND SUBMIT GSTR3B to submit GSTR-3B returns.

9.    Click FILE GSTR-3B WITH DSC or FILE GSTR-3B WITH EVC based on the mode you prefer to sign the returns.

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

Integrated tax on reverse charge purchases from registered dealers

If you have made purchases attracting reverse charge from registered dealers outside the state, you need to manually enter the integrated tax amount in the JSON or MS Excel file generated from Tally.ERP 9 before filing your returns.

To identify the values and enter it in the JSON or MS Excel file

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

2.    Under Reverse Charge Liability to be booked, press Enter on Reverse Charge Inward Supplies.

3.    Click E: Export from Purchase of Reverse Charge Supplies – Reverse Charge Liability report.

4.    Select the Format as Excel (Spreadsheet), and export the data.

5.    Filter for all the transactions on which Integrated Tax has been charged, and arrive at the total tax amount.

6.    Manually add this tax amount to the value of Table 3.1 d. Inward Supplies (liable to reverse charge) and 4A (3) Inward supplies liable to reverse charge (other than 1 & 2 above) in the data exported in JSON or MS Excel format from Tally.ERP 9.

Making Payments towards GSTR-3B

After successfully filing GSTR-3B, you can easily make payments to GST by creating a challan. The GST ITC amount will be updated in the credit ledger in the GST portal, and will be carried forward to the subsequent month.

  How to enter journal voucher for refund of tax credit under GST ?

To match the GST amount payable with your books of accounts, you can adjust the GST liability with the tax credit. Refer to Recording Journal Vouchers for Adjustments Against Tax Credit under GST for the procedure to record the transaction.

If the above example is taken, GST payable is as shown below:

To make payments towards GSTR-3B

1.    Log in to the GST portal.

2.    Go to Services > Payments > Create Challan.

3.    Under Tax Liability, enter the required values.

4.    Under Payment Modes, select the required method of payment. If you have chosen NEFT/RTGS as the mode of payment, you also have to select your preferred Remitting Bank.

5.    Click GENERATE CHALLAN.

GENERATE CHALLAN.

The Beneficiary Details appear according to the Remitting Bank selected.

selection of remitting bank

6.    Click DOWNLOAD to generate the challan. Using this challan, you can make the payment through net banking or cash/cheque payment in the bank. When you complete the payment, money gets transferred to your e-Cash ledger.

Note: If the tax amount is less than Rs. 10,000 you can make cash payment in the bank with the challan.

7.    Log in to the GST portal and make the tax payment.

8.    After the payment, submit your GSTR-3B returns.

This completes your GSTR-3B filing.

What is Form GSTR-3B ,How to generate GSTR-3B and file return in Tally erp 9
4.9 (98.5%) 40 votes
Filed in: GST

Share this post

Post Comment