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:
| 567 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
This invoice template is designed for New Zealand (NZ) lumber companies. It has 24 columns and includes a few custom fields for lumbering businesses, such as "Customer O/N", "SLC Ref No.", "Freight Details", "Tally", etc.
For a general tax invoice template, visit the New Zealand Tax Invoice Template (c4038).
By design, this template assumes your logo image includes company name and address information. So these text fields are moved out of the printable area.
The sheet contains two drop-down lists.
The first drop-down list shows freight details. It contains options like "PBT Transport", "Northern Southland Transport", "Summerland Transport", "Seaton Couriers", "NZ Couriers", and "Waikaka Freight".
The second drop-down list applies to the "Tally" column. It contains options like "RL", "PRL", "SL", "CSL", "CTL(E)", and "CTL(O)".
The "Quantity (LM)" column is calculated using an Excel array formula like this:
{=SUM(oknItem09_1:oknItem60_1*H17:Y17)}This template does not use the "Product#" column. It is moved outside of the printable area and assigned a formula to make it equal to the product description, like this:
=oknProductName_1
Format and Specification
| Template# | cm007 |
| Belongs to | |
| Format (XLS or XLSX) | .xlsx |
| Columns | |
| Lines | 12 |
| Line Height (Points) | 19.50 |
| Print Area | $D$2:$AC$37 |
| Papaer Orientation | Landscape |
| Default Margins (Points) | |
| Left | 22.68 |
| Right | 22.68 |
| Top | 36.85 |
| Bottom | 45.35 |
| Price | Free |
