BoostExcel main content
Download
| Description | Size | Download |
|---|---|---|
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:
| 349 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
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 | |
| Format (XLS or XLSX) | .xlsx |
| 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.00USD) |
Related
