Skip to main content main content
sharing is caring! we do appreciate your time to let others know us!



Download our printable billing templates and invoice makers for free. Create invoices and bills by filling in blank forms, print out with single click of mouse.

If you use the UIS edition, there are advanced options you can use to improve the printing experience, in addition to all those provided by Excel.

It is fair to say that Microsoft Excel has extensive options for controlling the printed result of a spreadsheet - most of them could be found on the Page Setup dialog box, but with a UIS-enabled template, you have more that are applied to only invoicing forms - i.e. they will not affect your general worksheets.

All templates here are printable. The following are the top 10 we picked up for you to test how we control invoice printing experience in various ways.

Print Shop Bill Sample

Print Shop Bill Sample

This bill template for printing shop is set with no tax, but the tax cells and fields defined in the default template are still there.

Simple Template with Printable Watermark

Simple Template with Printable Watermark

There are still ways to create invoice template with printable background image or watermark. In this sample, we'll use c4074 Simple Invoice Format for Letterhead Paper here on as the starting point and basic invoice template for demonstration purpose.

Tax Invoice for Printing Shop

Tax Receipt for Print Shop

In fact this template is not only for a printing shop, it can be seen as a general service invoice template, because with the two columns, "Description" and "Amount", you can fill in any service you offer.

Invoice and Packing List on Separate Worksheet

Invoice and Packing Slip on Separate Worksheet

Packing list and invoice are closely related business documents, yet there are significant differences between the two, in both the recipients of the document, the contents each document show include. A packing list is designed to aid recipients of the shipment in confirming that all items that were supposed to be included in the shipment have actually arrived. While slip designs vary somewhat, most will include a description of each item included, as well as the quantity of each item shipped. On the other hand, an invoice goes to the person responsible for paying the bill. The invoice is the bill for purchasing from your company and the notice to the customer to pay you.

Auto Repair Invoice Template

Blank Vehicle Repair Invoice

July 12 2016: Please visit the revised version of this auto service invoice template at Auto Repair Service Invoice with Car Lift Background Image.

Service VAT Invoice Template

Service VAT Invoice Format

Service VAT Invoice Template is an Excel format VAT invoice template designed mainly for United Kingdom (UK) businesses, including fields designed for VAT such as VAT Registration No., a VAT column and a VAT Rate column.

Professional Tax Invoice Template for Furniture

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.

Commercial Invoice for Export in Excel

Commercial Invoice in Excel

Note: This free Commercial Invoicing Template was original published on our company site,, with the ID number c7011.

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.

Advanced Sample - Print One Invoice in Two Different Formats

Advanced Sample - Print One Invoice in Two Different Formats

The default "Print" button included many templates here on print the whole "Invoice" worksheet. This in fact prints the Excel range defined by the "Print_Area" name. There are many ways you can customize the print behavior, as shown on the samples at printable invoice templates.

Debit Note Template

Debit Note Form

This debit note template contains regular fields that are seen in the default sales invoice template shipped with Invoice Manager for Excel. In addition to that, it also contains two custom fields - Agent and Ref#, as well as a custom column UOM (Unit of Measure). Agent and Ref# are custom fields that are added to Invoice Header database table, and the UOM field is a custom field that is added to both the Product and Invoice Body database table.

Printable Receipt Template for Pet Boarding

Printable Receipt Template for Pet Boarding

For generic pet sitting service receipt, visit c5135 Pet Sitting Invoice Sample. The template c5135 was released on Sunday, January 21, 2018, at that time our Invoice Manager still didn't support showing image dynamically. Starting from version 7.11, a new Excel formula was introduced by Invoice Manager, which was "DisplayImage".

Five Price Levels (Sales, Amount)

Form with 5 Price Levels

The discount level number of a customer and the discounted prices of the selected invoicing items, although appear on the invoice form when you create an invoice, they will not be included in the printed hard copy of an invoice or the extracted invoice that you sent to your customer. This happens because all these fields are placed outside the printable area, which is the area that will get printed when you issue the "Print" command in Excel. You can find more examples at blank invoice templates and printable invoice templates.

Invoice with Previous Balance (Sales)

Invoice with Previous Balance (Sales)

Sometimes it's helpful and necessary to add past due balance to the current new invoice. Although this feature is not directly implemented in the default invoice template shipped with Invoice Manager for Excel installer program, it is easy to implement such a feature so that whenever you pick up a customer, the past balance is shown automatically on the currently invoice, and added to the total due. If you decide not to use Invoice Manager for Excel, the previous balance should be retrieved and added manually. See Past Due Invoice Template for another example. This template is also added to our printable invoice templates and basic invoice templates gallery.

Invoice with Previous Balance (Service)

Invoice with Previous Balance (Service)

Please also refer to the original version to find out implementation details about this invoice template, including how Invoice Manager for Excel maps database fields to Excel cells, and how to unlock a cell to make sure Invoice Manager for Excel can read/write a cell even when the spreadsheet is protected. You can also find another example at invoice template with past due. This template is also a member of printable invoice templates and basic invoice templates galleries.

Pet Sitting Invoice Sample

Pet Care Billing Format

We've already published several form designs that are specialized for pet services. For example, c3013 Pet Food Store Invoice Template and c4123 Dog Walking Invoice Template. This template differs from the previously published ones in that it is based on c5014 service invoice template with fixed items. For a template that shows pet photo on receipts, see Printable Receipt Template for Pet Boarding.

Printable House Rent Receipt Template

Printable House Rent Receipt Template

This free printable house rent receipt template is a customized version of c1002 House Rent Receipt Template. The new version has exactly the same number of fields on the sheet. A new printable background / watermark image was added to show the purpose of this sheet.

Grout Pump Service Work Order and Invoice

Grout Pump Service Work Order and Invoice

The taxing system of this invoice template targets Hawaii. The business has two taxes that should be applied to different jobs (commercial -vs- private), -- one is 4% the other is 4.712%. However, the boss sometimes doesn't charge tax on some of the jobs (Check Avalara for more information -- be sure to consult your local tax agency for authoritative tax rates applied to your business type).

Business Invoice for Netherlands

Business Invoice for Netherlands

Finally, in the "Bill To" and "Ship To" sections inside the printable form, the following formula is applied to show the "ZIP City" in the desired format:

Simple Sample - Default Value

Simple Sample - Editable Default Value

The first category includes the special fields, including "invoice date" and "invoice#". The "invoice date" is filled with the current date. "Invoice#" is blank; but if you click "Save To DB" and leave the "invoice#" blank, a new sequentially increasing invoice number is generated automatically based on the previous numbers.

Tutorial for Adding New Line to Template

Tutorial for Adding New Line to Invoice Form

In the following step by step tutorial, we'll add only one new line. So it does not involve the adjustment of page layout and printing. Please refer to printable invoice templates for more samples on this topic.