Skip to main content
InvoicingTemplate.com main content

Summary

Download our 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 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 Template.

Blank Service Invoice Template with Auspicious Clouds Borderc3020

Blank Service Bill Format with Auspicious Clouds Border

"Blank Service Bill Format with Auspicious Clouds Border" was found to be relative to Blank Invoice Template with the score grade of 98.

...(49) This blank invoice template adopted Chinese auspicious clouds borders to beautify the bill form. The borders does not show when you are creating or editing an invoice, but it is printable with the billing form, and will also be included in the PDF blank service invoice generated with UIS.

...(38) 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 Travelerc5091

Hotel Bill Layout with Satisfied Business Traveler

"Hotel Bill Layout with Satisfied Business Traveler" was found to be relative to Blank Invoice Template with the score grade of 97.

...(83) On the bottom of the form, besides the usual "Subtotal", "Tax" and "Total" fields, it also adds space for "Cashier's Signature" (this is for printing purpose only - not a field saved to database), and "Guest's Signature", with a declaration like "I agree that my liability for this bill is not waived and agree to be held personally liable in the event that the indicated person, company or association fails to pay for any part or the full amount of the these charges".

...(28) 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 Borderc3019

Blank Service Invoice Template with Image Border

"Blank Service Bill Format with Image Border" was found to be relative to Blank Invoice Template with the score grade of 97.

...(71) As long as you create your new invoice template by following the rules detailed in the creating new invoice templates document, your own design of invoice template will work with Uniform Invoice Software without problems. This enables you to have your professional and private invoice and bill designs for your business, even if you are running a small business and not ready for those expensive and complex invoicing programs available online.

...(52) This blank invoicing format also has the number of taxes set to one. To change the taxing configurations, click the "Settings" button on the "Invoice" worksheet, and then go to the "Taxes" tab. You can set your tax names, such as "VAT", "PST" or "GST" etc., as well the corresponding tax rates.

Blank Service Invoicing Templatec3008

Blank Service Billing Form

"Blank Service Billing Form" was found to be relative to Blank Invoice Template with the score grade of 91.

...(97) While the free version of Blank Service Invoicing Template is simple, the result created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service bill creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Blank Service Invoicing Template work for you.

Blank Service Invoice with Green Gradient Designc2031

Blank Service Invoice with Green Gradient Design

"Blank Service Invoice with Green Gradient Design" was found to be relative to Blank Invoice Template with the score grade of 83.

...(103) If you want to modify the tax formula to ignore the "Taxable" options, in design mode click to select the tax cell (which is named "oknTax1"). Excel formula bar shows the current tax formula, like "=ROUND( IF ( oknTaxType=0, 0 , oknTax1Rate * ( oknLineTotalTaxable + IF( oknTaxTotalIncludingShippingCost = 0 , 0 , oknShippingCost ) ) ) , 2 )". To have it ignore the taxable options, simply replace "oknLineTotalTaxable" with "oknSubtotal", so that the formula looks like "=ROUND( IF ( oknTaxType=0, 0 , oknTax1Rate * ( oknSubtotal + IF( oknTaxTotalIncludingShippingCost = 0 , 0 , oknShippingCost ) ) ) , 2 )".

Blank Service Invoice with Logo Picture Illustrationc3014

Blank Service Invoice Layout with Logo Picture Illustration

"Blank Service Invoice with Logo Picture Illustration" was found to be relative to Blank Invoice Template with the score grade of 83.

...(76) Before doing any layout customizations to the blank service invoice template, make sure you have backed it up. This ensure you have a working copy if something goes wrong during the customizations. Although we are providing all the Excel invoice templates and PDF invoice templates for free on InvoicingTemplate.com, it is a good practice to back up the template before modifying it. To make a backup, simply copy the invoice template workbook file in Windows Explorer.

  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.

Bill Format for Computer Repair Servicec5096

Invoicing Template for Computer Repair Service

"Bill Format for Computer Repair Service" was found to be relative to Blank Invoice Template with the score grade of 73.

...(43) This free bill format for computer repair service is an Excel spreadsheet template in ".xlsx" format. You can also download the free PDF sample invoice. Use this template to create service invoice for repairing PC, tablet, mobile phone and other computer related devices.

...(50) Note that Uniform Invoice Software now supports PayPal payment buttons on PDF invoices too. To add a PayPal payment button to the invoice form, simply click the "Add / Update PayPal button" command on the "Invoice" ribbon tab, and then follow the wizard to add and customize the PayPal button.

