Skip to main content
InvoicingTemplate.com main content

Summary

Billing is the process of sending an invoice to customers for goods or services, so in many situations it is interchangeable with "invoicing". Electronic billing using a billing invoice template is the easiest way to create bills as there are no hard learning curve. All you need to do is to fill in blank forms just like using a blank paper form, and then you can print hard copy, or email the bills electronically in PDF or image formats.

Our free billing invoice templates are in Microsoft Excel ".xlsx", ".xls" and ".xlam" formats. Each template comes with a PDF invoice sample that show you what your billed clients will see when they receive your email.

There are also bill format in Word (".doc" or ".docx") that are available on the Internet. We choose Excel format because it is easier to do calculations in Excel using formulas (i.e. create / define the relationship between several data items). And, if you install our desktop invoicing software for Windows, each template becomes a complete and powerful invoicing system.

Here are our templates closely related to Billing Invoice Templates.

Bill Sample in Estonianc6026

Bill Format in Estonian

"Bill Format in Estonian" was found to be relative to Self Billing Invoice Template with the score grade of 97.

When you need to bill your clients in Estonia it is better to have your invoicing form translated to Estonian. As shown in this bill format sample, you can do this easily within Excel spreadsheet template by simply replacing existing text labels.

... "Text label", sometimes also called "static label", means those text that are not changed from invoice to invoice, such as the column headings on the detail section. Comparatively speaking, the content that changes from invoice to invoice is called "field", which has corresponding space in the backend database.

... To format a date cell with Estonian date format:

... The following table shows the English labels and their corresponding Estonian labels.

Contractor Billing Formatc3009

Contractor Invoicing Layout

"Contractor Billing Format" was found to be relative to Self Billing Invoice Template with the score grade of 89.

... This template has two taxes like the default template shipped with Uniform Invoice Software. However unlike the default template, where the two taxes applied to all taxable items added to the invoice detail section, Contractor Billing Format applies each tax to one section. In this implementation, "Tax 1" was applied to the "Service" section, and "Tax 2" was applied to the "Expense" section. All the tax-calculation formulas are modified according to this design requirement.

... While there are many invoicing software apps that are able to handle simple and regular invoicing forms, Uniform Invoice Software is designed with flexibility in mind. This, with the help of Microsoft Excel, especially its formulas that allows us to define the relationship between cells (for example, how one cell is calculated from the value of the other cells), makes it possible for Uniform Invoice Software to handle complex invoicing forms and layouts. You may be still invoicing in the traditional paper way because there is no invoicing software app is able to handle the complex formats you need. Uniform Invoice Software helps you turn to electronical invoicing with easy and quick.

Job Invoice Samplec5006

Job Billing Sample

"Job Invoice Sample" was found to be relative to Billing Invoice Templates with the score grade of 84.

... In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Job Invoice Sample. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

Commercial Invoicing Templatec7015

Commercial Billing Form

"Commercial Invoicing Template" was found to be relative to Billing Invoice Templates with the score grade of 81.

... In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Commercial Invoicing Template. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

Catering Invoice Templatec4045

Catering Invoice Template

"Catering Invoice Template" was found to be relative to Billing Invoice Templates with the score grade of 81.

... Catering service could be helpful in many cases. You may offer catering service for parties - showers (baby/bridal), weddings, birthdays, sports team dinners, block parties, or for meetings like ordering for office, ordering for clients, corporate parties, and school events. While you are committed to be the easy choice for irresistible food, and a remarkable experience across a variety of occasions: birthdays, soirees, graduation parties, tailgates and meetings... there is one more thing you need to consider - invoices are surely the details, but a beautiful and professional invoice gives your customer the experience that you are paying attention to the details, so it is true to your main business too. You ensure that customer's order is correct, ready to be picked up or delivered at the right temperature, at the right time - in other words, the hot food is hot, and the cold food is cold. Remember an eye-catching invoice could also be a good decoration to your service. There are many invoicing software apps you could choose from, and most of them are expensive. However there are budget-friendly choices too.

