Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Hourly Service Bill Sample (Price Including Tax). Double-click the downloaded file to extract all files.
  2. Open the template "hourlyservicepriceincludingtax.xlsx" or "hourlyservicepriceincludingtax-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Hourly Service Bill Sample (Price Including Tax)

Hourly Service Bill Sample (Price Including Tax) (c5068)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Hourly Service Bill Sample (Price Including Tax) - freeware edition

Hourly Service Bill Sample (Price Including Tax) - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Hourly Service Bill Sample (Price Including Tax) - Uniform Invoice Software V3 edition

Hourly Service Bill Sample (Price Including Tax) - Uniform Invoice Software V3 edition

Download Hourly Service Bill Sample (Price Including Tax) (c5068)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

282 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.77 MBDownload

Detail

Hourly Service Invoice Template (Price Including Tax) is a variant and customized version of Hourly Service Billing Form. It differs from the original template by adding a Tax column to the printable invoicing form, assuming prices including taxes.

Hourly Service Invoice Template (Price Including Tax), 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.

If you use the Uniform Invoice Software version of Hourly Service Invoice Template (Price Including Tax), there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Hourly Service Billing Format, which has been assigned with the template# of c4025 here on InvoicingTemplate.com, has only one tax set by default on the bottom of the form, which is named GST (Goods and Service Tax). c4025 is a currency- neutral invoicing format, meaning that it does not show currency on the prices and amounts. If you need to see an sample how customizing the currency symbol, see Hourly Service Billing Format (UK Currency) where we changed the currency symbol to United Kingdom pound. This template, Hourly Service Billing Format (Price Including Tax), or Hourly Service Billing Statement (Price Including Tax), details the tax calculations by adding a special "Tax" column to the printable invoice detail section. With this implementation, the template assumes that the prices already include tax. So in this template, the tax of each item is calculated with a formula like this:

=round(if(oknTaxable_1, oknLineTotal_1 * (1- 1/(1+oknTax1Rate)), 0,2)

The above formula means that, if the current item is taxable, the amount of tax will be "Line Total * (1-1/(1+Tax Rate)). For example, if the price is 10 and the quantity is 1, tax rate is 17.50%, then the tax amount equals 1.49 after rounding to 2 decimal digits. Also, in the example, the net price is 8.51.

A VAT sales invoicing format is also available here on InvoicingTemplate.com, at c6007 VAT Sales Invoicing Format - Price Including Tax. The VAT service billing design is located at c6013 VAT Service Billing Form - Price Including Tax. If you would like a version where prices excluding taxes, see c5069 Hourly Service (Price Excluding Tax). Or, the sales VAT version where the prices excluding taxes, is located at c6008 VAT Sales - Price Excluding Tax. Or, the service VAT version where the prices excluding taxes, is located at c6014 VAT Service - Price Excluding Tax.

In order to create this invoicing sample, we added a custom field to the invoice body database table.

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. Hourly Service Invoice Template (Price Including Tax) 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.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Hourly Service Invoice Template (Price Including Tax) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

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 Hourly Service Invoice Template (Price Including Tax).

When working with Uniform Invoice Software (UIS) version of Hourly Service Invoice Template (Price Including Tax), how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template Hourly Service Invoice Template (Price Including Tax) and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

In order to create this template, we adjust the existing columns to leave space for the new Tax column.

To adjust the existing columns to leave space for new column or columns that will be added to the printable form for Hourly Service Invoice Template (Price Including Tax), we first unmerge the item# (or product#), description and quantity columns - these are usually merged columns that each contains several Excel raw columns. To do this, after opening Hourly Service Invoice Template (Price Including Tax) as usual, select all the cells belong to these columns and then click the "Merge and Center" button on the Format toolbar in Excel 2003; in Excel 2003, the "Merge and Center" button can be found on the Home ribbon tab. Drag your mouse to select the Description column (this time, you select Excel raw column since the Description is no longer a merged column) and drag it one column left. Select the "oknProductName_1" cell (the first cell on the moved Description column) and drag your mouse to select the two adjacent cells at the right-hand too - so, you now select 3 cells started with the "oknProductName_1" cell. Now click the Merge and Center command again. This will expand the width of "oknProductName_1" to 3 columns. Do this process for all the other Description cells. Once done, you have one empty column that was left by moving the Description column to the left-hand of this original position. Adjust the columns widths of all the columns to make sure they have the proper widths that are able to hold the content they will display on this Hourly Service Invoice Template (Price Including Tax).

If you are working for hourly contracts, this template might be interesting you. If this template does not meet your requirements exactly, modify it to create your very own invoice spreadsheets. All our templates here on InvoicingTemplate.com are protected with no password. So simply unprotect it and do the modification as you need!

Like other form designs here on InvoicingTemplate.com, Hourly Service Billing Statement (Price Including Tax) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5068
NameHourly Service Bill Sample (Price Including Tax)
CategoryService Invoice Template
Release DateTuesday, September 30, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$G$1:$P$43
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00

Sample Templates