Exporting Form RT-I and RT-V (Bihar)

This topic explains how to export the government prescribed VAT form and the fields in VAT forms RT-I and RT-V.

To export data to VAT template

1.     Copy the excel template to the Tally.ERP 9 installed folder.

2.     Go to Gateway of Tally > Display > Statutory Reports > VAT > Form RT-I.

3.     Press Ctrl+E to view the Export Report screen. Based on the Form RT-I report period, the From and To dates are displayed here. Ensure the template is available in the Export Location.

4.     Press Enter to export data.

A brief explanation about the form fields of the quarterly return is given below:

Legend

Indicates what is new in the form

Indicates what has changed in the form

Indicates what has been removed from the form

 

Field Name

Description

Part I (Details of turnover/transfers)

1. Gross Turnover (including value of debit notes):*

Displays the:

      Gross assessable value of sales recorded with the nature of transactions provided for local sales.

      Net value of sales (including tax) recorded with the nature of transactions provided for interstate sales.

Deductions:

2. Sales in the course of inter-state trade and commerce

Displays the net value (including tax) of interstate sales.

3.1.  Value of sales outside the state under section 4 of the Central Sales Tax Act, 1956

Displays the credit value of exempt interstate sales recorded in journal voucher.

3.2. Value of stock transfer to outside the state

Displays the net value of sales made with the following nature of transactions:

      Interstate Branch Transfer Outward

      Interstate Consignment Transfer Outward

4. Value of sales return of goods within 6 months of sale under the Act

Displays the sales returns (within six months of the original invoice date) recorded with the following nature of transactions:

      Sales Taxable

      Sales - Transfer of Right to Use

      Sales - Works contract

      Sales Exempt

      Sales Transfer of Right to Use - Exempt

5. Export sales

Displays the net assessable value of sales recorded with the following nature of transactions:

      Exports

      Interstate Deemed Export

6. Amount of other allowable deductions [As per Box A]

Displays auto calculated value.

7. Total of deductions [2+3+4+5+6]

Displays auto calculated value.

8. Taxable turnover [1 - 7]

Displays auto calculated value.

Part 2: 9 Description of sale

9(i)(a) Sale of Motor Spirit by an Oil Company to a dealer/person other than an Oil Company (Details of dealer wise sales to be furnished as per Box E-1)

Displays the tax rate, net assessable value and tax amount for the Type of goods (set in VAT Details screen of the stock item or ledger) predefined as Motor Spirit in the taxable sales invoice.

In the sales invoice, the

      Nature of transaction is selected as Sales Taxable.

      Party ledger is predefined as Regular dealer.

9(i)(b) Sale of HSD Oil and Light Diesel Oil by an Oil Company to a dealer/person other than an Oil Company (Details of dealer wise sales to be furnished as per Box E-1)

Displays the tax rate, net assessable value and tax amount for the Type of goods (set in VAT Details screen of the stock item or ledger) predefined as Diesel in the taxable sales invoice.

In the sales invoice, the

      Nature of transaction is selected as Sales Taxable.

      Party ledger is predefined as Regular dealer.

9(i)(c) Sale of ATF Oil by an Oil Company to a dealer/person other than an Oil Company (Details of dealer wise sales to be furnished as per Box E-1)

Displays the tax rate, net assessable value and tax amount for the Type of goods (set in VAT Details screen of the stock item or ledger) predefined as Aviation Turbine Fuel in the taxable sales invoice.

In the sales invoice, the

      Nature of transaction is selected as Sales Taxable.

      Party ledger is predefined as Regular dealer.

9(i)(d) Sale of Natural Gas by an Oil Company to a dealer/person other than an Oil Company (Details of dealer wise sales to be furnished as per Box E-1)

Displays the tax rate, net assessable value and tax amount for the Type of goods (set in VAT Details screen of the stock item or ledger) predefined as Natural Gas in the taxable sales invoice.

In the sales invoice, the

      Nature of transaction is selected as Sales Taxable.

      Party ledger is predefined as Regular dealer.

9(i)(e) Sale of Country Liquor/Spiced Country Liquor

This field is currently left blank.

9(i)(f) Sale of Potable Spirit, wine or liquor whether imported from other countries or manufactured in India

