Tuesday, February 22, 2011

How to Create a Template for Taxes and Other Charges Related to Sales in ERPNext?

You can add taxes for example VAT , CST etc in sales transactions directly. But if there is a standard set of taxes which are always applicable, then it would be convenient to create a template for taxes and other charges and select the same in transactions. This would be more convenient to use and save time.

To create such a template follow steps as shown below.

Click on "New Other Charges" to get a screen as shown below. Mention the title of the template which will be selected in the transaction to pull the tax details. You can select Type based on the following requirements :

  1. Actual - when you know the actual amount of tax or other charge to be added to the net total, mention the amount in the Rate column.
  2. On Net Total - will be selected when a tax percentage has to be calculated on the net total.
  3. On Previous Row Amount - will be selected if a tax percentage needs to be calculated over the previous row tax amount . In this case mention the Row Id.
  4. On Previous Row Total - will be selected when a tax percentage needs to be calculated over the total of net total and the previous row tax amount. In this case also mention the Row Id

Select the relevant tax account head applicable. The account head should be created under Chart of Accounts. The tax rate will be mentioned in the account head and will get fetched under the Rate column on selecting the same. You can add multiple taxes in a single template.

Save the template. You can now pull the tax details in your sales transactions. Lets open a Sales Order and select the template we just created above.

Select the template and click on Get Charges button. In this way you can fetch the taxes in Delivery Note and Sales Invoice as well.

more details visit www.erpnext.com


  1. It is truly a well-researched content and excellent wording. I got so engaged in this material that I couldn’t wait reading. I am impressed with your work and skill. Thanks. Personal Income Tax

  2. Hey! I have read all your Blog this So Nice and Awesome service you have provided, I learn many new things from here and want implement my website. If you are also Know for Tax Accountants New related to this then visit my website.

  3. Business Tax Return

    About-us - We provide accounting services for small business, bookkeeping, cloud-based accounting, taxation, organizations throughout Australian. Contact us now! 0412 441 570

    to get more - https://ajas.com.au/about-us/