Invoice Design for Personal Trainer or Fitness Instructorc4082

Billing Format for Personal Trainer or Fitness Instructor

"Billing Format for Personal Trainer or Fitness Instructor" was found to be relative to Blank Invoice Template with the score grade of 70.

...(41) This free invoicing template designed for personal trainer or fitness instructor includes 4 columns, much like a general hours and rate based template. It differs from other form designs in that it includes a personal trainer woman picture as the background.

...(36) Most form design samples here on InvoicingTemplate.com include a logo image. This template fits into that category too. However unlike those samples, this invoice design for personal trainer or fitness instructor uses a Word Art logo.

...(38) Although we titled this template with "personal", it is in fact could be used by other business forms too, for example if you are running your training business as a limited company, you can use this template too.

Blank Commercial Invoice Templatec7004

Blank Commercial Invoice Template

"Blank Commercial Billing Form" was found to be relative to Blank Invoice Template with the score grade of 66.

...(77) The form offers an easy way to quickly complete a commercial invoice and print it directly from Microsoft Excel. All the essential information required by a commercial invoice is provided including invoice no, date, shipper/ exporter, consignee, booking #, term of payment, delivery conditions, port of lading, final destination, exporting carrier, currency of sale, total gross weight, cubic meters as well as other costs information such as packing cost, freight cost, insurance cost and duties and taxes.

...(12) This Blank Commercial Invoice Template formats prices with US dollars currency symbols.

Blank Cash Receiptc2011

Blank Cash Receipt

"Blank Cash Receipt" was found to be relative to Blank Invoice Template with the score grade of 55.

...(100) While a simple pure Excel spreadsheet template produces beautiful receipt like this sample shows you, for a business or seller, cash receipt is a record of individual transaction to keep track of all transactions made in a day or particular period of time and a buyer can save it as evidence of payment made in exchange of goods. Uniform Invoice Software helps in this situation by saving all data into a backend database, and it is also able to create sales report, product (item) report and payment report etc. So that you can easily know how your business is running.

Basic Blank Service Format (No-tax)c2012

Basic Blank Service Layout (No-tax)

"Basic Blank Service Layout (No-tax)" was found to be relative to Blank Invoice Template with the score grade of 50.

...(87) While some businesses prefer customized, no-standard invoicing forms, others find it is much simpler to use a basic invoicing layout, such as the layout implemented by this template - Basic Blank Service Format (No-tax) or Basic Blank Service Layout (No-tax). As a general purpose invoicing template, it does not include fields that are specific to certain businesses, and thus it is suitable for many service business types, like consulting agencies, solicitors and law firms, designers, cleaning service providers, freelancing agencies, accountants and other organizations in similar field.

Basic Blank Service Invoice Format (One-tax)c2013

Basic Blank Service Invoice Layout (One-tax)

"Basic Blank Service Invoice Layout (One-tax)" was found to be relative to Blank Invoice Template with the score grade of 47.

...(46) This configuration procedure isn't so basic and simple for someone who are not so familiar with Excel and Uniform Invoice Software templates. To get the job even easier, we build this template "c2013 Basic Blank Service Invoice Format (One-tax)" or Basic Blank Service Invoice Layout (One-tax).

...(97) Like all the other templates available here on InvoicingTemplate.com, "c2013 Basic Blank Service Invoice Format (One-tax)" could be used standalone without Uniform Invoice Software. But if Uniform Invoice Software is installed, it not only turns the simple Excel billing template into a powerful invoicing system, but also helpful commands like "Design Mode" (which unprotect the sheet and push the "design mode" button on the "Developer" ribbon tab). The trial version of Uniform Invoice Software is fully functional within the trial period, which you can download free of charge. So why don't download and give it a try?

Basic Blank Service Invoice Format (Two-taxes)c2014

Basic Blank Service Invoice Style (Two-taxes)

"Basic Blank Service Invoice Format (Two-taxes)" was found to be relative to Blank Invoice Template with the score grade of 43.

