user image

Keys to the Truck

Simple tools for small trade shops. Build one that runs and sells without you.

Crew Hours & Labor Cost Tracker

Crew Hours & Labor Cost Tracker

$19

See where your paid hours really go, and what each billable hour actually costs you.

Log each person's day: hours worked, then billable, drive time, callbacks and shop / admin. The tracker works out weekly regular and overtime hours, gross pay, and the loaded labor cost with payroll taxes, comp and benefits.

Weekly Pay and the Summary show each person's billable % against your target and the labor cost per billable hour, so you can see the leaks before they show up in your margin.

What's included:

  • Crew Hours & Labor Cost Tracker (.xlsx) with 2 example weeks

  • BLANK copy, ready for your crew

  • Weekly pay, overtime and billable % worked out for you

  • 2-page quick-start guide (PDF)

  • Instant download (.zip)

  • Works in Google Sheets and Excel 2010+. No macros, no add-ons, no subscription

  • Formulas locked so they can't be typed over; light copper cells are yours to fill in

Built for small trade businesses: electrical, plumbing, HVAC, roofing, landscaping, painting, cleaning, handyman, pest control, general contracting. Rename the job types, crews and items to fit yours. Example data is made up. This is an organizing tool, not accounting, payroll, tax or legal advice.

Want the prices your numbers need? The Flat-Rate Pricing Calculator works out your real hourly rate and flat-rate prices. Or get all 5 spreadsheets in the Trade Business Spreadsheet 5-Pack for $49.

See what each billable hour really costs

.

Terms & Conditions

Not professional advice: Keys to the Truck products are educational and organizing tools. They are not legal, tax, financial, or insurance advice. Review your agreements, coverage, and decisions with your own attorney, CPA, and insurance agent.

Digital products: All products are digital downloads, delivered instantly after purchase. They are licensed for use in your own business. Please don't resell, share, or post the files.

No guaranteed results: Results depend on your business and how you use the material. We don't guarantee any particular outcome, valuation, or sale price.

No Refunds: Due to the nature of digital products & the ability to instantly access and download them, we do not offer refunds once the purchase is made. All sales are final.

Subtotal :
Tax :
Total :
Loading payment form
or