Skip to main content main content
Sharing is caring


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


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 version of Template with Line Number on Invoice Body should be used with Invoice Manager for Excel installed.

Template with Line Number - Invoice Manager for Excel edition

Download Template with Line Number on Invoice Body

Quick facts

  • Template#: cn-005


Choose the format you like and download Template with Line Number on Invoice Body for free by clicking the corresponding "Download" button. The zip packages include the simplified version for Invoice Manager (Lite).

The Excel template integrated with Invoice Manager for ExcelDownload
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