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

Summary

blank invoice

Download our amazing looking blank invoice templates and billing samples in Excel format (".xls" or ".xlsx") for free, which enable you to easily create invoices and bills as easy as filling in a paper form. No hard learning curve like dealing with some complex and expensive accounting / bookkeeping systems. All the templates are printable with either Excel or Invoice Manager for Excel (namely Uniform Invoice Software), or you can choose to generate PDF invoices and then send electronically with email.

The blank templates offer a what-you-see-is-what-you-get experience on creating invoices. The layouts mimic paper sheet forms. For example, if you want to fill in customer information, simply click one of the empty cells inside the "Bill To" section, and then start typing (or choose an existing customer by clicking the on-sheet picker button to bring up a list of all customers).

We choose to create the templates in Microsoft Excel spreadsheet format, instead of Word (".doc" or ".docx") format, for the reasons explained here.

The empty cells (fields) that you should fill in are identified by names. This enables you to move the cells (fields) around the form within the printable area without breaking the relationship defined by using Excel formulas. This means that, our blank invoicing forms are customizable by dragging and dropping. See this document for more details.

Here are our templates closely related to Blank Invoice Templates - 20 Results Found.

Blank Service Invoice Template with Auspicious Clouds Border

c3020
Blank Service Bill Format with Auspicious Clouds Border

This form design, c3020 Blank Service Invoice Template with Auspicious Clouds Border / Blank Service Bill Format with Auspicious Clouds Border has exactly the same layout and fields as c3019, but with a different color schema and border.

Hotel Guest Folios with Satisfied Business Traveler

c5091
Hotel Guest Folios with Satisfied Business Traveler

The blank bill template includes a logo image on the top form. To replace with your own image, click the "Replace Logo Image" button on the ribbon tab.

Blank Service Invoice Template with Image Border

c3019
Blank Service Bill Format with Image Border

This blank service invoice template is a redesigned version of c3008 Blank Service Invoicing Template. This customized version keeps most of the fields found in the original design, but have a complete new look and feel due the addition of the image borders.

Blank Service Invoicing Template

c3008
Blank Service Invoicing Template

The template has two taxes set on the bottom of the form, GST and PST. You can modify the tax names and rates easily by simply type in what meets your suitation once the spreadsheet is unprotected. If you need only one tax or need no tax, install UIS, and modify the taxing rules by several simple mouse clicks.

Sample Invoice Template

c4128
Sample Billing Form

When you click the "Clear & New" button on the "Invoice" worksheet, the entire "Invoice" was cleared, making it a blank invoice form. This makes it ready for you to create the Next invoice. Note that the "Invoice#" cell is not filled at this time. An invoice# is generated automatically when you click "Save To DB". See automatic numbering for more discussions and samples on this topic.

Simple Sales Invoice for Australia

c6037
Lightweight Blank Sales Invoice Sample for Australia

This is a free lightweight / simple blank sales invoice template for Australia. It includes fields for ABN#, as well as a discount column. It does not contains many colored blocks, and thus looks clean, simple and lightweight.

Sales Invoice Template for United States

c5138
Sales Invoice Form in Excel for United States

To express the theme of United States, a watermark image if added to the background of the sheet. The watermark is a PNG image with the opacity set to 10%. This makes sure the foreground text is visible and clear. Since you'll be creating invoices and bills, it is important to make sure the text is readable and never causing dispute.

Sales Invoice Form with Discount Amount

c5032
Sales Invoice Template - Discount Amount

This Sales Invoice Form with Discount Amount invoice template in Excel spreadsheet format, and as the name implies it is a sales invoice template that has shipping fields inside the printable area. To do this, we simply move the shipping fields back into the printable area, including Shipping Name, Shipping Address, Shipping City State Zip, Shipping Country and Shipping Contact. The controls, such as the text labels of the shipping fields, the "select a shipping address" icon button, the "Same As Bill To" button should also be move into the printable area. Moving an ActiveX control on an Excel spreadsheet is easy if you know the trick - before you can move a control, first switch to design mode. In design mode, even if you have Invoice Manager for Excel installed, it won't response to your click event. If you browse our invoice template gallery, you may see many of the invoice template samples are created by moving the fields in or out of the print area.

Commercial Invoice for Export in Excel

c7015
Commercial Invoice for Export in Excel

However before using the commercial invoice template to create your first commercial invoice, there are some one-time job you should do, that is to enter your own company information and replace the default logo image. Before you can do this type of customization, you have to firstly unprotect the invoice form, and then switch to design mode.

Five Price Percentage Levels (Sales)

c4014
Form with 5 Price Levels

