BoostExcel.com main content

Summary

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 Invoice Manager for Excel 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 Invoice Manager for Excel than with others like Quickbooks.

Here are our templates closely related to Multiple-page Excel Invoice Templates.

Invoice Template with 4 Pages
c5083
Invoicing Layout with 4 Pages

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.

Tutorial for Adding New Line to Template
c5124
Tutorial for Adding New Line to Invoice Form

This sample shows the detailed steps required when adding new lines to an existing template, by using the default invoice template shipped with Invoice Manager for Excel as the starting point.

Things to consider when adding new lines to a template

Professional Tax Invoice Template for Furniture
c8007
Professional Tax Billing Form for Furniture

The "Special Order" field is defined as a custom field. It is implemented as a drop-down list. The possible values are defined at $20:$21 ("Yes" or "No"). The "Pickup Old Items:" and "Instructions:" are all text fields that allows you to show additional notes on invoices.

3-Page Invoice Template
c5082
3-Page Invoicing Format

The layout of this template, like the previous 2-page sample, basically keep the style of the default invoice template shipped with Invoice Manager for Excel. 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.

Proforma Invoice Template (4th Sample, Landscape Page Orientation)
c7014
Proforma Invoice Template (4th Sample, Landscape Page Orientation)

Now adjust the column widths to make it suitable for landscape A4 paper. Remember our goal is to have more space for the description column, so we'll mainly increase the widths of the Excel raw columns that are part of the Description column on the proforma invoice form.

1/2 Page Invoice Template
c4066
1/2 Page Bill Format

Many times you have only 1 or 2 items to bill your clients. In these situations a whole page of paper seems a waste. Here is how we implement a 1/2 page invoicing template (half page invoicing format).

Billing Summary Template
c5122
Billing Statement Form

This billing summary in Excel spreadsheet format was originally designed for an office of information technology that provides radio communication services. The downloadable package includes two formats, one-page template and two-page template.

Two Receipts on One Sheet
c1012
Two House Rent Receipts on One Sheet

In this sample, we create the second copy by duplicate the image of the original receipt. As you can see from the steps described below, it is much easier than the procedure described in c4067.

Consultant Invoice with Travel and Hourly Expenses
cm022
Consultant Invoice with Mileage and Hourly Expenses

There are 4 templates included in the downloadable package, each designed for different page numbers (from one page to four pages). All templates connect to one same database cm022.mdb. For more samples on multiple-page invoices, visit multiple-page invoice template.

2-Page Invoice Template
c5081
2-Page Invoice Template

The default template has 12 lines on one page. This sample template shows you a customized invoice layout that has 36 lines on two pages.

Excel Quotation Template
c9008
Excel Quotation Format with Special Discounting Model

The formula for "Line Total" incorporates both the auto-calculated portion, and the manually fillable field ("oknLineTotalManual_?" fields, placed outside the printable area, which means it is manually editable on creating invoices / estimations, but will not be included on printable invoices).

Excel Payment Voucher Template
c5052
Payment Voucher Template

Excel Payment Voucher Template is a editable sample voucher template created from Payment Voucher Template (Golden Shop). It differs from the original voucher template in that this sample Excel voucher template is suitable for general business.

Work Invoice in Excel
c4125
Work Invoice in Excel

The columns are titled with "Hours" and "Hourly Rate". However we didn't change the underlying database field names. So in the underlying database, which could be either Microsoft Access or Microsoft SQL Server, the corresponding fields are still "Quantity" and "Unit Price". Nearly all invoice templates created for hours worked take the same approach. The purpose of this is to simplify database design. Likewise, the field titled with "Work Description" is in face the "Notes" field in the underlying database.

Commercial Invoice for Export in Excel
c7015
Commercial Invoice for Export in Excel

Whether you are an individual or a corporation, the commercial invoicing template helps you create professional and beautiful invoices with quick and easy. However if you are a corporation we highly recommend the Invoice Manager for Excel version. With Invoice Manager for Excel installed, the commercial invoicing form becomes a powerful invoicing system, with the ability to manager customers, products, invoices and payments.

Excel Retail Invoice Template
c5155
Retail Invoice

This Excel retail invoice template features all the fields required by a general sales invoice. In addition to that, it also has a Discount Rate field, one 8.735% Sales Tax and a "Tax Exempt" checkbox is also added to meet the requirements of retail sales.

General Quote Template for Excel
c2035
General Quote Format in Excel Spreadsheet Format

As an Excel spreadsheet template, we use Excel formulas to calculate subtotal, tax and total. For example, for the subtotal field, the Excel formula assigned to the subtotal field is "=SUM(oknLinetotal_1:oknLinetotal_22)". This is one of the big advantages of using Excel spreadsheet templates. While you can create beautiful and professional forms too using Microsoft Word, Publisher, PowerPoint or even Adobe Photoshop, it is much easier when you need to do some calculations. This ability, combined with custom fields (user-defined fields) supported by Invoice Manager for Excel, resulting extremely flexible form designs, as you can see from the samples online here on InvoicingTemplate.com. Or see the PDF quotation sample to find out what it will like when your customer receive the quotation created using UIS.

Building Construction Bill Format
c4130
Building Construction Bill Format

Like other templates here on InvoicingTemplate.com, this template for civil construction contractor is an Excel spreadsheet template. It works with Invoice Manager for Excel, but could be used standalone for billing construction projects. As an Excel workbook file, it do calculations automatically using Excel formula functions. Compared to construction invoice templates in Microsoft Word / Office or PDF format, this is one of big advantage of Excel ".xlsx" or ".xls" file formats.

Job Estimate Template for Excel
c4084
Job Estimate in Excel Format

For this reason, the "ESTIMATE#" support all the features assigned to the "Invoice#" cell by Invoice Manager for Excel. 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 Invoice Manager for Excel, 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.

Appliance Repair Service Bill Template
c5020
Appliance Repair Service Bill Template

This template was originally published on our company web site uniformsoft.com with the template# "c5-020". We now revisited it and fine tune the form layout it here on InvoicingTemplate.com, and released it with the corresponding template# "c5020", and with a new template title Appliance Repair Service Bill Template.

Hotel Receipt Template
c7005
Hotel Invoice Template

A hotel receipt is also called guest invoice, folios or bill format for hotels. Usually when a folio is opened the starting balance is zero. All transactions which increase (debit) or decrease (credit) the balance of the account are recorded on the folio. In Invoice Manager for Excel, when guest does the final settlement of the invoice should be returned to zero balance by any of the method of payment given by guest. The process of recording transactions on an Invoice or a receipt is called posting. A transaction is posted either debit or credit when it has been recorded on the proper folio in the proper location and a new balance is determined.