You are safe to download the resources. We've added our digital signatures to the files.
Without database file. How to download and use
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
How can you tax items at different rates on the same invoice? This Excel sales invoice template offers a simple sample which allows you to define a tax group / type for each item, multiple tax rates is then applied according to the tax type of each item.
This template was originally published on office-kit.com as C5-016, and here on InvoicingTemplate.com there were already customized layouts created based on C5-016, such as c5034 Mixed Tax Rates (5 Columns), and c5035 Mixed Tax Rates in an Invoice (7 Columns). For more samples and formats related to taxing, visit tax invoice template.
One thing to note is that, since the formulas and relationship of fields on the form are deeply customized, the options on the "Taxes" tab of the "Settings" window may not work. So if you want to further customize such templates / forms, you may need to do that manually -- i.e. without using the options on the "Taxes" tab.
While not as complex and expensive as Quickbooks, Uniform Invoice Software is able to handle invoices with mixed tax rates. This is a great sample that shows the advantages of Excel invoicing over Word invoicing, as you can use Excel formulas to search and calculate values on the form. With Microsoft Word, that could hardly be done without macro or VBA code.
Unlike c5034 and c5035, this template (c5016) has exactly the same layout as C5-016 on office-kit.com. Of course we made necessary modifications to make it meet the requirements and specifications of Uniform Invoice Software and InvoicingTemplate.com.
The following description from office-kit.com still provides useful information for you to apply this template to your business.
The default invoice template does allow you to choose tax-type with 3 options: no-tax, one tax and two taxes, but this option is applied to all the items on the invoice form. This slightly-customized invoice template differs from the default invoice template in that it allows you, on the single invoice form, to have some products with no tax, some products with one tax (such as GST) and some products with two (such as GST and PST).
When using the customized template for the first time, you should firstly set up the tax names and rates, as detailed below.
To test the template:
This tax invoice template uses only one custom field, , which is added to both the and the database tables.
By adding thefield to the database table, you don't have to reenter the tax type of the specified product each time it is picked on creating invoices, because the information is loaded automatically when you pick up the product. By adding the field to the database table, the tax type information is saved along with other product data, as well as customer data, when you click , so that you can easily restore a previously saved invoice at a later time.
You specify the tax type of a product on thewindow, with the value , or . When the invoice template loads such a product into the worksheet, it uses the following formula to calculate the first tax:
=ROUND(SUMIF(oknProductType_1:oknProductType_12,"=TAX1", oknLineTotal_1:oknLineTotal_12)*oknTax1Rate+ SUMIF(oknProductType_1:oknProductType_12,"=TAX2", oknLineTotal_1:oknLineTotal_12)*oknTax1Rate,2)
Thefunction tests the value of , , ... cells, and if a value of the cells is " " or " ", the corresponding " " cell value is added. The sum is then multiplied by to get the amount of the first tax.
The second tax formula works in a similar way.
In the second tax formula, thefunction tests the value of , , ... cells, and if a value of the cells is " ", the corresponding " " cell value is added. The sum is then multiplied by to get the amount of the second tax.
Like other form designs here on InvoicingTemplate.com, Multiple Tax Types on One Invoice is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Name||Multiple Tax Rates on One Invoice|
|Category||Sales Invoice Template|
|Release Date||Friday, March 17, 2017|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|