UniformSoftware main content

Handyman Invoice Template

Template#: c7006

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

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

Screenshot

The screen shot for Handyman Invoice Template

Detail

This form is designed for service businesses where the usual "Ship To" section is changed to "Service Location".

Several other labels related to shipping, such as "Ship Date" and "Ship Via", are still there. You can replace these labels with whatever you like to meet the requirements of your business.

Related templates:

The form has 7 columns: Item #, Description, Quantity, Price, GST, PST, and Line total. The item# field is here for you to enter the short code for the goods you sold or services you performed.

This customized handyman invoice template redefines the tax formulas, providing the ability to apply one tax (PST) on goods (materials) and two taxes (GST and PST) on both service (labor) and goods (materials).

For example, the GST is calculated using a formula like this:

=IF(oknTaxable_1,ROUND(oknTax1Rate*oknPrice_1*oknQuantity_1,2),0)

The PST is calculated using a formula like this:

=IF(oknTaxable_1,IF(oknIsService_1=1,0,ROUND(oknPrice_1 * oknQuantity_1* oknTax2Rate,2)),0)

In order to implement the taxing rules, three custom fields were added to the "InvBdy" database table: "GST", "PST", and "IsService". The "IsService" field corresponds to the "IsService" field defined in the Product database table; however, with the default template, it is not added to the InvBdy database table because the on-form calculation of taxes and totals does not depend on this field. But with this form, calculating the taxes requires knowing the type of the item.

Format and Specification

Template#c7006
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns7
Lines12
Line Height (Points)19.50
Print Area$F$3:$O$44
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree