Skip to main content
InvoicingTemplate.com 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)

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

Sample Sales Invoice Template: Using Line Number Instead of Item# - freeware edition

Sample Sales Invoice Template: Using Line Number Instead of Item# - freeware edition

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

Sample Sales Invoice Template: Using Line Number Instead of Item# - Uniform Invoice Software V3 edition

Sample Sales Invoice Template: Using Line Number Instead of Item# - Uniform Invoice Software V3 edition

Download

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

Without database file. How to download and use

73 KBDownload

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

333 KBDownload

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

2.81 MBDownload

Detail

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 InvoicingTemplate.com 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 office-kit.com 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.

InvoicingTemplate.com 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 InvoicingTemplate.com, 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 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5036
NameSample Sales Invoice Template: Using Line Number Instead of Item#
CategorySales Invoice Template
Release DateWednesday, December 18, 2013
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$N$40
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35