InvoicingTemplate.com main content

Download

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 the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

468 KBDownload

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

5.80 MBDownload

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)

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

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

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
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$G$1:$P$43
Papaer Size / OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

August 27, 2018

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

Samples

Thumbnail for Hourly Service Invoice Template (Price Excluding Tax)
Thumbnail for Hourly Service Billing Sample
Thumbnail for Hourly Service Invoice Template (UK Currency)
Thumbnail for Beautiful Service Invoice Template with Hourly Rate
Thumbnail for Invoice Template with Hours and Rate
Thumbnail for UK Tax Invoice Template
Thumbnail for Consultant VAT Invoice for U.K. Limited Company