Purchase Taxes and Charges Template

Purchase Taxes and Charges may be applied to any item you buy.

The Purchase Taxes and Charges Template is similar to the Sales Taxes and Charges Template. The templates created from this form can be used in Purchase Orders and Purchase Invoices for internal records.

For Tax Accounts that you want to use in the tax templates, you must set the Account Type field as 'Tax' for that particular account.

To access Purchase Taxes and Charges Template, go to:

Home > Buying > Settings > Purchase Taxes and Charges Template

1. How to add Purchase Taxes/Charges via a template

Before creating a new template, note that templates are already created for many of the commonly used taxes.

Click on New.
Enter a title name for the Tax.

Under type, set on what the tax will be calculated and the tax rate. There are five options under type for which tax will be calculated.
Actual: On the actual amount of each item.
On Net Total: On the grand total of all the items.
On Previous Row Amount: This is for compounding the charges. For example, cess charges over the amount to which tax was already applied in the previous row.
On Previous Row Total: Same as above but applied on the total bill and not just the amount of an item.

Select an account head which has pre set tax rates or create your own.
Selecting default will apply this template by default for new Purchase transactions.
Save.



2. Features

1. Purchase Taxes and Charges table

Consider Tax or Charge for: Total - for the total of all items. Valuation - for each item. Valuation and total - apply tax/charge to both.

What Is The Differences Of Total And Valuation In Tax And Charges

Consider Tax or Charge field in Purchase Taxes and Charges master has three values.

Total
Valuation
Total and Valuation



Let's consider an example to understand an effect of each charge type. We purchase ten units of item, at the rate of 800. total purchase amount is 800. Purchased item has 4% VAT applied on it, and INR 100 was incurred in transportation.

Total:

Tax or Charge categorized as Total will be included in the total of purchase transactions. But it will not have impact on the valuation of item purchased.

If VAT 4% is applied on item, it will amount to INR 32 (at item's based rate is 800). Since VAT is the consumption tax, its should be added value of Purchase Order/Invoice, since it will be included in payable towards supplier. But its should not be added to the value of Purchased item.

When Purchase Invoice is submitted, general ledger posting will be done for tax/charge categorized as Total.

Valuation:

Tax or charge categorized as Valuation will be added in the value of purchased item, but not in the total of that purchase transaction.

Transportation charge of INR 100 should be categorized as valuation. With this, the value of purchased item will be increased from 800 to 900. Also, this charge will be not be added to the total of purchase transaction, because it your expense, and should not be reflected to the supplier.

Total and Valuation:

Tax or Charge categorized as for Total and Valuation will be added in the valuation of item, as well as in the totals of purchase transactions.

Let's assume that transportation is arranged by our supplier, but we need to pay transportation charges to them. In that case, for transportation charges, category selected should be Total and Valuation. With this, INR 100 transportation charge will be added to the actual purchase amount 800. Also, INR 100 will reflect in the total, as it will be payable for us towards supplier.

Add or Deduct: Whether you want to add or deduct the tax from the item.

Reference Row #: If tax is based on "Previous Row Total" you can select the row number which will be taken as a base for this calculation (default is the previous row).

Is this Tax included in Basic Rate?: If checked, the tax amount will be considered as already included in the Print Rate / Print Amount.

Account Head: The Account ledger under which this tax will be booked. If you select VAT or any other preset heads, the rate will be automatically filled.

Cost Center: If the tax/charge is an income (like shipping) or expense it needs to be booked against a Cost Center.

Description: Description of the tax (that will be printed in invoices/quotes).

Rate: The Tax rate, eg: 14 = 14% tax.

Amount: The Tax amount to be applied, eg: 100.00 = ₹100 tax.
Was this article helpful?
Cancel
Thank you!