Displays the tax rate, net assessable value and tax amount for the Type of goods (set in VAT Details screen of the stock item or ledger) predefined as Liquor in the taxable sales invoice.

In the sales invoice, the

      Nature of transaction is selected as Sales Taxable.

      Party ledger is predefined as Regular dealer.

9(i)(g) Sale of other schedule IV goods (except sl. no. 1 to 6 of schedule IV) [Details to be furnished as per Box I]

Displays the tax rate, net assessable value and tax amount for taxable and works contract sales of tobacco made at first point of sale.

For the transaction:

      Select Nature of transaction as Sales Taxable or Sales - Works Contract.

      In VAT Details screen of stock item or ledger, the options to be set as given below:

o      Set Type of goods as Tobacco.

o      Set Schedule as Schedule IV.

      Set the Point of Sale as First in the Statutory Details screen (displayed on enabling the option Provide VAT Details) of the invoice.

9(i)(h) Others specify

This is a blank field.

9(ii) Goods specified in Schedule II (goods wise sales to be furnished as per box G): 1%

Displays the net assessable value and tax amount, of sale of Schedule II (set in VAT Details screen of stock item or ledger) goods recorded at 1% tax rate with the following nature of transactions:

      Sales Taxable

      Sales - Works Contract

      Sales Transfer of Right to Use

9(iii)(a) Goods specified in Schedule IIIA (goods wise sales to be furnished as per box G): 5%

Displays the net assessable value and tax amount, of sale of Schedule III - A (set in VAT Details screen of stock item or ledger) goods recorded at 5% tax rate with the following nature of transactions:

      Sales Taxable

      Sales - Works Contract

      Sales Transfer of Right to Use

9(iii)(b) Goods specified in Schedule III (goods wise sales to be furnished as per box G): 5%

Displays the net assessable value and tax amount, of sale of Schedule III (set in VAT Details screen of stock item or ledger) goods recorded at 5% tax rate with the following nature of transactions:

      Sales Taxable

      Sales - Works Contract

      Sales Transfer of Right to Use

9(iii)(c) Goods specified in Schedule III (goods wise sales to be furnished as per box G): 6%

Displays the net assessable value and tax amount, of sale of Schedule III (set in VAT Details screen of stock item or ledger) goods recorded at 6% tax rate with the following nature of transactions:

      Sales Taxable

      Sales - Works Contract

      Sales Transfer of Right to Use

9(iv)(a) Goods not specified in any of the schedule: 13.5%

Displays the net assessable value and tax amount, of sales recorded at 13.5% tax rate with the following nature of transactions:

      Sales Taxable

      Sales - Works Contract

      Sales Transfer of Right to Use

9(iv)(b) Goods not specified in any of the schedule: 14.5%

Displays the net assessable value and tax amount, of sales recorded at 14.5% tax rate with the following nature of transactions:

      Sales Taxable

      Sales - Works Contract

      Sales Transfer of Right to Use

9(iv)(c) Goods not specified in any of the schedule: 15%

Displays the net assessable value and tax amount, of sales recorded at 15% tax rate with the following nature of transactions:

      Sales Taxable

      Sales - Works Contract

      Sales Transfer of Right to Use

9(v) Total sales of goods u/s 13(1) = {(ii) + (iii)(a) + (iiii)(b) + (iii)(c) + (iv)(a) + (iv)(b) + (iv)(c)} [Details of dealer wise sales to be furnished as per Box B]

Click here for previous row name

Displays auto calculated value.

9(vi) Sale of such goods in respect of which tax on MRP has been paid by the dealer filing this return in terms of section 15(5)(a) [Details of dealer wise sales to be furnished as per Box J]

Displays the net assessable MRP value (quantity * MRP) of:

      Stock items sold to Regular dealers, Unregistered dealers and Consumers.

      Stock items for which schedule is not specified and sold to Regular dealers, Unregistered dealers and Consumers.

In the VAT Details screen of stock item or ledger the options:

o      Nature of goods is set to MRP Goods.

o      Calculate VAT on MRP is set to Yes.

o      Schedule is set to Not Applicable.

o      Type of Dealer is set to Regular, Unregistered or Consumer.

