Explore Categories

 

 PDF

GSTR-3B Report in TallyPrime

Form GSTR-3B is an interim return form the GST dealers with regular registration should use, to file monthly returns. From TallyPrime, you can generate GSTR-3B, export the data in the JSON format, and upload it to the portal to file the returns. You can also view GSTR-3B report in TallyPrime with the tax computation details. This report can be changed to the return format view (specified/prescribed by the department) with the click of a button.

The triangulation design of the GSTR-3B report in TallyPrime helps you with:

Verification: You can check the transactions that are included in the returns and also that are not included as they are not relevant. In addition, you can view the list of transaction that are relevant but not added to returns due to errors in vouchers. And you can correct these errors using the different error resolution options to include them in the returns. Transactions which were flagged as exceptions but accepted by you as is to include in returns can be seen in Vouchers Accepted As Is report.

You can also analyse the values in each table. Drill down from any row to get the break-up of the value. You have detailed view at every level of the drill down. You can go up to the voucher level and make changes, as required. This gives you complete control on every transaction that is included in different tables of GSTR-3B returns.

Generate returns for any period: Once you are satisfied with the details of your transactions, you can generate a return file in the JSON or MS Excel format, or fill the details directly on the portal. After filing the returns, to ensure GST compliance, you have to match the information in your books with the data on the GST portal. Using the status reconciliation feature in GSTR-3B report, you can mark the status of each transaction based on the online status. You can thereby track the status of the uploaded transactions without visiting the portal.

Open GST Portal: The GSTR-3B report in TallyPrime also provides a direct link to the GST portal. You only have to click the Open GST Portal button to open the GST portal directly in the browser.

 

View GSTR-3B report in TallyPrime

  • Gateway of Tally > Display More Reports > Statutory Reports > GST > GSTR-3B.
    Alternatively, press Alt+G (Go To) > type or select GSTR-3B > and press Enter.



  • Press F5 to switch between Return View and Nature View.


Specify the required reporting period by pressing F2 (Period).

  • For a company whose State is selected as Ladakh, if you set the period as Dec 2019 to Jan 2020, the Periodical View screen will appear with the return period and corresponding GSTIN.

The above screen will appear only if you have provided the following GSTINs in the Company GST Details screen:

    • GSTIN/UIN applicable from 1-Jan-2020.
    • GSTIN/UIN (prior to 1-Jan-2020) in the scenario of head office forming part of Ladakh from 1-Jan-2020. A single GSTIN was applicable for head office and branch offices located in Jammu & Kashmir until 31-Dec-2019. When the location of head office changed to Ladakh with effect from 1-Jan-2020, the company’s GSTIN would have got changed to Ladakh. This would mean a fresh registration for the branch office in Jammu & Kashmir. Hence, to enter the fresh GSTIN received for the branch office in Jammu & Kashmir, you need to press F12 and enable the option Show GSTIN/UIN (prior to 1-Jan-2020) for Jammu & Kashmir.

In the above Periodical View screen, select the Return Period and the report will open for the corresponding GSTIN.

 

View and Verify Vouchers Recorded

The Particulars section at the top of the report provides an overview of your transactions in the selected return period. You can view the transactions that were considered or excluded from returns, and resolve uncertain transactions.

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

  • Total Vouchers– 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 return table: Displays the number of vouchers that are part of the return tables. Drill down to view the Summary of Included Vouchers.
    • 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.
  • Not relevant for returns: Displays the number of transactions that are excluded from the returns. Drill down to view the Summary of Excluded Vouchers.
  • Uncertain Transactions (Corrections needed)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 Uncertain Transactions (Corrections needed) to include them in the returns. If the computed tax is not equal to the tax entered in the invoice, the transaction appears under Uncertain Transactions (Corrections needed). To set the tax difference that you want to allow, to include the vouchers in the returns:
    • Press Ctrl+B (Basis of Values).
    • Enter the value in the field Allow Tax Value Difference up to.

 

