This free sales invoice template is a variant of the general sales invoice template. With this invoice template we moved out the 'Quantity', 'Price' and 'Product ID' columns from the invoice body, so that there are only two columns, 'Description' and 'Amount', are left within the print area. Both columns are set to editable. Also, with this sales invoice template, the fields for shipping address were also moved out, assuming that the shipping address is the same as the 'Bill To' address.
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.
Tip: Enlarge an image by clicking on it.
Choose the format you like and download Sales Invoice (2 Columns, without Shipping) 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 Excel||Download|
|Sales Invoice (2 Columns, without Shipping) (Sales Invoice (2 Columns, without Shipping)) in PDF format||Download|
|Sales Invoice (2 Columns, without Shipping) and database in a self-extracting zip package||Download|
|Sales Invoice (2 Columns, without Shipping), the Excel template (workbook) only (.xls or .xlsx)||Download|
|The Excel template in zip package||Download|
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.
This free sample invoice template implements a feature that allows you to charge different tax rates based on the type of an invoicing item - for example, one tax rate for labor and another tax rate for general items (products). The type of an item can be selected from a dropdown list, the Excel formulas implemented in the template check the type, and apply correct tax rate to the current item. The template then calculates all the line totals, subtotal, tax total and grand total, all done in an automated way. You might think this type feature could be hard to find even in some complicated invoicing programs, but with Excel it is done without a line of programming code. This is another good example of how to fulfill your special business requirements by using Excel-based invoicing.
Since this is a service invoice, it does not use 'Ship To' fields. Instead, it offers a group of 'Site Address' and one additional 'Job Address' field to let you detail the address the service performed. The 'Code' column on the invoice body part allows you to use simplified and standardized code to identify the server or job that is being invoiced, for example 'S01' for small plumbing jobs, 'F01' for full heating systems, 'F02' for under floor heating, and 'N01' for new high efficiency boilers, etc. The 'Description' column should be filled with a detailed description of the current item. All the computable fields are listed on the invoice body, including Materials, Labor, Subtotal, VAT, Total Including VAT, Total, Paid, and Total Due.
On the top of the invoice the form shows your company information and the big word 'INVOICE'. Following it there is a customer section located on the left (usually titled with 'Bill To' in the templates available on Uniform Software - but this type of static text can be changed easily - you can simply type in your own labels to replace the existing one.) At the right hand there are fields for 'VAT REG #', 'Tax Date', 'Invoice Number', 'Purchase Order #', 'Payment Term' and 'Due Date'. On the invoice detail section there are 4 columns inside the print area, i.e. 'Description', 'Price', 'VAT' and 'TOTAL'. Since this invoice template is designed for service business, the 'Quantity' column is fixed to '1' and located outside the print area. Another feature of this invoice template is that it allows you to specify VAT Rate for each item (again, outside the print area). If your items are always at the same vat level, you can fill in the VAT Rate column and lock this column of values.
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.
This invoice template is designed for those who publishing newsletters. On the invoice form you can detail customer billing information, as well as newsletter delivery address. On the invoice body, for each newsletter that the customer subscribes, you can detail the start date (month) and end date (month). This invoice template has 6 lines on the invoice form, leaving space on the bottom of the form for you to briefly introduce the service you provide.