...(149) Depending on your local laws, and sometimes it even is depending on where your customer resides, you may charge no tax, one tax or two taxes. Setting up tax options would not be a problem if Uniform Invoice Software is already installed on your computer, as you could simply go to the Settings window and then Taxes tab to set the configurations. However if it is not, you have to unprotect the spreadsheet manually and set the tax rules manually. To simplify this procedure for those users, this template, "Basic Blank Service Invoice Format (Two-taxes)", "Basic Blank Service Invoice Format (Two-taxes)", is added here as a free downloadable template on InvoicingTemplate.com. If you have to charge two taxes, the only thing left for you to customize is entering your own company name and replacing the default logo image. To do this, you first need to unprotect the Excel spreadsheet.

Basic Blank Service Billing Format (No-tax, Long Description)c2015

Basic Blank Service Billing Layout (No-tax, Long Description)

"Basic Blank Service Billing Format (No-tax, Long Description)" was found to be relative to Blank Invoice Template with the score grade of 39.

...(162) The template offers a blank form for you to fill in. Fixed content, like your own business name, address, contact etc., are locked so that you'll not overwrite them accidentally. Fillable content, like the invoice#, invoice date, customer information, service items, etc., are unlocked so that they are editable even when the form is protected. Without Uniform Invoice Software installed, you should fill in all information by hand. With the help of Uniform Invoice Software, filling an invoice is much simpler. You'll typically start by clicking the Clear & New command, which clears the invoice form so that it is ready for you to create a new invoice. After executing the "Clear & New" command, most editable fields are blank, but some of them are filled with default values. For example, the Invoice Date will be the current date, and the Sales Rep. Name, Shipping Date, Payment Term etc., are all filled with default value (if they appear on the invoice form).

Basic Blank Service Invoicing Format (One-tax, Long Description)c2016

Basic Blank Service Invoicing Layout (One-tax, Long Description)

"Basic Blank Service Invoicing Format (One-tax, Long Description)" was found to be relative to Blank Invoice Template with the score grade of 28.

...(36) 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.

...(31) Fourth, drag the border of each row headings to increase the row height. To make sure each row has exactly the same height, right-click a row heading and choose "Row Height".

...(39) Fifth, set the "Wrap text" property. Drag your mouse to select all the "Description" cells. Right-click one of the selected cell and choose "Properties". On the "Properties" dialog box, choose "Alignment" tab, and then check the "Wrap text" option.

Basic Blank Service Bill Format (Two-taxes, Long Description)c2017

Basic Blank Service Bill Layout (Two-taxes, Long Description)

"Basic Blank Service Bill Layout (Two-taxes, Long Description)" was found to be relative to Blank Invoice Template with the score grade of 27.

...(166) Uniform Invoice Software is our popular invoicing software app that leverages the power of both Microsoft Excel and a back end database (could be in either Microsoft Access or SQL Server format), and by combines the power of the two mature technologies it creates a flexible and complete invoicing system. By installing Uniform Invoice Software, you'll be able to create invoices and email directly to your customers (in Microsoft Excel spreadsheet format, in Adobe PDF format, or in Image / PNG format), at a glance see which customers are overdue for payment, record full and partial payments, provide credit notes or issue refunds, record payments received and create products and manage inventory. All this could be done from your Excel formatted invoicing template. You don't need expensive accounting software applications for invoicing. One of the advantages of a template is that it is very easy to use. A free and budget-friendly template could produce amazing result too, as what you could see from the screenshots shown.

Blank Sales Format (No-tax)c2018

Blank Sales Format (No-tax)

"Blank Sales Format (No-tax)" was found to be relative to Blank Invoice Template with the score grade of 19.

...(152) Since our templates are in Microsoft Excel spreadsheet format (most of them are xlsx format). It is easy to do calculation using Excel formulas. This is one of the big advantages of Excel formatted template. If you try to design an invoice template in Word format, doing calculations will not as easy as it is in Excel. If you prefer OpenOffice.org, another popular office / productive system, they also have a number of sales invoice template sample. For example, with this sample template - Blank Sales Format (No-tax), we use Excel formulas for calculating subtotal and total. Note that with the default implementation, the "Payments" and "Balance Due" fields are put inside the Print_Area - the area that will be printed when you click the Print command in Uniform Invoice Software, or click Excel's own Print command. By utilizing the Print_Area name, we make this template more printer-friendly - and more printable.

Blank Sales Invoice Format (One-tax)c2019

Blank Sales Invoice Sample (One-tax)

"Blank Sales Invoice Sample (One-tax)" was found to be relative to Blank Invoice Template with the score grade of 18.

...(31) With this sample template, the "Ship To" fields are moved back into the printable invoicing form. The default "Ship To" fields includes Name, Address, City State and ZIP, Country and Contact.

