Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Mixed Tax Rates in an Invoice (7 Columns). Double-click the downloaded file to extract all files.
  2. Open the template "tax-invoice-7-columns.xls" or "tax-invoice-7-columns-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Mixed Tax Rates in an Invoice (7 Columns)

Mixed Tax Rates in an Invoice (7 Columns) (c5035)

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

Mixed Tax Rates in an Invoice (7 Columns) - freeware edition

Mixed Tax Rates in an Invoice (7 Columns) - freeware edition

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

Mixed Tax Rates in an Invoice (7 Columns) - Uniform Invoice Software V3 edition

Mixed Tax Rates in an Invoice (7 Columns) - Uniform Invoice Software V3 edition

Download Mixed Tax Rates in an Invoice (7 Columns) (c5035)

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

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

377 KBDownload

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

2.84 MBDownload

Detail

This tax invoice template named Mixed Tax Rates in an Invoice (7 Columns) is a variant of Mixed Tax Rates in an Invoice (5 Columns). It differs from the original by moving the two new columns into the printable form.

In the original version, which is named Mixed Tax Rates in an Invoice (5 Columns) here on InvoicingTemplate.com, we implemented a feature that allows you to tax different types of items with different rates on one same invoice by adding several custom fields and creating some Excel formulas. By using custom fields and Excel formulas, we can create exciting features that are not supported by the default sales invoice template that was shipped with Uniform Invoice Software. The two newly added columns, which are "Product Type" and "Applied Tax Rates", are placed outside the printable invoice form in the original version. If the product / item description text labels are short, you may like to place these two new columns inside the printable invoice form. This customized form named Mixed Tax Rates in an Invoice (7 Columns) implements this.

This invoice template is also published on our company site here, and on office-kit.com here.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Mixed Tax Rates in an Invoice (7 Columns) uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Mixed Tax Rates in an Invoice (7 Columns) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Mixed Tax Rates in an Invoice (7 Columns) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Mixed Tax Rates in an Invoice (7 Columns) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Mixed Tax Rates in an Invoice (7 Columns) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

If your product / item descriptions are long and you need more space for the column, see Mixed Tax Rates in an Invoice (5 Columns).

Like other form designs here on InvoicingTemplate.com, Mixed Tax Rates in a 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#c5035
NameMixed Tax Rates in an Invoice (7 Columns)
CategorySales Invoice Template
Release DateMonday, November 25, 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
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates