Skip to main content
InvoicingTemplate.com main content

Summary

There are many free invoice templates and bill forms in Microsoft Word format, either ".doc" or ".docx", that you could download online and use as invoice assistant.

Microsoft Word, which is part of Microsoft Office, is a perfect and industry-standard program in its area, but for invoicing and billing purpose, MS Excel as a spreadsheet program has its advantages over Word.

Both Word and Excel are able to create professional printable business documents. Word is a word processing application that is used to write documents like memos, letters or essays where text formatting is very essential.

On the other hand, Excel is a spreadsheet program that offers a worksheet / table kind of interface, so handling regular data, like invoices, is much easier with Excel; and it is much easy to do calculations with Excel, for example calculating taxes from rate and amount, calculating balance due from total and paid amount.

Feel free to visit invoice templates on Microsoft Office online.

In short, you should choose invoice templates in Excel format, instead of invoice templates for Word, unless you do invoicing only a few times in a whole year.

The following top 10 blank templates in Excel format demonstrates our point by example. All templates work with Uniform Invoice Software (UIS), which means you can utilize those powerful features provided UIS, such as automatic invoice numbering, generating and sending electronical PDF invoices (with optional PayPal payment button to accept online payments), reporting, etc.

Simple Template with Printable Watermarkc4075

Simple Format with Printable Background Image

"Simple Template with Printable Watermark" was found to be relative to Invoice Template For Word with the score grade of 95.

...(44) Microsoft Excel provides options for background images too. For example in Microsoft Excel 2013, you can go to the "Page Layout" ribbon tab, click the "Background" to open a dialog box where you can browse to choose a local image, or search online image.

  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.

Timesheetcm001

Time Sheet

"Time Sheet" was found to be relative to Invoice Template For Word with the score grade of 81.

...(102) Following the Name column, there are 7 columns for you to enter hours worked each day. This is the place to record how long each employee worked for a job. After that, you see the Total Hours column. This column is calculated automatically using Excel formula, so you don't have to calculate and type it manually. The next column, Hourly Rate column, should be manually filled in. However, if you have Uniform Invoice Software installed, the Hourly Rate can be retrieved from backend database automatically. The last column on the printable form is called Total, which is also calculated using Excel formula.

Service Receipt Templatec5047

Service Receipt Form

"Service Receipt Form" was found to be relative to Invoice Template For Word with the score grade of 70.

...(230) Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Service Receipt Template before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Service Receipt Template is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Service Receipt Template that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

Invoicing Template for Roofing Servicec5098

Invoicing Template for Roofing Service

"Bill Format for Roofing Service" was found to be relative to Invoice Template For Word with the score grade of 65.

...(219) The next important difference between this roofing and ceiling repairing invoice sample and the standard invoice sample is that, this customized version has only one tax (named "TAX") set by default. To change the taxing options, with Uniform Invoice Software installed you can simply clicking the "Settings" button on either the "Invoice" worksheet, or on the ribbon tab, and then go to the "Taxes" tab, choose the tax type (no-tax, one-tax or two taxes), set up the tax names and rates for each taxes, and then click the "Apply" button. Uniform Invoice Software will modify the form layout according to the options you choose. The Excel formulas we created for the tax cells will work well too with the options you choose from the "Taxes" tab. The support for formulas is one of the big advantages of Excel as an invoicing assistant. The other Office invoicing templates could produce clean and professional-looking business documents too, like Word or even Power Point invoicing templates, but it is far easier to do automated calculations with Excel formatted template (".xlsx" or ".xls"). This is why Excel is used for many accounting activities. On the other hand, to many people Word is the writing tool. And, this is one of the reason why we are providing all our billing templates in Excel format.

Advanced Invoicing Sample - Invoiced Total in English Wordsc5102

Advanced Invoicing Sample - Invoiced Total in English Words

"Advanced Invoicing Sample - Invoiced Total in English Words" was found to be relative to Invoice Template For Word with the score grade of 64.

...(62) As of the current implementation, Uniform Invoice Software does not contain a built in function for converting a numeric value into equal English words. Fortunately, Uniform Invoice Software is built upon Excel. Like other Office programs, Microsoft Excel supports VBA (Visual Basic for Application) macros, which you can use to extend the functionalities of Excel itself, including creation of user-defined formulas (functions).

...(13) First, to convert an ".xlsx" invoice template into ".xlsm" format, follow steps below.

  1. First open the invoice template as usual.
  2. Click Excel menu "File", and then "Save As".
  3. Choose the location to save new workbook file.
  4. On the "Save As" dialog box, from the "Save as type" drop down list choose "Excel macro-enabled workbook (*.xlsm)", and then type in the file name for the new workbook.
  5. Click "Save".

Five Price Levels (Sales, Amount, Custom Column)c5009

Form with 5 Price Levels

"Five Price Levels (Sales, Amount, Custom Column)" was found to be relative to Invoice Template For Word with the score grade of 63.

