Skip to main content
InvoicingTemplate.com main content

Hourly Service Billing Samplec4025

Hourly Service Billing Sample

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

...(34) The default invoicing form calculates line totals from Quantity and Unit Price. This sample service bill template simply change the headings to Hours and Rate so that it becomes an hourly service bill template.

...(112) If you are in the service business and you charge your customers based on the time (hours) spent to render the service, this template should be a welcome addition to you if you think the item-based form layout, which is implemented in the default invoicing template shipped with Uniform Invoice Software, never quite matches the nature of your business. This ready-to-use template could be your favor on creating invoices, quotes or estimates. It offers a professional yet simple Hourly Billing Sample that can help you in creating service based invoices quickly and effectively. This template is created using Microsoft xlsx format so that anyone can easily use it for his/her own purpose.

Editable Bill Sample for Furniture and Appliancesc5100

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

...(45) This invoicing format is basically the default template shipped with Uniform Invoice Software (UIS), but with the "Taxable" boxes removed and an image of furniture and appliances on it. This sample template is suitable for stores and manufacturers that operate as a retailer or wholesaler.

...(48) 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 Note Template" was found to be relative to Editable Invoice Templates For Excel with the score grade of 81.

...(34) The result template of this customization can be downloaded for free here on InvoicingTemplate.com. If you are interesting in the implementation details on how to create this customized service credit note template, read on.

...(14) Moving a cell or a group of cells in an Excel template is easy.

...(233) 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 Credit Note 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 Credit Note 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 Credit Note 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.

Clothing Store (Manufacturer) Invoice with Size Breakdowncm003

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

...(88) 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 Format for B5 Paper

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

...(96) Like the original template, this new design does not use the customer account feature - that is, when run with Uniform Invoice Software, it does not distinguish between customers, and thus not keep customer accounting / bookkeeping data. We simply assign a letter "A" automatically to the field "oknWhoID" (database field "CustomerID" in both the "Customer" and "Invoice Header" database tables), so that Uniform Invoice Software will not create a new customer account. With this voucher format, The "Name" and "Address" field on the printable form is always manually entered (See all our editable invoicing templates).

Invoice with Date Columnc4004

Invoice with Date Column

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

...(130) 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 Invoicing Sample - Sales Rep Name on Product Report" was found to be relative to Editable Invoice Templates For Excel with the score grade of 56.

...(96) 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 Quotation Templatec9008

Excel Quotation Format with Special Discounting Model

"Excel Quotation Format with Special Discounting Model" was found to be relative to Editable Invoice Templates For Excel with the score grade of 54.

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

...(15) The "LESS" is also a manually editable field, which is designed as a percentage value.

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

Excel Payment Voucher Templatec5052

Excel Payment Voucher Template

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

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

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

...(123) 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 in Excel Format

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

...(47) While in the Estimate Templates gallery we've already published several templates that could be used for estimating and quoting purpose, like the General Estimate Template and Telecom Consultant Estimation Template, this template differs from other in the number of columns and the layout of the form itself.

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

...(25) 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 Format for Excel

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

...(109) 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 Invoicing Sample" was found to be relative to Editable Invoice Templates For Excel with the score grade of 33.

...(32) Just like most Excel sample invoicing template here on InvoicingTemplate.com, Labor Invoice Template has a logo placeholder image on the top of the form, which you can replace with your own image.

...(100) 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 27.

...(76) This free printable parts and labor billing format for Microsoft Excel shipping and delivery information, unit prices, rate, and more, as well as a box in which to note the date and invoice number. You can also download a PDF version of this template here on InvoicingTemplate.com. Unlike the our Excel labor invoice template, the detail section on this invoicing form is divided into two section, each section has its own tax rate and calculation formula.

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

"Excel Shipping Invoice with Printable Truck Background Image" was found to be relative to Editable Invoice Templates For Excel with the score grade of 21.

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

Service Bill with Profit and Taxable Columnc5063