... However, if you don't have Uniform Invoice Software installed, you should go to design mode manually in order to replace the default logo image that has the text "InvoicingTemplate.com" on it.

Welder Invoicing Templatec7021

Welder Invoicing Template

"Welder Invoicing Template" was found to be relative to Billing Invoice Templates with the score grade of 81.

... If you use the Uniform Invoice Software version of Welder Invoicing Template, 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.

Notary Invoice Templatec3007

Notary Invoice Template

"Notary Billing Template" was found to be relative to Billing Invoice Templates with the score grade of 70.

... This invoice template provides 3 columns on the invoice form - Date, Description and Amount. The Amount here is a manually fillable field. A notary is a lawyer or person with legal training who is licensed by the government to perform acts in legal affairs, in particular witnessing signatures on documents. The form that the notarial profession takes varies with local legal systems. A notary public (or notary or public notary) of the common law is a public officer constituted by law to serve the public in non-contentious matters usually concerned with estates, deeds, powers-of-attorney, and foreign and international business. As a general rule, on the invoice that you write out for your client, line-item each charge and expense along with each fee for performing a notarial act. Clearly state what each charge, expense and notary fee is for and the amount that you are charging for each item. If your first contact with the client is by phone, provide the same information to him that you will write on the invoice to present to him in person and have him agree to the charges before you provide services as a notary. When you present your invoice to the client, you may wish to have him sign it to show that he agrees with the charges and understands the purpose of each line-itemed charge. Some Notaries provide services that, in addition to authorized notarial acts, include other non-notarial aspects of the job assignment. Or, a notary can incur expenses associated with performing a notarial act. When invoicing a client for notarial services, the notary would like to invoice for any other charges and expenses as well. ALWAYS discuss your fees with the client before you perform any service. It is unwise and could be seen as unethical for you to wait to tell your client about your fees until after your services are performed. Always give clients the chance, up front, to accept or decline your fees.

Musician Invoice Templatec2036

Musician Invoice Template

"Musician Invoice Template" was found to be relative to Billing Invoice Templates with the score grade of 65.

This invoice template designed for musician includes a stave background image. Besides the Excel spreadsheet template, a PDF billing format template for musician is also included. This sample is formatted with Australian currency but you can easily change it with Excel formatting tools.

... The formula assigned to the "Amount" field is like this:

Psychologist Invoice Templatec6024

Psychologist Invoice Template

"Psychologist Billing Format" was found to be relative to Self Billing Invoice Template with the score grade of 50.

... Except the "Current Balance" column, which is in fact the "Line total" column in the default invoice template shipped with Uniform Invoice Software, all the other columns are manually fillable when you create an invoice. The calculation of "Current Balance" is done by "Charge - Payments - Insurance Payments" using Excel formulas. As you can see, we completely redefined the calculation method of the "Current Balance" or "Line total" cells, without breaking or modifying Uniform Invoice Software, which is our invoicing software that processes tasks like saving invoices, auto-generation of invoice numbers, tracking customers etc. Even in complex accounting / invoicing systems on the market, this level of flexibility could hardly be found. Uniform Invoice Software archived this easily because it uses Excel spreadsheets as its front end.

Jewelry Receipt Templatec4102

Bill Format for Jewelry Shop

"Jewelry Receipt Template" was found to be relative to Self Billing Invoice Template with the score grade of 48.

... So when we need to design a new form layout for a specific industry application, we started from looking for a similar Excel template that are already published here on InvoicingTemplate.com. This is true to the bill format for jewelry store too. If you are familiar with Microsoft Excel, you can do the customizations too, by following the tips and guidelines given in the Creating and Designing an Invoicing Template document.

