A work order tracking spreadsheet gives the office one row for each existing job, with its appointment, recorded work status, customer update, invoice handoff, and next administrative action. Use the blank workbook below if your office needs a shared register. Use the browser editor to prepare a few rows and export them to CSV. Neither version creates a work order or authorizes field work.
Download the blank spreadsheet or build your first rows
The workbook contains a blank Tracker tab, a field guide, and dropdown lists. It has 200 prepared rows, filters, and a frozen header. There are no pricing, tax, payment, or completion formulas. Fill it from existing records approved for office use, not from guesses about what happened on site.
Download the blank Excel workbook (.xlsx) · Download blank CSV headers
Work-order office tracker
Use job references rather than customer names or addresses. Rows stay in this tab only and are lost on reload. Export before leaving. A CSV does not preserve workbook dropdowns or formatting.
No rows added. Start with an existing work-order ID.
Dropdown labels are suggestions, not universal software statuses. “Field completion reported” records a report; it does not approve quality, billing, or closure. Review exported date and ID formatting before sharing the sheet.
Keep the tracker separate from the work order
The work order is the underlying job record. This spreadsheet is an office follow-through list pointing back to that record. Keep approved scope, customer details, field notes, and supporting documents in the place your company already uses. The tracker should tell a teammate where to look and what is still waiting, not become an incomplete duplicate job file.
Separate status fields matter when the office is looking for different kinds of unfinished work. For example, Jobber's job-status documentation distinguishes Active, Action Required, Requires Invoicing, and Archived. It defines Requires Invoicing around an overdue invoice reminder, not simply a finished visit. The suggested labels in this download are independent office labels, not a Jobber import format.
A field-completion report can therefore sit beside “Awaiting approved records” in the invoice column. That is not a contradiction. It tells the office that the reported work status and the billing handoff are different questions. Check the underlying job and billing records before changing either.
What belongs in each row
- Work-order ID and authoritative reference: use the existing job number and a reference that an authorized teammate can locate. Do not paste passwords, private access links, or complete customer files.
- Office owner: name the role or teammate responsible for keeping this row current. This is different from the person assigned to perform the field work.
- Appointment date and confirmation: copy the current agreed date from the scheduling record. “Proposed” is not “Confirmed.” Use the source schedule for arrival windows and time-zone details; this sheet only holds a date.
- Recorded work status: copy the latest authorized report. If it is missing or unclear, leave “Not checked” and assign a request for clarification.
- Customer update: show whether an approved update still needs to be sent, is awaiting wording, or was sent and logged. The sent message belongs in the normal customer record.
- Invoice handoff: record where the administrative handoff stands, not whether the invoice is correct or a payment has cleared.
- Next action, owner, and follow-up date: write the specific office step and who will do it. A follow-up date is an administrative reminder, not an urgency classification.
- Source record last checked: record when someone actually compared the row with its source. Do not refresh this date merely because the spreadsheet was opened.
Set up the workbook for your office
1. Decide which record takes precedence
Before adding jobs, agree where appointments, reported completion, and invoices are recorded. When the spreadsheet and that source disagree, check the source and ask the responsible person. Do not resolve a mismatch by quietly changing both records to whichever value looks plausible.
2. Use one row per existing work order
If one job has multiple visits, keep this register at job level and use the appointment date for the next relevant visit. Keep the detailed visit history in the source schedule. If you need a separate visit-by-visit sheet, define that structure before mixing visits and jobs in the same ID column.
3. Agree on labels before filling the sheet
The workbook's Lists tab holds the dropdown choices. The owner or office lead can adjust them to match the company's records. Do not use a label to invent an approval step, remove a required review, or suggest that the assistant may decide technical scope. If an unfamiliar status appears, clarify it with the person responsible for that record.
4. Filter for the next office action
Review one question at a time: appointments awaiting a reply, customer updates awaiting wording, or jobs waiting for billing records. In Excel, column filters temporarily hide rows that do not meet your criteria. Clear the filter when you need the full register. Filtering does not close or delete a job.
A clearly labeled illustrative office handoff
This example is invented to show how the fields work, not a client record or result. An existing job labeled EXAMPLE-WO-001 has a field-completion report in its source record. The office still needs an approved job note before handing the file to billing. Its row would show “Field completion reported,” “Awaiting approved records,” and the next action “Request the missing approved job note.”
Assign that request to the appropriate office owner and choose a follow-up date under your company's policy. Do not mark the invoice handoff complete just because the field visit ended. When the approved note arrives, check the source, update the handoff status, and record the actual check date. No technical decision or billing approval is made by this example.
Review open loops without creating a second dispatch board
During the office's regular review, check rows with missing owners, overdue administrative follow-ups, and status mismatches. Confirm the next appointment in the scheduling system before sending a customer message. If the underlying record changes, update this register after checking it. Do not use the spreadsheet to overwrite the schedule or issue field instructions.
For plumbing, that might mean following up on missing paperwork for an already approved return visit. For HVAC, it might mean checking whether a maintenance appointment reply was logged. An electrical office might be waiting for an existing inspection record from the responsible person. A roofing office might need an approved homeowner schedule update. In each case, the office records and communicates an authorized decision rather than making the trade decision itself.
Archive rows according to your own record-retention policy only after the responsible people confirm that their remaining office actions are resolved. A cancelled job can still have a customer message or billing question waiting. Keep those actions visible until the appropriate owner resolves them.
When a spreadsheet is not the right tool
Use the register for a defined office gap, not because every job needs another copy. If your current system already shows the same owners, next actions, and handoffs clearly, use that view instead. If several people keep editing conflicting copies, or the office cannot reconcile the sheet with current records, move the follow-through into the system your team can reliably maintain.
For assigning a recurring responsibility rather than listing jobs, use the task delegation template. For the customer message that accompanies an appointment, see the appointment confirmation templates.
Give someone ownership of the follow-through
Early Bird is a managed service built around one dedicated, full-time executive assistant with ongoing Early Bird support. Onboarding maps the full operating scope before stabilizing one priority workflow at a time. That scope can include keeping approved office records current, coordinating customer follow-up, and bringing unresolved decisions back to the right person.
The assistant is not hired for a disconnected spreadsheet task. The tracker is one possible aid within a broader office responsibility. The owner retains decisions about field work, spending, billing approval, and any exception outside the agreed authority. Explore the dedicated-assistant model when the underlying need is someone to own the recurring office follow-through, not just another download.