View and Verify Values in the Return

Nature View

Press F5 (Nature View). The Nature 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.

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.

 

Return View

Press F5 (Return View). The Return View format displays the values in the actual Form GSTR-3B format. The values are captured under different sections of the form.

 

Tables as per GST Format

3.1 Details of Outward Supplies and inward supplies liable to reverse charge

URD Purchases

3.2 Of the supplies shown in 3.1 (a) above, details of inter-Sate supplies made to unregistered persons, composition taxable persons and UIN holders

Reverse Charge Inward Supplies

4. Eligible ITC

Import of Services

5. Values of exempt, nil-rated and non-GST inward supplies

Input Credit to be Booked

5.1 Interest and Late fee Payable

Amount unadjusted against supplies

 

Sales against advance from previous periods

 

Amount unadjusted against purchase

 

Purchase against advance from previous periods

 

Table Name

Particulars

Year

Displays the year for which returns are filed. The calander year is captured in YYYY format.

Month

Displays the full name of the month for which the returns are filed.

1. GSTIN

Displays the GSTIN of the dealer filing the returns as recorded in the field GSTIN/UIN in the Company GST Details screen.

2. Legal Name of the registered person

Displays the company name of the dealer as recorded in the field Mailing name in the Company Creation screen.

3.1 Details of Outward Supplies and inward supplies liable to reverse charge

(a) Outward taxable supplies (other than zero rated, nil rated and exempted)

Displays the Total Taxable value, Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from sales and sales-related transactions with or without reverse charge applicability, recorded with:

  • Nature of transaction as:
  • Sales Taxable
  • Sales to Consumer – Taxable
  • Interstate Sales Taxable
  • Interstate Sales to Embassy/UN Body Exempt
  • Interstate Sales to Embassy/UN Body Nil Rated
  • Interstate Sales to Embassy/UN Body Taxable
  • Deemed Exports Taxable
  • Intrastate Deemed Exports Taxable
  • Journal vouchers with:
    • Nature of adjustment as Increase of Tax Liability, and Additional Details as On Account of Advance Receipts
    • Nature of adjustment as Decrease of Tax Liability, and Additional Details as:
  • Sale against advance receipts
  • Cancellation of Advance Receipts
Note: Total Taxable value is the sum of all taxable values including the value of the debit and credit notes, and advance liabilities, excluding tax.

(b) Outward taxable supplies (zero rated)

Displays the Total Taxable value, Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from sales and sales-related transactions recorded with:

  • Nature of transaction as:
  • Exports Taxable(with or without reverse charge)
  • Exports Exempt
  • Exports LUT/Bond
  • Exports Nil Rated
  • Sales to SEZ – Exempt
  • Sales to SEZ – LUT/Bond
    • Sales to SEZ – Taxable(with or without reverse charge)
  • Sales to SEZ – Nil Rated
  • Journal vouchers with:
    • Nature of adjustment as Increase of Tax Liability, and Additional Details as Advance Receipts for Exports/SEZ sales
    • Nature of adjustment as Decrease of Tax Liability, and Additional Details as:
  • Sale against Advance Receipts for Exports/SEZ sales
  • Cancellation of Advance Receipts for Exports/SEZ sales.

Note: Total Taxable value is the sum of all taxable values including the value of the debit and credit notes, and advance liabilities, excluding tax.

(c) Other outward supplies (Nil rated, exempted)

Displays the Total Taxable value, Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from sales and sales related transactions recorded with:

  • Nature of transaction as:
  • Sales Exempt
  • Sales Nil Rated
  • Sales to Consumer – Exempt
  • Interstate Sales Exempt
  • Interstate Sales to Embassy/UN Body Exempt
  • Interstate Sales to Embassy/UN Body Nil Rated
  • Interstate Sales Nil Rated
  • Deemed Exports Exempt
  • Deemed Exports Nil Rated
  • Intrastate Deemed Exports Exempt
  • Intrastate Deemed Exports Nil Rated
  • Sales to consumer Nil Rated

