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.
Tip: Enlarge an image by clicking on it.
Choose the format you like and download Template with Line Number on Invoice Body for free by clicking the corresponding "Download" button.
|The Excel template integrated with Uniform Invoice Software||Download|
|Template with Line Number on Invoice Body (Template with Line Number) in PDF format||Download|
|Template with Line Number on Invoice Body and database in a self-extracting zip package||Download|
|Template with Line Number on Invoice Body, the Excel template (workbook) only (.xls or .xlsx)||Download|
|The Excel template in zip package||Download|
The most interesting part of this invoice template is that how the template translate address the Holland format - the template allows you to enter the client address information (both the 'Bill To' and 'Ship To' addresses) in 'City (State) ZIP' format, and then transform it into 'ZIP CODE space City' format, for example '567 AA Amsterdam'. The transformation is done automatically with Excel formula. Another point to notice about this invoice template is that the invoice body has 6 columns - since this invoice template is designed for clothing-related business, a 'Size' (Maat) column is necessary - and usually important enough to list it as a dedicated column.
The sample invoice template has 6 columns, i.e. 'Product ID', 'Description', 'Tax Rate', 'Unit Price', 'Quantity', 'Line Total'. The 'Tax Category' and 'Tax Amount' columns are outside the print area. With the 'Tax Category' column you can choose the tax category for the current invoicing item from a dropdown list. It is this category that determines the tax rate that will be applied.
There are two columns on the invoice body within the print area. The 'Description' column is where you enter the hosting plan the client purchased. The 'Amount' column within the print area is for display purpose only - If the current billing item is not free, this 'Amount' column display the amount as usual, and if he current billing item is free, the column value will the Word 'Free'. You enter the actual 'Amount' value outside the print area, which is located near the right-side of the print area. The invoice template has only 6 lines, but added a payment slip to the bottom of the form. It is now added to InvoicingTemplates.comhere.
This is the default invoice form layout shipped with the installer program of our popular Invoice Manager program. It is suitable for many business types, as it offers both "Bill To" and "Ship To" fields, and the invoice body section allows you to details both the service provided and the goods supplied. Now this template is also featured as a free invoice template on InvoicingTemplates.com.
It's easy to make adjustment to the invoice format we provide to create your own invoice form by dragging and dropping cells in Excel. To do this, firstly drag your mouse to select the cell or cells you want to move, and then push your mouse on the border of the selected area and drag it to its new location you like. Excel also provides many tools you can use to format the invoice form, simply right-click the cell / cells you want to format, choose Format Cells from the menu - and, on the Format Cells dialog box, you may find a number of options for formatting the cell, including number format, fonts, borders, patterns, etc.
This is another sample of how to modify an existing invoicing template (in this case, a VAT invoice template with 2 VAT rates) to create a new one. The original free invoice template places the 'VAT Rate' and 'VAT Amount' columns outside the print area. While the original form design leaves more spaces for writing item descriptions etc., by moving the VAT Rate and VAT Amount columns into the print area you give your customers / clients more clear figures on how everything is calculated.