RT001- Box J-III (Bihar)

Annexure J-III displays the dealer-wise details of schedule III and III-A goods, and unspecified goods sold at MRP to cnsumers. It has to be filed with the VAT return every quarter.

Pre-requisites

Nature of Transaction

Details of sales recorded with the Nature of transaction set as Sales Taxable.

Dealer Type

Sales recorded with party ledger in which the Type of Dealer is set to Consumer are displayed in this annexure.

Nature of Goods

The sale of MRP goods are displayed in this annexure. In VAT Details screen of stock item, the options have to be set as given below:

● Nature of goods is set to MRP Goods.

● Calculate VAT on MRP? is set to Yes.

Schedule

The transactions recorded with stock items predefined with Schedule III are displayed in this annexure.

To export data to Box J-III 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. Click A: Annexures.

4. Select Box J-III and press Enter.

5. Click E: Export to view the Export Report screen. Based on the VAT Form RT-I report period, the From and To dates are displayed here. These dates can be changed from e-VAT Annexures report, if required. Ensure the template is available in the Export Location.

6. Add the number of rows based on the count provided in No. of rows to be added field.

7. Press Enter to export data.

A brief explanation about the annexure fields 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
Box J (Dealer wise sale of MRP goods mentioned in line 9(vi) above)
III. Sale to consumers:
Value of MRP goods
	Trade value	MRP Value
sale of Schedule - III goods	Displays the net assessable trade value (quantity * stock item rate) of stock items predefined as Schedule III and III - A goods. Displays the value of stock items predefined with the following schedules: ● SCHEDULE III - Part I ● SCHEDULE III - Part II ● SCHEDULE III - Part III ● SCHEDULE III - A Note: Schedule III - A is added.	Displays the net assessable MRP value (quantity * MRP) of stock items predefined as Schedule III and III - A goods. Displays the value of stock items predefined with the following schedules: ● SCHEDULE III - Part I ● SCHEDULE III - Part II ● SCHEDULE III - Part III ● SCHEDULE III - A 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. Note: Schedule III - A is added.
sale of unspecified goods	Trade value	MRP Value
sale of unspecified goods	Displays the net assessable trade value (quantity * stock item rate) of stock items for which schedule is not specified. In VAT Details screen of stock item, the Schedule is set to Not Applicable.	Displays the net assessable MRP value (quantity * MRP) of stock items for which schedule is not specified. In VAT Details screen of stock item, the Schedule is set to Not Applicable. 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.
Total	Trade value	MRP Value
Total	Displays auto calculated value	Displays auto calculated value
Goods supplied free of cost	Trade value	MRP Value
Goods supplied free of cost	Displays the net assessable trade value (quantity * stock item rate) of free stock items which are part of actual quantity but not billed. To account for sale with free samples 1. Go to Gateway of Tally > Accounting Vouchers > F8: Sale. ● Click F11: Features > F2: Inventory ● Set the option Use different actual and billed qty? to Yes. ● Press Ctrl+A to accept. 2. Select the party ledger, sales ledger and stock item. 3. Enter the Actual quantity (including the free samples) and the Billed quantity (for which the amount has to be paid). 4. Enter the Rate. 5. Select the VAT ledger. 6. Press Ctrl+A to accept.	Displays the net assessable MRP value (quantity * MRP) of free stock items which are part of actual quantity but not billed. To account for sale with free samples 1. Go to Gateway of Tally > Accounting Vouchers > F9: Purchase. ● Click F11: Features > F2: Inventory. ● Set the option Use different actual and billed qty to Yes. ● Press Ctrl+A to accept. 2. Select the party ledger, sales ledger and stock item. 3. Enter the Actual quantity (including the free samples) and the Billed quantity (for which the amount has to be paid). 4. Enter the Rate. 5. Select the VAT ledger. 6. Press Ctrl+A to accept. 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.

Last updated for Release 5.4.7