Note: Total Taxable value is the sum of all taxable values including the value of the debit and credit notes, and advance liabilities, excluding tax.

(d) Inward supplies (liable to reverse charge)

Displays the Total Taxable value, Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns for purchase or purchase-related transactions recorded with:

  • Nature of transaction as:
    • Imports Taxable with Type of Supply as Service
    • Purchase Taxable with the option Is reverse charge applicable? – Yes
    • Purchase From Unregistered Dealer – Taxable or Interstate Purchase From Unregistered Dealer – Taxable, with the option Is reverse charge applicable? – Yes
    • Interstate Purchase Taxable with the option Is reverse charge applicable? – Yes
  • Displays the values of journal vouchers with:
    • Nature of adjustment as Increase of Tax Liability & Input Tax Credit with:
  • Additional Details as Purchase from Unregistered dealer,if the option Enable tax liability on reverse charge (Purchase from unregistered dealer) is set to Yesin the Company GST Details screen.
  • Additional Details as Purchase under reverse charge.
    • Nature of adjustment as Increase of Tax Liability, and Additional Details as Advances Paid under Reverse Charge
    • Nature of adjustment as Decrease of Tax Liability, and Additional Details as:
  • Cancellation of Advance Payments under Reverse Charge
  • Purchase against Advance Payment

Note: Total Taxable value is the sum of all taxable values including the value of the debit and credit notes, and advance liabilities, excluding tax.

(e) Non-GST outward supplies

Displays the Total Taxable value, Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from journal transactions recorded with masters created by setting the option Is non-GST goods? to Yes.

3.2 of the supplies shown in 3.1 (a) above, details of inter-Sate supplies made to unregistered persons, composition taxable persons and UIN holders

Supplies made to Unregistered Persons

Displays the Place of Supply, Total Taxable value, and Amount of Integrated Tax in separate columns from sales and sales-related transaction, along with:

  • The party Registration type selected in party master or Statutory Details screen in the journal voucher, as Unregistered, and Consumer.
  • Nature of transaction as Interstate Sales Taxable
  • Journal vouchers with:
    • Nature of adjustment as Increase of Tax Liability, and Additional Details as On Account of Advance Receipts
    • Nature of adjustment as Decrease of Tax Liability, and Additional Details as:
  • Cancellation of Advance Receipts
  • Sales against Advance Receipts

Note: Total Taxable value is the sum of all taxable values including the value of the debit and credit notes, and advance liabilities, excluding tax.

Supplies made to Composition taxable persons

Displays the Place of Supply, Total Taxable value, and Amount of Integrated Tax in separate columns from sales and sales-related transaction with:

  • The party Registration type selected in party master or Statutory Details screen in the journal voucher, as Composite.
  • The Place of supply with State other than the company’s state.
  • Nature of transaction as Interstate Sales Taxable
  • Journal vouchers with:
    • Nature of adjustment as Increase of Tax Liability, and Additional Details as On Account of Advance Receipts
    • Nature of adjustment as Decrease of Tax Liability, and Additional Details as:
  • Sales against Advance Receipts
  • Cancellation of Advance Receipts

Note: Total Taxable value is the sum of all taxable values including the value of the debit and credit notes, and advance liabilities, excluding tax.

Supplies made to UIN holders

Displays the Place of Supply, Total Taxable value, and Amount of Integrated Tax in separate columns from sales and sales-related transaction, along with:

  • The Party type selected in party master or Statutory Details screen in the journal voucher, as Embassy/UN Body.
  • The Place of supply with State other than the company’s state.
  • Nature of transaction as:
  • Interstate Sales Taxable
  • Interstate Sales to Embassy/UN Body Taxable
  • Journal vouchers with:
    • Nature of adjustment as Increase of Tax Liability, and Additional Details as On Account of Advance Receipts
    • Nature of adjustment as Decrease of Tax Liability, and Additional Details as:
  • Sales against Advance Receipts
  • Cancellation of Advance Receipts