... The "ITEM#" column placed on the left-most column of the worksheet is functional if you have Uniform Invoice Software installed. On creating a receipt or invoice, you enter the Item# / SKU# / barcode# into this cell, the corresponding description and unit price is automatically retrieved from the backend database. This saves you time and prevent typo errors. This feature is called "in-cell lookup" in Uniform Invoice Software. You can turn this feature on or off on the "In-cell lookup" page of the "Settings" dialog box.

Standard Business Invoicing Template with Oval Buttonc5099

Standard Business Invoicing Format with Oval Button

"Standard Business Invoicing Template with Oval Button" was found to be relative to Self Billing Invoice Template with the score grade of 48.

... Both the buttons existing InvoicingTemplate.com templates, and those converted by UIS 5, are all traditional rectangle buttons. As mentioned before in this article, any shape objects could be used as a button if the shape object could have a macro assign to. In this sample, we change the "Save As New Customer", "View Customer Info." and "Same As Bill To" button to oval buttons. Although this is an advanced customization technique, you can do it yourself if you follow the steps carefully. In this tutorial, we'll use Microsoft Excel 2013.

... With this customized version of the standard business invoicing format, a new business image is also add to the top of the form. This is a background image, which is shown only on printed invoices and bills, or UIS-generated business invoices. This image shows a team of business people. The image / picture is adjusted to 35% opacity globally, and also has a gradient opacity from the top to bottom applied using Adobe Photoshop.

Simple Sample - Using Currency Symbolc4050

Simple Sample - Using Currency Symbol

"Simple Sample - Using Currency Symbol" was found to be relative to Self Billing Invoice Template with the score grade of 47.

... The default template and database file shipped with Uniform Invoice Software is currency-neutral. This means it assumes the template and database uses on currency, but it does not have a specific currency set. It also means that with the default implementation, our invoicing software program does not do any currency conversation or similar jobs.

... While not displaying a currency symbol is acceptable for many businesses or companies, there are cases that it is helpful to show a specific currency symbol on the invoices or bills. This tutorial details the steps required to set a currency symbol for all the money fields on the invoice layout. The result of this customization is a simple invoice template that could be downloaded for free, like all the other templates available here on InvoicingTemplate.com

Five Price Levels (Service, Amount)c4013

Five Price Levels (Service, Amount)

"Form with 5 Price Levels" was found to be relative to Self Billing Invoice Template with the score grade of 40.

This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original one in that it is service-oriented, i.e. it has no shipping fields.

... After unprotect the sheet, the second step is to switch to design mode, which is done by clicking the Design Mode button on the Developer ribbon tab in Excel 2007, Excel 2010 and Excel 2013, or in Excel 2003 by clicking the Design Mode command button on the Controls toolbar.

... 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.

Invoicing Template in Eurosc4100

Invoicing Template in Euros

"Invoicing Format in Euros" was found to be relative to Self Billing Invoice Template with the score grade of 26.

Download this free simple VAT invoice template in Excel format for invoicing in Euros. This design has a similar layout as the German version. The differences are that all labels are in English, and it shows the Euro symbol on cells, and also has a Euro watermark on the form.

... As you can see, with Microsoft Excel it is fairly easy to change the format and layout of a form design. While there are many other templates available for billing and invoicing, like Microsoft Word or Publisher, Google Docs, OpenOffice.org, even HTML + CSS or Photoshop, it is much easier to do formatting with Microsoft Excel.

Backorder Invoice Templatec7002

Backorder Invoice Template

"Backorder Invoice Template" was found to be relative to Self Billing Invoice Template with the score grade of 22.

When an order for inventory items is partially fulfilled, the portion of the order that has not yet been fulfilled is called a backorder. Backorder Invoice Template includes additional columns for you to detail Quantity Ordered, Quantity Shipped and Quantity Backordered.

...Backorder Invoice Template is provided in two editions - a freeware editions of Backorder Invoice Template, and a Uniform Invoice Software (UIS) edition of Backorder Invoice Template. Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

