Here you can find invoice templates with 4 pages, 3 pages, 2 pages, 1 page and 1/2 page (half-page). All these templates could be downloaded for free.
You can use any template standalone for creating invoice, or by installing Uniform Invoice Software you can upgrade the simple Excel template to a powerful invoicing system, which allows you to easily create bills and invoices. With our intuitive Excel forms you will find out something could be done much easier with Uniform Invoice Software than with others like Quickbooks.
Here are our templates closely related to Multiple-page Excel Invoice Templates.
The template also contains a "Tax" column on the detail section, implemented as a serial of checkboxes. Each checkbox controls whether the current line is taxable (that is, whether the amount of the current line is added to the taxable amount). If a taxable box is checked, the amount of current line is added to the taxable amount and thus the template should calculate tax for it. If all your products / items are taxable, and you don't want to show the "Taxable" checkboxes on the invoice body, you can remove all the taxable option boxes from the template by following the steps below.
This step by step tutorial is based on Windows 10 and Excel 2016.
Since we add only one new line to the template, it is still printable one a single A4 or letter paper. In practical situations you may want to add several lines. In this case, you may need to click Excel menu "File" and then "Print" to verify how many pages needed to print the form.
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.
Note that our goal is to not only create an invoice design that is printable on half paper size, but also make sure it work with Uniform Invoice Software, which is our invoicing software system for Windows desktop PCs running Windows XP, Windows Vista, Windows 7, Windows 8 and Windows 10 (Microsoft Office or Excel 2003, Excel 2007, Excel 2010, Excel 2013 or Excel 2016 is also required). Uniform Invoicing Software is an offline desktop invoicing app that does not require an Internet connection to run. By installing Uniform Invoice Software, a simple and pure Excel spreadsheet invoicing template becomes a complete invoicing management system. Uniform Invoice Software is implemented as an Excel COM add-in program, which means we don't use Excel macros to implement those advance features like connection with Access database. So, you don't have to change the security settings of your Office / Excel program in order to run Uniform Invoice Software, and all our templates here on InvoicingTemplate.com are not protected with passwords, which enable you to modify and customize the template to make sure it meets your business requirements exactly. Simply put, with Uniform Invoice Software, no matter you are a sole trader, home business, small business, limited company (ltd), you can generate professional and beautiful invoices and receipts without having to deal with complex accounting and billing systems that are usually expensive and hard to use.
The 2-page billing summary template has 55 lines on the detail section; whereas the 1-page billing summary format offers only 19 lines. The 1-page template was created by simply hiding the line 20 to line 56 of the 2-page template. Both templates connect to the same Microsoft Access database "c5122.mdb". For more samples on multiple-page templates, click here.
The "MILEAGE EXPENSE" column is a calculated field. Even the column heading is calculated using the Excel formula:
Under the "TIME (p/hour or day)" heading there are two columns, the first allows you to enter a numeric value, and the second is implemented as a drop-down list with options "DAY" and "HOUR".
All templates here on InvoicingTemplate.com are created from the default template shipped with Uniform Invoice Software setup program. While the format and layout look very different between the templates, most of them are printable on a single page (or even 1/2 page, also see 5.5 X 8.5 - 2 Invoices On One Template). However some businesses requires more lines on each invoice, for example a store or limited company selling auto parts.
The discounting calculations in this template is built specially for a real business. It may not be suitable for you, but it is a good sample on how to customize the invoice template shipped with Uniform Invoice Software. For more samples on quotations and estimations, visit Estimate Templates.
The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:
The word art feature is an interesting and useful feature available in Microsoft Office programs such as Word, Excel and Power Point. The basic usage of word art is described at Insert WordArt document on Microsoft's web site. With word art, you can create fancy text effects with just a few mouse clicks. Programs like Adobe Photoshop is able to create beautiful arts of word too, the advantages of using Office's built-in word art feature are obvious - it is simple, and the result is easily editable within Excel and Word itself.
Since the line totals are manually editable, i.e. not calculated from hours and rate or quantity and unit price, it is more like a general invoice template.
For this reason, the "ESTIMATE#" support all the features assigned to the "Invoice#" cell by Uniform Invoice Software. For example, if you click "Save To DB" or "Save Invoice", a sequential, progressive and unique estimate# is generated automatically if the "Estimate#" cell is left blank (see our gallery page at Excel Invoice Template Automatic Invoice Numbering). With pure-Excel spreadsheet solutions, this automatic numbering is not possible without using macros. To display / retrieve an existing estimate or quote, you can simply enter the estimate# into the cell. With the support from Uniform Invoice Software, the pure-Excel spreadsheet template is not only printable, but also enables features that could be hardly to implement with pure-Excel estimating and quoting software apps.
Secondly, the receipt should include the donor's name, this is necessary in order to be legally valid. Although not required, we've placed the "Phone#", "Mobile#" fields on the top of the section outside the printable area. In case you want to include these information on the PDF donation receipt or printed receipt, you can easily move them into the "Donor" section.
This Excel labor invoice template calculates line totals from hours and hourly rates. There are many other samples here on InvoicingTemplate.com that could be used for invoicing parts, labors and services. For example, Invoice Template Labor Excel Spreadsheet, Contract Labor Invoice Template and Excel Job Invoice Template collect the top 10 invoice templates in our database that are closely related to labor invoicing; for specific implementations, there are samples like Handyman Invoice Template, Engineering Service Invoice Template, Welding and Fabrication Service Invoice Template, Freelance Invoice Template, etc. Still not find your desired invoice template? We've developed a search box for you to find and download invoice template with template# or name.
The following description from office-kit.com still provides useful information for you to apply this template to your business.
By adding thefield to the database table, you don't have to reenter the tax type of the specified product each time it is picked on creating invoices, because the information is loaded automatically when you pick up the product. By adding the field to the database table, the tax type information is saved along with other product data, as well as customer data, when you click , so that you can easily restore a previously saved invoice at a later time.
As a small or home business, you may not like to pay too much on invoicing and accounting, but you know a professional bill could give your customer the impression that you are really care about your business. So our solution is to use a simple invoice template. Our Excel spreadsheet formatted templates here on InvoicingTempate.com are all free. And if you have many invoices, quotes or work orders to deal with, simply install Uniform Invoice Software.
While there are complex and expensive hotel management software programs available, which, generally, could also produce invoices and receipts for you, this free hotel invoice template and receipt template offers a budget-free way for creating professional invoices and receipts. The intuitive blank form of this template allows you to prepare and draft your invoices and receipts without a hard learning curve.
With Uniform Invoice Software installed, it is recommended to run the template in protected mode (by clicking Excel ribbon Review tab, and then click the "Protect Sheet" command, or go to the "Invoice" ribbon tab and make sure "Design Mode" is not enabled).
This template is suitable for travel business. It has the summary section moved to the top of the form, and also has several custom field for vehicle rental and travel, including "Vehicle Number", "Vehicle Type", "Discount", and two custom column on detail section, including "Date From" and "Date To". See c2029 travel invoice template and c5091 Hotel Guest Folios with Satisfied Business Traveler for other samples on tour and travel topic.