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

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

Screenshot

screenshot for Contractor Billing Format

Detail

This form itemizes "service" and "expense" in two separate sections. Each section has a different tax.

It has 18 lines in the detail section, but these lines are grouped into two sections: the "Services" section and the "Expenses" section.

To make this template work with our invoicing app, the leftmost column on the printable area was a custom field named "ItemLine", which was continuously named from "oknItemLine_1" to "oknItemLine_18". The other columns, such as "DATE", "DETAILS", and "AMOUNT", have an interruption in their names. For example, "oknItemDate_1" to "oknItemDate_6" are put into the same column; "oknItemDate_7" to "oknItemDate_12" are put into another column outside the printable area; and "oknItemDate_13" to "oknItemDate_18" are put into the same column as "oknItemDate_1" to "oknItemDate_6". This is necessary because the space for "oknItemDate_7" to "oknItemDate_12" is used by the tax and amount cells.

"Tax 1" is applied to the "Service" section, and "Tax 2" is applied to the "Expense" section. All the tax calculation formulas are modified according to this design.

The two custom fields "Service Amount" and "Expense Amount" calculate the sum amount of each section. These two fields are also added to the "Sales Report", namely "oknRsServiceAmount" and "oknRsExpenseAmount".

Format and Specification

Template#c3009
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns3
Lines18
Line Height (Points)18.00
Print Area$D$2:$K$46
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree