The printed version.
Sample Sales Invoice Template 2 (c2001)
This is how the template looks like when you open the freeware template in Microsoft Excel.
Sample Sales Invoice Template 2 - freeware edition
The following template was designed for Uniform Invoice Software version 3.
Sample Sales Invoice Template 2 - Uniform Invoice Software V3 edition
You are safe to download the resources. We've added our digital signatures to the files.
Without database file. How to download and use
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Sample Sales Invoice Template 2 is a free general purpose sales invoicing template that has 2 columns on the invoice body. The line total (titled "Amount") in this form is manually editable on the printable form.
Many templates here on InvoicingTemplate.com calculate the line total (sometimes titled "Amount") using Excel formulas based on Quantity and Price, or something like Hourly Rate and Hours. Allowing to manually edit the line total cells is necessary in certain situations where the amount is not calculable from some other figures.
This invoicing form is originally published in the member area on office-kit.com with the id number "c2-001". InvoicingTemplate.com tested it and found it to be fully compatible with the latest version of Uniform Invoice Software, and now it is available here on InvoicingTemplate.com in two editions - one free edition, and another edition that works with Uniform Invoice Software. A PDF version of the billing form is also available here.
For Excel gurus who like to know the details on how to create this general purpose sales invoicing sample from the default sales invoicing design: unprotect the Invoice worksheet, move out product#, quantity and unit price columns, and then remove the formula from the line total cells and unlock the line total cells.
The protection of the "Invoice" worksheet in Sample Sales Invoice Template 2 prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Sample Sales Invoice Template 2.
In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Sample Sales Invoice Template 2. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.
TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.
Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.
Once you have finished your design work for Sample Sales Invoice Template 2, click the Design Mode button again to exit design mode.
Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Sample Sales Invoice Template 2 before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Sample Sales Invoice Template 2 is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Sample Sales Invoice Template 2 that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.
To remove the formulas from the line total cells, first drag your mouse to select all the cells, and then hit DEL key on your keyboard.
Unlocking the line total fields is necessary in order to make the fields editable when the Invoice worksheet of the spreadsheet is protected.
The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Sample Sales Invoice Template 2, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the "Invoice" worksheet of Sample Sales Invoice Template 2. To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.
Tip: If you create a formula for a field or a cell be sure to lock it otherwise a warning mark appears on the cell. On the other hand, if you remove a formula from a locked cell in Sample Sales Invoice Template 2, unlock the cell to make sure it is editable when Sample Sales Invoice Template 2 is protected.
We usually call the default template shipped with Uniform Invoice Software a general invoicing template because the template includes both the "Ship To" and the "Bill To" section. This sample is even more general because the line totals are manually inputable.
Like other form designs here on InvoicingTemplate.com, Sample Sales Invoice Form 2 is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.
|Name||Sample Sales Invoice Template 2|
|Category||Sales Invoice Template|
|Release Date||Tuesday, December 17, 2013|
|Format (XLS or XLSX)||.xls|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||19.50|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|