The printed version.
Simple Sample - Moving Taxable Controls (c5076)
c5076 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open
Simple Sample - Moving Taxable Controls - IMFE edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you want this design to be set as the default template by the installer program.
Without database file. How to download and use
Download this if you have already installed IMFE, and are looking for additional customized templates; or if you want a template for Invoice Manager (Lite).
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 Invoice Manager for Excel (namely Uniform Invoice Software), and many other customized version that are available here on InvoicingTemplate.com, 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 InvoicingTemplate.com.
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 InvoicingTemplate.com. 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.
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 InvoicingTemplate.com, 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, 2016 or 2019.
|Name||Simple Sample - Moving Taxable Controls|
|Category||Sales Invoice Template|
|Release Date||Wednesday, January 27, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|