Item Tax Template

Item Tax Template is useful for item wise taxation.

If some of your Items have tax rates different from the standard tax rate assigned in the Taxes and Charges table, then you can create an Item Tax Template and assign it to an Item or Item Group. The rate assigned in the Item Tax Template will get preference over the standard tax rate assigned in the Taxes and Charges table.

For example, if tax VAT 15% is added in the Taxes and Charges table in Sales Order, then it will be applied on all the items in that Sales Order. However, if you need to have different tax rate applied on some of the items, the steps are given below

1. Prerequisites

Before creating and using an Item Tax Template, it is advised to create the following first:

2. How to create an Item Tax Template

To Create a new Item Tax Template list, go to
Finance > Basics > Item Tax Template

Now the Item Tax Template is ready to be assigned to an Item. To do this, go the Item, Item Tax section and select an Item Tax Template

Note: It is advised to not use the Sales/Purchase Template selected here in Tax Rule, it may cause interference. If you want to use same tax rates for Tax Rule and Item Tax Template, use a different name for the Sales/Purchase Tax Templates.

2.1 Mention Tax Applicable in the Item master

Tax templates are preset with values. For items which have a different tax rate than the others, you need to change it in the Item master. Go to the tax table in the Item, add a row, select the tax type and change the rate. Now, this new rate will over ride the template when creating an order/invoice.

For the Item which is exempted from tax entirely, mention 0% as tax rate in the Item master.

Note: For Item Tax Template to work, you need to ensure that the tax types (accounts) set in Item Tax Template (with changed tax rates) are present in the Sales Taxes and Charges Template.
If you want to include multiple items with different tax rates, you need to have record them under different tax heads. For example, VAT 14%, VAT 5% etc.

2.2 Tax Calculation in transaction

In sales transactions like Quotation, Sales Order, and Sales Invoice the taxes on items are calculated as per the Sales Taxes and Charges Template selected. However, if some items have an Item Tax Template linked, then the taxes are calculated on those items as per the rates mentioned in the Item Tax Template instead of the rates mentioned in the Sales Taxes and Charges Template.

2.3 Item Tax Template for each Items

You can also manually select a different Item Tax Template for each Item in a transaction:

2.4 Item wise tax on an Item Group

You can assign the Item Tax Template to an Item Group by modifying the Item Tax table in the Item Tax section within the Item Group document.

Item Tax Template applied on an Item Group will apply to all Items in that group unless an individual Item in the Item Group has its own Item Tax Template assigned to it.

2.5 Validity of Item Taxes

You can also assign validity to tax templates

  • Based on the posting date of the transaction, a valid tax template will be automatically fetched.
  • If there are more than one valid tax templates then the first valid tax template from Item Tax table will be fetched.
  • In case when there are no valid tax templates then the first tax template with no 'Valid From' date in the Item Tax table will be fetched.
Note: While adding items in Purchase Invoice first preference will be given to 'Supplier Invoice Date' instead of 'Posting Date' for fetching valid Item Tax Template.

2.6 Some points to note

  • If you set the Tax Category as empty, the default Item Tax Template will be applied to Items in transactions.

  • You can apply different Item Tax Templates for different Tax Categories.

  • For an Item Tax Template to override taxes, there must be a row in the Taxes and Charges table with the same tax Account Head with a standard tax rate.

  • If you wish to apply taxes only on the Items with an Item Tax Template then you can set the standard tax rate as 0.

Left Right