Skip to main content
InvoicingTemplate.com main content

Summary

There are many free invoice templates 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.

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

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

  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.

... This free Timesheet template designed by InvoicingTemplate.com is in Microsoft Excel (xls) format. You can use it with Excel 2003, 2007, 2010 or 2013. A timesheet (or time sheet) is a method for recording the amount of a worker's time spent on each job. Originally developed for an employer to determine payroll, timesheets are not just for payroll any more. Timesheets may record the start and end time of tasks, or just the duration. This information may be used for payroll, client billing, and increasingly for project costing, estimation, tracking and management.

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

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

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

Bill Format for Roofing Service

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

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

... Most templates here on InvoicingTemplate.com are ".xlsx" files. ".xlsx" workbooks are Microsoft Excel Open XML Format Spreadsheet files. It's an XML-based spreadsheet file created by Microsoft Excel version 2007 and later. One limitation of ".xlsx" format is that it cannot store macros (i.e. VBA codes). To save the macro function code with the Excel invoicing template, you have to firstly convert your template into ".xlsm" format, which is called "Excel macro-enabled Workbook". See c5101 - Advanced Invoice Sample - Macro-Enabled Invoicing Template for more information on this topic.

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

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

Five Price Levels (Sales, Amount, Custom Column)

"Form with 5 Price Levels" was found to be relative to Invoice Template For Word with the score grade of 63.

... 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 Bill with Pleased Customer Image" was found to be relative to Invoice Template For Word with the score grade of 58.

... As a business document, a service bill should clearly show your customer what services are offered, and at what prices they are charged. This is always the key to reduce doubts and ensure you can get payments on time. Besides that, by putting a related image on your bills you can easily make your invoices lively - It is an easy way to make your clients remember your businesses, and also a chance to get returning customers.

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

... This template still leaves the "Paid" and "Total Due" cells inside the printable area. In many situations, a bakery bill or cake shop bill are paid with cash, so these fields may not be required. You can easily move these cells out of the printable form to create a cash bill format or cash memo bill format. See Customizing Invoicing Template to find more information regarding further customizations. All the templates here on InvoicingTemplate.com are customizable - i.e. you can either download a template and use it, or create a customized copy of this according to your special business requirements. See c4045 Catering Invoice Template for a sample.

Web-hosting Invoicing Templatec2007

Web-hosting Invoicing Template

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

... The template has two columns, a description column and an amount column. The amount column is manually editable, as it is not calculated from something like Quantity and Price, or Hourly and Rate. This makes the template suitable for general service businesses. With the "Description" column you can enter the service performed, such as the hosting plan a client purchased from you.

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

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

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

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

... This sample is implemented as a sales invoicing template. For stores that don't ship goods, and you need more lines on the detail section, you can move the "Shipping To" section out of the printable invoicing form, and then adjust the layout of the "Bill To" section to leave space for the detail section.

Automotive Sample Invoice Templatec9001

Automotive Sample Invoice Format

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

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.

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

... If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

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

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

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

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

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

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

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

Excel Shipping Invoice with Printable Truck Background Image

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

... In this sample invoice template, we use c5013 Shipping Invoice Template (1) as the basic invoice template, add a truck background image to its print result (as well as the PDF shipping invoice), and discuss the key points involved in the customization process. PDF is an idea format for sending out your electronic shipping invoice. Here on InvoicingTemplate.com we also have a list of PDF invoice templates for you to choose from.

... First, if a cell has a background set, the cell background covers the truck background image. Our original shipping invoice template has background set for a number of cells, like the column heading cells "#", "Description", "Quantity", "Unit Price" and "Line Total". The rows in the invoice detail section are set with striped gray background. To clear all the background settings for all the cells in the Print_Area range, follow the steps below (However, make a backup copy of your current template before modifying it).

Packing List Templatecn010

Packing List Template

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

... The free Packing List Template is provided in Excel spreadsheet format, and like all the other templates on here on InvoicingTemplate.com, it is created by modifying the default invoice template shipped with Uniform Invoice Software setup program, which make it works seamlessly with Uniform Invoice Software. The packing slip template is designed to look professional and classic. The spreadsheet automatically calculates weight totals. The template has fields for Packing List Number, Shipping Date, Customer ID, Ship To Address, Payment Terms, Shipping Method, and for each shipped product, you can detail the Product #, Description and Quantity. On the bottom of the form, there is also a notes field that allows you to enter any comments regarding the order and shipment.

Music Store Invoice Template (Retail)c5010

Music Store Invoicing Form (Retail)

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

... 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. Music Store Invoice Template (Retail) 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.

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.

... To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

  1. Set VAT tax rates.

    Open the template in Excel. Click the Settings button. On the Taxes tab specify the tax rates for the two VAT taxes. Click Apply.

  2. Create new customer accounts.

    New customers can be added by either clicking the Save As New Customer button on the Excel spreadsheet form, or by using the New Customer window that can be opened by clicking the Customers button on the Invoice worksheet.

    In either way, you can enter the VAT ID (VAT #) of the customer.

    When creating invoices, you pick up a customer by clicking the icon button, the VAT ID of the customer is retrieved along with other customer information. If a VAT ID is present, the invoice is VAT free.

  3. Create product/service items.

    To add new products, click the Products button on the Invoice worksheet, and then click Add Product. On the New Product window, you can find a TaxCategory field on the Custom Fields tab; with this field you can specify the tax category of the current product or service item. Please make sure the tax category you enter here matches the tax name you enter on the Settings window.

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