Skip to main content main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Simple Sample - Moving Taxable Controls. Double-click the downloaded file to extract all files.
  2. Open the template "simple-invoice-template-taxable-controls.xlsx" or "simple-invoice-template-taxable-controls-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.

Simple Sample - Moving Taxable Controls

Simple Sample - Moving Taxable Controls (c5076)

c5076 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-invoice-template-taxable-controls-uis.xlsx.

Simple Sample - Moving Taxable Controls (UIS Edition)

Simple Sample - Moving Taxable Controls - UIS edition

Download Simple Sample - Moving Taxable Controls (c5076)

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.


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

294 KBDownload

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

2.79 MBDownload


If all the products or items you are invoicing are taxable or not taxable, you may like to not show the Taxable column. This simple invoice template demonstrates how to prevent it from printing.

The default invoicing form shipped with Uniform Invoice Software, and many other customized version that are available here on, have the "Taxable" column on the detail section (sometimes called invoice body). This is useful if you need to invoicing both taxable and no-taxable items / products, as the taxable boxes on the form shows whether the amount of the each item is counted on tax calculation clearly.

However, if you have only taxable or non-taxable products, it's wise to prevent the taxable boxes from printing, or even to delete the taxable boxes / controls completely.

This simple invoicing template shows you how to create a billing format that exclude the taxable boxes from the printable form. This sample is based on the result of c5075 Simple Invoice Template - Moving Balance and Payment Cells. The customized template created in this tutorial could be downloaded for free from here on

The idea to exclude the taxable boxes from printing is to move the controls out of the printable invoicing form which is identified by the special Excel range name "Print_Area". To find out what area on your template is defined as the print area, pull down the name list that is located on the left side of the formula bar, and on the bottom of the name list choose "Print_Area". Excel selects the area defined as the printable form on the current worksheet. You may need to switch the worksheet in to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab if the worksheet is protected.

Now let's see how to move the Taxable controls. There are in fact two forms of taxable controls implemented in the templates available here on Some of them are implemented as ActiveX controls, and some of them are implemented as Office form controls. No matter what the control types are, the steps required to move the controls are the same, as detailed below.

  1. First of all, back up your template. It is always recommended to back up the template before modifying the layout and format. This way, you could easily return to a working state in case something goes wrong during customization.
  2. Now click to push down the "Design Mode" button on the "Invoice" ribbon tab. This switch the spreadsheet into design mode, showing gridlines and column / row headings, unprotecting the sheet, as well as push down the "Design" button on Excel "Developer" ribbon tab (The "Developer" ribbon tab is not visible by default).
  3. Now push down the CTRL key on your keyboard. Without releasing the CTRL key, click the taxable boxes one by one with your mouse. This select the taxable controls that you click.
  4. Once all the taxable boxes are selected, release the keyboard CTRL key.
  5. Click and drag one of the taxable box. Drop it outside the printable area - in this sample, we put it on $C10. By dragging and dropping one of the selected controls, all the selected controls are moved to the new location.
  6. If you want to delete the controls completely, with all the controls still selected, hit DEL key on your keyboard. If you want to leave them there, skip this step.
  7. You can also modify the formulas of the tax fields to have them ignore the value of the taxable boxes completely. If all your products or items are always taxable, modify the formula of the first tax cell to " =ROUND( IF ( oknTaxType =0 ,0, oknTax1Rate * ( oknSubTotal + IF( oknTaxTotalIncludingShippingCost =0,0, oknShippingCost ))),2)"; and modify the formula of the second tax cell to " =ROUND ( IF( oknTaxType <> 2,0, oknTax2Rate * ( oknSubTotal + IF ( oknTaxTotalIncludingShippingCost = 0,0, oknShippingCost )+IF( oknTax2IsAppliedToTax1= 0 ,0, oknTax1 ))),2) ". If all your products / items are not taxable, simply choose "No-tax" from the "Taxes" page of the Settings dialog box that could be opened by clicking the "Settings" button on the "Invoice" ribbon tab.
  8. Now modify the column heading of the original "#/Taxable" column. To do this, simply replace the text "#/Taxable" with something like "Item#" or simply "#".
  9. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab again.
  10. Once done, save the template by clicking the Save button on Excel quick access toolbar.

If your business don't have the need to show taxable boxes, moving it outside the printable form or deleting it could simplify the form greatly. The simple invoice template created in this tutorial shows you how to archive this.

Like other form designs here on, Simple Invoicing Format - Moving Taxable Controls 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.

Format and Specification

NameSimple Sample - Moving Taxable Controls
CategorySales Invoice Template
Release DateWednesday, January 27, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Line Height (Points)18.00
Print Area$D$2:$K$46
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)

Sample Templates