This template uses the same database structure and field definition as the original version, but changes the meaning of the fields. The 5 prices field in the original database definition are decimal (15,6) which is enough for storing a percentage value. In this implementation offered by InvoicingTemplate.com, the first price custom field (Discount Price A) is used as the base price, and the other 4 prices (from Discount Price B to Discount Price E) are used to store discount percentage values. For example, in the sample database attached with this template, product "ABC-01" has 5 custom fields defined for prices, named from "Discount Price A" to "Discount Price E", and the values are 19.00, 0.11, 0.21, 0.31 and 0.41. If the discount level of a customer is 1 and he purchases the product "AB-01", the base price (19.00) will be applied; If the customer's discount level is 3, the discount will be 0.21 (i.e. 21%), the applied price will be 19 * (1-0.21) = 15.01. You can find more examples at standard invoice templates and blank invoice templates.

Five Price Levels (Service, Amount)

c4013
Form with 5 Price Levels

Once you moved the cells and controls out of the printable area, and done all the other formatting jobs, such as setting colors and background patterns, setting up borders, you need to restore the invoice template to its working state - that is to exit design mode and protect the sheet.

Five Price Levels (Sales, Amount)

c4012
Form with 5 Price Levels

With this customization applied, the "invoice form with 5 price levels (sales)" invoice template here on InvoicingTemplate.com allows you to define 5 prices for each product. When creating an invoice, Invoice Manager for Excel shows both base and discounted price per item on invoice form whenever you choose a product. For each customer, you can assign it a discount level, ranging from 1 to 5. When you pick up a customer, Invoice Manager for Excel will apply the correct price based on the discount level of the customer.

Form with Product Category

c5008
Template with Product Category

If you use the freeware edition of this invoice template, you may find there is no much difference between this invoice template and the default sales invoice template shipped with Invoice Manager for Excel. The only difference appears outside the printable area on the center of the form, where you can find a Product Category column near the invoice body. Visit the gallries at Simple Invoice Template and Blank Invoice Templates for more information.

Car Rental Invoice Sample

c7034
Car Rental Bill Form

This is a further-customized version of our rental invoice format c7001. It shows an image of tourisms on a limo. The images will show on the PDF car rental invoice too. It also adds a "Remark" field for you to fill in the driver's license in the United States or the international driving permit.

Home Inspection Invoice Sample

c1008
Home Inspection Bill Form

This home inspection invoice template includes a watermark of an image that shows a house, a paper of checklist and an inspector. The watermark is added to the top-center of the spreadsheet form, and is available on both the printed hard copy and PDF invoice sent via Email.

Building Maintenance Bill Format

c4117
Building Maintenance Invoice Sample

This form design does not distinguish materials and labor. If you need such a design where materials and labor are put into different sections on the sheet, visit our parts and labor invoice sample. For service-only formats visit our category page at service invoices. Our templates are itemized, which allow you to fill items line by line; but there are also non-itemized designs like c1001 Construction Proposal Template and c1005 Construction Contract Template with Watermark of Urban Buildings.

Blank Service Invoice with Green Gradient Design

c2031
Blank Service Invoice with Green Gradient Design

This template has two columns - "Description" and "Line Total", both are manually editable when the sheet is protected. A "Taxable" checkbox is also provided for each of the invoicing item, which allows you to control separately whether each item is taxable. If all your items are taxable (or not taxable), you may not need the "Taxable" options. If this is your situation, you can easily remove the "Taxable" options and then modify the tax formula to ignore this option.

Blank Service Invoice with Logo Picture Illustration

c3014
Blank Service Invoice Layout with Logo Picture Illustration
  1. Open the blank service invoice template in Microsoft Excel. In this sample, we use Excel 2013.
  2. Click the "Design Mode" on the "Invoice" ribbon tab.
  3. Click to select logo image. The formula bar shows something like "=EMBED("Forms.Image.1","")", in which the special formula "EMBED" indicates it is an embedded object.
  4. Hit DEL on keyboard to delete it.
  5. Go to Excel "Insert" ribbon tab.
  6. Click "Picture" to load an image, or click "Online Picture" to find and insert a picture from a variety of online resource. In this sample, we insert a PNG image from local computer that shows the text "InvoicingTemplate.com".
  7. With the newly inserted picture object selected, you'll find a ribbon tab "Picture Tools / Format" shows. There are a number of options / commands on this tab. For example, with the commands in the "Picture Styles" group, it is just one click to add various frames, shadows, rounded corners, rotated effect, relaxed perspective, bevel perspective, etc., to the picture.
  8. Click the "Design Mode" button again once you have done your customization, to exit design mode.
  9. Save the template.