Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
You are safe to download the resources. We've added our digital signatures to the files.
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|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
The invoice template is designed for book wholesaler, publisher or store. It calculates discounts on each product as they are entered on an invoice, by using Excel formulas. Besides wholesale, it also allows applying discounts to retail customers when you invoice them.
This free Canadian invoice template charges both GST (Goods and Services Tax) and PST (Provincial Sales Tax). If the item being invoiced is a service, GST is charged; if the item is a material, then both GST and PST is charged. This billing format is suitable for business who sells products or provides service in Canada.
With this business invoice template you can assign each customer a specific discounting rate. This rate is saved with other customer information such as street address and email. On creating invoices if you choose a customer, its discount level / rate is retrieved and applied too.
In most business situations the quantity numbers on an invoice are not addable - for example, if you are invoicing for both goods sold and service rendered. But there are cases where you want to add up quantities on an invoice and show the sum on the sales report.
Starting from Uniform Invoice Software version 5, a new Excel add-in module "Uniform Invoice Software Helper" was introduced to provide functions for the Excel on-sheet buttons on the Invoice and report worksheets. This sample demonstrates how you can call the action procedures from your own macro.
Standard fields are those that already created in the default database file shipped with Uniform Invoice Software (UIS), as opposed to custom fields (i.e. user-defined fields) which you should create yourself. This template demonstrates how to change the definition of standard fields.
As a business document, an invoice sent by a business to a client to denote an obligation to pay for goods or services. One of the most important fields is the total amount to pay. This sample invoicing template shows you how to show the invoiced total in English words.