📁
ActiveBooks
  • ActiveBooks Documentation
  • Importing Data in ActiveBooks
    • Downloading Backups
    • Chart of Accounts Importer
    • Data Export
    • Data Import Tools
  • Printing
    • Printing and Branding
    • Print Settings
    • Print Format
    • Print Format Builder
    • Print Style
    • Print Headings
    • Address Template
    • Terms And Conditions
    • Cheque Print Template
    • Custom Translations
    • Raw Printing
  • Workflows
    • Workflows
    • Workflow Actions
    • Workflow State
    • Assignment Rule
    • Email
      • Email
      • Email Domain
      • Email Account
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Email
  • Email
    • Users and Permissions
      • Basic setup of ActiveBooks
        • Setting up Company in ActiveBooks
        • Setting up Taxes in ActiveBooks
        • Setting up Company's Sales Goals
        • Global Defaults in ActiveBooks
        • System Settings in ActiveBooks
        • Letter Head
      • Adding Users
      • Users and Permissions
      • Role and Role Profile
      • Role Based Permissions
      • User Permissions
      • Role Permission for Page and Report
      • Sharing
      • Limited User
      • Administrator
    • Email
    • Email Domain
    • Email Account
    • Email Inbox
    • Email Template
    • Sending Email from any Document
    • Linking Emails to Documents
    • Email Digest
    • Auto Email Reports
    • SMS Settings
    • Notification
    • Document Follow
    • Email Dropbox
  • System Configuration
    • Settings
    • Show or Hide Modules
    • Naming Series
    • Session Defaults
    • Bulk Renaming of Records
    • Bulk Update
    • Milestone Tracking
    • Auto Repeat
    • Domain settings
    • Energy Point System
  • Data Privacy
    • Personal Data Download
    • Personal Data Deletion
  • Articles
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
  • Using ActiveBooks
    • Articles
      • Checking Link Between Documents
      • Access Log
      • Duplicate Records
      • To-Do Auto Creation
      • Document Versioning
      • Deleting and Restoring Documents
      • Bulk Rename
      • Renaming Documents
      • Tree Master Renaming
      • Letter Head in the Report
      • Copy Pasting Multiple Records From Excel
      • Adding Attachments to Outgoing Messages
    • Collaboration Tools
      • Assignment
      • Tags
      • Kanban Board
      • Filter by
      • Save Filter
      • Search Filter
      • Collaborating Around Forms
      • Delete Company Transactions
    • Introduction
      • Tools
        • To Do
        • Notes
        • Video
        • Calendar
        • Chat
        • Dashboard
        • Global Search
        • Desktop
  • Automation
    • Automation
    • Assignment Rule
    • Milestone Tracking
    • Auto Repeat
    • Event Streaming
  • Accounts
    • Introduction
      • Setup and Opening
        • Accounting Entries
        • Accounts Settings
        • Company Setup
        • Chart of Accounts
        • Opening Balance in Accounts
        • Cost Center
        • Distributed Cost Center
        • Fiscal Year
        • Accounting Period
        • Finance Book
        • Accounting Dimensions
        • Accounting Dimensions Filters
        • Bank
        • Bank Account
      • Billing
        • Sales Invoice
        • Purchase Invoice
        • Inter Company Invoices
        • Credit Note
        • Debit Note
        • Credit Limit
      • Taxes
        • Item Tax Template
        • Tax Withholding Category
        • Tax Rule
        • Tax Category
      • Pricing
        • Pricing Rule
        • Promotional Scheme
        • Exchange Rate Revaluation
        • Currency Exchange
        • Currency
      • Retail Operations
        • Point of Sale Profile
        • Point of Sale
        • Cashier Closing
      • Tools
        • Bank Reconciliation
        • Payment Reconciliation
        • Period Closing Voucher
        • Payment Order
        • ActiveBooks to QuickBooks Migrator
        • Process Statement of Accounts
      • Accounting Reports
        • Accounting Reports
      • Advanced
        • Multi Currency Accounting
        • Deferred Revenue
        • Deferred Expense
        • Process Deferred Accounting
        • Bank Guarantee
          • Budgeting
        • Loyalty Program
        • Auto Repeat
        • Invoice Discounting
      • Subscription
        • Subscription
        • Subscription Plan
        • Subscription Settings
      • Shareholder Management
        • Share Holder
        • Share Transfer
        • Share Reports
      • Articles
        • Articles
        • Freeze Accounting Entries
        • Post Dated Cheque Entry
        • Adjust Withhold Amount in the Payment Entry
        • Bulk Payment Entry
        • Difference Entry
        • Changing Parent Account
        • Withdrawing Salary from Owner's Equity Account
        • Common Receivable Account
        • Freeze an Account
        • Round of Account Validation Message
        • Purchase Tax or Charges Categories
        • Types in Sales and Purchase Tax Template
        • Manage Foreign Exchange Difference
        • Recurring Orders and Invoices
        • Delivery from Sales Invoice
        • Exchange Rate Field Frozen
        • Fiscal Year Creation
        • How To Customize Cash Flow Report
        • Immutable Ledger In ActiveBooks
        • Purchase Invoice - Account Type Error
        • Fixing Fiscal Year Error
        • Stock and Accounting Module Integration
        • Merging Accounts
  • Stock
    • Basics
      • Introduction
      • Warehouse
      • Item
      • Opening Stock
      • Accounting Of Inventory Stock
      • Price Lists
      • Stock Settings
    • Item Variants
      • Item Variants
      • Item Attribute
    • Setup
      • Item Price
      • Item Group
      • Unit of Measure (UoM)
      • Manufacturer
    • Stock Transactions
      • Material Request
      • Purchase Receipt
      • Delivery Note
      • Stock Entry
      • Packing Slip
      • Shipment
      • Retaining Sample Stock
      • Landed Cost Voucher
      • Pick List
      • Putaway Rule
    • Serial and Batch Number
      • Serial Number
      • Batch
      • Installation Note
    • Tools
      • Quality Inspection
      • Stock Reconciliation
      • Quick Stock Balance
    • Return
      • Sales Return
      • Purchase Return
    • Advanced
      • Delivery Trip
      • Projected Quantity
      • Perpetual Inventory
    • Stock Reports
      • Stock Ledger Report
      • Stock Level Report
      • BOM Explorer
      • Stock Value and Account Value Comparison Report
      • Articles
        • Allow Over Delivery/Billing
        • Auto Creation of Material Request
        • Delivery Note Negative Stock Error
        • Stock Entry Purpose
        • Purpose of Stock Received but not Billed
        • Item Valuation Methods and Transactions
        • Maintain Stock field Frozen in the Item master
        • Managing Rejected Finished Goods Items
        • Return Rejected Items
        • Track Items Using Barcode
        • Item Valuation Fifo And Moving Average
        • Item Codification
        • Serial No. Naming
        • Opening Stock Balance Entry for Serialized and Batch Item
        • Managing Batch wise Inventory
        • Sales Return Management
        • Managing Fractions in UOM
        • Repack Entry
        • Material Transfer from Delivery Note and Purchase Receipt
        • Mode of Payment
        • Migrate To Perpetual Inventory
        • Depreciation Entry
  • CRM
    • Introduction to CRM
    • Sales
      • Lead
      • Opportunity
      • Customer
      • Contact
      • Address
      • Appointment
    • Reports
      • CRM Reports
    • Setup
      • Lead Source
      • Opportunity Type
      • Sales Stage
      • Sales Person
      • Customer Group
      • Email Group
      • Contract
      • Appointment Booking Settings
    • Marketing
      • Campaign
      • Email Campaign
      • Newsletter
      • LinkedIn Settings
      • Twitter Settings
      • Social Media Post
    • Articles
      • Automate Lead Creation
      • CRM Analytics
      • Difference between Lead, Contact and Customer
  • Selling
    • Selling
    • Quotation
    • Sales Order
    • Sales Partner
    • Brand
    • Blanket Order
    • Territory
    • Setup
      • Selling Settings
      • Product Bundle
      • Sales Person Target Allocation
      • Sales Taxes and Charges Template
      • Shipping Rule
      • Party Specific Item
    • Articles
      • Sales Persons in the Sales Transactions
      • Request for Raw Material from Sales Order
      • Applying a Discount
      • Selling in Different Unit (UoM)
      • Adding Margin
      • Amending Sales Order after Submit
      • Drop Ship
      • Calculate Incentive for Sales Team
      • Shipping Rule
      • Close Sales Order
      • Taxes and Charges
      • Print Settings
      • Payment Terms
    • Selling Reports
      • Sales Reports
  • Buying
    • Buying
      • Request for Quotation
      • Purchase Order
      • Purchase Taxes and Charges Template
      • Supplier
      • Supplier Quotation
      • Supplier Scorecard
    • Setup
      • Buying Settings
      • Supplier Groups
    • Articles
      • Maintaining Supplier's Item Code in the Item Master
      • Purchasing in Different Unit (UoM)
      • Amending Purchase Order after Submit
      • Procurement Tracker Report
  • HR
    • Employee
      • Employee
      • Employment Type
      • Branch
      • Department
      • Designation
      • Employee Grade
      • Employee Group
      • Employee Health Insurance
    • Attendance
      • Attendance
      • Employee Attendance Tool
      • Attendance Request
      • Upload Attendance
      • Auto Attendance
    • Leave Management
      • Leaves
      • Holiday List
      • Leave Type
      • Leave Period
      • Leave Policy
      • Leave Policy Assignment
      • Leave Allocation
      • Leave Application
      • Compensatory Leave Request
      • Leave Encashment
      • Leave Block List
      • Leave Ledger Entry
    • Recruitment
      • Recruitment
      • Employee Referal
      • Staffing Plan
      • Job Opening
      • Job Applicant
      • Job Offer
      • Appointment Letter
    • Training
      • Training Program
      • Training Event
      • Training Result
      • Training Feedback
    • Employee Life Cycle
      • Employee Life Cycle Management
      • Employee Onboarding
      • Employee Promotion
      • Employee Seperation
      • Employee Transfer
      • Employee Skill Map
    • Payroll
      • Payroll Setup
      • Payroll Management
      • Payroll Period
      • Income Tax Slab
      • Salary Component
      • Salary Structure
      • Salary Structure Assignment
      • Salary Slip
      • Payroll Entry
      • Additional Salary
      • Retention Bonus
      • Employee Incentive
    • Employee Tax and Benefits
      • Setting Up Income tax Deduction
      • Employee Tax Exemption Declaration
      • Employee Tax Exemption Proof Submission
      • Employee Other Income
      • Employee Benefit Application
      • Employee Benefit Claim
    • Travel and Expense Claim
      • Travel Request
      • Employee Advance
      • Expense Claim
    • Gratuity
      • Gratuity
      • Gratuity Rule
    • Loans
      • Loan Type
      • Loan Application
      • Loan
    • Shift Management
      • Shift Management
    • Fleet Management
      • Fleet Management
      • Vehicle
      • Vehicle Log
    • Setup
      • Human Resource Setup
      • HR Settings
      • Daily Work Summary Group
    • Reports
      • Human Resources Reports
    • Articles
      • Articles
      • Leave Calculation in Salary Slip
      • Workdays Calculation in the Salary Slip
    • Performance
      • Appraisal
  • Projects
    • Project
      • Project and Managing Expenses
      • Salary Slip from Timesheet
      • Activity Type
      • Project Template
      • Timesheet
      • Projects
      • Introduction to the Project Module
      • Project Profitability
      • Project Reports
      • Project Type
      • Project Update
      • Project from Customer Portal
      • Activity Cost
      • Project Costing
      • Project
      • Tasks
      • Project Views
      • Sales Invoice from Timesheet
      • Delayed Tasks Summary
      • Project Profitability Report
    • Articles
      • Make A Colorful Gantt Chart
