Skip to main content
InvoicingTemplate.com main content

Summary

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 Samplec4006

Print Shop Bill Sample

"Print Shop Billing Format" was found to be relative to Printable Invoice Templates Free with the score grade of 99.

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

...(33) Note that the Invoice worksheet is protected by default. Before you can use the spreadsheet for the first time, you need to unprotect the Invoice worksheet and then type in your business details.

...(97) While the free version of Print Shop Bill Sample 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 Print Shop Bill Sample work for you.

Simple Template with Printable Watermarkc4075

Simple Template with Printable Watermark

"Simple Format with Printable Background Image" was found to be relative to Printable Invoice Templates Free with the score grade of 98.

  1. As always before customizing a template you first need to back up it. To do this, simply copy the Excel template file in Windows Explorer.

    With Uniform Invoice Software installed, it is recommended to run the template in protected mode (by clicking Excel ribbon Review tab, and then click the "Protect Sheet" command, or go to the "Invoice" ribbon tab and make sure "Design Mode" is not enabled).

  2. In this sample, we need to change the design of the template. So click the "Design Mode" button on the "Invoice" worksheet to unprotect the sheet, display gridlines and row/column headings.
  3. Go to Excel "Page Layout" ribbon tab, click the expand button in the "Page Setup" group. This opens the "Page Setup" dialog box.
  4. Go to the "Header / Footer" tab.
  5. Click "Custom Header", or "Custom Footer", depending on whether you want to lay out the image from top or bottom. In this sample, we choose "Custom Header".
  6. Choose a section to place the image - "left section", "center section" or "right section". In this case, we click and choose "Center section".
  7. Click the "Insert Picture" button on the toolbar.
  8. Browse to and pick up your picture or watermark image from locally store, or download it online.
  9. The section now has a "&[Picture]" placeholder symbol. Click to select it, and then click "Format Picture" command on the toolbar (the last one).
  10. The "Format Picture" dialog box appears. Here you can set the size, scale ratio, cropping, color (automatic, grayscale, black & white and washout), brightness and contrast of the image.
  11. Once you have set the options done, click the dialog boxes.
  12. Go to Excel menu File / Print, you can see that the background image on the printed invoices (see screenshot images below). The background image / watermark will also be included in PDF invoices.
  13. To finish your design job, click the "Design Mode" button on the "Invoice" ribbon tab. Click the Save button on Excel quick access toolbar to persevere the changes.

Tax Invoice for Printing Shopc2005

Tax Receipt for Print Shop

"Tax Receipt for Print Shop" was found to be relative to Printable Invoice Templates Free with the score grade of 96.

...(68) Although we at InvoicingTemplate.com names this invoice template as a service invoice template, it actually includes a shipping information - but unlike most other templates designed by us at InvoicingSoft.com, the shipping information section is moved to the invoice body section and titled with "Delivery to". This is not a usual design but we hope this gives you an inspiration on how the invoice template can be customized.

...(79) Like all the other invoice templates here on InvoicingTemplate.com, this template work fine with Uniform Invoice Software too. And, like all the other templates here, it is created starting from the general sales invoice template shipped with Uniform Invoice Software. Although it is very different from the general sales invoice template, creating this "Tax Invoice for Printing Shop" template is actually not as hard as you might think. The most important thing you should do is just moving cells.

Invoice and Packing List on Separate Worksheetc4080

Invoice and Packing List on Separate Worksheet

"Invoice and Packing Slip on Separate Worksheet" was found to be relative to Printable Invoice Templates Free with the score grade of 92.

...(115) This template differs from our existing packing slip template in that we put the packing slip (waybill) in a separate worksheet, but within same Excel template as the invoice form. The advantages of this approach is that - you don't have open another template for the purpose of printing a packing slip (like what we implemented in c3010 and cn010), or you don't have to always print an invoice and a packing list together (like c4078). Since we place the packing list form in a separated worksheet, we can define its own "Print_Area", and print the number of copies as needed - for example, print one invoice, and then print 2 copies of packing list.

Invoicing Sample for Cosmetics Shopsc4095

Billing Template for Cosmetics Shops

"Billing Template for Cosmetics Shops" was found to be relative to Printable Invoice Templates Free with the score grade of 88.

