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 Billing Format

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

...(162) If you use the Uniform Invoice Software version of Print Shop Bill Sample, 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.

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

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.

...(50) However this type of background images are not printable. If you go to Excel menu "File" and then choose "Print", Excel shows the print preview of the current invoice spreadsheet. However the background image set previously is not included. And for watermarks, Excel does not provide directly support for it.

...(40) 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 InvoicingTemplate.com as the starting point and basic invoice template for demonstration purpose.

Tax Invoice for Printing Shopc2005

Tax Invoice for Printing 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.

...(52) So, how do you move a cell in Excel? It's easy! Just drag your mouse to select the cell or cells you want to move to select it, then push your mouse key on the border of the selected area, and then drag and drop the selected area to its new location.

Invoice and Packing List on Separate Worksheetc4080

Invoice and Packing Slip 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.

  1. Remember to back up the template before modifying it.
  2. Open the template and switch to design mode by clicking the "Design Mode" button on the "Invoice" worksheet.
  3. Click the "+" button (i.e. the "New Sheet" button) next to worksheet names on the bottom of the Excel window.
  4. Excel adds a worksheet which is automatically named "Sheet1".
  5. Click the worksheet name "Sheet1" twice to rename it. In this sample, we name it "Packing List".
  6. Activate the "Invoice" worksheet by clicking its worksheet name.
  7. Drag your mouse to select the entire packing list form, ranging from D50 to L91.
  8. Press "CTRL+C" on keyboard to copy the selected area.
  9. Activate the packing list worksheet.
  10. Click the cell B5 (You can choose another cell. This is just the starting cell of our new packing list form).
  11. Click the "down arrow" of the "Paste" command in the "Clipboard" group of the "Home" ribbon tab. Click "Keep Source Column Width". Excel pastes the formats of the original form, and shows lots of "#REF" errors - simply ignore the errors for now.
  12. Click the "down arrow" of the "Paste" command again. Click "Paste Link". Now all cell values are pulled from the original packing slip form. The worksheet shows lots of "0" (zero) values since many cells in the original form have no content. To hide the zero values:
    • Click the "File" menu and then choose "Options".
    • Choose "Advanced" in the left pane.
    • In the "Display options for this worksheet" section, uncheck the "Show a zero in cells that have zero value".
    • Click OK.
  13. With the "Packing List" worksheet is still activated and the new packing list form is selected, go to the "Page Layout" ribbon tab, click "Print Area" and then "Set Print Area".
  14. Go the "Invoice" worksheet, select the entire form for the invoice. In this case, it is D2:L47. From the "Page Layout" ribbon tab, click "Print Area" and then "Set Print Area". This redefines the printable area of the "Invoice" worksheet to exclude the packing list below it, since we'll no longer want to print one invoice and one packing list together. However don't remove the packing list form under the invoice form, since the cells on the "Packing List" worksheet is referencing to it. However you can hide the entire packing list form under the invoice form.

    You can also go through the steps detailed in Invoice and Packing List on Same Form (c4078), but place the new packing list form on a separate sheet. This way, you'll avoid the packing list form under the invoice form altogether.

  15. Exit design mode.
  16. Save the template by clicking the "Save" command on Excel quick access toolbar.

Invoicing Sample for Cosmetics Shopsc4095

Invoicing Sample for Cosmetics Shops

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

