Skip to main content
InvoicingTemplate.com main content

Hourly Service Billing Samplec4025

Hourly Service Billing Statement

"Hourly Service Billing Sample" was found to be relative to Editable Invoice Templates For Excel with the score grade of 96.

... c4001 Template with 4 Columns was created from the default template shipped with Uniform Invoice Software, by moving the Product# column out of the printable invoicing form and placing it before the taxable column. We don't remove the product# mainly for two reasons. First, with Uniform Invoice Software the Product# is a standard field that is required. Second, with Uniform Invoice Software installed, you can retrieved item descriptions, prices and other related information from the backend database by simply entering the item# into the Product# field. This feature is called in-cell lookup, and it is useful even you are running a service business, because it helps you avoid typing same content again and again once it is save to database.

Editable Bill Sample for Furniture and Appliancesc5100

Editable Bill Sample for Furniture and Appliances

"Fillable Billing Template for Furniture and Appliances" was found to be relative to Editable Invoice Templates For Excel with the score grade of 86.

... The idea to remove the "Taxable" boxes is that for many business entities either all the invoiced items are taxable, or all are not taxable (or tax-exempt). In such situation showing the "Taxable" boxes on the printable form is not necessary and redundant, as the boxes occupy editable Description space on the form. With the removal of the "Taxable" options, we also modify the Excel formula assigned to the fields that calculates taxes. So in this version, taxes are calculated based "oknSubtotal", but not "oknLineTotalTaxable".

... Unlike Microsoft Word (".doc" or ".docx" format), the background image / watermark we added to an Excel file (".xls" or ".xlsx" format) does not show in the edit mode. Instead, it shows only on the printed document, or the PDF format editable bill sample for furniture and appliances.

Service Credit Note Templatec5046

Service Credit Memo Template

"Service Credit Memo Template" was found to be relative to Editable Invoice Templates For Excel with the score grade of 81.

Service Credit Note Template is a variant of Credit Note Template. It differs from the original one by moving all shipping fields out of the printable credit note form, making the template more suitable for service business.

... In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Service Credit Note Template. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

... The gridlines and row/column headings could help a lot when design the layout of the form.

Clothing Store (Manufacturer) Invoice with Size Breakdowncm003

Clothing Store (Manufacturer) Format with Size Breakdown

"Clothing Store (Manufacturer) Invoice with Size Breakdown" was found to be relative to Editable Invoice Templates For Excel with the score grade of 81.

... If you need to set "Lock" property yourself on designing an invoice template (to prevent Excel from showing a warning on the cells that have formulas when the spreadsheet is protected), first you have to switch the template into design mode by clicking the "Design Mode" button on the "Invoice" worksheet, and then drag your mouse to select all the cells which you want to set the "lock" property for. And then, right-click one of the selected cells and then choose "Format Cells". On the "Protection" tab, check or uncheck the "lock" property to make the cells editable / not editable when the spreadsheet is protected.

... 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 Clothing Store (Manufacturer) Invoice with Size Breakdown.

Payment Voucher Template for B5 Paperc5086

Payment Voucher Template for B5 Paper

"Payment Voucher Template for B5 Paper" was found to be relative to Editable Invoice Templates For Excel with the score grade of 79.

The print result of an Excel form usually is usually not ideal if the paper size isn't what the Excel form designed for. This sample Payment Voucher Template for B5 Paper demonstrates how to adjust the form design for a changed paper size.

... Step 3: Go to Excel "Page Layout" ribbon, in "Page Setup" group click "Size" and then choose B5 paper size.

... With this template, we removed all the product / item buttons. They are no longer necessary because Uniform Invoice Software now supports the "on-sheet" picker button. When you enable this function, the invoicing software shows a small button automatically whenever you click a product / item row, allowing you to open the list of all products / items, where you can search and select one or multiple items.

Invoice with Date Columnc4004

Invoice with Date Column