Powered by GitBook
On this page
  • 1. Prerequisites
  • 2. How to create an Item Tax Template

Was this helpful?

  1. Accounts
  2. Introduction
  3. Taxes

Item Tax Template

Item Tax Template is useful for item wise taxation.

PreviousTaxesNextTax Withholding Category

Last updated 3 years ago

Was this helpful?

  • 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.

To access the Item Tax Template list, go to

Accounting > Taxes > Item Tax Template

Let's assume that we are creating a Sales Order. We have the master for GST 9%. Out of all the Sales Items, on one Item, only 5% GST will be applied, while another item is exempted from tax (non taxable). You need to select the Account Head of the tax and set its overriding rate.

1. Prerequisites

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

  1. Item

  2. Enable 'Automatically add Taxes and Charges from Item Tax Template' in Account Settings.

  1. Go to the Item Tax Template list and click on New.

  2. Enter a title for the Item Tax Template.

  3. Select an account and set the overriding rate. Add more rows if required.

  4. Save.

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:

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 example, in the below screenshot you can see that the tax rate is set as 5 and that's the rate which will be applied in transactions.

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.

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.

For example, in the following screenshot, you can see that taxes are calculated at 3% even though the rate as per Sales Taxes and Charges Template is 6.25%.

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

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.

You can also assign validity to tax templates as shown in the image above.

  • 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.

  • 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.

2. How to create an Item Tax Template

Item Tax In Item

Note: It is advised to not use the Sales/Purchase Template selected here in , 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

Item-wise Tax
Tax Exempted Item

2.2 Tax Calculation in transaction

Tax Calculation

2.3 Item Tax Template for each Items

Slect Item Tax Template

2.4 Item wise tax on an Item Group

Item Tax Template in Item Group

2.5 Validity of Item Taxes

Item Tax in Item Group

2.6 Some points to note

Tax Rule
Sales Taxes and Charges Template