...(105) The itemized detail section in the sample invoicing template allows you to list the products a customer purchased, for example "Dermactin-TS Collagen Gel Patches", "Dermactin-TS Anti-Wrinkle Eye Cream" etc. Whether you are a reseller or wholesaler, you can use the "Products" database table to manage your product / inventory. By default Uniform Invoice Software connects with Access database (you don't have to install Microsoft Access in order to just use the database), but Enterprise edition of Uniform Invoice Software supports SQL Server database too. For SQL Server, you can even run it online and access your data anywhere around the world via an Internet connection.

...(16) With Uniform Invoice Software installed, there are several ways you can pick items on creating invoices.

Simple Lightweight Service Invoicec4073

Simple Lightweight Service Invoice

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

...(38) This Simple Lightweight Service Billing Format is designed with the "simple" and "lightweight" principle in mind. It uses only black font color, no logo image (should be printed on company letter-head paper). It's clean and ink-saving invoice design.

...(51) Since this is a service invoicing template, it does not requires the shipping address fields. We've retargeted the fields so they are now designed for "Service Location", including fields for contact name, address, city state and ZIP. The "Bill To" section, like most invoicing templates here on InvoicingTemplate.com, are still there.

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.

...(37) Like they said, a picture is worth a thousand words. This is true even to an invoicing form such as this one designed for painters. The images easily make the form not only professional, but also elegant.

Excel Quotation Templatec9008

Excel Quotation Format with Special Discounting Model

"Excel Quotation Format with Special Discounting Model" was found to be relative to Printable Invoice Templates Free with the score grade of 59.

...(31) This template is created for businesses who sell goods. For a job estimating and quoting template, visit Job Estimate Template for Excel. For a general estimate template, see General Estimate Template.

...(23) "Unit Price" is a manually editable field. "Line Total" is also a calculated field, which looks like this (again, "_?" indicates line numbers):

...(122) On the bottom of the form, you'll find the usual "Subtotal", "Discount" and "Total" fields. There is also the "Last Balance" field and the "Total Due" cell. The "Last Balance" cell has its field name set to "oknAccountBalance", which is filled whenever you fill in the quotation form / estimation form with an existing client by using the on-sheet picker button, you by enter the client# into the "Customer#" cell (also located outside of the printable quotation form, at $U$2). See Invoice with Previous Balance (Sales) and Invoice with Previous Balance (Service) for more information on how to show previous balance on the form. The "Total Due" is the sum of the previous account balance and the total of the current quotation.

Bill Format for Computer Repair Servicec5096

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

...(92) On the heading section, there are spaces for a logo image, your computer repair business information, a big text title "INVOICE" indicating the type of this document, and also the two most important fields for any invoice - the invoice# and invoice date cells. If you have Uniform Invoice Software installed, our invoicing software app is able to generate increment and unique invoice numbers based on a counter inside database. This "auto numbering" feature is a huge time-saving functionality as you don't have to manually create and track used invoice numbers again.

Standard Invoice with Double Borderc5085

Standard Invoice Format with Double Border

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

  1. Make sure the "Invoice" worksheet is the active sheet. Click the "Down arrow" button on the name box located on the left side of the formula bar. Excel shows all the names in a drop down list.
  2. Scroll the drop down list till bottom.
  3. Click and select "Print_Area" from the list.
  4. Excel selects the cells that defined by the "Print_Area" name - this is the printable form that will be printed when you issue the "Print" command, or will be extracted when you click the "Extract/Email" button. When generating PDF invoices, the printable area defined by the "Print_Area" will also be respected.
  5. Right-click the heading of the first row on the printable area. Choose "Insert". This adds one row above the top of the current printable area.

    To add a column to the left of the first column of the printable area, right-click the heading of the first column of the printable area, and then choose "Insert" from the shortcut menu.

    You can add new row / column to the bottom, right edge of printable form, or skip this procedure since the right and bottom direction already have empty columns / rows there.

Invoice and Packing List on Same Formc4078

Invoice and Packing Slip on Same Form

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

...(90) The packing slip template here on Invoicing Template shows you how to create a standalone pack list template. With the help of Uniform Invoice Software, you can easily loaded an existing invoice using the packing list template, and thus to print the packing list for shipment using the packing list template. If you always have the need to print both an invoice and a packing list at the same time, then consider to have both documents - invoice and packing list, on the same form, as shown in this sample.

...(57) To archive this goal, we first have to copy the existing invoice design to create a new form, and then modify the new form to make it suitable for packing lists. And finally, we modify the definition of the printable form, to have Excel print both documents (the invoice and the packing list) at the same time.

...(11) Let's see the detailed procedures and steps involved in this customization.

Simple Sample - Changing Print Orientationc4053

Simple Sample - Changing Print Orientation

"Simple Invoicing Format - 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".

...(60) If you have just started your business and have limited budget for invoicing / accounting, using a free invoice template like the simple invoice template created in this tutorial could produce professional invoices with easy and quick. If you need a more powerful invoicing tool, install Uniform Invoice Software, which works with any / all templates published here on InvoicingTemplate.com.

Pet Food Store Invoicec3013

Pet Food Shop Invoicing Format

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

...(94) In the tax rate cell, we use an Excel formula "=IF(oknTaxStateName="",0,VLOOKUP(oknTaxStateName,O3:P13,2,FALSE))" to fill the correct rate value according to the state name you choose from the drop-down list. This is one of the great samples that shows the flexibility of Excel invoicing templates. While it is possible to generate professional looking invoices using templates in other formats, like Microsoft Word (doc or docx), HTML + CSS, PDF, or even Adobe Photoshop, or online invoice templates, Uniform Invoice Software combined with Microsoft Excel creates a level of flexibility that other invoicing software could hardly implement.

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) With these two assumptions made, now let's see how to customize the basic invoice template, Simple Invoice Template - Discount Amount Field (also see the gallery of simple invoicing template), to split the "city, state zip" into separate fields.

  1. Backup both your Excel Invoice Template and database file.
  2. Open the invoice template as usual.
  3. Click the Design Mode button on Excel "Invoice" ribbon tab. Note that to show the "Invoice" ribbon tab you have to install Uniform Invoice Software, our Excel invoicing software that leverage both the features of front-end Excel and back-end database.
  4. Look for an empty area to place the extracted city, state and zip values. Since we'll not show the extracted values on the printed invoices or auto-generated PDF invoices. In this case we choose the O6:P20 area outside of the printable invoice form. In cell o6, type in the name of this section - "separate U.S style city state zip".
  5. Click to select cell O7. Type in the formula ' =TRIM(oknWhoCityStateZip)'. This formula makes corrections to the original value - i.e. removing the leading and trailing spaces.
  6. Click to select cell O8. Type in the Excel formula ' =IF(O7="","",LEFT(O7,(FIND(",",O7))-1))'. This formula looks for the common symbol in the text, and retrieve the left part as the "city name". Click to activate the name box on the left-side of the formula bar, enter the name of this cell "oknCustomerCity".
  7. Click to select cell O9. Type in the Excel formula ' =IF(O7="","",MID(O7,FIND(",",O7)+2,FIND("*", SUBSTITUTE(O7, " ", "*", LEN(O7) - LEN(SUBSTITUTE(O8, " ", ""))))-(FIND(",",O7)+2)))'. This formula retrieve the part between the comma and space symbols. This is the state name. Name this cell "oknCustomerState".
  8. Click to select cell O10. Type in the formula ' =IF(O7="","",RIGHT(O7, LEN(O7) - FIND("*", SUBSTITUTE(O7, " ", "*", LEN(O7) - LEN(SUBSTITUTE(O7, " ", "")))))) '. This formula retrieve the zip / postal code from the "city, state zip string. Name this cell "oknCustomerZip".

    With all these formulas correctly set, if you enter "La Jolla, California 92092-0100" into the "oknWhoCityStateZip" cell, the "oknCustomerCity" cell should show "La Jolla", the "oknCustomerStateCell" should show "California", and the "oknCustomerZip" cell should show "92092-0100".

  9. Now exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  10. Click the "Customers" button on the "Invoice" ribbon.
  11. Click "Custom Fields", and then "Add Field".
  12. Enter the name of the field "CustomerCity", choose its type "Text", and set the size to "50". Click OK to create the custom field.
  13. Click "Add Field" again. Create the second custom field - Name: oknCustomerState; Type: Text; Size: 50. Click OK to create the custom field.
  14. Click "Add Field" again. Create the third custom field - Name: oknCustomerZip; Type: Text; Size: 50. Click OK to create the custom field.
  15. Now from the "Database table" list, choose "Invoice Header". Click "Add Field".
  16. Repeat the above steps to add "CustomerCity", "CustomerState" and "CustomerZip" custom fields for the Invoice Header database table.
  17. Click "Close" to close the custom field manager.
  18. Save the invoice template by clicking the Save button on Excel quick access toolbar.
  19. Test the template.

