Skip to main content
UniformSoft.com main content
Sharing is caring

Introduction

You might notice that lots of invoice templates designed by us here at Uniform Software have a 'Product ID' or 'Item #' on the invoice body. Although it could have different names, the invoice column should always be the unique identifier of the product you sold or the service you performed, such as 'P100' or 'S020'. The benefit of this approach is that you and your client can reference the item clearly and quickly without any doubt. If you have our invoicing program - Invoice Manager for Excel installed, the 'Product ID' or 'Item #'' column allows you to retrieve item information (description, price, category etc.) from database, and it is also important when you need to generates various reports.

But in case you don't use 'Product ID' or 'Item #', it is possible to show a line number automatically when the description of the invoice line is populated.

The sample invoice template here differs from the other invoice templates available here on UniformSoft.com in that it does not use 'Product ID' or 'Item #'. Instead, if you fill in an item description on a line, it shows the line number of the current line; but if the description is not filled in, it shows nothing in the field. All this is implemented by using a simple Excel formula.

Screenshots

Tip: Enlarge an image by clicking on it.

Template with Line Number - printed document

This is how template with line number on invoice body will look like when you open it with Microsoft Excel.

Template with Line Number - Excel worksheet

The following Uniform Invoice Software version of Template with Line Number on Invoice Body should be used with Uniform Invoice Software installed.

Template with Line Number - Uniform Invoice Software edition

Download Template with Line Number on Invoice Body

Quick facts

  • Template#: cn-005

Download

Choose the format you like and download Template with Line Number on Invoice Body for free by clicking the corresponding "Download" button.

FormatDownload
The Excel template integrated with Uniform Invoice SoftwareDownload
Template with Line Number on Invoice Body (Template with Line Number) in PDF formatDownload
Template with Line Number on Invoice Body and database in a self-extracting zip packageDownload
Template with Line Number on Invoice Body, the Excel template (workbook) only (.xls or .xlsx)Download
The Excel template in zip packageDownload

Related Templates