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:
| 586 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Detail
This building contractor invoice template is decorated with an image on the form. The image shows a 3D puppet building a house, which is printable and is included on PDF invoices too. Try this free template if you are a civil contractor in the construction industry.
The form layout is based on the Mixed Tax Rates in an Invoice (7 Columns) (c5035). It keeps the original main layout. For example, it still has seven columns and calculates taxes separately for "Material" and "Labor". On the other hand, it also changed a lot, including the addition of images of a construction worker and a house.
Each cell on the "Type" column is a drop-down list that allows you to choose from two possible values: "Material" and "Labor".
The "Tax Rate" cells show the applied rates. They are calculated using Excel's "VLookup" formula. For example, on the first line, the tax rate is calculated using the formula shown below:
=IF(oknProductType_1="",0,VLOOKUP(oknProductType_1,$M$34:$N$35,2,FALSE))
"$M$34:$N$35" is the area where it shows all the possible tax names and rates. The existing values are just placeholders. You have to change this before you use it for creating invoices. Visit an online resource, such as Sales Tax Rates in Major U.S. Cities, or talk to a local tax authority. Visit our Multiple Tax Rates on One Invoice (c5016) for another example.
Format and Specification
Template# | c7033 |
Belongs to | |
Format (XLS or XLSX) | .xlsx |
Columns | 7 |
Lines | 12 |
Line Height (Points) | 15.75 |
Print Area | $F$3:$O$42 |
Papaer Orientation | Portrait |
Default Margins (Points) | |
Left | 22.68 |
Right | 22.68 |
Top | 45.35 |
Bottom | 45.35 |
Price | Free |