Freelance Invoice Templatec6018

Freelance Billing Template

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

...(97) As a freelancer, creating invoices might not what you best at but it is necessary. Further more your invoice should be prim and proper, so that you can get paid by your clients efficiently. While invoicing is not a fun task, it's a necessary one: by keeping clients informed of your expectations, you will get paid punctually and reinforce your professionalism. Using a template is the most easy and quick way to get the job done. Our templates online here on InvoicingTemplate.com help you spend less time creating invoices and more time doing the things you love.

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.

...(153) Whenever you have completed a service and are ready to be paid, you must always submit an invoice to your client. Occasionally, clients will not follow up with an invoice request, so it's your job to keep track of the payments due to you. The important part is to keep track of the invoices you submit (using an invoice processing system helps with this a great deal), and follow up on a regular basis with a polite email or phone call asking for a status update on your payment. With Uniform Invoice Software installed, you can find all pending (not paid) invoices with a single click of mouse - i.e. clicking the "Invoices" button on the ribbon tab. You can sort the invoice list by any column - simply double clicking the column heading, or search for an existing invoice by a criterion applied to almost any fields available on the invoicing form.

...(79) You may find many invoicing templates available here on InvoicingTemplate.com meet the above criterion, including Freelance Invoice Template, Invoice Template Hourly Rate, or visit our service invoice template category. Every business is different. You may like your invoices not only including all the required information, but also looks professional and special to your business. That is why we at InvoicingTemplate.com create this new freelance invoice template and offer you for free, Professional Freelance Bill / Professional Freelance Billing Format.