...(117) Firstly you can use the "on-sheet picker" button which appears next to the active Excel cell. Clicking the "on-sheet picker" button pops up a list of active products / items that you are selling. Above the product list you'll also find a search bar which allows you to filter / search the product list with any property belongs to a product, such as product# (SKU#, barcode etc.), product name and unit price etc. The search bar allows you to enter only part of the item name. For example, if you specify the search criterion "contains words" for the field "Product Name", and then enter the search word "eye cream", all products contains that word will be listed.

Simple Lightweight Service Invoicec4073

Simple Lightweight Service Billing Format

"Simple Lightweight Service Invoice" was found to be relative to Printable Invoice Templates Free with the score grade of 72.

...(196) This Simple Lightweight Service Billing Format has 4 columns on the detail section - Description, Quantity, Unit Price and Amount. The "Item#" column found on many forms here on InvoicingTemplate.com was moved out of the printable billing form. Although this column is not printed, or is not included when you are generating PDF invoices using Simple Lightweight Service Invoice Template, it is a required field for Uniform Invoice Software. An invoicing item (or line) is seen as incomplete if the item# is missing (this this case, if you want to save invoices without item# values, you have to enable "Allow incomplete lines on invoice body" option on the "Template" tab of the "Settings" dialog box (open it by clicking the "Settings" button on the invoice worksheet. Besides that, there is a useful feature assigned to the "Item#" cells by Uniform Invoice Software - you can type in the item# codes to retrieve the related description, unit price easily, so that you don't have to type in the text again and again on creating invoices. This feature is called "in-cell lookup" in Uniform Invoice Software. This feature also works for the Customer# ("oknWhoID") and Invoice# ("oknInvoiceID") cells.

Bill Format for Painting Servicec4087

Invoicing Template for Painting Service

"Bill Format for Painting Service" was found to be relative to Printable Invoice Templates Free with the score grade of 60.

...(79) Besides all the elements required by a general invoicing template, this particular invoicing form features a background image with set of repair instruments located on the on the bottom of the form. The opaqueness of the background image is set to 35% so even in the overlapping area the front text is still readable and clear. While there are templates that have similar layout here on InvoicingTemplate.com, this special background easily mark the business type of this invoicing template.

...(39) While the title of the current template is set to "INVOICE", you can easily modify it to be a work order by moving out cells like "Total Due" and "Paid" to the area out of the printable invoicing form.

Excel Quotation Templatec9008

Excel Quotation Format with Special Discounting Model

"Excel Quotation Template" was found to be relative to Printable Invoice Templates Free with the score grade of 59.

...(58) The template includes 9 columns. The first two columns are titled with "PACKAGE", under which two columns allows you to enter number of packages, and the package type that is implemented as a drop-down list with 3 options - "BOX", "S.BOX" and "GUDDI". Followed are the columns "BOX No.", "Description", "Per", "Quantity", "Unit Price", "Line Total" and "LESS".

...(41) The formula for "Line Total" incorporates both the auto-calculated portion, and the manually fillable field ("oknLineTotalManual_?" fields, placed outside the printable area, which means it is manually editable on creating invoices / estimations, but will not be included on printable invoices).

Bill Format for Computer Repair Servicec5096

Invoicing Template for Computer Repair Service

"Invoicing Template for Computer Repair Service " was found to be relative to Printable Invoice Templates Free with the score grade of 48.

...(88) The "Bill To" section includes 6 fields - client#, name, address, city state and zip, email and phone. In many situations email is a key field now, especially if you want to send PDF invoices to your clients via email. By adding the email field to the "Bill To" section, you are able to create new customer records along with their email address populated; and besides that, it also ensure you can send a PDF version of the invoice to the customer by simply clicking the "Extract/Email" button.

Standard Invoice with Double Borderc5085

Standard Invoice Format with Double Border

"Standard Invoice with Double Border" was found to be relative to Printable Invoice Templates Free with the score grade of 42.

...(16) Here we look at how to add a double border surrounding the entire printable invoice form.

  1. Drag your mouse to select the entire new "Print_Area". In this sample, it is $C$2:$L$48. Tip: you can just the the "Print_Area" name from the name box on the formula bar.
  2. Right-click one of the select cell and choose "Format Cells".
  3. Go to the "Border" tab.
  4. From the "Style" list, choose the double-border style.
  5. Choose a proper color.
  6. In the "Border" section, click the borders respectively.
  7. Click OK to close the "Format Cells" dialog box.

Invoice and Packing List on Same Formc4078

Invoice and Packing Slip on Same Form

"Invoice and Packing List on Same Form" was found to be relative to Printable Invoice Templates Free with the score grade of 41.

  1. First, backup the template that you want to customize. It seems redundant that we repeat this in every tutorials targeted to simple invoice template customizations. But it is important and highly recommended that you do so. Baking up data frequently saves you a lot time and efforts when the newest version of data is lost.
  2. Open the template.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" worksheet.
  4. Pull down the name box located on the left-end of the formula bar. On the end of the name list you'll find "Print_Area". Click to select it.
  5. Excel select all the cell defined by the "Print_Area" name. This is the printable area that is printed when you print the current worksheet.
  6. On Excel "Home" ribbon tab, click "Copy" in the "Clipboard" group. This copies the entire printable invoice form to the clipboard.
  7. Choose an empty area underneath the existing printable form. In this sample, our original printable area is defined at D2:L47, so we click and select D50, this will be our starting cell of the new packing list form.
  8. On Excel "Home" ribbon tab, pull down "Paste" in the "Clipboard" group and then choose "Paste All".
  9. Now the key step - pull down "Paste" in the "Clipboard" command group again, chose "Paste Link" in the "Other Paste Option" section. This will create a simple formula for each cell in the paste destination section. The simple formula retrieves data from the original printable form (the invoice form), fill it in the packing list section. This way, if we you fill in the invoice data, either manually or loading an existing invoice from database by using Uniform Invoice Software, the data of the packing list is automatically filled.
  10. Till now our new packing list form has exactly the same format and content as the invoice. Modify it to make it meets your requirements of packing slip. For example, change the title from "Tax Invoice" to "Delivery Docket".
  11. In this sample, we also clear the "Price" and "Amount" column, and then expand the "Description" column.
  12. With this sample template, we also cleared the bottom section that details "Freight", "GST", "Total Incl. GST" etc., as they are usually not required on a packing list.
  13. Add your notes and declarations to the form, usually bottom of the form.
  14. It is also common to add fields for manually singed. For example, we added "Signed", "Sign Date", "Print Name" and "Print Date".
  15. Once the design of the packing list is finished, select all the cells inside the packing list. Lock all the cells.
  16. Now once again, select "Print_Area" from the name box on the left end of the formula bar. This selects the original printable area.
  17. Now push down the CTRL key on the keyboard, drag mouse to select the new packing list area - in this sample, it is D50:L92.
  18. Release keyboard CTRL key.
  19. With both the invoice and packing list form selected, from Excel "Page Layout" ribbon choose "Print Area", and then "Set Print Area". This define the new printable form. As you can see, the print area could be discrete area that contains multiple ranges.
  20. Go to Excel menu File / Print Preview. Make sure the worksheet will be printed on 2 pages.
  21. Exit design mode once you have done the customization.
  22. Save the template.

Simple Sample - Changing Print Orientationc4053

Simple Invoicing Format - Changing Print Orientation

"Simple Sample - Changing Print Orientation" was found to be relative to Printable Invoice Templates Free with the score grade of 40.

...(87) Most template available here on InvoicingTemplate.com using "Portrait" paper orientation / print orientation. In the real business world, there is no one template fits all. Different businesses have very different requirements regarding their invoicing forms. Some businesses need relatively long content on each field, such as address, description etc., and they need less lines on the invoice detail section. This tutorial, based on the result of c4051 Simple Invoice Template - Discount Amount Field, demonstrates how to change the orientation option of the invoicing form to "Landscape".

...(13) Now let's see how to change the paper orientation of an invoice format.

Pet Food Store Invoicec3013

Pet Food Store Invoice

"Pet Food Shop Invoicing Format" was found to be relative to Printable Invoice Templates Free with the score grade of 40.

...(137) Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Pet Food Store Invoice uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

Simple Sample - Splitting City State ZIPc4072

Simple Invoice Template - Splitting City State ZIP

"Simple Sample - Splitting City State ZIP" was found to be relative to Printable Invoice Templates Free with the score grade of 37.

...(39) In this case, assuming both the customer data and invoice data need separate city, state and zip code (postal code), we need to add the custom fields (CustomerCity, CustomerState, CustomerZip) into both the "Customer" and "Invoice Header" database tables.

