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: Using Line Number Instead of Item#

Sample Sales Invoice Template: Using Line Number Instead of Item# (c5036)

c5036 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open sample-sales-line-number-uis.xlsx.

Sample Sales Invoice Template: Using Line Number Instead of Item# (UIS Edition)

Sample Sales Invoice Template: Using Line Number Instead of Item# - UIS 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.


Without database file. How to download and use

96 KBDownload

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

287 KBDownload

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

2.74 MBDownload


This sample invoice template shows automatically the line number of an item in the place of item# or product# on the invoice body. The sample demonstrates the flexibility of an Excel-formatted invoicing template.

Most invoice templates available here on have a Product # (or sometimes titled "Product ID" or "Item#") column on the invoice body. If you are using Uniform Invoice Software, our invoicing software and billing software that uses Excel invoice templates as it's front-end, the product# or item# is a required field that is used to uniquely identify a product or an item. With the product# or item# field, Uniform Invoice Software is able to save the description, unit price and all the other related information into database, so that you can retrieve these type of information by entering the product# or item#, without typing the same description, unit price etc. again and again. So in most cases if the product# or item# column is not required to display on the printable invoice form, we move it out of the printable form, instead of delete it. The product# field also helps in generating the product report in Uniform Invoice Software.

But there are situations where you don't need the product# or item# at all. In this Sample Sales Invoice Template: Using Line Number Instead of Item# we'll assign a line number to the product# field automatically using Excel formula. It is a good example on how the default sales invoice template could be customized in the way you like.

This sample invoice template was originally published as a customization sample on at Sample Invoice Template: Using Line# as Product IDs, where you can also find detailed steps on how to create the sample invoice template based on the default sales invoice template shipped with Uniform Invoice Software. categorizes this template as Sales Invoice Template, meaning it includes shipping fields on the form. A service template, where we moved out the shipping fields from the printable invoice form, is also available at Sample Service Invoice Template: Using Line Number Instead of Item#.

Like other form designs here on, Sales Template with line Number 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

NameSample Sales Invoice Template: Using Line Number Instead of Item#
CategorySales Invoice Template
Release DateWednesday, December 18, 2013
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Line Height (Points)16.50
Print Area$F$3:$N$41
Papaer Size / OrientationPortrait
Default Margins (Points)

Update History

January 30, 2018

  • Upgraded all buttons so that they are now hyperlink buttons, instead of the original macro buttons. This makes the template meets the requirements of Uniform Invoice Software version 5.26. Starting from this version, "Uniform Invoice Software Helper" add-in program is no longer required.