The printed version.
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
Hourly Service Bill Sample (Price Including Tax) - IMFE edition
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.
Without database file. How to download and use
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).
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!
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, 2016 or 2019.
|Name||Hourly Service Bill Sample (Price Including Tax)|
|Category||Service Invoice Template|
|Release Date||Tuesday, September 30, 2014|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
August 27, 2018