Data Captured in GSTR-2 Excel File

b2b

Displays the details of B2B invoices - 3, 4A of the GSTR-2 report.

The taxable, exempt and nil rated purchases made from regular dealers and deemed exporters are captured here. If your tax invoice includes exempt and nil rated items along with taxable items, then the total invoice value is captured here.

If you want to capture the values of only the taxable items as a B2B invoice , as per GST rules record separate invoices for taxable items. Use separate invoices for purchase of exempt/nil rated items.

Displays the gross value of purchases recorded with:

Nature of transaction (with or without reverse charge):

● Purchase Taxable (including Nature of goods - Capital Goods when grouped under Fixed Assets )

● Purchase Exempt

● Purchase Nil Rated

● Interstate Purchase Taxable (including Nature of goods - Capital Goods when grouped under Fixed Assets )

● Interstate Purchase Exempt

● Interstate Purchase Nil Rated

● Purchase Deemed Exports - Exempt

● Purchase Deemed Exports - Nil Rated

● Purchase Deemed Exports - Taxable (including Nature of goods - Capital Goods when grouped under Fixed Assets )

● Purchase From SEZ (Without Bill of Entry) - Exempt (including Nature of goods - Capital Goods when grouped under Fixed Assets )

● Purchase From SEZ (Without Bill of Entry) - Nil Rated (including Nature of goods - Capital Goods when grouped under Fixed Assets )

● Purchase From SEZ (Without Bill of Entry) - Taxable (including Nature of goods - Capital Goods when grouped under Fixed Assets )

● Purchase From SEZ - LUT/Bond (including Nature of goods - Capital Goods when grouped under Fixed Assets )

Taxability as:

● Taxable

● Exempt (Taxable and exempt item in invoice)

● Nil Rated (Taxable and nil rated item in invoice)

Registration type as Regular

Consider Party as Deemed Exporter for Purchases? set to Yes in the party ledger

GSTIN of Supplier

Displays the GSTIN/UIN defined in the party ledgers, or entered in the Party Details screen of the voucher.

Invoice Number

Displays the:

● Supplier invoice no. entered in the purchase voucher

● Reference no. entered in the journal or payment vouchers used to record inward supplies

Invoice date

Displays the:

● Supplier invoice Date entered in the purchase voucher

● Reference Date entered in the journal or payment vouchers used to record inward supplies

Invoice Value

Displays the total value of the voucher including tax and cess. The TDS amount deducted from the purchases will not be captured here.

Place Of Supply

Displays the State name of the company.

Reverse Charge

Displays Y if it is a reverse charge transaction, else N .

Invoice Type

Displays Regular for vouchers recorded with the following Nature of transaction :

● Purchase Taxable

● Purchase Exempt

● Purchase Nil Rated

● Interstate Purchase Taxable

● Interstate Purchase Exempt

● Interstate Purchase Nil Rated

Displays SEZ supplies with payment for vouchers recorded with the following Nature of transaction :

● Purchase From SEZ (Without Bill of Entry) - Exempt

● Purchase From SEZ (Without Bill of Entry) - Nil Rated

● Purchase From SEZ (Without Bill of Entry) - Taxable

Displays SEZ supplies without payment for vouchers recorded with Purchase From SEZ - LUT/Bond as the Nature of transaction .

Displays Deemed Exp for vouchers recorded with the following nature of transactions:

● Purchase Deemed Exports - Exempt

● Purchase Deemed Exports - Nil Rated

● Purchase Deemed Exports - Taxable (including Nature of goods - Capital Goods when grouped under Fixed Assets and reverse charge supplies)

Rate

Displays the integrated tax rate, or the total of central and state tax rates.

Taxable Value

Displays the assessable value (including the additional expenses apportioned to item value) entered for each tax rate.

Integrated Tax Paid

Displays the integrated tax amount entered in the voucher.

Central Tax Paid

Displays the central tax amount entered in the voucher.

State/UT Tax Paid

Displays the state tax amount entered in the voucher.

Cess Paid

Displays the cess amount entered in the voucher.

Eligible for ITC

Displays Inputs if the Type of Supply is selected as Goods in the purchase ledger .

Displays Input services if the Type of Supply is selected as Services in the purchase ledger.

Displays Capital goods if the Nature of goods is selected as Capital Goods in the GST Details screen of the purchase ledger (grouped under Fixed Assets ).

Displays Ineligible if the option Is ineligible for input credit? is set to Yes in the GST Details screen of the purchase ledger.

Availed ITC Integrated Tax

Displays the integrated tax amount availed as input credit for the voucher.

Availed ITC Central Tax

Displays the central tax amount availed as input credit for the voucher.

Availed ITC State/UT Tax

Displays the state tax amount availed as input credit for the voucher.

Availed ITC Cess

Displays the cess amount availed as input credit for the voucher.

b2bur

Displays the details of B2BUR invoices - 4B of GSTR-2 report.

Displays the details of journal vouchers recorded by debiting and crediting tax ledgers with:

● Nature of Adjustment - Increase of Tax Liability & Input Tax Credit

● Additional Details - Purchase From Unregistered dealer . You can set this as additional details only if you have set Enable tax liability on reverse charge (Purchase from unregistered dealer)? to Yes in the Company GST Details screen.

Supplier Name

This column is left blank.

Invoice Number

Displays the voucher number of the journal voucher.

Invoice date

Displays the voucher date of the journal voucher.

Invoice Value

Displays the total value in the voucher including tax and cess.

Place Of Supply

Displays the State name of the company.

Supply Type

Displays the description as Inter-State or Intra-State based on the nature of transaction.

Rate

Displays the total of central and state tax rates.

Taxable Value

Displays the assessable value (including additional expenses apportioned to item value) entered for each tax rate.

Integrated Tax Paid

This column is left blank.

Central Tax Paid

Displays the central tax amount entered in the voucher.

State/UT Tax Paid

Displays the state tax amount entered in the voucher.

Cess Paid

Displays the cess amount entered in the voucher.

Eligibility for ITC

Displays the Type of Input selected in the journal voucher recorded with:

● Nature of Adjustment- Increase of Tax Liability & Input Tax Credit

● Additional Details - Purchase From Unregistered Dealer

Availed ITC Integrated Tax

This column is left blank.

Availed ITC Central Tax

Displays the debit value entered for the central tax ledger value in the journal voucher with:

● Nature of Adjustment- Increase of Tax Liability & Input Tax Credit

● Additional Details - Purchase From Unregistered Dealer

Availed ITC State/UT Tax

Displays the debit value entered for the state tax ledger value in the journal voucher with:

● Nature of Adjustment- Increase of Tax Liability & Input Tax Credit

● Additional Details - Purchase From Unregistered Dealer

Availed ITC Cess

Displays the debit value entered for the cess ledger value in the journal voucher with:

● Nature of Adjustment- Increase of Tax Liability & Input Tax Credit

● Additional Details - Purchase From Unregistered Dealer