Freelance Writer Invoicec3012

Freelance Writer Billing Template

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

...(152) Another important invoicing tips for freelancer writers or designers is tracking invoices and payments. While the pure Excel-formatted template does produce beautiful and professional invoices, it is not easy when it comes to number and tracking invoices / payments. With pure Excel spreadsheet template, you have to number invoices manually and track payments manually. And as a freelancer, you may not want to use those expensive and complex accounting / bookkeeping software systems. This is no longer a problem if you have Uniform Invoice Software installed, which is our Excel-based desktop invoicing software app that connect an Excel spreadsheet template with back end database, offers advanced features like management of customers, products, invoices and payments. Feel free to download the fully functional trail version and see how it works for you. The invoicing app is also able to generate PDF copy of your freelance invoice and send it to your customer electronically.

Excel Shipping Invoice with Printable Truck Background Imagec5087

Shipping Invoice with Printable Truck Background

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

...(91) Secondly, we deleted all "pick up" buttons as they are not needed for now. Our new Uniform Invoice Software version implements an "On-Sheet Picker" that shows a small button when you click one of the supported fields, including all fields defined in the "Customer" database table, the "Invoice#", all the fields on the invoice detail section, "Sales Rep. Name" and "Payment" term. So it won't affect the usability if we delete the "pick up" (magnifying glass icons) buttons. Here is how you can delete an icon button from the "Invoice" worksheet.

Proforma Invoice with Printable Earth Map Backgroundc7029

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

...(29) Microsoft Excel provides powerful and flexible tools to format and present font-end data. This means we can easily design a professional and beautiful invoice layout easily with Microsoft Excel.

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

...(49) This printable image is located on the center-bottom of the form, where in the original template we placed the default logo image for your consultancy business. In order to show the background image, we've moved the default logo image (the placeholder image) to the top of the form layout.

...(54) All templates hosted here on InvoicingTemplate.com support our desktop invoicing software, Uniform invoice Software (UIS). Without UIS, you are able to use the template to create invoices by a filling-in-the-blank form, much like filling a paper form. However by installing UIS, you are able to use a number of powerful features provided by UIS.

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