Van Fleet Maintenance Excel - Free Template

1. Open Lists & Instructions and amend the reference values for your vans, drivers, depots, maintenance types and VAT rates before adding new records.
2. Go to Maintenance Log and enter one maintenance event per row, starting with the Record ID and Van Registration.
3. Complete the input fields for the van, driver, depot, maintenance date, maintenance type, supplier, odometer and next service details.
4. Enter net Parts Cost, net Labour Cost and the VAT Rate shown on the supplier invoice. The VAT Amount and Total Cost (Gross) fields calculate automatically.
5. Enter the MOT Expiry Date, where relevant, and record Downtime (Days) and Notes so the operational impact is not lost.
6. Review the Status column regularly. It uses TODAY() to identify MOT overdue, MOT due soon and MOT current records.
7. Use Fleet Dashboard to review fleet totals, vehicle comparisons, maintenance cost by type and maintenance jobs by depot.

A small courier, building contractor or facilities company can use this workbook whenever a van returns from a garage, tyre supplier or MOT centre. The driver or fleet coordinator records the event in Maintenance Log, while the owner or operations manager reviews the accumulated cost and downtime on Fleet Dashboard.

For example, the sample record for BX26 LMO is a Ford Transit Custom 280 Limited assigned to Oliver Bennett at the London depot. Its service entry has £180.00 of parts and £240.00 of labour, one day of downtime and an MOT expiry date of 05/11/2026. Those values show the level of detail required for a useful history rather than a simple list of invoice totals.

One row for every workshop event

Record a separate row for each service, MOT, repair, tyre job, inspection or recall. The supplied maintenance types include Service, MOT, Repair, Tyres, Inspection and Recall. This matters when a single van has two jobs in a month: combining them into one row would obscure the supplier, mileage, downtime and cost attached to each event.

Useful at weekly fleet reviews

A fleet manager can filter the Maintenance Log by depot, driver, van or maintenance type using the sheet's auto-filter. The dashboard then provides a higher-level view: the sample fleet includes BX26 LMO, CU26 RHT and MF25 KJD, with vehicle-level job counts and gross costs calculated from the log.

The workbook is also suitable for a monthly bookkeeping review. Match the supplier or garage entry and net cost to the invoice, then compare the calculated gross amount with the recorded payment. Keep the operational note, such as four all-season commercial tyres fitted, alongside the financial figures so the reason for the spend remains clear.

Maintenance Log separates the figures you enter from the calculated outputs. Parts Cost (Net), Labour Cost (Net) and VAT Rate are inputs; VAT Amount in column P and Total Cost (Gross) in column Q are formulas. For a hypothetical job with £850.00 of parts, £150.00 of labour and a 20% VAT rate, the VAT Amount is £200.00 and the gross total is £1,200.00.

The VAT formula calculates SUM(Parts Cost, Labour Cost) multiplied by VAT Rate. The gross formula adds the net parts and labour to the calculated VAT amount. If the Van Registration cell is blank, these calculated cells remain blank rather than displaying a zero for an unused row.

Controlled inputs reduce drift

Dropdown validation applies from rows 3 to 1002 for Van Registration, Driver, Depot, Maintenance Type and VAT Rate. The lists come from Lists & Instructions, where the supplied VAT values include 20%, 5% and 0%. Use the invoice's applicable rate rather than typing a variation such as 20 percent or standard, because the calculation expects a numeric percentage.

Date and mileage checks

Enter dates in DD/MM/YYYY format and record both Next Service Due (Date) and Next Service Due (Miles) when the information is available. A record can therefore show a date trigger and a mileage trigger without replacing one with the other. Odometer (miles) records the reading at the maintenance event, while Downtime (Days) records the operational effect.

Status is calculated from MOT Expiry Date and TODAY(). An expiry date before today returns MOT overdue; an expiry date within the next 30 days returns MOT due soon; otherwise it returns MOT current. This is a live calculation, so the same row can change status when the workbook is opened on a later date.

Fleet Dashboard uses COUNTA, SUM, AVERAGE, COUNTIF, SUMIF and VLOOKUP to turn the log into totals and vehicle summaries. For instance, a van's gross cost is summed by registration and its average cost is calculated only when that van has a recorded job.

The most damaging error is usually attaching a workshop event to the wrong registration. If a £1,200.00 hypothetical tyre job is entered against CU26 RHT instead of MF25 KJD, the dashboard assigns the cost, job count and downtime to the wrong vehicle. That can distort replacement decisions and make a genuine high-cost van appear cheaper than it is.

A similar problem occurs when a supplier invoice is entered as one combined amount with no parts and labour split. The workbook can still hold a record, but the VAT calculation depends on the values in Parts Cost (Net), Labour Cost (Net) and VAT Rate. Leaving labour blank on a hypothetical £850.00 parts invoice would understate the calculated net base if labour was actually charged.

Dates that do not describe the same event

Do not copy the maintenance date into Next Service Due (Date) unless that is genuinely the next planned date. If a service took place on 14/03/2026 and the next service is due on 14/09/2026, entering the same date twice removes the planning signal. The same applies to Next Service Due (Miles): 58,720 miles at the current event and 68,720 miles as the next trigger should remain distinct.

False confidence from an incomplete log

The dashboard counts records from Record ID and aggregates the log's gross costs and downtime. If three garage invoices are kept in email but only two rows are entered, the dashboard cannot know about the missing event. A hypothetical fleet with 12 invoices and 11 rows would show one fewer job and could understate total cost by the missing invoice value.

Another failure is leaving MOT Expiry Date empty. The status formula is designed around a date; without one, you do not have a meaningful MOT status for that row. Likewise, entering text such as one day instead of the numeric value 1 makes downtime harder to total and compare.

Finally, changing a registration or driver directly in a log row can create inconsistent spellings if the reference lists are not maintained. Update Lists & Instructions first, then use the dropdown. This is more reliable than correcting a dashboard that contains several versions of the same van name.

Make the workbook part of the handover between the garage and whoever controls the vehicles. Set a fixed point after every maintenance job to enter the row, rather than waiting until the end of the month when invoices, mileage readings and expiry dates are harder to match.

A practical routine is to update the log when the invoice is approved, then review Fleet Dashboard once a week. For example, if five vans generate one maintenance record each in a week, a 10-minute entry check prevents 20 or more rows from accumulating as an end-of-month backlog. The workbook already provides a fixed place for the supplier, invoice-related costs, downtime and notes.

Use the sheets in a fixed order

• Check Lists & Instructions before adding a new van, driver, depot or maintenance type.
• Enter the event on Maintenance Log immediately after the vehicle returns.
• Review MOT overdue and MOT due soon counts on Fleet Dashboard during the weekly fleet meeting.
• Reconcile gross totals to supplier invoices and the business bank account during the bookkeeping review.

Keep the formula columns intact. If a calculated cell is overwritten with a typed amount, later changes to parts, labour or VAT will not flow through to the gross cost or dashboard. The 1,000-row entry range means you can keep a substantial history, but use filters and regular checks so the log remains manageable.

You may have outgrown the workbook when several people edit it simultaneously, approvals need an audit trail, or fleet size makes manual invoice matching too slow. At that point, move to a dedicated fleet or maintenance system while retaining this file as an export or historical reference. Do not use a new system as a reason to stop recording the basic facts: registration, date, mileage, work type, cost and downtime still need to be captured accurately.