9(vii) Turnover liable to Purchase tax

Displays the assessable value entered for VAT ledger in journal voucher recorded for tax on purchase from URDs.

9(viii) Excess of reverse credit [14 - 13] if 14 is greater than 13

Displays auto calculated value.

9(ix) Excess tax realised = Value of Sales Return x (Current rate of tax - Rate of tax at the time of such sales)

This field is blank.

10. Total Output tax [(i)(a)+(i)(b)+(i)(c)+(i)(d) +(i)(e)+(i)(f)+(i)(g)+(i)(h)+(v)+(vi)+(vii)+(viii) +(ix)]

Click here for previous row name

Displays auto calculated value.

Part III (Details of purchases/receipts)

11.1. Purchases from within the state [Details of dealer wise purchases to be submitted as per Box C]

Goods notified u/s 15(5)

Displays the net assessable MRP value (quantity * MRP) of purchases recorded with the nature of transaction Purchase Taxable.

Schedule IV goods (other than all kinds of liquor)

Displays the net assessable value of schedule IV goods other than Liquor, selected in purchases recorded with the nature of transaction Purchase Taxable.

Schedule I goods

Displays the net assessable value of purchases recorded by selecting the nature of transaction Purchase Exempt.

Other taxable goods

1%

Displays the net assessable trade value (quantity * stock item rate) of purchases taxable at 1% recorded with the following nature of transactions:

      Purchase Taxable

      Purchase - Works Contract

      Purchase Taxable - Capital Goods

5% (Sch-III A)

Displays the net assessable trade value (quantity * stock item rate) of taxable purchases of schedule III - A goods attracting 5% (in the VAT Details screen of accounts or inventory masters, Schedule is selected as Schedule III - A and Tax Rate is set to 5%) tax rate, recorded with the following nature of transactions:

      Purchase Taxable

      Purchase - Works Contract

      Purchase Taxable - Capital Goods

5% (Sch-III)

Click here for previous column name

Displays the net assessable trade value (quantity * stock item rate) of taxable purchases of schedule III goods attracting 5% (in the VAT Details screen of accounts or inventory masters, Schedule is selected as Schedule III - Part I/Schedule III - Part II/Schedule III - Part III and Tax Rate is set to 5%) tax rate, recorded with the following nature of transactions:

      Purchase Taxable

      Purchase - Works Contract

      Purchase Taxable - Capital Goods

6% (Sch-III)

Displays the net assessable trade value (quantity * stock item rate) of taxable purchases of schedule III attracting 6% (in the VAT Details screen of accounts or inventory masters, Schedule is selected as Schedule III - Part I/Schedule III - Part II/Schedule III - Part III and Tax Rate is set to 6%) tax rate, recorded with the following nature of transactions:

      Purchase Taxable

      Purchase - Works Contract

      Purchase Taxable - Capital Goods

13.5%

Displays the net assessable trade value (quantity * stock item rate) of purchases taxable at 13.5%, recorded with the following nature of transactions:

      Purchase Taxable

      Purchase - Works Contract

      Purchase Taxable - Capital Goods

14.5%

Displays the net assessable trade value (quantity * stock item rate) of purchases taxable at 14.5%, recorded with the following nature of transactions:

      Purchase Taxable

      Purchase - Works Contract

      Purchase Taxable - Capital Goods

15%

Displays the net assessable trade value (quantity * stock item rate) of purchases taxable at 15%, recorded with the following nature of transactions:

      Purchase Taxable

      Purchase - Works Contract

      Purchase Taxable - Capital Goods

Total

Displays auto calculated value.

11.2. Purchase from outside the state

Goods notified u/s 15(5)

Displays the net MRP value (quantity * MRP), including tax, of purchases recorded with the following nature of transaction:

      Interstate Purchase - Taxable

      Interstate Purchase - Against Form C

      Interstate Purchase Exempt

      Interstate Purchase - E1

      Interstate Purchase - Zero Rated

      Interstate Purchase Deemed Export

      Interstate Purchase - E2

      Interstate Purchase Exempt - E1

      Imports

Schedule IV goods (other than all kinds of liquor)

