Ute fleet maintenance log Excel - Free Template

1. Step 1 — Open Fleet & Summary and review the vehicle register in rows 13 to 112. Replace the sample vehicles or add your own registrations, make/model, year, fuel type, base, driver, odometer and WOF expiry date.
2. Step 2 — Go to Maintenance Log and enter a unique Job ID, such as MNT-2026-004, then select the vehicle registration from the drop-down list.
3. Step 3 — Enter the service date in DD/MM/YYYY format, the odometer reading in kilometres, the maintenance type, supplier or workshop and a useful work description.
4. Step 4 — Enter parts, labour and other costs excluding GST in columns K to M. Leave the calculated columns unchanged; the workbook applies 15% GST and shows totals in NZD.
5. Step 5 — Record the next service due odometer and date, then add the invoice or reference number and any notes. The workbook calculates days until due and the maintenance status.
6. Step 6 — Review Fleet & Summary each week. Check open or overdue jobs, WOF expiry dates, vehicle costs and the three included charts before allocating a ute to work.
7. Step 7 — Use Instructions for the workbook guidance, and retain invoices and workshop documentation with the spreadsheet for at least seven years.

A Christchurch building contractor with four utes usually has several people touching the fleet records: the foreman knows the kilometres, drivers notice faults, and the office manager receives workshop invoices. A shared ute fleet maintenance log gives each job one row instead of leaving service history in gloveboxes, text messages and supplier emails.

Image 1 shows the Maintenance Log sheet. Its columns run from Job ID and Vehicle Registration through to service date, odometer, maintenance type, supplier, work description and three separate ex GST cost fields. The final columns hold the next due kilometre reading, next due date, days until due and maintenance status, followed by invoice reference and notes.

Useful during the weekly fleet check

For a small tradie firm, Friday afternoon is a practical time to review the log before Monday's jobs are allocated. If KFU482 has a current odometer of 78,950 km and its next service is set at 88,450 km, you can compare the latest driver reading with the planned interval rather than relying on memory.

The sample records demonstrate the different jobs you may record: a scheduled service, a WOF inspection and a tyre replacement. They are populated examples, not a claim that your fleet has those vehicles or suppliers. The prepared Maintenance Log has rows 2 to 101 available for events.

Useful for more than servicing

A ute may visit a workshop for brakes, electrical work, tyres or an unexpected repair, not just a scheduled service. Selecting a consistent maintenance type makes later review easier, while the work description records what was actually done.

Image 2 shows the Fleet & Summary sheet. Its register stores 100 possible vehicles, while the summary beside it calculates total jobs, total inclusive cost, average job cost, latest odometer and open jobs for each registration. The three included charts help a manager see where spending or outstanding work is concentrated.

The workbook records parts, labour and other costs excluding GST, then calculates GST at New Zealand's standard 15% rate. For example, $285.00 of parts, $220.00 of labour and $18.00 of other costs gives $523.00 ex GST, $78.45 GST and $601.45 including GST. The sample scheduled service in the workbook follows that calculation.

This spreadsheet is a cost and maintenance record, not a substitute for checking the GST treatment of each supplier invoice. A GST-registered business needs taxable supply information to support an input tax claim, including the supplier's details, date, description and GST-inclusive amount. Keep the original invoice or supporting document with the row's invoice or reference number.

Keep the evidence behind each row

Inland Revenue requires business records to be kept for at least 7 years. That includes workshop invoices, WOF paperwork, tyre invoices and other documents supporting the amounts entered in columns K to M. The row can point to the document using Invoice / Reference, but it does not store the invoice itself.

If a Christchurch contractor enters $1,485.00 ex GST for tyres, the workbook calculates $222.75 GST and $1,707.75 inclusive. The contractor still needs to confirm the invoice is a legitimate business cost and retain the source document for the GST return and annual accounts.

Vehicle compliance is separate from tax

Image 2 includes WOF Expiry Date in the fleet register, alongside the current odometer. The workbook helps you review those dates, but it does not connect to the NZTA register, renew a WOF or verify a vehicle's registration.

Use the Instructions sheet, shown in image 3, as the operating guide: enter dates as DD/MM/YYYY, use NZD currency, review due items weekly and check WOF, registration, servicing and safety records before assigning a ute. A maintenance spreadsheet supports compliance evidence; it does not replace the driver's pre-start checks or your obligations under the Health and Safety at Work Act 2015.

The most expensive problem I see in small fleets is not always a major mechanical failure. It is incomplete history. A driver says the ute was serviced, but there is no date, kilometre reading or invoice reference, so the office books another service unnecessarily or misses the next one altogether.

When the due fields are left blank

The status formula needs a registration, service date, odometer, next due kilometre and next due date. If either due field is missing, the status can remain blank rather than giving you a useful warning. For a ute travelling 800 km a week, a missed 10,000 km service interval can arrive in roughly 12 to 13 weeks.

Dates cause another practical failure. Entering 09/02/2026 as text instead of a real Excel date can stop the days-until-due calculation working. The workbook uses TODAY to compare the due date with the current date and marks a job Due Soon when it is within 30 days or the odometer has reached the due point.

Cost totals that do not tell the full story

Entering an invoice total into Parts Cost and then entering the same total into Total Cost would double count, but this workbook does not ask you to type Total Cost. Enter only parts, labour and other ex GST costs in K to M. A $1,240 tyre invoice, $210 labour and $35 other cost produces $1,485.00 ex GST and $1,707.75 including GST.

Do not overwrite the calculated columns C to E, N to P or S to T. Those formulas bring through fleet information, add costs and determine status. If someone pastes over them, KFU482 might display the wrong driver or the fleet summary might understate the cost by hundreds of dollars.

Weak descriptions waste workshop time

Repair is not enough as a work description. Write front brake pads and rotors replaced, or intermittent tail-light fault diagnosed, so the next person can distinguish a repeat fault from routine work. A useful description can save a second phone call and makes the maintenance history defensible when a warranty or insurance question arises.

A spreadsheet works when it is attached to a task that already happens. Set a fixed 15-minute fleet review every Friday, immediately after timesheets or before the Monday vehicle allocation. The person doing that review should compare the log with workshop invoices received during the week and chase missing due dates.

Use a simple handover routine

• Drivers text or email the odometer and fault details when a ute returns from a workshop.
• The office administrator enters the event while the invoice is open, rather than leaving a paper docket in a tray.
• The fleet manager checks Overdue and Due Soon items, then records the booking date or workshop reference in Notes.
• At month-end, compare the inclusive totals with the maintenance expense ledger before filing the supporting invoices.

Image 3 shows the Instructions sheet, including weekly review, costs and GST, dates and currency, record retention and vehicle allocation guidance. Keep that sheet visible for new staff so they enter one event per row and do not type over calculated fields.

Keep entries consistent

Use the registration and maintenance-type drop-downs rather than typing alternatives such as Hilux KFU482, KFU 482 and KFU482. Consistent registrations are important because the summary uses COUNTIF, SUMIF and AVERAGEIF to calculate each vehicle's jobs, costs and average cost.

Use filters on the Maintenance Log to isolate WOF work, tyre jobs or one driver. The sheet has an auto-filter and freezes the first row, which helps when the 100 prepared event rows begin filling up.

Know when to move on

This workbook is a sensible starting point for a small fleet with fewer than 100 logged events in the prepared range. If you have several hundred jobs each year, multiple users editing at once, purchase-order approvals or live workshop integrations, move to fleet software or a system such as Xero or MYOB and retain this workbook as an export or historical record.