...(115) One of the advantages of having city, state and zip in one single cell is that it is easy to manually enter the information, and the printed result (or the auto-generated PDF invoice) looks exactly as what you entered. This meets our design principle of Uniform Invoice Software - easy to use. So our invoicing templates here on InvoicingTemplate.com are designed in a what-you-see-is-what-you-get way. To create new invoices with Uniform Invoice Software you don't have to deal with many complex forms that are not intuitive. But having separate city, state and zip has its own advantage, for example it is easy to manipulate the data such as sorting by state name or zip codes.

Freelance Invoice Templatec6018

Freelance Billing Template

"Freelance Billing Template" was found to be relative to Printable Invoice Templates Free with the score grade of 33.

...(109) This invoice design has 6 columns on the invoice detail section - Description, Date, Hours, Rate / Fee and Amount. The Amount is calculated automatically using Excel formulas once the Hours and Rate / Fee are filled in. The other 5 columns, Description, Date, Hours and Rate / Fee are all fillable in this invoice format. As you can see from the screen shots below, this is basically a hourly service invoice template, like Hourly Service Invoice Template. You can also find other interesting invoice template in the Consulting Invoice Template category or Service Invoice Template category here on InvoicingTemplate.com, including those designed specially with UK (United Kingdom) style.

Professional Freelance Billc4047

Professional Freelance Bill

"Professional Freelance Bill" was found to be relative to Printable Invoice Templates Free with the score grade of 20.

...(105) The template has no tax set by default (the tax cells are hidden and not printable). With Uniform Invoice Software installed, you can easily change it to one tax or two taxes, depending on your particular needs. Simply click the Settings button on the ribbon tab, and then go to the Taxes tab, choose your tax type (no tax, one tax, two taxes), enter the tax name such as VAT, and the rate, click Apply and you are done! With this flexibility, we can say this template is not only suitable for freelancer, limited company and also sole trader, whether they are VAT-registered or not.

Freelance Writer Invoicec3012

Freelance Writer Invoice

"Freelance Writer Invoice" was found to be relative to Printable Invoice Templates Free with the score grade of 15.

...(65) All invoice templates here on InvoicingTemplate.com are in Excel spreadsheet format (xlsx or xls). While Microsoft Word can also be used to procedure beautiful and professional invoices in docx or doc format, the benefits of Excel is clear - it is more suitable for doing calculations. For example, in this template the line totals, subtotal, tax and total are all computed automatically using Excel formulas.

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

Excel Shipping Invoice with Printable Truck Background Imagec5087

Excel Shipping Invoice with Printable Truck Background Image

"Excel Shipping Invoice with Printable Truck Background Image" was found to be relative to Printable Invoice Templates Free with the score grade of 5.

...(34) Fortunately it is still possible to print an image in the background of a worksheet. This technique could also implement watermark effect on your invoices, as shown in Simple Invoice Template with Printable Watermark.

...(15) The last step is to add the image. To do this, follow the steps below.

  1. Open the "Page Setup" dialog box as described above.
  2. Go to the "header / Footer" tab.
  3. Check "Scale with document" and "Align with paper margins", and then click "Custom Header".
  4. On the "Header" dialog box, click to activate the "Center section" box.
  5. Click the "Insert Picture" button on the toolbar.
  6. Specify the picture / image you want to use, by browsing local computer, or search online.
  7. Once the picture has been specified, Excel inserts a "&[picture]" placeholder to the "Center section" box.
  8. Click to select the "&[Picture]" symbol, click the "Format Picture" button on the toolbar. This opens the "Format Picture" dialog box.
  9. On the "Size and rotate" section, set height and width of the picture to proper values. In this shipping invoice sample, the target paper is standard A4 paper (8.27 inch X 11.69 inch), so we set the image size to 6.89 inch (height) and 8 inch (width). This makes the truck image to be on the center of the printed invoice. If you are following this sample to insert your own image, you should adjust the width and height according to your own image.
  10. Go to the "Picture" tab. In the "Image Control" section, set "Brightness" to 85%, set contrast to 30%. Again, you should choose these values depending on your image colors.
  11. Click the "Compress" button to make the inserted image smaller in file size.
  12. Close the "Format Picture" dialog box.
  13. Click OK to close the "Header" dialog box.
  14. Click "Print Preview" on the "Page Setup" dialog box.
  15. Excel shows what it will like when the "Invoice" worksheet is printed.
  16. You may need to open again the "Header" dialog box to adjust the size, brightness and contrast to get a best / satisfying background image effect.
  17. Once everything is done, click "Design Mode" button on the "Invoice" ribbon tab to exit design mode.
  18. Save the template.

