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

Screenshots and Images

The printed version.

Sample Sales Invoice Template: Fixed Items

Sample Sales Invoice Template: Fixed Items (c5040)

c5040 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open sample-sales-template-fixed-items.xlsx.

Sample Sales Invoice Template: Fixed Items (IMFE Edition)

Sample Sales Invoice Template: Fixed Items - IMFE edition


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 want this design to be set as the default template by the installer program.

3.90 MBDownload

Without database file. How to download and use

628 KBDownload

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).

1666 KBDownload


"Sample Sales Invoice Template: Fixed Items" is a sample invoice that demonstrates how to use fixed or static product items on the body part of the printable invoice form. It is a sales template thus including shipping fields. For a practical example of using fixed items, visit Concrete Pumping Work Order and Invoice.

In some businesses the number of products or service items offered are limited, i.e. the client / customers always order the same group of products / services from the company. It would be nice to have the invoice form always leaves the item#, item description, or even item unit price there and does not change them from invoice to invoice. We call these static or fixed items because they don't change. Using static and fixed items prevent you from type or choose the same product items again and again, saving your time and avoiding typo mistakes. The fixed items even won't get cleared when you execute "Clear & New" with Invoice Manager for Excel (namely Uniform Invoice Software) installed - it sounds interesting because the "Clear & New" command is designed to clear all the content to make it a blank invoice form for next new invoice. So how do we tell the "Clear & New" command not to touch the items that shouldn't change from invoice to invoice?

Looking into Invoice Manager for Excel (namely Uniform Invoice Software) documents you'll find that although the command clear every fields, there are two exceptions - the cells that have formulas defined, and the cells that are locked. As detailed at Invoice Form with Fixed or Static Product / Service Items on, what we do is just enabled the "Locked" of the cells that you want to keep from invoice to invoice.

Note that these static or fixed items are not static text labels such as your company information on the invoice header. The static or fixed items are linked to database fields, and get saved to database when you click "Save To DB" in Invoice Manager for Excel (namely Uniform Invoice Software).

So with very little effort the items that don't change from invoice to invoice become static or fixed. They stay on the invoice form even if you click the "Clear & New" command in Invoice Manager for Excel (namely Uniform Invoice Software). The sample invoice template has exactly the same format and layout as the default sales invoice template included in Invoice Manager for Excel (namely Uniform Invoice Software) setup program, but has some items fixed on the form.

As the name implies "Sample Sales Invoice Template: Fixed Items" includes shipping fields. For a service invoice template please see "Sample Service Invoice Template: Fixed Items".

Like other form designs here on, Sales Template with Fixed Items 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.

Format and Specification

NameSample Sales Invoice Template: Fixed Items
CategorySales Invoice Template
Release DateSaturday, December 21, 2013
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019
Line Height (Points)16.50
Print Area$E$2:$N$44
Papaer Size / OrientationPortrait
Default Margins (Points)

Update History

January 20, 2018

  • Removed all the text labels (ActiveX controls) from the "Bill To" and "Ship to" sections. Added reminder text, such as "Name", "Address", "City, ST ZIP" etc. outside of the printable form.
  • The values on the fixed line are assigned using Excel formula, instead of using the "Locked" cell property, because Uniform Invoice Software now set the "Locked" property automatically whenever you exit design mode.
  • The default tax names are set to "State Tax" and "Local Tax".
  • Applied Excel "Organic" theme.

September 19, 2018

  • Updated the built-in document properties for sample-sales-template-fixed-items.xlsx.

November 8, 2018

  • As required by Invoice Manager for v7, this "Customer Statement" was renamed to "Aging" report.