Store / Contractor Job Estimate & Pricing Sheet

Contractor Job Estimate & Pricing Sheet

Price every job for the margin you actually want.

A job-estimating spreadsheet that adds your overhead to every labor hour, prices at a true margin, and prints a clean estimate for your customer that never shows your costs. For Excel and Google Sheets.

Excel + Google Sheets · No macros · .xlsx download

$19 one payment · no subscription

Five reasons to use it

  • Price for the margin you actually want Set a 30% margin and the price really leaves 30% profit. The sheet also shows the matching markup, so you see both side by side.
  • Every job carries its overhead Your yearly overhead and billable hours become an overhead cost per labor hour. Each job picks up overhead by its hours.
  • Real job cost Materials with waste %, sales tax on materials, labor by task (each task can have its own hourly cost), subs, equipment, permits, disposal and contingency.
  • A customer estimate you can send Three clean price lines, the scope and your payment schedule. Your costs and margin never appear, and it's already set up to print.
  • Works in Excel and Google Sheets No macros, and the formulas are locked.

What you get

  • One .xlsx workbook with four tabs:
  • How to use: one page.
  • Inputs: your business, the customer and the job, and your rates and rules; 15 material lines, 10 labor tasks, and 8 lines for subs, equipment and other costs; the payment schedule.
  • Results (for you): your break-even price and your price at the target margin; gross profit, margin and the matching markup; price per labor hour, and the price at margins from 15% to 40%.
  • Customer estimate (to send): printable, marked "estimate, not a quote".
  • A filled-in sample job, with invented numbers, so you can see it work.

Honest limits

  • It's an estimate, not a quote or a contract. It doesn't know your local prices, your state's sales-tax or deposit rules, or your contract terms.
  • It counts sales tax as a cost you pay on materials. That's common for contractors in many states, but not all.
  • It handles one job per file. Save a copy for each estimate.
  • It prices the job before the work starts. It doesn't track estimate against actual cost once the job is running.
  • The customer estimate shows three category lines, not every material.

Questions

Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it. It uses only functions that Google Sheets supports. Google Sheets doesn't keep the cell locks.
Margin or markup: which does it use?
You set a margin, and the sheet shows the markup that equals it. For example, a 30% margin is a 42.9% markup.
Can I put my business name on the customer estimate?
Yes. The name, phone, email and license number on the Inputs tab fill in the estimate.
Can I use it for any trade?
Yes. The lines are general: materials, labor tasks, subs, equipment, permits and disposal. The sample job is a deck.
Can I unlock the formulas?
Yes. In Excel, go to Review > Unprotect sheet. There's no password.

More from the store

Spreadsheets for estimating, not advice. The sample data is invented.