Trade show and event crews still sign in on paper, and for good reason: a sheet on a table works with no signal, no batteries and no app to install. The pain is what happens after the show, when a payroll administrator has hundreds of handwritten lines and a hard payroll deadline. This guide walks through the process the way it is done in the office, where the mistakes creep in, and how to make it faster without changing anything on the floor.
What a crew sign-in sheet needs to capture
Whatever layout you use, payroll needs the same things from every line:
- Who: the crew member's name and classification (journeyman, foreman, apprentice, general foreman).
- When: in time, lunch, out time, and the date and job at the top of the page.
- Hours by type: straight time, overtime and double time, as the foreman wrote them.
- Money that is not hours: parking, travel and other reimbursements.
- A page total: the foreman's total hours, so the lines can be checked against it.
The process, step by step
- Collect every sheet in one place.Sheets come back in gang boxes, on freight trucks, as texted photos and emails. Make one pile, physical or digital, before you start, and count pages per day so nothing is missed.
- Check each line's math.Out minus in, minus lunch, should equal the hours written. A 7:00 to 5:30 day with a 30-minute lunch is 10 hours. Flag any line that does not add up instead of quietly fixing it.
- Apply the overtime rules from your agreement.Daily overtime after 8 hours, double time outside a set window, minimum calls, and Sunday or holiday rates all change how the same 10 hours are paid. Check the split the foreman wrote against the rule, not against habit. See overtime and double time for trade show crews.
- Check the page against the foreman's total.If the lines add to 78 hours and the box says 80, find the two hours before payroll does.
- Match every name to a payroll ID.Hand-written names vary from day to day. Payroll needs the employee ID your provider uses, never a guess. Hold back any line you cannot match.
- Total by person and pay week.One row per crew member per pay code (regular, overtime, double time) plus reimbursements, summed across every day in the pay week.
- Build the import file in your provider's template.ADP, Paychex and Gusto each expect their own columns and earning codes. Test-import one file before relying on a new layout.
- Keep the trail.File the original sheets with the payroll batch so any line can be proved weeks later, when a foreman, client or fund auditor asks.
A worked example
Three lines from one page, with daily overtime after 8 hours and a 30-minute unpaid lunch:
| Crew member | In | Lunch | Out | Total | ST | OT |
|---|---|---|---|---|---|---|
| Crew Member 01 | 7:00 | 0:30 | 5:30 | 10.0 | 8.0 | 2.0 |
| Crew Member 02 | 7:00 | 0:30 | 3:30 | 8.0 | 8.0 | 0.0 |
| Crew Member 03 | 7:30 | 0:30 | 3:30 | 7.5 | 7.5 | 0.0 |
If the foreman wrote 8 hours for Crew Member 03, that is a half-hour question to settle with the foreman before payroll runs, not after the check is cut.
Where the time and the mistakes go
A show with 300 handwritten lines at 30 seconds a line is about two and a half hours of typing, before anyone checks the math, the overtime split or the payroll IDs. Then the same hours are often typed again into a budget spreadsheet and again into each benefit fund report. Every retyping is another chance to drop a line or misread a 7 as a 1.
Doing it faster without changing the floor
This is the problem myCrewIQ was built for. The crew keeps signing paper. A supervisor photographs each sheet with a phone, or the office uploads scans. Each line is read beside its photo, the math and foreman totals are checked automatically, and only the values that need a person are highlighted. You approve the batch, then download a payroll import file laid out for ADP, Paychex or Gusto and import it yourself.
Honest notes: machine reading is built for the myCrewIQ sign-in sheet; pages from your own sheets can be photographed and keyed beside the photo. myCrewIQ never connects to or submits to a payroll system, so test-import one file before relying on a layout.
See it on a fictional show in the Test Drive, including a sample weekly summary and import file.
Frequently asked questions
- How long does it take to key trade show sign-in sheets into payroll by hand?
- Plan on a few hours per show just for typing, before any checking. A show with 300 handwritten lines at 30 seconds a line is about two and a half hours of keying, and checking the math, overtime and payroll IDs usually takes as long again.
- Do my crews have to stop using paper sign-in sheets?
- No. Paper works on a show floor: no batteries, no app, no signal needed. The time goes into the office work after the sheets come back, so that is the part worth fixing.
- What should a crew sign-in sheet capture for payroll?
- Name, classification, in, lunch and out times, straight-time, overtime and double-time hours, reimbursements such as parking or travel, the job and date, and the foreman's page total so the lines can be checked against it.
- Can myCrewIQ upload the file into ADP, Paychex or Gusto for me?
- No. myCrewIQ prepares the import file and you import it yourself. It never connects to or submits to a payroll system. Test-import one file before relying on a layout.