Rate for Excise Amount

YouTube: How to Define a Separate Rate for Excise (%) / Cess (%) Calculation in Sale Bill?

How to Define a Separate Rate for Excise (%) / Cess (%) Calculation in Sale Bill?

Step-By-Step Guide:

  • Open the Sales Voucher Configuration.

  • Select the relevant Billing Series.

  • Click on "Other Settings- 2".

  • Locate the option labeled: "Rate for Excise Amount"

    • This setting offers a dropdown with available rate options (e.g., MRP, Selling Price, Cost).

    • MRP is the most commonly used rate for calculating excise in many ERP systems.

As mentioned above, follow the given steps and select the appropriate option from the dropdown as per your requirement.
  • Click Save to apply the configuration.


Prepare for Transaction

  • Before creating an item transaction, go to Setup Column Attribute.

  • Enable the following columns to display during billing:

    • Excise(%)

    • Rate for Excise(%)

As shown in the picture, enable both of these columns.

Perform an Item Transaction

  • Proceed to transact an item in the billing window.

  • Observe the "Rate for Excise" column—it shows the rate used as the basis for excise calculation.

  • The "Excise" column will reflect the applicable excise percentage.

"Rate for Excise" shows the calculation rate; "Excise" displays the applicable percentage.

Review the Calculated Excise

  • Click to the View Total section of the billing window.

  • Here, you’ll find the calculated excise amount, which is computed based on the selected rate (e.g., MRP).

Displays the calculated excise amount based on the selected rate (e.g., MRP).

This concludes the tutorial on configuring and using the Rate for Excise Amount setting.

Last updated