Skip to main content main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Hourly Service Bill Sample (Price Including Tax)

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

c5068 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open hourlyservicepriceincludingtax.xlsx.

Hourly Service Bill Sample (Price Including Tax) (IMFE Edition)

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


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.


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

3.38 MBDownload

Without database file. How to download and use

81 KBDownload

Download this if you have already installed IMFE, and are looking for additional customized templates; or if you want a template for Invoice Manager (Lite).

435 KBDownload


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 Billing Format, which has been assigned with the template# of c4025 here on, 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, 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.

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

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 are protected with no password. So simply unprotect it and do the modification as you need!

Like other form designs here on, 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, 2016 or 2019.

Format and Specification

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 / Excel 2019
Feature Gallery
Line Height (Points)19.50
Print Area$G$1:$P$43
Papaer Size / OrientationPortrait
Default Margins (Points)

Update History

August 27, 2018

  • This template was updated to be compatible with UIS 6.