Service ticket template for field crews, and how to check them

A service ticket records one visit: the customer and site, the date, who was there, hours, parts used and what was done. It is billable when the office can price every line without calling the technician. The template below lists the fields billing needs, and the free check above looks at a week of tickets laid out as a spreadsheet and flags the gaps.

This page is for the person who bills from the tickets. If you are choosing field-service dispatch software, that is a different search. Here the question is what a ticket must hold so that invoicing is a copy job and not a research project.

What fields does a service ticket need?

• Ticket or work order number.
• Job or account. Use your own job number, the one on your job list, so the ticket lands on the right customer.
• Service date. The day the work was done.
• Crew or technician.
• Hours per person, with their classification so a bill rate applies.
• Parts and materials. Each with a quantity and a unit.
• Equipment used, if you bill it by the day.
• Work performed. One or two plain sentences the customer will recognize.
• Open items. Anything that was left undone or needs a follow-up visit.

What does a complete service ticket look like?

Ticket 2207   Job 3150 (Harbor Dental)   2026-10-14
Technician: R. Silva, journeyman, 3.5 h
Parts:      20 A breaker, 2 each
            14/2 cable, 40 ft
Work:       Replaced two tripped breakers in suite 4, tested circuits
Open:       None

Hours, rate class, parts with units and a description are all present. The office can write the invoice line without asking anyone.

What makes service tickets hard to bill?

• No job or account, because the technician wrote the customer's name and the office keeps jobs by number.
• Parts without a quantity or unit.
• Hours with no name or class. A rate cannot be chosen.
• Tickets that arrive days late and fall outside the week being billed.
• Duplicates, from a field copy and an office copy of the same visit.
• A tech with a day and no ticket. If a crew has tickets Monday, Tuesday and Thursday and none Wednesday, someone should ask.

Weekly Field Log flags each of these on a week of entries, and lists them by crew so the questions go to the right person. It also flags a worker over 14 hours in one day, and more than 24 hours across entries on a day, which cannot be right.

How do you bill from a week of service tickets?

Put the week's tickets in one table with a row per person per ticket, one column per field above. Group by job. Price labor by class at the bill rate, overtime past 40 hours for a worker in the week at your overtime multiplier, parts at cost plus markup, equipment at its day rate. The time and materials invoice template shows how each of those lines is built.

Weekly Field Log does the table, the flags and the pricing from your rate card, and writes a CSV in the layout QuickBooks Online's invoice import takes. It does not connect to QuickBooks and never emails your customers. It does not handle prevailing wage, progress billing or change orders, so tickets that depend on them need a manual edit.

Can service tickets be photos or PDFs?

Yes. Text PDFs and phone photos are read by an AI model, and each is shown beside what was read and has to be approved before it counts. Handwritten tickets are read less reliably, so expect more corrections. For the spreadsheet layout that reads best, see the construction daily log template, and for a related record see the T&M ticket template.

How do I check a week of tickets for gaps?

Use the free check at the top of this page. Run the sample week, or upload a week of your own tickets as a CSV or Excel file up to 4 MB. You see every entry, the flagged ones, and the week compiled by job. Nothing is stored and no email is asked.

Who should fill the ticket in, and when?

The technician or crew lead, on the day of the visit. A ticket written on the day carries the right date, the right parts and a description the customer will recognize. A ticket written a week later is where missing quantities and wrong dates come from, so the cheapest fix is the habit: the ticket is closed before the truck leaves the site.

FAQ

How long are files kept if I sign up?

Uploaded logs and their entries are kept 13 months, then deleted. If you cancel, everything is kept 30 days and then deleted.

Can it chase technicians for missing information?

On the higher plan it emails each crew lead its open questions each weekday morning, up to four times, then tells you to call. On the entry plan it shows the flags and a ready message you send yourself.

Does it replace dispatch or scheduling software?

No. It starts after the work is done, with the tickets and logs, and prepares the billing.