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. The following nature of transactions are considered here: o Sales Taxable o Sales Transfer of Right to Use o Sales - Works Contract o Labour Charges Collected o Interstate Sales - Zero Rated with Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid or SEZ / STP / EHTP selected as Party Entity/Org. Type. o Sales Exempt o Sales Transfer of Right to Use - Exempt ● Net value of sales (including tax) recorded with the nature of transactions provided for interstate sales. The following nature of transactions are considered here: o Branch Transfer Outward o Consignment Transfer Outward o Interstate Sales - Against Form C o Interstate Sales - E1 o Interstate Sales Taxable o Exports o Interstate Branch Transfer Outward o Interstate Consignment Transfer Outward o Interstate Sales Exempt - E1 o Interstate Sales Exempt o Interstate Sales - E2 o Interstate Deemed Export
Deductions:
2. Sales in the course of inter-state trade and commerce	Displays the net value (including tax) of interstate sales. Displays the net value, of sales made with the following nature of transactions: ● Interstate Sales - Taxable ● Interstate Sales - E1 ● Interstate Sales - Against Form C ● Interstate Sales Exempt - E1 ● Interstate Sales - E2 ● Interstate Sales Exempt ● Interstate Sales - Zero Rated with Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid or SEZ / STP / EHTP selected as Party Entity/Org. Type.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Decrease in Sales in the Nature of adjustment field. o Press Enter to save and return to voucher screen. 3. Debit the interstate sales ledger. 4. Enter the amount in the Debit column. 5. Debit the CST ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Enter the amount in Debit column. 7. Credit the interstate sales ledger predefined with the nature of transaction Interstate Sales Exempt. 8. Credit the party or branch ledger. 9. Press Ctrl+A to accept.
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 9(v) Total sales of goods u/s 13(1) = {(ii) + (iii) + (iv)(a) + (iv)(b)} [Details of dealer wise sales to be furnished as per Box B]	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. To account for tax liability on purchase from unregistered dealers 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen: o Select the option VAT in the Type of duty/tax field. o Select the option Tax on URD Purchase in the Nature of adjustment field. o Press Enter to save and return to the voucher screen. 3. Debit the ledger created under the group Indirect Expenses and enter the amount. 4. Credit the VAT ledger. o Enter the Rate, Assessable Value, and Commodity Code, and select the Commodity name of the item purchased in the VAT Details screen. The VAT Details screen appears as shown below: o Press Enter to return to voucher screen. 5. Press Ctrl+A to accept.
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 10. Total Output tax [(i)(a)+(i)(b)+(i)(c)+(i)(d) +(i)(e)+(i)(f)+(i)(g)+(i)(h)+(v)+(vi)+(vii)+(viii)]	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. In the VAT Details screen of stock item the option: ● Nature of goods is set to MRP Goods. ● 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 nature of transaction Purchase Taxable. In VAT Details screen of the stock item, set the options as shown below: ● Type of goods to any goods other than Liquor. ● Schedule to Schedule IV.
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 This column name was 5% in old template.	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)). In VAT Details screen of the stock item, set the options as shown below: ● Type of goods to any goods other than Liquor. ● Schedule to Schedule IV.
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. Displays the value of stock items or ledger predefined with the following schedules: o SCHEDULE III - Part I o SCHEDULE III - Part II o SCHEDULE III - Part III 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. Displays the value of stock items or ledger predefined with the following schedules: o SCHEDULE III - Part I o SCHEDULE III - Part II o SCHEDULE III - Part III 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. Displays the value of stock items or ledger predefined with the following schedules: o SCHEDULE III - Part I o SCHEDULE III - Part II o SCHEDULE III - Part III 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. Displays the value of stock items or ledger predefined with the following schedules: o SCHEDULE III - Part I o SCHEDULE III - Part II o SCHEDULE III - Part III 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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen: o Select the option VAT in the Type of duty/tax field. o Select the option Input Tax Adjustment for Purchases From URDs in the Nature of adjustment field. o Press Enter to save and return to the voucher screen. 3. Debit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 4. Enter the amount in the Debit column. 5. Credit the ledger grouped under Current Assets. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen: o Select the option VAT in the Type of duty/tax field. o Select the option Input Tax Credit Admitted On Capital Goods in the Nature of adjustment field. o Press Enter to save and return to the voucher screen. 3. Debit the VAT ledger. o Select the Input Credit details in the Credit Settlement Details screen. o Press Enter to return to voucher screen. 4. Enter the amount in the Debit column. 5. Credit the ledger grouped under Current Assets. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Decrease of Output Tax in the Nature of adjustment field. o Select the option Rebate in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 4. Enter the amount in the Debit column. 5. Credit the income ledger. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Increase of Tax Liability in the Nature of adjustment field. o Select the option Surcharge in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Increase of Tax Liability in the Nature of adjustment field. o Select the option Additional Tax in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Increase of Tax Liability in the Nature of adjustment field. o Select the option Interest in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Decrease of Input Tax in the Nature of adjustment field. o Select the option Against CST in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the CST ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reducing Tax Liability in the Nature of adjustment field. o Select the option Entry Tax in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 4. Enter the amount in the Debit column. 5. Credit the ledger grouped under Current Assets. 6. Press Ctrl+A to accept.
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). To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen: o Select the option VAT in the Type of duty/tax field. o Select the option Input Tax Adjustment for Purchases From URDs in the Nature of adjustment field. o Press Enter to save and return to the voucher screen. 3. Debit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 4. Enter the amount in the Debit column. 5. Credit the ledger grouped under Current Assets. 6. Press Ctrl+A to accept. To account for tax liability on purchase from unregistered dealers 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen: o Select the option VAT in the Type of duty/tax field. o Select the option Tax on URD Purchase in the Nature of adjustment field. o Press Enter to save and return to the voucher screen. 3. Debit the ledger created under the group Indirect Expenses and enter the amount. 4. Credit the VAT ledger. o Enter the Rate, Assessable Value, and Commodity Code, and select the Commodity name of the item purchased in the VAT Details screen. The VAT Details screen appears as shown below: o Press Enter to return to voucher screen. 5. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reducing Tax Liability in the Nature of adjustment field. o Select the option Advance Tax Paid in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 4. Enter the amount in the Debit column. 5. Credit the ledger grouped under Current Assets. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Increase of Output Tax in the Nature of adjustment field. o Select the option Advance Tax in Additional Details field. o Press Enter to save and return to voucher screen. 3. Credit the ledger grouped under Current Liabilities. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Decrease of Output Tax in the Nature of adjustment field. o Select the option Tax Deferred in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 4. Enter the amount in the Debit column. 5. Credit the ledger grouped under Current Liabilities. 6. Press Ctrl+A to accept.
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 (vi). Sale of petroleum products 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 respective sales values)	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. To create journal voucher to reverse the input tax 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reversal of Input Tax in the Nature of adjustment field. o Select the option Intra State Stock Transfer in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
(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. To create journal voucher to reverse the input tax 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reversal of Input Tax in the Nature of adjustment field. o Select the option Inter State Stock Transfer in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
(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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reversal of Input Tax in the Nature of adjustment field. o Select the option Transfer of Right to Use Goods, Gifts Or Self Consumptions in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
(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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reversal of Input Tax in the Nature of adjustment field. o Select the option Goods Specified in Schedule- IV in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
(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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reversal of Input Tax in the Nature of adjustment field. o Select the option Sale of Goods in Schedule- I in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
(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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reversal of Input Tax in the Nature of adjustment field. o Select the option Goods Damaged / Lost in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
(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. To record the journal voucher 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. In the Stat Adjustment Details screen, o Select the option VAT in the Type of duty/tax field. o Select the option Reversal of Input Tax in the Nature of adjustment field. o Select the option Goods Sold Below Purchase Price in Additional Details field. o Press Enter to save and return to voucher screen. 3. Debit the expense ledger. 4. Enter the amount in the Debit column. 5. Credit the VAT ledger. o Enter the Rate and Assessable Value in the VAT Details screen. o Press Enter to return to voucher screen. 6. Press Ctrl+A to accept.
(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. The form type that appears against each nature of transaction is given below: ● C - Interstate Sales - Against Form C ● E-I/E-II - Interstate Sales - E1, Interstate Sales - E2, Interstate Sales Exempt - E1 ● F - Branch Transfer Outward, Consignment Transfer Outward, Interstate Branch Transfer Outward, Interstate Consignment Transfer Outward ● H - Interstate Deemed Export ● I - Interstate Sales - Zero Rated (Party Entity/Org. Type: SEZ / STP / EHTP (or) Type of Exemption: SEZ) ● J - Interstate Sales - Zero Rated (Party Entity/Org. Type: Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid (or) Type of Exemption: Diplomatic Missions & U.N.)
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

Rate this article*

E-mail ID

Contact Number

Share your feedback about this page

Remaining Characters: 520

Tally.ERP 9 Topics

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