Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
You are safe to download the resources. We've added our digital signatures to the files.
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.
This is another invoice format sample that contains multiple pages inside one template. To be specific, it contains 60 lines on 3 pages. This template uses exactly the same database as the previous sample, 2-Page Invoice Template (c5081).
The layout of this template, like the previous 2-page sample, basically keep the style of the default invoice template shipped with Uniform Invoice Software. However, there are 3 custom fields added to the bottom of the invoicing form, "Labor Hours" (cell name oknLaborQuantity, at $I$83), "labor hourly rate" (cell name oknLaborUnitPrice, at $J$83) and "Labor Total" (cell name oknLaborTotal, at $K$83). These 3 fields are custom fields added to the "Invoice Header" database table.
Custom fields (also called user-defined fields) are a powerful feature implemented by Uniform Invoice Software since many years ago - at that time, our desktop invoicing software is named Excel Invoice Manager. Custom fields could be added to all the main tables defined by Unifomr Invoice Software, including Customer, Product, Invoice Header and Invoice Body. And by using Excel formulas, you can easily create (define) the relationship between fields. For example in this template, the Labour Total value is calculated using the formula "=ROUND(J83*I83,2".
As you can see from 3-Page Invoice Template, one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.
Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.
When working with Uniform Invoice Software (UIS) version of 3-Page Invoice Template, how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template 3-Page Invoice Template and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.
Like other form designs here on InvoicingTemplate.com, 3-Page Invoicing Format is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Name||3-Page Invoice Template|
|Category||Sales Invoice Template|
|Release Date||Friday, May 6, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||15.75|
|Printable with Papaer Size / Orientation||Letter (8-1/2 in. x 11 in.) - Portrait|
|Default Margins (Points)|
This Excel Invoicing Template contains 84 lines on the invoice detail section and is printable on 4 pages of standard A4 paper. It also contains fields that are required on general sales invoices such as invoice#, invoice date, client details, shipping details, P.O.#, sales rep. name, payment term etc.
If you are running a pet food store or shop then this invoice template could be used for easy invoicing. The invoice format is printable on standard A5 paper size (148 mm X 210 mm, or 5.83 inch X 8.27 inch). A PDF version of the invoice template is also included and downloadable.
On our templates "City, State ZIP" are usually put into one single cell, like a U.S. style address line (There is an option for UK style postal code on a separate cell). This simple invoice template shows you how to extract and store separate city, state and zip.
This free sample invoice template in Excel format demonstrates how to add a remittance slip to the bottom of an existing invoicing template. The remittance slip / letter is printable with the invoice, so that the customer can be detached and sent along with the check.
The default product report does not include sales representative name. This simple tutorial on customization demonstrates how to add the sales rep name to the product report by using custom fields.
This parts & labor invoice template in Excel spreadsheet format divides the invoice detail section into two parts, one for labor where the calculation of line totals is based on hours and rate; the another section for parts and materials, where line total calculation are based on price and quantity.
This invoice template has 11 columns on the invoice detail section (invoice body) that allow you to itemize the sizes of clothes sold out. Clothing stores and manufacturers could use this template for creating professional invoices.
Adding a background image or watermark can be an attractive and appealing enhancement, especially for business documents like invoices. This Simple Invoice Template with Printable Background Watermark demonstrates how to accomplish this in Microsoft Excel.