Displays the net assessable value of schedule IV goods other than Liquor, selected in purchase invoice (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)).

Schedule I goods

Displays the net assessable value of schedule I goods (in VAT Details screen of the stock item, set the option Schedule to Schedule I), selected in the purchase invoice (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)).

Other taxable goods

1%

Displays the net assessable trade value (quantity * stock item rate) of purchases (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)), taxable at 1% tax rate for Schedule II goods (displays the value of stock items or ledgers in which the option Schedule is set to Schedule II).

5% (Sch-III A)

Displays the net assessable trade value (quantity * stock item rate) of purchases (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)), taxable at 5% tax rate for Schedule III - A goods (displays the value of stock items or ledgers predefined with SCHEDULE III - A).

5% (Sch-III)

Click here for previous column name

Displays the net assessable trade value (quantity * stock item rate) of purchases (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)), taxable at 5% tax rate for Schedule III goods (in the VAT Details screen of accounts or inventory masters. Schedule is selected as Schedule III - Part I/Schedule III - Part II/Schedule III - Part III and Tax Rate is set to 5%).

6% (Sch-III)

Displays the net assessable trade value (quantity * stock item rate) of purchases (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)), taxable at 6% tax rate for Schedule III goods (in the VAT Details screen of accounts or inventory masters Schedule is selected as Schedule III - Part I/Schedule III - Part II/Schedule III - Part III and Tax Rate is set to 6%).

13.5%