Service Invoicing Form with Profit and Taxable Column

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

...(86)Service Bill with Profit and Taxable Column, like the default template, has two tax items on the bottom of the worksheet, which are applied to all the items, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version and the Uniform Invoice Software version.

Transportation Invoicec5014

Transportation Bill Format

"Transportation Bill Format" was found to be relative to Editable Invoice Templates For Excel with the score grade of 12.

...(33) Here on InvoicingTemplate.com we've already published several templates related to transportation business. For example, c5013 Shipping Invoice Template, c5048 Shipping Invoice Template (2), and c5087 Excel Shipping Invoice with Printable Truck Background Image.

...(30) As a service template, it does not require the fields/cells related to shipping. The oknSalesRepName cell in the original default invoice template now has a new label, "Account Executive Name".

Table nameField nameField type
InvHdrAccountBalancedecimal (12,2)
InvHdrTotalBalancedecimal (12,2)
InvBdyItemDatedate
InvBdyPassengertext (60)
ProductItemDatedate
ProductPassengertext (60)

Simple Sample - Moving Taxable Controlsc5076

Simple Invoicing Format - Moving Taxable Controls

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

  1. First of all, back up your template. It is always recommended to back up the template before modifying the layout and format. This way, you could easily return to a working state in case something goes wrong during customization.
  2. Now click to push down the "Design Mode" button on the "Invoice" ribbon tab. This switch the spreadsheet into design mode, showing gridlines and column / row headings, unprotecting the sheet, as well as push down the "Design" button on Excel "Developer" ribbon tab (The "Developer" ribbon tab is not visible by default).
  3. Now push down the CTRL key on your keyboard. Without releasing the CTRL key, click the taxable boxes one by one with your mouse. This select the taxable controls that you click.
  4. Once all the taxable boxes are selected, release the keyboard CTRL key.
  5. Click and drag one of the taxable box. Drop it outside the printable area - in this sample, we put it on $C10. By dragging and dropping one of the selected controls, all the selected controls are moved to the new location.
  6. If you want to delete the controls completely, with all the controls still selected, hit DEL key on your keyboard. If you want to leave them there, skip this step.
  7. You can also modify the formulas of the tax fields to have them ignore the value of the taxable boxes completely. If all your products or items are always taxable, modify the formula of the first tax cell to " =ROUND( IF ( oknTaxType =0 ,0, oknTax1Rate * ( oknSubTotal + IF( oknTaxTotalIncludingShippingCost =0,0, oknShippingCost ))),2)"; and modify the formula of the second tax cell to " =ROUND ( IF( oknTaxType <> 2,0, oknTax2Rate * ( oknSubTotal + IF ( oknTaxTotalIncludingShippingCost = 0,0, oknShippingCost )+IF( oknTax2IsAppliedToTax1= 0 ,0, oknTax1 ))),2) ". If all your products / items are not taxable, simply choose "No-tax" from the "Taxes" page of the Settings dialog box that could be opened by clicking the "Settings" button on the "Invoice" ribbon tab.
  8. Now modify the column heading of the original "#/Taxable" column. To do this, simply replace the text "#/Taxable" with something like "Item#" or simply "#".
  9. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab again.
  10. Once done, save the template by clicking the Save button on Excel quick access toolbar.

Invoicing Template in Eurosc4100

Invoicing Format in Euros

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

...(50) As a simple customized sample of VAT invoice created for Germany (See c4098 Sales Invoicing Format for Germany and Service Billing Template for Germany), we make the currency symbol shown for the appropriate cells. This customization is easy and simple. If you are interesting in the details, here is how.

...(56) 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
c9008
Excel Quotation Template
Friday, February 10, 2017,
37
9
A4
Portrait
Other
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
c5063
Service Bill with Profit and Taxable Column
Sunday, September 21, 2014,
12
5
A4
Portrait
Service
c5014
Transportation Invoice
Thursday, March 16, 2017,
16
5
A4
Portrait
Service
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