"Invoice with Date Column" was found to be relative to Editable Invoice Templates For Excel with the score grade of 71.

... Of course you have to do some formatting work too to make the new Date column has the same style like the other columns. You can use Excel's format painter, which allows you to copy the formatting, to quickly duplicate the formatting (background color, border style etc) of an entire column. Next, format the Date column with appropriate date format - to do this, first select all the date cells, right-click one of the selected cell and choose Format Cells. On the Format Cells dialog box, go to the Number tab, and then choose Date from the Category list. On the right-hand of the tab, you can find various date formats that you can choose. Pick the one you like and click OK to close the Format Cells dialog box.

Simple Invoice Sample - Sales Rep Name on Product Reportc5084

Simple Invoicing Sample - Sales Rep Name on Product Report

"Simple Invoice Sample - Sales Rep Name on Product Report" was found to be relative to Editable Invoice Templates For Excel with the score grade of 56.

The default product report does not include sales representative name. This simple tutorial on customization demonstrates how to add the sales rep name to the product report by using custom fields.

... Note that on the invoicing templates we're publishing here on InvoicingTemplate.com, the term "price" is the money the client / customer pay you for each unit of product / service they purchase; on the other hand, we use the term "cost" for the money you pay to your vendor. In case of selling of goods / materials, "price - cost" results in the gross profit of each unit you sell out. On most of our invoicing formats, you see only the "Price" or "Unit Price" column, because the "Cost" fields are put into a hidden column.

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Excel Payment Voucher Template" was found to be relative to Editable Invoice Templates For Excel with the score grade of 54.

Excel Payment Voucher Template is a sample voucher template created from Payment Voucher Template (Golden Shop). It differs from the original voucher template in that this sample Excel voucher template is suitable for general business.

... The protection of the "Invoice" worksheet in Excel Payment Voucher Template prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Excel Payment Voucher Template.