Note: Total Taxable value is the sum of all taxable values including the value of the debit and credit notes, and advance liabilities, excluding tax.

4. Eligible ITC

(A) ITC Available (whether in full or part)

(1) Import of goods

 

Displays the Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns with Nature of transaction as:

  • Imports Taxable with
    • Type of Supply as Goods.
    • Nature of goods set to Capital Goods when grouped under Fixed Assets with Type of Supply as Goods.
  • Purchase From SEZ – Taxable with Type of Supply as Goods.

Displays only journal vouchers if recorded for the reverse charge tax liability or input credit. Purchases will not be displayed if journal vouchers are recorded with:

  • Nature of adjustment as Increase of Input Tax Credit and Additional Details as Import of Goods
  • Nature of adjustment as Increase of Tax Liability & Input Tax Credit and Additional Details as Import of Goods

To display only purchases, exclude the journal voucher from the Participating in return tables of GSTR-3B.

(2) Import of services

 

Displays the Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns with Nature of transaction as Imports Taxable with Type of Supply as Services.

Displays only journal vouchers if recorded for the reverse charge tax liability or input credit. Purchases will not be displayed if journal vouchers are recorded with:

  • Nature of adjustment as Increase of Input Tax Credit and Additional Details as Import of Services
  • Nature of adjustment as Increase of Tax Liability & Input Tax Credit and Additional Details as Import of Services

(3) Inward supplies liable to reverse charge (other than 1 & 2 above)

 

Displays the Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns.

  • Only purchases if journal vouchers are not recorded. The purchases should have the following Nature of transaction with the option Is reverse charge applicable? set to Yes
  • Purchase Taxable
  • Interstate Purchase Taxable
  • Purchase From Unregistered Dealer – Taxable
  • Interstate Purchase From Unregistered Dealer – Taxable
  • Only journal vouchers if recorded for the reverse charge tax liability or input credit. Purchases will not be displayed if journal vouchers are recorded with Nature of adjustment as Increase of Tax Liability & Input Tax Credit and Additional Details as:
  • Purchase Under Reverse Charge
    • Purchase from Unregistered dealer if the option Enable tax liability on reverse charge (Purchase from unregistered dealer)? is set to Yes in the Company GST Details screen.

To display only purchases, exclude the journal voucher from the Participating in return tables of GSTR-3B.

(4) Inward supplies form ISD

 

Displays the Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from journal transactions recorded with:

  • Nature of adjustment as Increase of Input Tax Credit, and Additional Details as ISD Transfer.

(5) All other ITC

Displays the Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from purchase transactions recorded with:

  • Nature of transaction as:
  • Purchase Taxable
  • Interstate Purchase Taxable
  • Purchase Deemed Exports – Taxable
  • Intrastate Purchase Deemed Exports – Taxable
  • Purchase From SEZ (Without Bill of Entry) – Taxable
  • Nature of goods as:
  • Not Applicable
  • Capital Goods

(B) ITC Reversed

(1) As per rules 42 & 43 of CGST Rules

Displays the Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from journal transactions recorded with:

  • Nature of adjustment as Reversal of Input Tax Credit and Additional Details as:
  • Exempt and non-business supplies – Rule 42(1)(m)
  • Capital credit due to exempted supplies – Rule 43(1)(h)
  • On account of claiming more – Rule 42 (2)(a)
  • Nature of adjustment as Increase of Input Tax Credit, and Additional Details as Re-claim of reversal ITC – Rule 42 (2)(b)

(2) Others

