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.

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

Fillable Billing Template for Furniture and Appliances

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

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

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.

...(59) The protection of the "Invoice" worksheet in Service Credit Note 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 Service Credit Note Template.

  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.

Clothing Store (Manufacturer) Invoice with Size Breakdowncm003

Clothing Store (Manufacturer) Format with Size Breakdown

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

...(53)Clothing Store (Manufacturer) Invoice Format with Size Breakdown has other two columns that designed specifically for clothing store and manufacturers that are "Style #and Color". The actual usage of these fields could vary from business and business, but general speaking, they allow you to further detail the items and products you are selling.

...(87) There is also a "Discount" field on the bottom of the form, which is implemented as an amount value. The form firstly calculates the subtotal (cell name "oknSubtotal") using Excel formula "=SUM(oknLineTotal_1:oknLineTotal_12)", and then calculates Total (cell name "oknTotal") using Excel formula " =ROUND(oknSubTotal - oknDiscount + oknShippingCost + IF(oknTaxType = 0,0,IF ( oknTaxType = 1,oknTax1, oknTax1 + oknTax2 )), 2)". This is one of the advantages of using Excel formatted invoice templates as you can easily using formulas to define the relationships between cells and fields.

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.

...(45) Step 4: Click Excel menu "File", and then "Print". Excel shows in preview how many pages it required to print the current form. In this case, Excel shows that it requires two pages to print the original voucher form with the new B5 paper size.

...(49) Step 5: Inspect the preview image. On the vertical direction, without scaling one page height is enough to print the original form. On the horizontal direction, the width is not enough - by default it is able to print 4 columns only, but our payment voucher has 5 columns.

Invoice with Date Columnc4004

Template with Date Column

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

...(85) Adding a new column is a bit complex than just moving cells. With the previous generation of Uniform Invoice Software, which is named Excel Invoice Manager, you have to use Database Designer to add new fields to the Invoice Body database definition file and database table (and the field with the same name to the Product table, if you wish to fill the cell automatically when a product / service item is picked up), and then name the cells based on the database field name.

Simple Invoice Sample - Sales Rep Name on Product Reportc5084

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

...(90) However if you are a business manager you may also find it is helpful to include the sales representative name on the product report, so that you have an easy way to know who sold out what products in the specified date range. So in this simple invoice template, we'll see the detailed procedure on customizing an existing invoice template to add this feature. We'll be using the default sales invoice template shipped with Uniform Invoice Software setup program as our base invoice template and starting point of the customization.

Excel Quotation Templatec9008

Excel Quotation Template

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

...(38) This free quotation and estimation template in Microsoft Excel ".xlsx" format provides a sample of customizing the default invoice template shipped with Uniform Invoice Software. It implements a special / complex discounting model to meet practical business requirements.

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

...(41) The formula for "Line Total" incorporates both the auto-calculated portion, and the manually fillable field ("oknLineTotalManual_?" fields, placed outside the printable area, which means it is manually editable on creating invoices / estimations, but will not be included on printable invoices).

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

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

...(131) In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Excel Payment Voucher 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.

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.

...(138) 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. General Quote Template for Excel 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.

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.

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

...(119) For this reason, the "ESTIMATE#" support all the features assigned to the "Invoice#" cell by Uniform Invoice Software. For example, if you click "Save To DB" or "Save Invoice", a sequential, progressive and unique estimate# is generated automatically if the "Estimate#" cell is left blank (see our gallery page at Excel Invoice Template Automatic Invoice Numbering). With pure-Excel spreadsheet solutions, this automatic numbering is not possible without using macros. To display / retrieve an existing estimate or quote, you can simply enter the estimate# into the cell. With the support from Uniform Invoice Software, the pure-Excel spreadsheet template is not only printable, but also enables features that could be hardly to implement with pure-Excel estimating and quoting software apps.

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.

...(60) First of all, the most important item to include on the receipts is the name and status of charity / organization name. It must be a non-profit, meaning you have 501c3 status under the federal government. In our donation receipt design, we simply used the fields that are usually for seller information, located on the top of the Excel form.

...(25) Third, it is also required to clearly describe the donation, including the date the donation was made, as well as the amount of the donation.

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

...(111) This Excel labor invoice template calculates line totals from hours and hourly rates. There are many other samples here on InvoicingTemplate.com that could be used for invoicing parts, labors and services. For example, Invoice Template Labor Excel Spreadsheet, Contract Labor Invoice Template and Excel Job Invoice Template collect the top 10 invoice templates in our database that are closely related to labor invoicing; for specific implementations, there are samples like Handyman Invoice Template, Engineering Service Invoice Template, Welding and Fabrication Service Invoice Template, Freelance Invoice Template, etc. Still not find your desired invoice template? We've developed a search box for you to find and download invoice template with template# or name.

Parts and Labor Invoicing Formatc4071

Parts and Labor Billing Format for Excel

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

...(96) The tax calculation methods differs completely from the default invoice template shipped with Uniform Invoice Software, where two taxes (if two taxes are all applied / enabled for the template) are all applied to all the items listed on the template. Since this design breaks the assumption of the locations of tax cells, you cannot adjust the number of taxes using the features on the "Taxes" tab on "Settings" window inside Uniform Invoice Software. On the other hand, Uniform Invoice Software will have no problem to help you adjust the tax names and rates for you.

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.

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

Service Bill with Profit and Taxable Columnc5063

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

...(51) This customization job could be done in 4 main steps. First, you have to unprotect the "Invoice" worksheet; secondly, switch the template into design mode, so that you can move the buttons and controls; third, move the cells and controls; and finally, you turn on protection and switch off design mode.

Note that if you use the Uniform Invoice Software and need to show the control on an extracted worksheet, then the control should be named with an "oknWidget_" prefix. For example, if you move the Taxable checkboxes into the , then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

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.

...(10) As detailed on belastingdienst.nl, an invoice should include the following:

...(37) This Netherland sales billing template meets above requirements, and all the labels on this template are translated into Dutch. For example, "Bill To" on the default template is now "Factuuradres", "Ship To" becomes "fleveradres", "VAT" becomes "BTW".

...(35) This Netherland Sales Invoicing Sample does not show currency symbols on the invoice form and the printed invoices. If you would like to change or set the currency symbol, here is how to do it.

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.

...(28) However, if you have only taxable or non-taxable products, it's wise to prevent the taxable boxes from printing, or even to delete the taxable boxes / controls completely.

...(64) Now let's see how to move the Taxable controls. There are in fact two forms of taxable controls implemented in the templates available here on InvoicingTemplate.com. Some of them are implemented as ActiveX controls, and some of them are implemented as Office form controls. No matter what the control types are, the steps required to move the controls are the same, as detailed below.

Invoicing Template in Eurosc4100

Invoicing Format in Euros

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

  1. Backup the template before you modifying the template.
  2. Click the "Design Mode" button. This unprotect the sheet, show gridlines and row / column headings.
  3. Click to select the cell that you want to show a currency symbol. Or, if you want to make the change for multiple cells, push CTRL key on keyboard and click each cell one by one.
  4. Right-click one of the selected cell and choose "Format Cells" from Excel shortcut menu.
  5. On the "Number" tab, choose "Accounting" from the "Category" list, make sure "Decimal Place" is "2", and from the "Symbol" list choose Euro.
  6. Once done, click the "Design Mode" button again to exit design mode.
  7. Save the template by clicking the "Save" button on Microsoft Excel quick access toolbar.

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