True Hourly Rate Calculator for Handymen & Solo Trades: Job Quote + Past Job Check (Excel)
Most solo tradespeople price by the hours on site. Then the drive, the store run, the quote visit, the texts and the invoice eat the hourly rate they thought they were getting.
This spreadsheet counts all of it and tells you the least you should charge.
What's inside (one Excel workbook, 3 tabs):
- Quote a job: type your target hourly rate, on-site hours, drive there and back, supply runs, quoting and admin time, callbacks, costs you don't bill back, flat fees and card or platform fees. It shows your minimum quote, rounded up to the dollar, with a plain-English line explaining it.
- Check a past job: type what you charged and every minute the job really took. It shows what you kept after fees and costs, your true hourly rate, whether you beat your target, and the price that would have hit it.
- How to use: 8 short steps and a worked example with made-up round numbers.
You type only in the shaded boxes. The formula cells are locked so they don't get typed over by accident (no password, so you can unlock them). Leave a box blank and it shows NEEDS INPUT instead of quietly treating it as zero.
Good for: handymen, painters, and any one-person trade business that quotes by the job.
Instant digital download. Nothing ships. An Excel file (.xlsx). The minimum quote is a floor worked out only from what you type in: it leaves out income taxes and any overhead you don't enter; you still check the scope of every job yourself.