user image

Keys to the Truck

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

Job Costing Tracker: Bid vs Actual

Job Costing Tracker: Bid vs Actual

$19

Find out which jobs actually make you money, and which ones quietly eat your profit.

Log what you bid and what each job really took: labor hours, materials and other costs. The tracker costs your labor at its true cost per hour (wage plus payroll tax, workers' comp and benefits), not just the wage.

Every job gets its profit, margin and a flag (OK, OVER, Low margin). The Summary rolls it all up by job type and by tech or crew, so you can see what to re-price, re-estimate or coach.

What's included:

  • Job Costing Tracker (.xlsx) with labeled example jobs

  • BLANK copy, ready for your jobs

  • 5 trade example files: plumbing & HVAC, electrical, landscaping, cleaning, painting

  • 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.

Know which jobs really make money

.

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