... While the free version of Backorder Invoice Template is simple, the result created by using this Microsoft Excel spreadsheet template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelancers who sales products and do need a shipping section on their invoicing form. It is a good invoice generator, but if you need more features, like management of customers, products / items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Backorder Invoice Template work for you.

Simple Sample - Moving Balance and Payment Cellsc5075

Simple Sample - Moving Balance and Payment Cells

"Simple Sample Invoicing Template - Moving Cells" was found to be relative to Self Billing Invoice Template with the score grade of 19.

... The default template includes two payment related fields on the bottom of the form - the first is "PAID", the second is "TOTAL DUE" (or "BALANCE DUE" on some versions), with two cells names "oknPayments" and "oknBalanceDue" assigned to them respectively. If you take advance payments these cells would be useful as they tell your customer how much they owe. If you don't take advance payment, you may not want to show these two cells on your invoices.

... Note that it is not recommended to delete the "oknPayments" and "oknBalanceDue" cells. "oknPayments" is a fillable (i.e. not locked) cell which stores the amount of payments post to this invoice. "oknBalanceDue" is the field that calculates the balance of the current invoice. Uniform Invoice Software determines the status of an invoice according to the value of the "oknBalanceDue" cell. On the default template, this cell has the formula "=ROUND(oknTotal-oknPayments,2)" assigned. However once you move these cells out of the printable invoice form, to make the worksheet clean and simple you can hide the columns / rows on which you store the "oknPayments" and "oknBalanceDue" cells.

Advanced Invoicing Sample - Macro-Enabled Invoicing Templatec5101

Advanced Bill Sample - Macro-Enabled Billing Template

"Advanced Bill Sample - Macro-Enabled Billing Template" was found to be relative to Self Billing Invoice Template with the score grade of 16.

... If you are an expert in Microsoft Excel if may want to do more with your invoice template. One of the advanced way is to use Excel macros.

... Uniform Invoice Software supports all the Excel file formats, including the traditional ".xls" and ".xla" formats, and the new ".xlsx" (Excel XML-based file format), ".xlsm" (Excel XML-based and macro-enabled file format), and ".xlsb" (Excel Binary (or BIFF12) file format). ".xlsx" are now the most widely used workbook file format. Feel free to see our Invoice Template ".xlsx" topic page.

... To convert an Excel workbook or template from ".xlsx" to ".xlsm" format, simply issue the "File" and "Save As" command. We'll skip the detailed steps here as there are already many resource online, such as Create a Macro in Excel - EASY Excel VBA, and How to Use Macros in Excel: 15 Steps (with Pictures), and Quick start: Create a macro.

PayPal Payment Button Using Custom Imagec3015

Excel Invoice with PayPal Payment Button Using Custom Image

"PayPal Payment Button Using Custom Image" was found to be relative to Self Billing Invoice Template with the score grade of 12.

... For steps on adding the PayPal payment button to your invoices and bills, see PDF Invoice with PayPal Button.

... If you prefer to make your invoices differ from others, like to make your business stands out from the generals, you are free to replace the default image with your own, just like you can easily replace the default logo image we used on many of our forms, by using just the built-in tools provided by Microsoft Excel.

... Here we look at how to do the customization.

... Note that the PayPal hyperlink assigned to the button on the Excel spreadsheet is just a template. It will be replaced with the real payment link on a PDF invoice. However if the PDF bill is blank (i.e. no balance due), the payment button is removed.

Sales Invoicing Format for Germanyc4098

Sales Invoicing Example for Germany

"Sales Invoicing Example for Germany" was found to be relative to Self Billing Invoice Template with the score grade of 8.