...(143) The printable area, or print area, is the area with white background on the center of the Blank Sales Invoice Format (One-tax) spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Blank Sales Invoice Format (One-tax), only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Blank Sales Invoice Format (One-tax), select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Blank Sales Invoice Layout (Two-tax)c2020

Blank Sales Invoice Layout (Two-tax)

"Blank Sales Invoice Layout (Two-tax)" was found to be relative to Blank Invoice Template with the score grade of 6.

...(23) The default sales invoice template shipped with Uniform Invoice Software also has two taxes set by default, which are named GST and PST.

...(163) If you use the Uniform Invoice Software version of Blank Sales Invoice Layout (Two-tax), there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Blank Sales Billing Format (No-tax, Long Description)c2021

Blank Sales Billing Sample (No-tax, Long Description)

"Blank Sales Billing Format (No-tax, Long Description)" was found to be relative to Blank Invoice Template with the score grade of 1.

...(33) This is the fourth template in our blank sales invoice template serial. With this customized format we reduce the lines on the invoice body so that each line accepts a longer product description.

...(126) By default, Microsoft Excel shows all content of a cell on a single line. This is true no matter what the data type it holds - be it text, date or numeric value. To change this default behavior, simply enable the "Wrap Text" option. To do this, first you have to unprotect the sheet, and then drag your mouse to select all the cells for which you want to set the option for, and then right-click one of the selected cells, choose Properties from the shortcut menu. This shows the Format Cells dialog box. Go to the "Alignment" tab, on the Text Control section, you will see the "Wrap Text" option. Check it, and then click "OK". This way, Excel will wrap text automatically when necessary.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c3020
Blank Service Invoice Template with Auspicious Clouds Border
Tuesday, December 5, 2017,
8
3
A4
Portrait
Service
c5091
Hotel Guest Folios with Satisfied Business Traveler
Thursday, July 28, 2016,
7
5
A4
Portrait
Receipt
c3019
Blank Service Invoice Template with Image Border
Monday, November 21, 2016,
8
3
A4
Portrait
Service
c3008
Blank Service Invoicing Template
Sunday, October 5, 2014,
12
3
A4
Portrait
Service
c2031
Blank Service Invoice with Green Gradient Design
Thursday, June 30, 2016,
6
2
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c3014
Blank Service Invoice with Logo Picture Illustration
Thursday, July 14, 2016,
12
3
A4
Portrait
Service
c5096
Bill Format for Computer Repair Service
Tuesday, October 18, 2016,
12
5
A4
Portrait
Service
c4082
Invoice Design for Personal Trainer or Fitness Instructor
Saturday, July 30, 2016,
8
4
A4
Portrait
Service
c7004
Blank Commercial Invoice Template
Wednesday, May 21, 2014,
12
7
Letter (8-1/2 in. x 11 in.)
Landscape
Pro-forma
c2011
Blank Cash Receipt
Saturday, September 12, 2015,
25
2
A4
Portrait
Receipt
c2012
Basic Blank Service Format (No-tax)
Sunday, November 15, 2015,
12
2
A4
Portrait
Service
c2013
Basic Blank Service Invoice Format (One-tax)
Monday, November 16, 2015,
12
2
A4
Portrait
Service
c2014
Basic Blank Service Invoice Format (Two-taxes)
Tuesday, November 17, 2015,
12
2
A4
Portrait
Service
c2015
Basic Blank Service Billing Format (No-tax, Long Description)
Wednesday, November 18, 2015,
5
2
A4
Portrait
Service
c2016
Basic Blank Service Invoicing Format (One-tax, Long Description)
Thursday, November 19, 2015,
5
2
A4
Portrait
Service
c2017
Basic Blank Service Bill Format (Two-taxes, Long Description)
Friday, November 20, 2015,
5
2
A4
Portrait
Service
c2018
Blank Sales Format (No-tax)
Friday, November 20, 2015,
12
2
A4
Portrait
Sales
c2019
Blank Sales Invoice Format (One-tax)
Saturday, November 21, 2015,
12
2
A4
Portrait
Sales
c2020
Blank Sales Invoice Layout (Two-tax)
Sunday, November 22, 2015,
12
2
A4
Portrait
Sales
c2021
Blank Sales Billing Format (No-tax, Long Description)
Monday, November 23, 2015,
6
2
A4
Portrait
Sales

What Is Hot

Feature Galleries