...(26) This sample of customizing invoice templates is named with the keyword "cosmetic". A new column "Color" was added to meet the requirements of the cosmetic business.

...(119) The color column is a custom field defined both in the Product and Invoice Body database tables, which is the most noticeable difference between this customized invoice template and the original 5 Price Levels (Sales, Amount) invoice template. This means that for each product, you can set its color property, and the color values are filled automatically when you choose products from the database. Like all the other invoice templates in this serials available here on InvoicingTemplate.com, the full power of the invoice template comes only with the installation of Uniform Invoice Software, although the free version of this "Form with 5 Price Levels (Sales, Amount, Custom Column)" invoice template can also help you create professional and beautiful invoices.

Simple Service Bill with Pleased Customer Imagec2033

Simple Service Invoicing Sample with Pleased Customer Image

"Simple Service Invoicing Sample with Pleased Customer Image" was found to be relative to Invoice Template For Word with the score grade of 58.

...(99) This is a simple service bill template is a revised version of c2003 Simple 2-Column Service Bill Sample hosted here on InvoicingTemplate.com. Like the original simple bill sample, it has two columns on the detail section, which are "Description" and "Amount". Another column "Product ID" (i.e. "Item #") is placed outside the print area. The summary section, which contains 4 fields - "Shipping Cost" (cell name "oknShippingCost"), "Total" (cell name "oknTotal"), "Paid" (cell name "oknPayments") and "Total Due" (cell name "Balance Due") - we moved from the bottom of the spreadsheet form to be near the "Bill To" section.

Invoicing Format for Bakery and Cake Shopc4090

Invoicing Template for Bakery and Cake Shop

"Invoicing Format for Bakery and Cake Shop" was found to be relative to Invoice Template For Word with the score grade of 55.

...(136) In this design sample the big title "INVOICE" is not a general static text, but an Excel Word Art object. Word Art is a powerful feature supported by Microsoft Office suite, including Word, Excel, and Power Point etc. Compared to general text, Word Art support more formatting options. To find this out in Excel, click to select the Word Art object, and then click and activate the "Format" ribbon tab. Note that in order to include the Word Art object in the bakery and cake shop PDF invoice, the object must be named with "oknWidget" prefix. Otherwise, it will be removed from the extracted Excel spreadsheet invoices or generated PDF invoices. For example, the command buttons, such as "Customers", "Products" and "Reports", are named with "oknCmd*" prefix, so they are all removed from the PDF invoices.

Web-hosting Invoicing Templatec2007

Web-hosting Billing Form

"Web-hosting Invoicing Template" was found to be relative to Invoice Template For Word with the score grade of 51.

...(35) This free template in Excel spreadsheet format is suitable for business and companies who offer web hosting or other service, especially those small-scale businesses that are not ready for a complicated accounting or invoicing system.

...(73) There is also a payment slip attached on the bottom of the invoice form. For those of you who are new to this - a payment slip is a document sent by a creditor to a debtor with all the necessary information filled in order a payment to take place. The debtor confirms the payment by her/his signature and the sum due to be paid, in case the latter has not been included.

Appliance Repair Service Bill Templatec5020

Appliance Repair Service Bill Template

"Appliance Repair Service Invoice Template" was found to be relative to Invoice Template For Word with the score grade of 44.

...(48) This template was originally published on our company web site uniformsoft.com with the template# "c5-020". We now revisited it and fine tune the form layout it here on InvoicingTemplate.com, and released it with the corresponding template# "c5020", and with a new template title Appliance Repair Service Bill Template.

...(138) A common requirements in the appliance repair business is that you need some fields to record the identifier of the device / appliance. Like in the auto repair invoice design, there are fields for auto maker, auto color and auto model. In this form design, there two fields designed for this purpose, which are "Computer Model" and "Computer Serial#". If you want to modify these labels to more common words like "Appliance Model" and "Appliance Serial#", it is easy to do with the help from Uniform Invoice Software. You can simply switch to design mode by clicking the "Design Mode" button on Excel "Invoice" ribbon tab, and then type in your own text to replace the existing labels. In fact, your own business name (as a service provider), address and contact information are entered in the same way.

Invoicing Sample for Cosmetics Shopsc4095

Billing Template for Cosmetics Shops

"Billing Template for Cosmetics Shops" was found to be relative to Invoice Template For Word with the score grade of 43.

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

Automotive Sample Invoice Templatec9001

Automotive Sample Invoice Format

"Automotive Sample Invoice Template" was found to be relative to Invoice Template For Word with the score grade of 40.

...(21)Automotive Sample Invoice Template is the sample invoice template shipped with Excel Invoice Manager that demonstrating the use of custom fields.

Medical Invoice Template (2)c7017

Medical Billing Form (2)

"Medical Billing Form (2)" was found to be relative to Invoice Template For Word with the score grade of 38.

...(89) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Medical Invoice Template (2) with your own image, follow the steps below:

Blank Sales Invoicing Sample (One-tax, Long Description)c2022