... Here on InvoicingTemplate.com we've already have a category of templates for VAT invoicing at VAT Invoice Templates, which lists the Excel forms that could be used to invoicing German-based clients, this template differs from the others in that all the text labels are translated into German. As detailed at 2016 European Union VAT rates, the standard Germany VAT rates is 19% for most goods and services, although a reduced rate could be applied for some foodstuffs; water supplies; medical equipment for disabled persons; some public transport; books; newspapers and periodicals; admission to cultural events; writers and composers; agricultural supplies; hotel accommodation; admission to sports events; social services; medical and dental care. This sample template set the default rate to 19%, and assuming all items on the form are taxable. In case you need to change the tax rate with Uniform Invoice Software, follow the steps below.

  1. Click the Settings button on the "Invoice" ribbon tab.
  2. Go to the "Taxes" tab.
  3. Enter the tax rate, such as 7% (reduced VAT rate) into the appropriate text box.
  4. Click "Apply". Uniform Invoice Software modifies the layout of the template according to your settings, including the formulas used to calculate the tax amount.
  5. Close the "Settings" dialog box.
  6. Save the template by clicking the "Save" button on Excel quick access toolbar.

UIS V5.11 Standard Invoice Template and Shortcut Keysc5094

Standard Invoice Format and Shortcut Keys for UIS Version 5.11

"UIS V5.11 Standard Invoice Template and Shortcut Keys" was found to be relative to Self Billing Invoice Template with the score grade of 7.

... With this new version of the standard invoice template, we replaced all ActiveX buttons with shape buttons - which are actually "Text Box" controls formatted with proper background colors to mimic the look and feel of buttons. With the release of UIS version 5, all templates published here on InvoicingTemplate.com are converted to use this new types of buttons.

... If you are using an old template, and install Uniform Invoice Software version 5, the invoicing program will convert the button types automatically.

... If you are using a template that does not have buttons on the sheet, but want to add the buttons, follow the steps below.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c6026
Bill Sample in Estonian
Thursday, October 13, 2016,
17
6
A4
Portrait
Service
c3009
Contractor Billing Format
Saturday, October 17, 2015,
18
3
A4
Portrait
Service
c5006
Job Invoice Sample
Tuesday, September 16, 2014,
12
5
A4
Portrait
Service
c7015
Commercial Invoicing Template
Wednesday, December 11, 2013,
16
7
A4
Portrait
Pro-forma
c4045
Catering Invoice Template
Tuesday, November 10, 2015,
12
4
A4
Portrait
Receipt
c7021
Welder Invoicing Template
Friday, September 26, 2014,
20
7
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c3007
Notary Invoice Template
Thursday, October 2, 2014,
12
3
A4
Portrait
Service
c2036
Musician Invoice Template
Sunday, October 9, 2016,
6
2
A4
Portrait
Service
c6024
Psychologist Invoice Template
Saturday, February 27, 2016,
20
6
A4
Portrait
Service
c4102
Jewelry Receipt Template
Friday, November 11, 2016,
16
4
A4
Portrait
Receipt
c5099
Standard Business Invoicing Template with Oval Button
Monday, October 24, 2016,
12
5
A4
Portrait
Sales
c4050
Simple Sample - Using Currency Symbol
Monday, January 25, 2016,
12
4
A4
Portrait
Sales
c4013
Five Price Levels (Service, Amount)
Tuesday, November 12, 2013,
30
4
A4
Portrait
Service
c4100
Invoicing Template in Euros
Tuesday, November 29, 2016,
12
4
A4
Portrait
Sales
c7002
Backorder Invoice Template
Monday, May 19, 2014,
12
7
A4
Portrait
Sales
c5075
Simple Sample - Moving Balance and Payment Cells
Saturday, January 23, 2016,
12
5
A4
Portrait
Sales
c5101
Advanced Invoicing Sample - Macro-Enabled Invoicing Template
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c3015
PayPal Payment Button Using Custom Image
Thursday, August 11, 2016,
10
3
A4
Portrait
Service
c4098
Sales Invoicing Format for Germany
Sunday, November 20, 2016,
12
4
A4
Portrait
Sales
c5094
UIS V5.11 Standard Invoice Template and Shortcut Keys
Thursday, September 29, 2016,
12
5
A4
Portrait
Sales

What Is Hot

Feature Galleries