Explore Categories



Record Sales at MRP Rate (Excise for Manufacturer)

When goods are configured to be sold at MRP rate, tax is calculated on MRP in the sales invoice.

National Enterprise sells Oval Eyeglasses, model T1234 100 nos. at MRP rates (revised once in 15days) as specified below:



1 April, 2020

Rs. 6000/-

1 May, 2020

Rs. 6100/-

1 June, 2020

Rs. 6500/-

1 July, 2020

Rs. 6600/-

1 Aug, 2020

Rs. 6750/-


Configure MRP based Tax Calculation

  1. Gateway of Tally > Alter > type or select Stock Item.
    Alternatively, press Alt+G (Go To) > Alter Master > type or select Stock Item.
  2. Enable the option Set/alter excise details.
  3. Press F12 (Configure) in the Excise Tariff Details screen.
  4. Enable the option Enable Tax Based on MRP.
  5. Press Ctrl+A.
  6. Enable the option Calculate Duty on MRP.
  7. Enter Abatement%, as required.


Define MRP Details

  1. Enable the option Set/alter MRP details in the stock item master.
    If you do not see this option, press F12 (Configure).
    • Set Show more configurations to Yes
    • Set Provide MRP Details to Yes.
  2. Press Enter.
  3. Press Alt+W (Details).
  4. Enter MRP Details.
  5. Press Enter.
  6. Press Enter to save the MRP details screen.


Record an MRP Sales Transaction

  1. Gateway of Tally > Vouchers > press F8 (Sales).
    Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).
  2. Press Ctrl+H (Change Mode) > select Excise Invoice
  3. Select National Enterprise as the Tax Unit. The Excise Book Name and the Rule 11 Serial No are displayed automatically.
  4. Enter details as shown in the image below:
  5. Press Ctrl+O (Related Reports) > type or select Excise – Tax Analysis.

    If you are on TallyPrime Release 1.1.3 or earlier, follow the step:
    Press Ctrl+I (More Details) > type or select Excise – Tax Analysis.

  6. Press Esc.
  7. 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.


Configure MRP State-wise

  1. Enable the option Set/alter MRP details in the stock item master.
  2. Press F12 (Configure).
  3. Enable Allow state-wise MRP.
  4. Select the State and enter the MRP.
    The MRP Details screen appears as shown below:
  5. Press Enter.

Depending on the state selected in the party ledger, the MRP will be calculated in the transaction.

Post a Comment

Is this information useful?