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.

...(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 Format with Printable Background Image

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

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

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

Lumber Company Invoicecm007

Lumber Company Invoice Template

"Lumber Company Invoice" was found to be relative to Printable Invoice Templates Free with the score grade of 60.

...(33) This spreadsheet form has two drop-down lists created using Excel "Data Valuation" feature. See c4062 Simple Tax Invoice Sample with Tax Rate List for another example on using drop-down list on Excel sheets.

...(34) The first drop-down list shows freight details. The data source of this list is located on $AE$19:$AE$24, featuring items like "PBT Transport", "Northern Southland Tspt", "Summerland Transport", "Seaton Couriers", "NZ Couriers" and "Waikaka Freight".

...(12) The "Quantity (LM)" column was calculated using Excel array formula, like this:

...(29) This template does not use the "Product#" column. It is moved outside of the printable area and assigned a formula to make it equals to product description, like this:

Bill Format for Painting Servicec4087

Bill Format for Painting Service

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

...(96) Another picture added to the form is located on the top of the invoice, which is a normal picture object (i.e. added by clicking the "Picture" command on Excel "Insert" ribbon tab). Since this picture is placed above Excel normal cells, the underlying cells are no longer easily selectable - so we place this picture on top center of the bill form, where there is no editable text / field on creating invoices. Note this image is named as "oknWidget_house" to keep it on extracted Excel spreadsheet invoices (".xlsx" or ".xls") and UIS generated PDF invoice.

Excel Quotation Templatec9008

Excel Quotation Template

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

...(19) The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:

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

...(103) This blank bill template is a variant of c5020 Appliance Repair Service Bill Template / Appliance Repair Service Invoice Template here on InvoicingTemplate.com. Like c5020, as a service invoice template the form does not offer the "Shipping Address" section. To fill the blank left by moving the shipping fields out of the printable section, a carton image of a desktop computer was added. This is a vector image with transparent background so you can easily resize it by dragging the image border in design mode. Visit printable invoice template to find more options and tutorials on customizations related to printing and page setup.

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

...(17) Step 2: Open the template as usual. Click the "Design Mode" button on the "Invoice" ribbon tab.

  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.

...(52) Tip: You can click Excel menu File / Print. This shows the print preview of the current print area. Here you can change the column widths by dragging and dropping. Make sure to leave proper spaces between the double-border lines and actual content, and proper space between double-border lines and paper margins.

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

...(46) In this template sample, we will use c4074 Simple Invoice Template for Letterhead Paper as the basic template, and add a packing list to the same form on the "Invoice" worksheet, so that when an invoice is printed a corresponding packing list will be printed too.

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

...(62) Now when you click Print to print an invoice, Uniform Invoice Software will print two documents, one invoice and one packing list. However the "Extract" feature will encounter problems if you choose the exact an Excel-format worksheet - but the PDF formatted invoice and packing list work just fine. Feel free to take a look of our pdf invoice template gallery too.

Simple Sample - Changing Print Orientationc4053

Simple Sample - 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".

Pet Food Store Invoicec3013

Pet Food Shop Invoicing Format

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

...(71) Here on InvoicingTemplate.com we've already published some tutorials on customizing invoice templates regarding changing paper sizes, like Simple Invoice Template - Changing Paper Size. While many billing forms here on InvoicingTemplate.com are suitable for printing on A4 paper (210 mm X 297 mm, or 8.27 inch X 11.69 inch) or letter (8.5 inch X 11 inch), with this Pet Food Store Invoice Template we've implemented another sample of changing paper size.

...(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 Sample - Splitting City State ZIP

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

...(48) On our templates "City, State ZIP" are usually put into one single cell, like a U.S. style address line (There is an option for UK style postal code on a separate cell). This simple invoice template shows you how to extract and store separate city, state and zip.

...(33) To split the "city, state zip" value into separate cells, we have to use Excel formulas. To store the extracted city value, state value and zip value, we have to create custom fields.

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

Freelance Invoice Templatec6018

Freelance Invoice Template

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

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

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

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

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

...(116) We've already published an invoice format for freelancers, at Freelance Invoice Template; and for a list of invoicing forms that could be used by freelancers like designers, developers etc., visit Freelance Invoice Template For Service Business, Graphic Design Freelance Invoice Template, Freelance Web Design Invoice Template, etc. Unlike Freelance Invoice Template, where the calculation of line totals are done by multiply "Hours * Hourly Rate", in this billing template sample Freelance Writer Invoice Template, the amount of each line is manually fillable - this means that it is more suitable for project or contract - based billing. You can find more invoice samples for hourly-rate based invoicing under the Service Invoice Template and Consulting Invoice Template.

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.

...(60) On the other hand, to some people it may be not intuitionistic enough when they want to make their invoices stand out from competition by using a background image. Although Microsoft Excel does provided a "Background" command on the "Page Layout" ribbon tab, the background image or picture set in this way is removed (not included) in the printed result.

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

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

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

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
cm007
Lumber Company Invoice
Sunday, July 2, 2017,
12
x
A4
Landscape
Sales
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

What Is Hot

Feature Galleries