UniformSoftware main content

Hourly Service Bill Sample (Price Including Tax)

Template#: c5068

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
423 KBDownload

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

Screenshot

The screen shot for Hourly Service Bill Sample (Price Including Tax)

Detail

This is a variant of the Hourly Service Billing Form (c4025). It differs from the original template by adding a Tax column, assuming prices include taxes.

The tax on each item is calculated with a formula like this:

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

This 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, and the tax rate is 17.50%, then the tax amount equals 1.49 after rounding to 2 decimal digits.

Related templates:

Format and Specification

Template#c5068
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)19.50
Print Area$G$1:$P$43
Papaer OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00
PriceFree