Handyman Business Profit Tracker Excel with job costing, a quote builder with markup pricing, expenses by category, and a monthly P and L dashboard. Know what every job actually made — and what every hour is worth.…
About this template
Handyman Business Profit Tracker Excel with job costing, a quote builder with markup pricing, expenses by category, and a monthly P and L dashboard. Know what every job actually made — and what every hour is worth. Built for handymen, handywomen, and small repair contractors who price jobs by feel and want the numbers instead — without accounting software. If a job pays badly per hour, this workbook shows it before you quote the next one like it.
$39
Excel & Google Sheets template — instant download on Etsy
Jobs — date, client, service, hours, price charged, materials, and other job costs (dump fees, parking, a helper's pay) for every job. Profit, profit per hour, and margin fill in by formula. Profit equals price minus materials minus other job costs.
Quotes — quote builder with line items, quantity, unit cost, and markup percent. Line cost, quoted price, and profit fill in by formula. Quoted price equals line cost times 1 plus markup. Set the client, quote number, date, and status (Won, Lost, or Pending) at the top. Give the client the quoted total — keep the profit column for yourself.
Materials and Expenses — business expenses by category: Materials, Fuel, Tools, Insurance, Other. Job materials stay on the Jobs sheet, so nothing is counted twice. A totals-by-category summary sits below the log.
Monthly P and L — jobs, hours, revenue, job costs, and business expenses by month, Jan-Dec, with net profit, margin, and profit per hour. All formulas from sheets 1 and 3.
Dashboard — total revenue, jobs, hours, expenses, net profit and margin, average profit per job, profit per hour, best and worst jobs, costs by category, and the sample quote summary.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Handyman Business Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Handyman Business Profit Tracker track?
The Handyman Business Profit Tracker tracks Jobs; Quotes; Materials and Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 9,955 from 20 jobs and 80.00 hours; average price per job 497.75.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.
This template is a bookkeeping and planning tool only — not tax, legal, or CPA advice. Built by an accountant: B.S. Accountancy, ASU W. P. Carey.
VickeryFinance — “Know your numbers — without the accounting software.”
Gear that pairs with this tracker
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you. We only list gear genuinely used in this trade.