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.
Details of sales recorded with the Nature of transaction set as Sales Taxable.
Sales recorded with party ledger in which the Type of Dealer is set to Consumer are displayed in this annexure.
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.
To enable MRP feature, and select MRP goods as the nature of goods
1. Go to Gateway of Tally > Inventory Info. > Stock Items > Create/Alter.
2. Click F12: Configure. In the Master Configuration screen,
o Set the option Allow MRP/Marginal for stock items? to Yes.
o Press Ctrl+A to accept.
3. Set the option VAT Applicable to Applicable.
4. Enable the option Set/alter VAT details? to view the VAT Details screen. To configure the VAT Details screen,
o Click F12: Configure and set the option Allow nature of goods? to Yes.
o Press Ctrl+A to accept.
5. Select MRP Goods as the Nature of goods in VAT Details screen.
6. Press Ctrl+C to select the Commodity name.
7. Enter the Tax rate
8. Select Schedule III as the Schedule.
9. Set the option Calculate VAT on MRP? to Yes.
10. Set the option MRP Incl. of VAT? to Yes/No as per requirement.
11. Press Enter to return to stock item
12. Press Ctrl+A to accept.
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 |
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 |
Displays auto calculated value |
Displays auto calculated value |
|
Goods supplied free of cost |
Trade value |
MRP Value |
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
'RT001- Box J-III (Bihar)' has been shared with