... (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 Excel Payment Voucher Template with your own image, follow the steps below:

General Quote Template for Excelc2035

General Quote Format in Excel Spreadsheet Format

"General Quote Format in Excel Spreadsheet Format" was found to be relative to Editable Invoice Templates For Excel with the score grade of 53.

... As an Excel spreadsheet template, we use Excel formulas to calculate subtotal, tax and total. For example, for the subtotal field, the Excel formula assigned to the subtotal field is "=SUM(oknLinetotal_1:oknLinetotal_22)". This is one of the big advantages of using Excel spreadsheet templates. While you can create beautiful and professional forms too using Microsoft Word, Publisher, PowerPoint or even Adobe Photoshop, it is much easier when you need to do some calculations. This ability, combined with custom fields (user-defined fields) supported by Uniform Invoice Software, resulting extremely flexible form designs, as you can see from the samples online here on InvoicingTemplate.com. Or see the PDF quotation sample to find out what it will like when your customer receive the quotation created using UIS.

Job Estimate Template for Excelc4084

Job Estimate Template for Excel

"Job Estimate Template for Excel" was found to be relative to Editable Invoice Templates For Excel with the score grade of 44.

This job and work estimate template in Excel spreadsheet format is a design based on c4009 Service Proposal and Quote. With this blank sample template, we move in the "ESTIMATE#" cell and the "Item#" column.

... On the top of the blank estimate form you see the service business name. Next to it is the highlighted "ESTIMATE#" and "ESTIMATE DATE" fields. These fields are essentially the "Invoice#" and "Invoice Date" cells that appear on most free invoice templates here on InvoicingTemplate.com.

... With Uniform Invoice Software, the auto-generation of invoice# (in this case, estimate# or quote#) is based on a counter stored in the backend Access database.

Donation Receipt Template for Excelc1004

Donation Receipt Template for Excel

"Donation Receipt Format for Excel" was found to be relative to Editable Invoice Templates For Excel with the score grade of 38.

... While not required, this form includes a "Receipt#" field on the top of the form under the "Date" field. If you have used one of our form designs for invoicing, you may know it is just the "Invoice#" field - we just place a new label "Receipt#" before the cell. So all features Uniform Invoice Software offer for the "Invoice#" field, works for the "Receipt#" field too. For example, the automatic receipt numbering feature, which generates a unique, sequential and unique based on a counter stored in the backend database. You can also retrieve information about an already-saved receipt by type in the receipt number into the "Receipt#" field.

Labor Invoicing Samplec4070

Labor Billing Format for Excel

"Labor Billing Format for Excel" was found to be relative to Editable Invoice Templates For Excel with the score grade of 37.

... (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 Labor Invoice Template with your own image, follow the steps below:

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

Parts and Labor Invoicing Formatc4071

Parts and Labor Billing Format for Excel

"Parts and Labor Billing Format for Excel" was found to be relative to Editable Invoice Templates For Excel with the score grade of 33.

... For example, in the first section for labor / service, where you itemize the work or job that you have done. The default tax name is "tax 1" in this part, with the calculation formula assigned as "=ROUND(oknTax1Rate*SUM(oknLinetotal_1:oknLinetotal_6),2)"; and the formula of the total charges for labor / service is calculated with the formula "=ROUND(oknTax1+SUM(oknLinetotal_1:oknLinetotal_6),2)".

... Note that if you or your client are UK (United Kingdom)-based, your invoices must meet specific requirements as detailed on Invoicing and taking payment from customers, and our sample templates include Hourly Service Invoice Template (UK Currency) etc. For Australian-based users, note the Requirements on Issuing tax invoices, and we've built sample Excel invoice templates here on InvoicingTempte.com, including Australian GST Invoice Template, Australian GST Invoice Template (2), etc.

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 Editable Invoice Templates For Excel with the score grade of 27.

If you are running a shipping business, this Excel-formatted (xlsx) shipping invoice template helps you to create beautiful and professional invoices. On revising the original shipping invoice template, we added a printable Volvo heavy truck background image.

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

PayPal Payment Button Using Custom Imagec3015

PayPal Payment Button Using Custom Image

"Excel Invoice with PayPal Payment Button Using Custom Image" was found to be relative to Editable Invoice Templates For Excel with the score grade of 21.

In this sample we look at how to use a custom image to replace the default PayPal payment button image inserted with our invoicing software app, which is in fact a Microsoft Excel picture object with a hyperlink set.

... For steps on adding the PayPal payment button to your invoices and bills, see PDF Invoice with PayPal Button.

... If you prefer to make your invoices differ from others, like to make your business stands out from the generals, you are free to replace the default image with your own, just like you can easily replace the default logo image we used on many of our forms, by using just the built-in tools provided by Microsoft Excel.

Service Bill with Profit and Taxable Columnc5063

Service Invoicing Form with Profit and Taxable Column

"Service Invoicing Form with Profit and Taxable Column" was found to be relative to Editable Invoice Templates For Excel with the score grade of 19.

Service Bill with Profit and Taxable Column is the service edition of Sales Invoicing Sample with Profit and Taxable Column. It includes no shipping address section on the printable invoicing form, but adds a "taxable" and "profit" columns.

... Once Service Bill with Profit and Taxable Column is unprotected and switched into design mode, you can now move the controls to the new location you like. To do this, click to select a control, or push the CTRL on your keyboard and then select all the controls you want to move using mouse. Then, drag (one of) the select controls to move them to the new location.

Netherland Sales Invoice Templatec6009

Netherland Sales Billing Form

"Netherland Sales Invoice Template" was found to be relative to Editable Invoice Templates For Excel with the score grade of 12.

Netherland Sales Invoicing Sample, like all the other invoicing templates here on InvoicingTemplate.com, was created based on the default template shipped with Uniform Invoice Software, but customized for Netherland sales companies.

... While the free version of Netherland Sales Invoice Template is simple, the result created by using this Microsoft Excel spreadsheet template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelancers who sales products and do need a shipping section on their invoicing form. It is a good invoice generator, but if you need more features, like management of customers, products / items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Netherland Sales Invoice Template work for you.

Simple Sample - Moving Taxable Controlsc5076

Simple Invoicing Format - Moving Taxable Controls

"Simple Sample - Moving Taxable Controls" was found to be relative to Editable Invoice Templates For Excel with the score grade of 6.

... The idea to exclude the taxable boxes from printing is to move the controls out of the printable invoicing form which is identified by the special Excel range name "Print_Area". To find out what area on your template is defined as the print area, pull down the name list that is located on the left side of the formula bar, and on the bottom of the name list choose "Print_Area". Excel selects the area defined as the printable form on the current worksheet. You may need to switch the worksheet in to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab if the worksheet is protected.

Invoicing Template in Eurosc4100

Invoicing Template in Euros

"Invoicing Template in Euros" was found to be relative to Editable Invoice Templates For Excel with the score grade of 5.

Download this free simple VAT invoice template in Excel format for invoicing in Euros. This design has a similar layout as the German version. The differences are that all labels are in English, and it shows the Euro symbol on cells, and also has a Euro watermark on the form.

... As you can see, with Microsoft Excel it is fairly easy to change the format and layout of a form design. While there are many other templates available for billing and invoicing, like Microsoft Word or Publisher, Google Docs, OpenOffice.org, even HTML + CSS or Photoshop, it is much easier to do formatting with Microsoft Excel.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4025
Hourly Service Billing Sample
Sunday, September 28, 2014,
12
4
A4
Portrait
Service
c9007
Commercial Invoice Format with Editable Word Art Logo
Wednesday, July 13, 2016,
9
9
A4
Landscape
Pro-forma
c5100
Editable Bill Sample for Furniture and Appliances
Tuesday, November 1, 2016,
12
5
A4
Portrait
Sales
c5046
Service Credit Note Template
Tuesday, January 7, 2014,
12
5
A4
Portrait
Service
cm003
Clothing Store (Manufacturer) Invoice with Size Breakdown
Monday, June 27, 2016,
12
x
A4
Portrait
Sales
c5086
Payment Voucher Template for B5 Paper
Tuesday, July 5, 2016,
12
5
A5 (148 mm x 210 mm)
Portrait
Receipt
c4004
Invoice with Date Column
Monday, November 4, 2013,
12
4
A4
Portrait
Service
c5084
Simple Invoice Sample - Sales Rep Name on Product Report
Saturday, June 25, 2016,
12
5
A4
Portrait
Sales
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c2035
General Quote Template for Excel
Friday, August 19, 2016,
18
2
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c4084
Job Estimate Template for Excel
Wednesday, August 17, 2016,
10
4
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c1004
Donation Receipt Template for Excel
Monday, August 22, 2016,
8
1
A4
Portrait
Receipt
c4070
Labor Invoicing Sample
Wednesday, May 11, 2016,
8
4
A4
Portrait
Service
c4071
Parts and Labor Invoicing Format
Thursday, May 12, 2016,
18
4
A4
Portrait
Sales
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c3015
PayPal Payment Button Using Custom Image
Thursday, August 11, 2016,
10
3
A4
Portrait
Service
c5063
Service Bill with Profit and Taxable Column
Sunday, September 21, 2014,
12
5
A4
Portrait
Service
c6009
Netherland Sales Invoice Template
Thursday, May 22, 2014,
12
6
A4
Portrait
Sales
c5076
Simple Sample - Moving Taxable Controls
Wednesday, January 27, 2016,
12
5
A4
Portrait
Sales
c4100
Invoicing Template in Euros
Tuesday, November 29, 2016,
12
4
A4
Portrait
Sales

What Is Hot

Feature Galleries