Displays the net assessable trade value (quantity * stock item rate) of purchases (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)), taxable at 13.5% tax rate for which schedule is not specified (in VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

14.5%

Displays the net assessable trade value (quantity * stock item rate) of purchases (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)), taxable at 14.5% tax rate for which schedule is not specified (in VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

15%

Displays the net assessable trade value (quantity * stock item rate) of purchases (with nature of transactions mentioned in box 11.2 Goods notified u/s 15(5)), taxable at 15% tax rate for which schedule is not specified (in VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

Total

Displays auto calculated value.

11.3. Stock transfers receipts from within the state

Goods notified u/s 15(5)

Displays the net assessable MRP value (quantity * MRP) of purchases recorded with the nature of transactions:

      Branch Transfer Inward

      Consignment Transfer Inward

In the VAT Details screen of stock item or ledger the option:

o      Nature of goods is set to MRP Goods.

o      Calculate VAT on MRP is set to Yes.

Schedule IV goods (other than all kinds of liquor)

Displays the net assessable value of schedule IV goods other than Liquor, selected in purchases recorded with the following nature of transactions:

      Branch Transfer Inward

      Consignment Transfer Inward

In VAT Details screen of the stock item or ledger, set the options as shown below:

o      Type of goods to any goods other than Liquor.

o      Schedule to Schedule IV.

Schedule I goods

Displays the net assessable value of schedule I goods (in VAT Details screen of the stock item or ledger, set the option Schedule to Schedule I), selected in the purchases recorded with the following nature of transactions:

      Branch Transfer Inward

      Consignment Transfer Inward

Other taxable goods

1%

Displays the net assessable value of branch/consignment transfer inwards recorded by selecting stock items predefined with 1% tax rate for Schedule II goods (displays the value of stock items or ledger in which the option Schedule is set to Schedule II).

Nature of transaction is selected as:

      Branch Transfer Inward

      Consignment Transfer Inward

5% (Sch-III A)

Displays the net assessable value of branch/consignment transfer inwards recorded by selecting stock items predefined with the 5% tax rate for Schedule III - A goods (displays the value of stock items or ledger predefined with SCHEDULE III - A).

Nature of transaction is selected as:

      Branch Transfer Inward

      Consignment Transfer Inward

5% (Sch-III)

Displays the net assessable value of branch/consignment transfer inwards recorded by selecting stock items predefined with 5% tax rate for Schedule III goods.

Nature of transaction is selected as:

      Branch Transfer Inward

      Consignment Transfer Inward

6% (Sch-III)

Displays the net assessable value of branch/consignment transfer inwards recorded by selecting stock items predefined with 6% tax rate for Schedule III goods.

Nature of transaction is selected as:

      Branch Transfer Inward

      Consignment Transfer Inward

13.5%

Displays the net assessable value of branch/consignment transfer inwards recorded by selecting stock items predefined with 13.5% tax rate for which schedule is not specified (in VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

Nature of transaction is selected as:

      Branch Transfer Inward

      Consignment Transfer Inward

14.5%

Displays the net assessable value of branch/consignment transfer inwards recorded by selecting stock items predefined with 14.5% tax rate for which schedule is not specified (in VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

Nature of transaction is selected as:

      Branch Transfer Inward

      Consignment Transfer Inward

15%

Displays the net assessable value of branch/consignment transfer inwards recorded by selecting stock items predefined with 15% tax rate for which schedule is not specified (In VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

Nature of transaction is selected as:

      Branch Transfer Inward

      Consignment Transfer Inward

Total

Displays auto calculated value.

11.4. Stock transfers receipts from outside the state

Goods notified u/s 15(5)

Displays the net MRP value (quantity * MRP) of purchases recorded with the following nature of transaction:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

Schedule IV goods (other than all kinds of liquor)

Displays the net assessable value of schedule IV goods other than Liquor, selected in purchases recorded with the following nature of transactions:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

In VAT Details screen of the stock item or ledger, set the options as shown below:

o      Type of goods to any goods other than Liquor.

o      Schedule to Schedule IV.

Schedule I goods

Displays the net assessable value of schedule I goods (in VAT Details screen of the stock item or ledger, set the option Schedule to Schedule I), selected in the purchases recorded with the following nature of transactions:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

Other taxable goods

1%

Displays the net assessable value of interstate branch/consignment transfer inwards recorded by selecting stock items predefined with 1% tax rate for Schedule II goods (displays the value of stock items or ledger in which the option Schedule is set to Schedule II).

Nature of transaction is selected as:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

5% (Sch-III A)

Displays the net assessable value of interstate branch/consignment transfer inwards recorded by selecting stock items predefined with 5% tax rate for Schedule III - A goods (displays the value of stock items or ledger predefined with SCHEDULE III - A).

Nature of transaction is selected as:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

5% (Sch-III)

Click here for previous column name

Displays the net assessable value of interstate branch/consignment transfer inwards recorded by selecting stock items predefined with 5% tax rate for Schedule III goods.

Nature of transaction is selected as:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

6% (Sch-III)

Displays the net assessable value of interstate branch/consignment transfer inwards recorded by selecting stock items predefined with 6% tax rate for Schedule III goods.

Nature of transaction is selected as:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

13.5%

Displays the net assessable value of interstate branch/consignment transfer inwards recorded by selecting stock items predefined with 13.5% tax rate for which schedule is not specified (In VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

Nature of transaction is selected as:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

14.5%

Displays the net assessable value of interstate branch/consignment transfer inwards recorded by selecting stock items predefined with 14.5% tax rate for which schedule is not specified (In VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

Nature of transaction is selected as:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

15%

Displays the net assessable value of interstate branch/consignment transfer inwards recorded by selecting stock items predefined with the 15% tax rate for which schedule is not specified (In VAT Details screen of stock item or ledger, the Schedule is set to Not Applicable).

Nature of transaction is selected as:

      Interstate Branch Transfer Inward

      Interstate Consignment Transfer Inward

Total

Displays auto calculated value.

12. Total of purchase/receipts

Displays auto calculated value.

Part IV

13. Input tax (including purchase tax in case of manufacturers) paid by the dealer on purchases during the quarter

Displays the gross assessable value and tax on stock items recorded using the following nature of transactions:

      Purchase Taxable

      Purchase Taxable - Capital Goods

      Purchase - Works contract

Displays the assessable value and tax entered for VAT ledger in journal voucher recorded for input tax credit on purchase from URDs.

14. Reverse Credit [As per Box D]

Displays auto calculated value.

15. Input tax credit on account of capital inputs under rule 12

Displays the assessable value and tax rate entered for VAT ledger in journal voucher recorded for input tax credit on capital goods.

16. Unadjusted Input tax credit brought forward from previous quarter

Displays the:

      Opening balance of VAT ledger if the VAT return is not saved.

      Value of box 25 if previous return was saved.

17. Total Input tax credit for the quarter [(13 - 14) + 15 + 16]

Displays auto calculated value.

18. Rebate under section 24(12) [to be claimed only if 10 is greater than 17 and to be computed on 10 - 17]

Displays the debit value of VAT ledger selected in the journal voucher recorded for tax rebate.

19. Surcharge payable under section 3A

Displays the Assessable Value (entered for VAT ledger) and the credit value of VAT entered in journal voucher recorded for surcharge.

20. Additional Tax payable under section 3AA

Displays the Assessable Value (entered for VAT ledger) and the credit value of VAT entered in journal voucher recorded for additional tax.

21. Total of output tax, surcharge and additional tax (net of rebate)[(10-18)+19+20]

Displays auto calculated value.

22.1 VAT payable for the quarter [21-17] if 21 is greater than 17

Displays auto calculated value.

22.2 Interest payable

Displays the credit value of VAT (tax amount) entered in journal voucher recorded for interest due. The value column will be blank.

22.3 Total tax payable for the quarter [22.1+22.2]

Displays auto calculated value.

23 Unadjusted input tax credit [17-21] if 17 is greater than 21

Displays auto calculated value.

24.1 Central Sales Tax admitted

Displays auto calculated value from box 7 of CST Form 1.

24.2 Adjustment of unadjusted input tax credit from liability under CST Act, 1956

Displays the credit value of VAT entered in journal voucher recorded for adjustment towards CST.

24.3 Central Sales Tax payable, if any [24.1-24.2]

Displays auto calculated value.

25.1 Input tax credit carried forward [23-24.2] if 23 is greater than 24.2

Displays auto calculated value.

25.2 Vat paid to the extent of VAT payable in the month/months of the quarter

Displays the amount of excess tax paid for the return period.

25.3 Total input tax credit carried forward [25.1 + 25.2]

Displays auto calculated value.

Part V (Payment Details)

26. Payment details: (Tax paid under VAT and Entry tax shall be furnished as per box L)

26.1 By way of entry tax set-off, if any

Displays the debit value entered in journal voucher recorded for adjustment towards VAT.

26.2 By way of purchase tax paid (in case of a manufacturer only)

Displays the difference in assessable value entered for the journal vouchers recorded for tax on purchase from URDs (box 9.7 of Part II)) and input tax credit on purchase from URDs (box 13 of Part IV).

26.3 By way of advance tax, if any, paid under section 3(7)

Displays the debit value of VAT entered in journal voucher recorded for advance tax paid.

26.4 By way of advance deduction under section 40 or 41 (attach certificate in form C-II)

Displays the credit value of VAT entered in journal voucher recorded for advance tax adjustment.

26.5 DD/cheque (specify number, dates of payments and name of issuing bank)

Displays the amount entered in payment voucher by selecting the Tax Type as VAT with:

      Bank ledger in Account field or

      Mode of payment as Cheque, Draft or e-Payment, in the Stat Payment Details screen of Tax Payment Reconciliation report.

26.6 Cash

Displays the amount entered in payment voucher by selecting the Tax Type as VAT with cash ledger selected in the Account field.

26.7 By way of adjustment on account of excess paid during any earlier month of the same financial year (give details of computation of such excess and the mode of its payment)

Displays auto calculated value from box 16.

26.8 Any other mode eg. Deferment, etc. (specify mode)

Displays the debit value of VAT entered in journal voucher recorded for tax deferred.

26.9 Excess tax carried forward to the next quarter

Displays the value captured in box 25. The excess input tax credit (box 23 - box 24.2) appears here.

Box A (other allowable deductions)

aa. Deduction on account of:

(i). Sales of  goods mentioned in Schedule I of the Act

Displays the net assessable value of sales (excluding MRP sales) recorded with the following nature of transactions:

     Sales Exempt

     Sales Transfer of Right to Use - Exempt

(ii). Sale of Petrol, Diesel, ATF and Natural Gas by an Oil Company to another Oil Company (a list of different goods to be annexed to this return separately alongwith their respective sales values) [Details of goods sold to different companies to be submitted as per Box E-2]

Displays the net assessable value of sale of schedule IV goods (in VAT Details screen of the stock item, set the option Schedule to Schedule IV) recorded with:

      The nature of transaction Sales Exempt.

      Stock items predefined with Motor Spirit or Diesel or Natural Gas or Aviation Turbine Fuel as the Type of goods.

      Point of Sale set to First in Statutory Details screen of the invoice.

(iii). Value of stock transfers within the state of Bihar

Displays the net assessable value of sales recorded by selecting the following nature of transactions:

      Branch Transfer Outward

      Consignment Transfer Outward

(iv). Amount of labour charges and other charges in case of a works contract

Displays the amount entered in the:

      Deductions field of sales invoice recorded with nature of transactions Sales - Works Contract.

      Invoice with the nature of transaction Labour Charges Collected.

(v). Sale of goods on which tax has been paid on MRP at the time of their purchase in terms of section 15(5)

Displays the net assessable value of sales recorded with:

      The nature of transaction Sales Exempt.

      Stock items predefined as MRP Goods (in the VAT Details screen of stock item the option Nature of goods is set to MRP Goods).

(vi). Sale of goods on which tax has been paid on the first point of sale u/s 13(2)(b) of the Act (a list of different goods to be annexed to this return separately alongwith their sale value)

Click here for previous column name

Displays the value of sale of schedule IV goods (In VAT Details screen of the stock item, set the option Schedule to Schedule IV) recorded with:

      The nature of transaction Sales Exempt.

      Stock items predefined with Aviation Turbine Fuel, Diesel, Motor Spirit and Natural Gas as Type of goods.

      Point of Sale set to Second in Statutory Details screen of the invoice.

(vii). Sales to organisations specified in Schedule V.

Displays the net assessable value of sales recorded by selecting the nature of transaction Interstate Sales - Zero Rated with the Party Entity/Org. Type set to Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid.

Total [(i)+(ii)+(iii)+(iv)+(v)+(vi)+(vii)] {to be taken to line 6 of the return.}

Displays auto calculated value.

Box D (Reverse credit)

Reverse Credit on account of:

(i). Value of Input-Output ratio ("K" as per rule 15) of the previous year in case of a manufacturing dealer

This box is left blank.

(ii). Intra-state stock transfers

Displays the net Assessable Value and tax Rate entered in the VAT Details screen of VAT ledger for reversing the tax credit on intra-state transfer of stock.

(iii). Inter state stock transfers

Displays the net Assessable Value and tax Rate entered in the VAT Details screen of VAT ledger for reversing the tax credit on interstate transfer of stock.

(iv). Value of purchase return by the dealer filing this return

Displays the assessable value and tax amount entered for credit ledger in debit note by selecting the following nature of transactions:

     Purchase Taxable

     Purchase - Works Contract

(v). Transfer of the right to use goods, gifts or self-consumption

Displays the Assessable Value entered in VAT Details screen and the credit value of VAT entered in journal voucher recorded for reverse of tax on transfer of right to use.

(vi). Sale of goods specified in Schedule IV

Displays the Assessable Value entered in VAT Details screen and the credit value of VAT entered in journal voucher recorded for reverse of tax on goods specified under schedule IV.

(vii). Sale of goods specified in Schedule I

Displays the Assessable Value entered in VAT Details screen and the credit value of VAT entered in journal voucher recorded for reverse of tax on goods specified under schedule I.

(viii). Value of goods stolen, lost, or destroyed, if any

Displays the Assessable Value entered in VAT Details screen and the credit value of VAT entered in journal voucher recorded for reverse of tax on goods damaged or lost.

(ix). Goods sold at a price lower than the corresponding purchase price

Displays the Assessable Value entered in VAT Details screen and the credit value of VAT entered in journal voucher recorded for reverse of tax on goods sold below purchase price.

(x). Total Reverse Credit [to be taken to line 14 of the return]

Displays auto calculated value.

Box F (Details of statutory Forms/Declarations/Certificates submitted in support of claims)

Number of forms

Displays the count of forms based on the sales transactions.

Period to which transaction relates (dd/mm/yyyy or dd-mon-yyyy)

Displays the period to which the transaction relates.

Value of forms

Displays the net value of (assessable value + tax) of the sales transactions recorded by selecting declaration forms.

 Last updated for Release 5.4.7