Looking for spreadsheet invoicing templates for Microsoft Excel 2003, Excel 2007, Excel 2010 or Excel 2016? You've come to the right place. Our invoicing spreadsheet templates are free, and each of them comes with a PDF invoice that shows you what will the form like when it is used to generate your PDF invoices.
Most of our templates are provided ".xlsx" format, which is Microsoft Excel Open XML Format Spreadsheet file. The file format is supported by Excel 2007/2010/2013/2016, except Excel 2003. There also a few samples provided in ".xls" format, which is the format supported by Excel 2003 and all the later versions.
Unlike the ".xls" format, a spreadsheet file in ".xlsx" format cannot contains macros (VBA code). A special file format, ".xlam" (macro-enabled format), is also provided. We have some sample spreadsheets here on InvoicingTemplate.com to demonstrate how you can integrate your own macros with our invoicing software program.
Here are our templates closely related to Excel Invoice Templates Multiple Pages.
"Invoicing Layout with 4 Pages" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 97.
...(49) 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.
...(104) 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.
"3-Page Invoicing Format" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 97.
...(38) 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).
...(84) 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".
"Proforma (4th Sample)" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 96.
...(26) Once you have finished your design work for Proforma Invoice Template (4th Sample, Landscape Page Orientation), click the Design Mode button again to exit design mode.
...(40) After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.
...(48) 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 Bill Format" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 89.
...(38) 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).
...(232) 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.
"2-Page Invoice Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 86.
...(25) 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.
...(32) Uniform Invoice Software is able to handle this type of multiple-page invoices. This feature is even implemented since very early versions of Excel Invoice Manager (the former name of Uniform Invoice Software).
...(124) This invoice template is based on the default invoice template shipped with Uniform Invoice Software, which is our desktop invoice software which runs offline (without the requirement of an online Internet connection). This template includes 36 lines on the invoice body section, and is printable with 2 pages of standard 8.5 X 11 inch letter paper. This invoicing format is a "Sales Invoice Template", as it contains the "Shipping Address" section, it also added 3 custom fields on the bottom of the form to calculate labor hours and expense. The template shows only one tax on the bottom of the form - to change this tax option / layout, go to Uniform Invoice Software Settings window / Taxes tab and set your preferences easily.
"Excel Quotation Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 72.
...(38) This free quotation and estimation template in Microsoft Excel ".xlsx" format provides a sample of customizing the default invoice template shipped with Uniform Invoice Software. It implements a special / complex discounting model to meet practical business requirements.
...(48) 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.
...(23) "Unit Price" is a manually editable field. "Line Total" is also a calculated field, which looks like this (again, "_?" indicates line numbers):
"Payment Voucher Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 66.
...(213) InvoicingTemplate.com also offers the Uniform Invoice Software version of this Excel Payment Voucher Template / receipt template. The Uniform Invoice Software version is also free if you have Uniform Invoice Software installed, and it has exactly the same layout as the freeware edition of the Payment Voucher Template, but with many buttons on it, such as "Clear & New", "Save To DB", "Exact / Email", "Print". Uniform Invoice Software, as the name suggests, is our invoicing software that has the ability to make any invoicing templates available here on InvoicingTemplate.com a complete invoicing program that is able to manage customers, products, invoices and payments. For example, if you click the "Clear & New" button, the payment voucher form is cleared and is ready for you to enter a new payment voucher, with several fields filled with default data - for example, the current date is filled into the "Date" field. If you click "Save To DB", the current voucher is saved to backend database and a voucher# is generated automatically. If you click "Exact / Email", a standard Excel spreadsheet is created and the current voucher is copied to the newly created Excel spreadsheet file, which you can email to your client. You can also create a PDF voucher document using Microsoft Excel.
"General Quote Template for Excel" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 66.
...(27) 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.
...(88) Due to this difference, it is important to clearly identify the document type on the header - whether it is a quote or an estimate. It is also useful, at least in some business areas, to include an expiry date on the document, if your prices are subject to change on the time. In this sample, we added it as a custom field "ExpiryDate". This field is defined as "text (100)" in the backend Access database, and the corresponding cell is named "oknExpiryDate" on the top quote form.
"Job Estimate Template for Excel" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 65.
...(35) This job and work estimate template in Excel spreadsheet format is a design based on c4009 Service Proposal and Quote. With this blank sample template, we move in the "ESTIMATE#" cell and the "Item#" column.
...(45) On the top of the blank estimate form you see the service business name. Next to it is the highlighted "ESTIMATE#" and "ESTIMATE DATE" fields. These fields are essentially the "Invoice#" and "Invoice Date" cells that appear on most free invoice templates here on InvoicingTemplate.com.
...(119) 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.
"Donation Receipt Format for Excel" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 60.
...(43) According to IRS Publication 1771, Charitable Contributions Substantiation and Disclosure, charitable donations are tax-deductible for the donor and reportable by the nonprofit organization. A donation receipt must include specific information about the value of the donation and what the donor received in return.
...(61) 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.
"Labor Billing Format for Excel" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 49.
...(54) This labor billing format for Excel is in Microsoft Excel spreadsheet "xlsx" format. A PDF format is also generated using Excel, including the document for this template. If you have Uniform Invoice Software installed, the invoicing software app is able to create PDF invoice automatically and send to your clients with simple mouse clicks.
...(88) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Labor Invoice Template with your own image, follow the steps below:
"Multiple Tax Rates on One Invoice" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 47.
...(52) This template was originally published on office-kit.com as C5-016, and here on InvoicingTemplate.com there were already customized layouts created based on C5-016, such as c5034 Mixed Tax Rates (5 Columns), and c5035 Mixed Tax Rates in an Invoice (7 Columns). For more samples and formats related to taxing, visit tax invoice template.
...(62) While not as complex and expensive as Quickbooks, Uniform Invoice Software is able to handle invoices with mixed tax rates. This is a great sample that shows the advantages of Excel invoicing over Word invoicing, as you can use Excel formulas to search and calculate values on the form. With Microsoft Word, that could hardly be done without macro or VBA code.
...(18) The following description from office-kit.com still provides useful information for you to apply this template to your business.
"Drop-down List for Multiple Price Levels" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 46.
...(64) With c5009, you specify multiple prices (5, to be specific) for each product. On creating an invoice, all the prices all loaded from the underlying Microsoft Access database and shown on the invoice form (outside the printable section). Once you specify the price level for the current customer, we use an Excel formula to pick up the applied price for the invoice being created:
...(59) As you can see from the formula above, the proper price is chosen according to the value of "oknDiscountRate". The value of "oknDiscountRate" could be any value from 1 to 5. For example, if you enter "1" into "oknDiscountRate", then the value of "oknDiscountPriceA_1" is applied to "oknPrice_1". Then the value of "oknPrice_1" is used for calculating line totals.
"Appliance Repair Service Invoice Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 41.
...(43) This service bill template is suitable for appliance repair service, such as computer repair service. It could be an appliance repair invoicing software app if UIS is installed, or be a work order form by moving out the "Paid" and "Total Due" fields.
...(138) A common requirements in the appliance repair business is that you need some fields to record the identifier of the device / appliance. Like in the auto repair invoice design, there are fields for auto maker, auto color and auto model. In this form design, there two fields designed for this purpose, which are "Computer Model" and "Computer Serial#". If you want to modify these labels to more common words like "Appliance Model" and "Appliance Serial#", it is easy to do with the help from Uniform Invoice Software. You can simply switch to design mode by clicking the "Design Mode" button on Excel "Invoice" ribbon tab, and then type in your own text to replace the existing labels. In fact, your own business name (as a service provider), address and contact information are entered in the same way.
"Hotel Receipt Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 38.
...(121) A hotel or motel needs different invoice and receipt formats than a generic sales invoice template or generic service invoice template for purchasing goods and service. The blank receipt form provided here on InvoicingTemplate.com offers a sample hotel receipt that you could use to create your hotel bills in an easy way. Our templates are in Microsoft Excel format. All templates here are not protected with password, so that you can easily customize the layout without problems. You can also download a printable PDF version of the hotel invoice template here. If you are looking for a hotel invoice template in Word ".doc" format online, we recommend this Excel-format template instead, as Excel provides more features for calculations and data validations.
"Simple Format with Printable Background Image" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 28.
...(35) 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.
...(50) However this type of background images are not printable. If you go to Excel menu "File" and then choose "Print", Excel shows the print preview of the current invoice spreadsheet. However the background image set previously is not included. And for watermarks, Excel does not provide directly support for it.
"Gift Invoice" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 25.
...(48) This template design is based on the default template shipped with Uniform Invoice Software version 5. So it is a sales invoice template with 5 columns on the printable form and PDF gif invoices generated. For more business invoice template designs visit business invoice template here on InvoicingTemplate.com.
...(69) The next step is to assign formulas to the "Line total" column inside the printable section (Remember the "Line total" column inside the printable form is now for displaying purpose only, the actual line total values saved to database are identified by a serial of "oknLineTotal_?" names that were moved out of the printable section). For example, for the first "Line total" cell, the formula assigned looks like this:
"Simple Consulting Invoice Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 16.
...(34) As a consultant you need a beautiful invoicing template to bill your clients, yet the template should be simple and easy to use. Simple Consulting Invoice Template might be your choice for creating invoices.does not include the shipping address section on the printable invoicing form. If you need the shipping address fields, try
"Simple Sample - Separate City State ZIP" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 1.
...(33) The default invoice template stores "City, State and ZIP" in two separate fields. This customization sample of our simple invoice templates demonstrate how to store it in 3 separate fields using custom fields.
...(55) To make the text shown on the printed invoice matches exactly the specification - that is, the "City" name followed by a comma, the "State" name followed by a space, we'll put the editable "city", "state" and "zip" fields outside the printable invoicing form, and use an Excel formula to concatenate what the user entered.
"Book Store Invoice Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 1.
...(42) The invoice template is designed for book wholesaler, publisher or store. It calculates discounts on each product as they are entered on an invoice, by using Excel formulas. Besides wholesale, it also allows applying discounts to retail customers when you invoice them.
...(18) Discounts could vary by product. Some invoices may have products at 40% discounts, others at 50%, for example.
...(23) In order to implement the feature required with this invoicing format, the template uses 3 custom fields (custom columns) on the invoice body.
Invoice Template with 4 Pages
Sunday, May 8, 2016,
|Letter (8-1/2 in. x 11 in.)|
3-Page Invoice Template
Friday, May 6, 2016,
|Letter (8-1/2 in. x 11 in.)|
Proforma Invoice Template (4th Sample, Landscape Page Orientation)
Monday, December 9, 2013,
1/2 Page Invoice Template
Monday, February 29, 2016,
|Letter (8-1/2 in. x 11 in.)|
2-Page Invoice Template
Wednesday, March 2, 2016,
|Letter (8-1/2 in. x 11 in.)|
Excel Quotation Template
Friday, February 10, 2017,
Excel Payment Voucher Template
Thursday, May 29, 2014,
General Quote Template for Excel
Friday, August 19, 2016,
|Letter (8-1/2 in. x 11 in.)|
Job Estimate Template for Excel
Wednesday, August 17, 2016,
|Letter (8-1/2 in. x 11 in.)|
Donation Receipt Template for Excel
Monday, August 22, 2016,
Labor Invoicing Sample
Wednesday, May 11, 2016,
Multiple Tax Rates on One Invoice
Friday, March 17, 2017,
Drop-down List for Multiple Price Levels
Tuesday, April 4, 2017,
Appliance Repair Service Bill Template
Thursday, August 18, 2016,
Hotel Receipt Template
Monday, January 20, 2014,
Simple Template with Printable Watermark
Tuesday, June 28, 2016,
Friday, March 31, 2017,
Simple Consulting Invoice Template
Friday, November 14, 2014,
Simple Sample - Separate City State ZIP
Tuesday, July 26, 2016,
Book Store Invoice Template
Wednesday, March 15, 2017,
This template for Hong Kong service businesses is built for translation service, but you can easily adapt it for other service business too. The form includes 4 columns, including a user-defined date column for you to detail the date when the service was performed.
Uniform Invoice Software version 5.11 includes a new default / standard invoice template shipped with the installer program. This document explains the changes made to the template, and the default hotkeys defined by this new version.
It is said that a picture is worth a thousand words. Do you want to place a beautiful image on your service bills to impress your satisfied customers? It is actually easy to do with Microsoft Excel and Uniform Invoice Software (UIS). This invoice sample shows you how.
This service invoice template offers a basic and blank invoicing form that is able to do auto calculation of one-tax. It has two editable columns. The invoice detail section allows to fill up to 5 items.
Invoices are business documents, and they should be beautiful and professional like the other business documents. Beautiful Service Invoice Template with Hourly Rate is a sample invoice created based on c4025 (Hourly Service Billing Format) .