BoostExcel main content


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.

Description Size Download

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

484 KB Download

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

6.28 MB Download

Screenshots and Images

The printed version.

Hourly Service Bill Sample (Price Including Tax)

Open the template in Excel.

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


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!

Format and Specification

Template# c5068
Name Hourly Service Bill Sample (Price Including Tax)
Category Service Invoice Template
Release Date Tuesday, September 30, 2014
Format (XLS or XLSX) .xlsx
Feature Gallery
Columns 5
Lines 12
Line Height (Points) 19.50
Print Area $G$1:$P$43
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 36.00
Right 36.00
Top 72.00
Bottom 72.00
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.

Update History

August 27, 2018

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