ABC Company sells Oval Eyeglasses, model T1234 100 nos. at MRP rates (revised once in 15days) as specified below:
Date |
Rate/ no. |
1 April, 2015 |
Rs. 6000/- |
15 April, 2015 |
Rs. 6100/- |
30 April, 2015 |
Rs. 6500/- |
15 May, 2015 |
Rs. 6600/- |
30 May, 2015 |
Rs. 6750/- |
To Configure MRP based Tax Calculation
Click F12: Configure in the Excise Tariff Details screen.
Enable the option Enable Tax Based on MRP.
Press Ctrl+A.
Enable the option Calculate Duty on MRP.
Enter the Abatement%, as required.
To Define MRP Details
Enable the option Set/ alter MRP details in the stock item master.
Press Enter.
Click L: Details.
Enter MRP Details.
Press Enter.
Press Enter to save the MRP details screen.
To record an MRP Sales Transaction
Go to Gateway of Tally > Accounting Vouchers > F8: Sales.
Select ABC Company as the Tax Unit. The Excise Book Name and the Rule 11 Serial No are displayed automatically.
Enter details as shown in the image below:
Click A: Tax Analysis.
The tax analysis shows that the duty is calculated on Rs. 6,60,000.00. Since the invoice date was recorded on 20 May, 2014, the MRP rate is 6,600.
Press Esc.
Press Ctrl+A.
Similarly, you can define MRP details for a specific period, and record the invoice. The duty rate will be calculated on the MRP rate defined.
To Configure MRP State-wise
Enable the option Set/ alter MRP details in the stock item master.
Click F12: Configure.
Enable Allow state-wise MRP.
Select the State and enter the MRP.
The MRP Details screen appears as shown below:
Press Enter.
Depending on the state selected in the party ledger, the MRP will be calculated in the transaction.
'Recording Sales at MRP Rate (Excise for Manufacturer)' has been shared with