Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Mixed Tax Rates (5 Columns)

Mixed Tax Rates (5 Columns) (c5034)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Mixed Tax Rates (5 Columns) - freeware edition

Mixed Tax Rates (5 Columns) - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Mixed Tax Rates (5 Columns) - Uniform Invoice Software V3 edition

Mixed Tax Rates (5 Columns) - Uniform Invoice Software V3 edition

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Without database file. How to download and use

92 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

356 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.83 MBDownload

Detail

The default sales invoicing template applies the defined tax rules to all items in an invoice. The customized free tax invoice template in this Mixed Tax Rates in an Invoice allows charging different rates to different items.

For example, if you are selling both beverages and non-beverages products, which must be charged with different tax rates, for example beverage tax must be at 3.0% and non-beverage tax rate must be at 5.0%; or if you are selling both general products (goods) and labor (service) to customers, which are two types of taxable items and should be charged with different tax rates. If you want to add these two types of invoicing items to the default template, you may find the template will fail to calculate the taxes because with the default implementation, the tax items you defined on the default template, no matter one tax or two, will applied to all the items that have the "taxable" option checked.

What do you do if you want to tax some items at different rates than other items? In the traditional approach shown above, you either tax an item at the one rate or two rates, or don't tax the item.

Firstly, we added the custom field "Product Type" to the Product database table. With this field you'll define the tax type of the product or item, which could be have a value of "beverage" or "non-beverage", or something like "General" or "Labor" - depending on your business requirements. Secondly, we added the custom field "Product Type" to the "InvBdy" database table, with exactly the same name and type as what defined in the Product database table; and add the custom field "Applied Tax Rate" to the "InvBdy" data table, which saves the actual rate applied to the current invoicing item.

Mixed Tax Rates in an Invoice here is a sales invoicing sample, which means it includes shipping information on the form.

This design, Mixed Tax Rates in an Invoice, has the "Product Type" and "Applied Tax Rate" placed outside of the printable area. What if you want to show these two columns on the printable invoicing form? It is easy actual to do - as mentioned above, all you need to do is to first adjust the existing columns to leave space for the two newly added columns, and then move in the two new columns.

The next step is to move the new columns added for this template, i.e. "Product Type" and "Applied Tax Rate" to the printable invoicing form.

The result of moving the "Product Type" and "Applied Tax Rate" columns into the printable form can be found at Mixed Tax Rates in an Invoice (7 Columns).

Like other form designs here on InvoicingTemplate.com, Mixed Tax Rates in an Invoicing Form (5 Columns) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5034
NameMixed Tax Rates (5 Columns)
CategorySales Invoice Template
Release DateSunday, November 24, 2013
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$N$40
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35