A moving company's payroll problem isn't calculating hours. It's that each job generates a different combination of crew members, vehicles, cargo volume, tip amounts, and commission structures — and reconciling that after the fact, from memory, is where disputes start.
The Job Record
Each record is a single job. Start time and end time feed calculated Total Time, which drives straight hourly payroll. Contract number anchors the record to the paper trail. Move type — local, long distance, full packing, storage — determines the rate structure that applies before any calculation begins.
Crew assignment via Team (multi-select, up to 25 named movers) and a single Foreman creates the personnel snapshot for the job. Who was on site, who led the crew. When a dispute arises about a job from six weeks ago, this is the record that resolves it.
Vehicle and Driver fields track which truck and who drove it. DMV tickets and fuel expenses get logged directly on the job record — not in a separate sheet that may or may not be reconciled at month end.
Cargo and Complexity
Cubic Feet and Additional CF feed Total CF — the calculated total volume. This figure is central to long-distance pricing and storage rate calculations. Flight of stairs is the field that captures the job complexity multiplier: a third-floor walkup with no elevator isn't the same labor as a ground-floor unit, and it shouldn't be billed the same way.
Multi-stop logistics are handled through three pickup addresses and three delivery addresses. A job that pulls furniture from two locations and delivers to one — or the reverse — is documented without improvisation.
The Financial Breakdown
Commission estimate captures the projected earnings before the job. Commission records the actual. Commission share is the percentage split when foremen or drivers earn a differential. Tip is logged separately because it flows to crew directly and shouldn't be buried in revenue totals.
Total estimate and Total are calculated fields — tip plus estimate, and tip plus actual commission respectively. Status (UNPAID / PAID) closes the loop at the job level. Aggregate by status and you have outstanding receivables without running a separate report.
Audio notes capture site conditions, customer instructions, or damage observations in real time — faster than typing and harder to misremember later.