Displays the Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from journal transactions recorded with:

  • Nature of adjustment as Reversal of Input Tax Credit and Additional Details as:
  • Not Applicable
  • Non-payment to the Supplier – Rule 37(2)
  • ISD credit note – Rule 39(1)(j)(ii)
  • Others
  • Nature of adjustment as Increase of Input Tax Credit, and Additional Details as:
  • Re-claim of reversal ITC (on account of buyer payment)
  • Others

(C) Net ITC Available (A)-(B)

Displays the autocalculated values.

(D) Ineligible ITC

(1) As per section 17(5)

Displays the Integrated Tax, Central Tax, State/UT Tax, and Cess in separate columns from purchase and purchase-related transaction with:

  • Nature of transaction as:
  • Purchase Taxable
  • Interstate Purchase Taxable
  • Imports Taxable
  • Purchase From SEZ – Taxable
    • Purchase From Unregistered Dealer – Taxable or Interstate Purchase From Unregistered Dealer – Taxable when the option Enable tax liability on reverse charge (Purchase from unregistered dealer) is set to Yes in the Company GST Details screen
  • Purchase Deemed Exports – Taxable
  • Intrastate Purchase Deemed Exports – Taxable
  • Purchase From SEZ (Without Bill of Entry) – Taxable
  • The option Is ineligible for input credit? is enabled in the relevant masters.
  • Journal vouchers with Nature of adjustment as Reversal of Input Tax Credit, and Additional Details as Ineligible Credit

(2) Others

This field is left blank.

5. Values of exempt, nil-rated and non-GST inward supplies

From a supplier under composition scheme, exempt and nil rated supply

Displays the taxable value from all purchase and purchase-related transactions.

Displays value for inter-state supplies from the transactions recorded with Nature of transaction as:

  • Interstate Purchase Nil Rated
  • Interstate Purchase Exempt
  • Imports Exempt
  • Imports Nil Rated
  • Purchase from SEZ – Exempt
  • Purchase From SEZ – LUT/Bond
  • Purchase From SEZ – Nil Rated
  • Purchase Deemed Exports – Exempt
  • Purchase Deemed Exports – Nil Rated
  • Intrastate Purchase Deemed Exports – Exempt
  • Intrastate Purchase Deemed Exports – Nil Rated
  • Interstate Purchase From Unregistered Dealer – Services
  • Purchase From SEZ (Without Bill of Entry) – Exempt
  • Purchase From SEZ (Without Bill of Entry) – Nil Rated

Displays value for intra-state supplies from the transactions recorded with Nature of transaction as:

  • Purchase from Composite Dealer
  • Purchase Nil Rated
  • Purchase Exempt
  • Purchase from Unregistered dealer – Exempt
  • Interstate Purchase From Unregistered Dealer – Exempt
  • Purchase From Unregistered Dealer – Nil Rated
  • Interstate Purchase From Unregistered Dealer – Nil Rated
  • Purchase From Unregistered Dealer – Taxable (when the option Enable tax liability on reverse charge (Purchase from unregistered dealer) is set to No in the Company GST Details screen).

Non GST supply

 

Displays invoice value from a transaction recorded with ledgers or items created by setting the option Is non-GST goods? to Yes. The value is displayed in Inter-State supplies column if the supplier is from a different state and in the Intra-State supplies column if the purchases are made from a local supplier.

5.1 Interest and Late Fees Payable

Interest

Displays the value of the journal voucher recorded with Nature of adjustment as Increase of Tax Liability, and Additional Details as Interest.

Late Fees

Displays the value of the journal voucher recorded with Nature of adjustment as Increase of Tax Liability, and Additional Details as Late Fees.

6.1 Payment of tax

This section will be left blank.

In GSTR-3B, press F12 (Configure).

  • Show Tax types in separate columns– Enable it to view the breakup of tax amount.
  • Show break-up of nett values – Enable to view sales return values reduced from total sales to show the nett amount. Similarly for purchase. 
  • Format of Report – Enable this option to view the report in Condensed or Detailed format.
Post a Comment

Is this information useful?
YesNo
Helpful?