InvoicingTemplate.com main content

Screenshots and Images

The printed version.

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

Open the template in Excel.

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

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

494 KBDownload

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

5.78 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 Invoice Manager for Excel, 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, Invoice Manager for Excel 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 Invoice Manager for Excel.

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 Invoice Manager for Excel.

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

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).xlsx
Columns5
Lines12
Line Height (Points)16.50
Print Area$F$3:$N$41
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

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.

Samples

Screenshot for Sample Sales Invoice Template 2

Sample Sales 2

Screenshot for Sample Sales Invoice Template: Using Handwriting Signature

Using Handwriting Signature (Sales)

Screenshot for Invoice Template with Long Product Description

Long Product Description

Screenshot for Sales Invoice Template with Discount Percentage Column

Discount Percentage Column (Sales)

Screenshot for Sales Invoicing Template

Sales Invoicing Template

Screenshot for Subscription Invoice Template (Sales)

Subscription (Sales)

Screenshot for Mixed Tax Rates in an Invoice (7 Columns)

Mixed Tax Rates (7 Columns)

Screenshot for Mixed Tax Rates (5 Columns)

Mixed Tax Rates (5 Columns)

Screenshot for Invoice Template with 4 Columns

Basic 4-Column Layout

Screenshot for Sales Tax Invoice Format in Excel

Sales Tax Invoice Format in Excel

Screenshot for Invoice with Previous Balance (Sales)

Previous Balance (Sales)

Screenshot for Form with Product Category

Form with Product Category