UniformSoftware main content

Building Service Invoice Template

Template#: c3028

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

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

Screenshot

The screen shot for Building Service Invoice Template

Detail

In the top of the detail section, the column heading section where it is usually titled 'Description' is now replaced with a label 'Re:' and a text field for showing the site address. This (merged) cell is named oknSiteAddress and is filled with a formula automatically:

=IF(ISNA(S43),"",S43)

The above formula means that if the S43 cell has a value, then the value should be filled into oknSiteAddress; otherwise, oknSiteAddress shows an empty string.

Now if you take a look at cell S43, it has a formula too:

=VLOOKUP(oknJobNumber,'Job & Site Ref'!B5:C100,2,FALSE)


The above formula tells Excel to search for the value of the cell named "oknJobNumber" in the B5:C100 section on the 'Job & Site' worksheet, and if found, use the value in the second column to populate the current cell.

The above two formulas work together to implement a feature that allows you to enter a reference number in the "oknJobNumber" cell (to the right side of the 'Invoice To' section), and the site address will automatically be filled in according to the list in the B5:C100 area on the Job & Site Ref worksheet.

For example, if the B5:C100 area has a line of 'j01', '12345 Appold Street', and you enter the job number 'j01' into the "oknJobNumber" cell, then the site address '12345 Appold Street' will be filled by the formulas.

Format and Specification

Template#c3028
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns3
Lines9
Line Height (Points)64.50
Print Area$F$3:$N$42
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree