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.