CST on Total Including Excise Duty

Hi Everyone,

I have a scenario where I want to add CST on Total including excise duty.
For example:

Item Qty. Rate Amount
X 10 100 1000

Excise Duty 12.5%:
125 Rs.

CST 5%:
It should be (1000+125)/5=56.25

Can anyone tell me how to do this?

Hi @ruchin78,

I think you need to use “Sales Taxes and Charges Template” which is in selling -> setup -> Sales Taxes and Charges Template
here you need create your own taxes calculation pattern
https://frappe.github.io/erpnext/user/manual/en/accounts/item-wise-tax

if this is not helpfull to you then please inform me.

@Nishant_Jariwala

Thanks for your response, but I did it before your reply.
It cannot be done by template. here you need to manually calculate the tax and add it to the CST.

Regards
Ruchin Sharma

@ruchin78 In the taxes, for excise duty put the type as “on net total” and in next row put cst with type “on previous row total”.

-Amit