Maintenance work order template: one printable A4 form per job

What a maintenance work order is for

A maintenance work order, often shortened to WO, is the document that turns a request into a job. The request says something is wrong; the work order says who will deal with it, on which asset and with which precautions, and then records what was actually done. One work order covers one intervention. Once the job is finished and signed, the sheet becomes part of the asset’s history.

A work order form is not the same thing as a list of jobs. A list keeps one line per job to show the workload at a glance; the form keeps the full detail of one job, the detail a technician needs on site and an auditor asks for months later. This template gives you the form on the first sheet and a register on the second.

A filled-in work order should answer seven questions without anyone having to call the technician.

• What was requested, by whom and when, and by when it should be done.
• Which asset, with its code and location, so there is no doubt about the machine.
• Which safety measures applied: lockout and tagout, a work permit, personal protective equipment.
• What was found and what was done, with the cause written separately from the symptom.
• Who worked on it, on which day and for how long.
• Which parts went in, how many and at what price.
• How long the machine was stopped, and who accepted the work.

What the template contains, block by block

The first sheet follows the order in which the job unfolds. Grey cells hold formulas; everything else is typed or picked from a drop-down list. The page set-up is already A4 portrait, scaled to the width of the page, so the sheet prints without adjusting margins. The file is blank: there are no example rows to delete.

• Header: work order no., request date, requested by, asset / equipment, asset code, location, maintenance type (corrective, preventive, improvement, inspection), priority (low, medium, high, urgent) and requested completion date.
• Description: four boxes for the problem reported, the work carried out, the cause found and remarks.
• Safety: lockout / tagout required, work permit required and PPE required, each answered yes or no from a list.
• Labour: six lines with technician, date, start, end, hours, hourly rate and labour cost.
• Parts used: eight lines with part number, description, quantity, unit price and line total.
• Downtime: the date and time the machine stopped and restarted, and the downtime in hours.
• Totals: total labour hours, labour cost, parts cost and total cost.
• Closure and sign-off: completion date, status (open, in progress, completed, cancelled) and three signature boxes for the technician, the requester or approver and the maintenance manager, each with name, date and signature.
• Register, on the second sheet: 200 rows with work order no., request date, asset, type, priority, assigned to, status, completed on, days to complete, labour hours and total cost, under a summary of open, in-progress and completed work orders and the average days to complete.

The formulas, exactly

Excel stores a time as a fraction of a day, so 06:00 is 0.25. That is why the hours are multiplied by 24. Enter times as hh:mm and dates as real dates, not as text, or the grey cells stay empty.

The labour formula wraps past midnight: a night shift from 22:00 to 02:00 gives 4.00 hours, not a negative figure. Downtime uses full date and time stamps instead, because a stop can last several days; it is only computed when the restart comes after the stop.

An example with illustrative figures: a technician works from 08:30 to 11:00 at a rate of 40 per hour, which gives 2.50 hours and 100.00 of labour. Two bearings at 35.00 and one seal at 12.50 make 82.50 of parts, so the total cost of the work order is 182.50.

• Hours = (end − start) × 24, wrapping past midnight
• Labour cost = hours × hourly rate
• Line total = quantity × unit price
• Downtime (h) = (restarted at − stopped at) × 24
• Total cost = labour cost + parts cost
• Days to complete, in the register = completed on − request date
• Average days to complete = average of the days computed in the register

Filling it in well: the details that make a work order useful later

A work order is read far more often than it is written: by the next technician on the same machine, by the planner, by whoever prepares next year’s budget. A few habits make the difference between a sheet that informs and a sheet that only proves someone was there.

• Number every work order and never reuse a number. A cancelled work order keeps its number, with the status cancelled.
• Write the problem as it was reported, then the cause as it was found. “Pump noisy” is a symptom; “bearing worn, not greased” is a cause.
• Use the asset code, not only the name. Two machines both called “compressor” are a classic source of mixed-up histories.
• Keep labour and downtime apart. Labour hours are what the job cost in people; downtime is how long production lost the machine. A two-hour repair can follow a six-hour wait for a part.
• Write the part number, not just “belt”. Without it, nobody can reorder the same part or notice that it is replaced every month.
• Fill in the safety block before the work starts, not at the end. If lockout is required, it is done before anyone touches the machine.
• Copy each closed work order to the register the same day. A register filled in at the end of the month is always missing lines.

When the Excel work order shows its limits

For a small team, one copy of the sheet per job and a register kept up to date work well, and the file stays useful as it is. The limits appear as the team grows: several technicians filling in copies at the same time, several sites, a history per asset that means opening dozens of files, nobody reminding the team of due dates, technicians who need the work order on their phone, and an audit asking who changed what and when.

FreeMaint is a freemium CMMS built around the same work order. On the free Core tier, $0, each work order is numbered automatically, assigned with a notification, and carries its tasks, labour, parts taken from stock, additional costs, photos and comments, with a History tab that records every status change with who and when. A stop recorded on its Machine downtime tab also appears on the asset. Technicians work from the mobile app.

Starter, $29 per company per month, flat, adds the complete PDF export and the lockout register. Business, $99, adds electronic signatures. Prices are never per user. You do not have to retype the past either: work orders can be imported from a CSV file saved from Excel, using FreeMaint’s import template, on every plan.