Blank Sales Invoicing Sample (One-tax, Long Description)

"Blank Sales Billing Sample (One-tax, Long Description)" was found to be relative to Invoice Template For Word with the score grade of 36.

...(26) So if you have one tax to charge on your sales invoices and need to write relatively long product description, this template is suitable for you.

...(172) One of the most common accounting documents is the invoice. The purpose of a sales invoice is to document a transaction. The sales invoice provides the seller with a record of what has been sold, when the transaction has taken place and how much money is involved. In bookkeeping, sales invoices provide you with vital information about your company's financial history. In taxing, sales invoices provide documentation to back up the information you provide on your tax forms. In inventory, a sales invoice can be useful to both buyers and sellers for the purpose of tracking inventory. As How to Write an Invoice for Your Ecommerce Sales states, tax is one of the important detail to make clear on an invoice. With the help of this template, c2022 Blank Sales Invoicing Sample (One-tax, Long Description) or Blank Sales Billing Sample (One-tax, Long Description), the calculation of tax, as well as subtotal, total and balance due, all done in an automatic way using Excel formulas, so you never have to do it manually.

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 Invoice Template For Word with the score grade of 32.

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

Excel Shipping Invoice with Printable Truck Background Imagec5087

Shipping Invoice with Printable Truck Background

"Excel Shipping Invoice with Printable Truck Background Image" was found to be relative to Invoice Template For Word with the score grade of 28.

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

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

Packing List Templatecn010

Packing Slip Form

"Packing List Template" was found to be relative to Invoice Template For Word with the score grade of 16.

...(81) If you use the freeware version of our packing list template, there is no need to install Uniform Invoice Software. But if you need those advanced features, such as management of customers, products, invoices and payments, or want to be able to convert an invoice to a packing list, installing Uniform Invoice Software is necessary. The trial version of Uniform Invoice Software works for 30 days, within this period you can test it to see if it meets your business requirements.

Music Store Invoice Template (Retail)c5010

Music Store Invoicing Form (Retail)

"Music Store Invoice Template (Retail)" was found to be relative to Invoice Template For Word with the score grade of 11.

...(86) Adding a custom field to the "InvBdy" database table makes it possible to save the data on the invoice spreadsheet to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the "InvBdy" database table allows save the type value on the invoicing form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Music Store Invoice Template (Retail).

VAT Invoicing Sample with 2 Separate Ratesc5005

VAT Invoicing Sample with 2 Separate Rates

"VAT Invoicing Sample with 2 Separate Rates" was found to be relative to Invoice Template For Word with the score grade of 9.

...(11) To show gridlines and row/column headers in Excel 2000 - 2003:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

...(40) After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4075
Simple Template with Printable Watermark
Tuesday, June 28, 2016,
20
4
A4
Portrait
Sales
c9007
Commercial Invoice Format with Editable Word Art Logo
Wednesday, July 13, 2016,
9
9
A4
Landscape
Pro-forma
cm001
Timesheet
Sunday, October 27, 2013,
26
x
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c5047
Service Receipt Template
Wednesday, January 8, 2014,
12
5
A4
Portrait
Receipt
c5098
Invoicing Template for Roofing Service
Sunday, October 23, 2016,
12
5
A4
Portrait
Service
c5102
Advanced Invoicing Sample - Invoiced Total in English Words
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c5009
Five Price Levels (Sales, Amount, Custom Column)
Friday, November 15, 2013,
30
5
A4
Portrait
Sales
c2033
Simple Service Bill with Pleased Customer Image
Wednesday, July 27, 2016,
12
2
A4
Portrait
Service
c4090
Invoicing Format for Bakery and Cake Shop
Friday, October 21, 2016,
8
4
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c2007
Web-hosting Invoicing Template
Wednesday, October 23, 2013,
6
2
A4
Portrait
Service
c5020
Appliance Repair Service Bill Template
Thursday, August 18, 2016,
12
5
A4
Portrait
Service
c4095
Invoicing Sample for Cosmetics Shops
Saturday, October 29, 2016,
12
4
A4
Portrait
Sales
c9001
Automotive Sample Invoice Template
Sunday, January 12, 2014,
28
9
A4
Portrait
Sales
c7017
Medical Invoice Template (2)
Friday, January 17, 2014,
8
7
A4
Landscape
Service
c2022
Blank Sales Invoicing Sample (One-tax, Long Description)
Tuesday, November 24, 2015,
6
2
A4
Portrait
Sales
c4080
Invoice and Packing List on Separate Worksheet
Sunday, July 10, 2016,
20
4
A4
Portrait
Sales
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
cn010
Packing List Template
Thursday, October 24, 2013,
12
x
A4
Portrait
Other
c5010
Music Store Invoice Template (Retail)
Friday, September 19, 2014,
12
5
A4
Portrait
Sales
c5005
VAT Invoicing Sample with 2 Separate Rates
Saturday, April 26, 2014,
12
5
A4
Portrait
Sales

What Is Hot

Feature Galleries