Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Sample Sales Invoice Template: Fixed Items. Double-click the downloaded file to extract all files.
  2. Open the template "sample-sales-template-fixed-items.xls" or "sample-sales-template-fixed-items-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.

Sample Sales Invoice Template: Fixed Items

Sample Sales Invoice Template: Fixed Items (c5040)

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

Sample Sales Invoice Template: Fixed Items - freeware edition

Sample Sales Invoice Template: Fixed Items - freeware edition

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

Sample Sales Invoice Template: Fixed Items - Uniform Invoice Software V3 edition

Sample Sales Invoice Template: Fixed Items - Uniform Invoice Software V3 edition

Download Sample Sales Invoice Template: Fixed Items (c5040)

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.

340 KBDownload

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

2.81 MBDownload

Detail

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

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 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 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 office-kit.com, what we do is just enabled the "Locked" of the cells that you want to keep from invoice to invoice.

The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Sample Sales Invoice Template: Fixed Items, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the "Invoice" worksheet of Sample Sales Invoice Template: Fixed Items. To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

Tip: If you create a formula for a field or a cell be sure to lock it otherwise a warning mark appears on the cell. On the other hand, if you remove a formula from a locked cell in Sample Sales Invoice Template: Fixed Items, unlock the cell to make sure it is editable when Sample Sales Invoice Template: Fixed Items is protected.

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 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 Uniform Invoice Software. The sample invoice template has exactly the same format and layout as the default sales invoice template included in 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 InvoicingTemplate.com, 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 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5040
NameSample Sales Invoice Template: Fixed Items
CategorySales Invoice Template
Release DateSaturday, December 21, 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$E$1:$N$43
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00

Sample Templates