Proforma Invoice with Printable Earth Map Backgroundc7029

Proforma Invoice with Printable Earth Map Background

"Proforma Invoice with Printable Earth Map Background" was found to be relative to Printable Invoice Templates Free with the score grade of 5.

...(85) Like our previous pro-forma invoice templates, this Proforma Invoice with Printable Earth Map Background is in Microsoft Excel format (xlsx) format too. In fact, all of our invoice templates are provided you in Excel format, although a PDF version of the invoice template is provided with each Excel invoice template too. The reason that we choose Microsoft Excel as our template format is that Microsoft Excel is very widely applied spreadsheet around the world, and has replaced Lotus 1-2-3 as the industry standard for spreadsheets.

...(59) Since proforma invoices, like commercial invoices, are mainly for cross-board international trading, we believe an earth map is a suitable background / watermark for it. The earth map is an abstract image create from a vector image. It is placed on the center of the printable proforma invoicing form, which is defined by the special "Print_Area" Excel range name.

Simple Consulting Bill with Printable Background Imagec4085

Simple Consulting Billing Template with Printable Background Image

"Simple Consulting Billing Template with Printable Background Image" was found to be relative to Printable Invoice Templates Free with the score grade of 1.

...(38) The background image we added to the template shows a business man checking for documents. It shows on the printed version of your consulting invoices / bills, or on the PDF consultant bills generated by Uniform Invoice Software.

...(66) Use the search tool to easily locate and download your favorite billing format. You don't have to be an artist or Excel professor to have a beautiful form. We've prepared a number of templates that you can choose from. Our templates are pure-Excel based template that are not locked with password, built without macros - just simple spreadsheet forms with Excel formulas to do basic calculations.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4006
Print Shop Bill Sample
Friday, May 30, 2014,
12
4
A4
Portrait
Service
c4075
Simple Template with Printable Watermark
Tuesday, June 28, 2016,
20
4
A4
Portrait
Sales
c2005
Tax Invoice for Printing Shop
Tuesday, October 22, 2013,
12
2
A4
Portrait
Service
c4080
Invoice and Packing List on Separate Worksheet
Sunday, July 10, 2016,
20
4
A4
Portrait
Sales
c4095
Invoicing Sample for Cosmetics Shops
Saturday, October 29, 2016,
12
4
A4
Portrait
Sales
c4073
Simple Lightweight Service Invoice
Monday, May 9, 2016,
12
4
A4
Portrait
Service
c4087
Bill Format for Painting Service
Saturday, October 22, 2016,
8
4
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c9008
Excel Quotation Template
Friday, February 10, 2017,
37
9
A4
Portrait
Other
c5096
Bill Format for Computer Repair Service
Tuesday, October 18, 2016,
12
5
A4
Portrait
Service
c5085
Standard Invoice with Double Border
Friday, July 1, 2016,
12
5
A4
Portrait
Sales
c4078
Invoice and Packing List on Same Form
Wednesday, July 6, 2016,
20
4
A4
Portrait
Sales
c4053
Simple Sample - Changing Print Orientation
Friday, January 29, 2016,
6
4
A4
Landscape
Sales
c3013
Pet Food Store Invoice
Sunday, May 15, 2016,
15
3
A5 (148 mm x 210 mm)
Portrait
Sales
c4072
Simple Sample - Splitting City State ZIP
Saturday, May 7, 2016,
12
4
A4
Portrait
Sales
c6018
Freelance Invoice Template
Wednesday, October 1, 2014,
12
6
A4
Portrait
Consulting
c4047
Professional Freelance Bill
Friday, November 13, 2015,
6
4
A4
Portrait
Service
c3012
Freelance Writer Invoice
Saturday, May 14, 2016,
10
3
A4
Portrait
Service
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c7029
Proforma Invoice with Printable Earth Map Background
Sunday, July 10, 2016,
8
7
A4
Landscape
Pro-forma
c4085
Simple Consulting Bill with Printable Background Image
Friday, August 19, 2016,
16
4
A4
Portrait
Consulting

What Is Hot

Feature Galleries