Your four questions and the hire test
Read top to bottom: cash now, cash ahead, which work pays, who owes you, then whether you can add a tech.
Cash you can spend today
What's yours to spend once you set aside what you already owe.
$22,983 over your $144,170 floor
Uncleared items: $22,385 in checks your bank hasn't paid yet. Your bank shows $234,784.
You can spend $167,152 today, $22,983 over your $144,170 floor. That's after setting aside the card balance and October 16's payroll.
See the numbers as a table
| Piece | Amount |
|---|---|
| In the bank (your books) | $212,400 |
| Received, not yet deposited | $6,982 |
| Customer deposits you’re holding | −$4,155 |
| Card balance due | −$30,001 |
| Sales tax owed | −$1,283 |
| Next payroll, Oct 16 | −$16,790 |
| Cash you can spend | $167,152 |
Cash in the bank, next 13 weeks
Where cash is headed, week by week. Tight weeks show up here before they show up at payroll.
Week 7 dips to $163.2K, $19.0K over your $144.2K floor. Two payrolls and the $52,600 bill from your equipment distributor land the same week. Hold the next two owner draws and week 7 holds $179.8K.
Floor $144,170: the larger of $53,974 (next payroll plus a cushion) and $144,170 (three months of fixed costs). At one month it would be $53,974. You can change it any time.
At four weeks out, the ending-cash forecast has landed within $39.5K 80% of the time, over 26 weekly cycles.
DefaultCollection curve. The later aging buckets use the Gaviti default until about 30 of your own paid invoices land in each.
Shading darkens with confidence: weeks 1 and 2 come from scheduled items, 3 to 6 from approved bills and booked work, 7 to 13 from your seasonal pattern.
See the numbers as a table
| Line | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Week starting | Oct 12 | Oct 19 | Oct 26 | Nov 2 | Nov 9 | Nov 16 | Nov 23 | Nov 30 | Dec 7 | Dec 14 | Dec 21 | Dec 28 | Jan 4 |
| Opening cash (bank) | $234,784 | $179,839 | $189,619 | $179,499 | $205,424 | $180,343 | $208,125 | $163,170 | $201,807 | $237,095 | $229,262 | $244,314 | $241,606 |
| + Deposits on the way and received, not deposited | $6,982 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| + Collections on money owed to you | $2,598 | $5,407 | $5,580 | $2,142 | $103 | $103 | $13,603 | $27,103 | $13,603 | $103 | $103 | $103 | $103 |
| + Booked work (from your job software) | $3,598 | $1,741 | $696 | $540 | $0 | $0 | $0 | $0 | $54,000 | $0 | $0 | $0 | $0 |
| + Maintenance plan renewals | $2,520 | $1,512 | $1,764 | $2,268 | $1,260 | $2,520 | $3,024 | $3,528 | $2,772 | $3,276 | $3,024 | $2,772 | $1,764 |
| + Financing company payouts | $8,919 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| + Work not booked yet (your last three years) | $4,264 | $16,744 | $25,702 | $36,193 | $36,733 | $36,715 | $36,711 | $36,619 | $0 | $36,622 | $36,726 | $36,862 | $37,405 |
| − Payroll with employer taxes | $16,790 | $8,593 | $16,790 | $8,593 | $16,790 | $8,593 | $16,790 | $8,593 | $16,790 | $8,593 | $16,790 | $8,593 | $16,790 |
| − Checks written, not cleared yet | $22,385 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| − Owner draws (your call) | $0 | $0 | $17,000 | $0 | $0 | $0 | $17,000 | $0 | $0 | $0 | $0 | $17,000 | $0 |
| − Bills you owe, by due date | $11,452 | $4,999 | $1,228 | $1,056 | $10,991 | $0 | $52,600 | $0 | $0 | $0 | $0 | $0 | $0 |
| − Rent, insurance and other fixed costs | $3,199 | $750 | $8,843 | $3,000 | $13,599 | $750 | $0 | $11,843 | $10,400 | $3,949 | $0 | $8,843 | $13,400 |
| − Truck and equipment loans | $0 | $0 | $0 | $2,570 | $0 | $0 | $0 | $2,570 | $0 | $0 | $0 | $0 | $2,570 |
| − Credit card payment | $30,001 | $0 | $0 | $0 | $21,796 | $0 | $0 | $0 | $0 | $21,796 | $0 | $0 | $0 |
| − Sales tax | $0 | $1,283 | $0 | $0 | $0 | $1,283 | $0 | $0 | $0 | $1,283 | $0 | $0 | $0 |
| − Insurance, true-ups and estimates | $0 | $0 | $0 | $0 | $0 | $0 | $8,250 | $0 | $0 | $4,200 | $0 | $0 | $0 |
| − Parts for work not booked yet | $0 | $0 | $0 | $0 | $0 | $930 | $3,653 | $5,607 | $7,896 | $8,014 | $8,010 | $8,009 | $7,989 |
| Ending cash | $179,839 | $189,619 | $179,499 | $205,424 | $180,343 | $208,125 | $163,170 | $201,807 | $237,095 | $229,262 | $244,314 | $241,606 | $240,129 |
| Your floor | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 | $144,170 |
| Same week last year | $183,156 | $184,854 | $175,852 | $193,454 | $198,752 | $195,835 | $203,224 | $195,643 | $187,332 | $183,654 | $164,960 | $180,630 | $184,394 |
| Customer deposits held (in the totals above) | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 | $4,155 |
Which work makes money
Revenue and what each type of job kept, before truck costs.
Maintenance plans kept the most, 65.4% before truck costs. Commercial kept the least at 31.0%, down from 34.1% last year.
See the numbers as a table
| Job type | Revenue | Share | Cost of goods | Gross profit | Margin | Target band | Last year margin |
|---|---|---|---|---|---|---|---|
| Replacements and installs | $307,150 | 53.8% | $179,760 | $127,390 | 41.5% | 35% to 50% | 38.8% |
| Service calls | $172,884 | 30.3% | $72,862 | $100,022 | 57.9% | 50% to 65% | 54.7% |
| Commercial | $55,066 | 9.6% | $38,002 | $17,064 | 31.0% | none published | 34.1% |
| Maintenance plans | $36,300 | 6.4% | $12,543 | $23,757 | 65.4% | 40% to 60% | 62.0% |
| All job types | $571,400 | 100.0% | $303,166 | $268,234 | 46.9% |
July to September, closed months. Bars show revenue; the thin line under each shows what it kept, with the target band shaded.
Maintenance plans kept the most, 61.3% before truck costs. Commercial kept the least at 31.1%.
See the numbers as a table
| Job type | Revenue | Share | Cost of goods | Gross profit | Margin | Target band | Last year margin |
|---|---|---|---|---|---|---|---|
| Replacements and installs | $1,052,250 | 53.5% | $640,262 | $411,988 | 39.2% | 35% to 50% | n/a |
| Service calls | $586,396 | 29.8% | $265,617 | $320,779 | 54.7% | 50% to 65% | n/a |
| Commercial | $188,235 | 9.6% | $129,668 | $58,567 | 31.1% | none published | n/a |
| Maintenance plans | $140,500 | 7.1% | $54,345 | $86,155 | 61.3% | 40% to 60% | n/a |
| All job types | $1,967,381 | 100.0% | $1,089,892 | $877,489 | 44.6% |
October to September, closed months. Bars show revenue; the thin line under each shows what it kept, with the target band shaded.
Money owed to you
Unpaid invoices, by how long they're late. Tap a customer to call.
Five biggest balances (sample phone numbers)
10 days late$55,898
not due yet$8,159
103 days late$6,840
25 days late$1,959
not due yet$992
You're owed $76,466 on 12 invoices. $6,840 of it is over 90 days late, all from Oak Hollow Apartments. Expect about $12,789 in by October 31.
See the numbers as a table
| Age | Invoices | Amount | Share |
|---|---|---|---|
| Current | 6 | $64,169 | 83.9% |
| 1 to 30 days late | 4 | $5,457 | 7.1% |
| 31 to 60 days late | 0 | $0 | 0.0% |
| 61 to 90 days late | 0 | $0 | 0.0% |
| Over 90 days late | 2 | $6,840 | 8.9% |
| Total owed | 12 | $76,466 | 100.0% |
Can you afford to hire?
Set the all-in monthly cost: wage, payroll taxes, insurance, phone and the truck.
Cash with and without the hire
Ending cash for 13 weeks. The dotted line carries the hire's cost while the new tech ramps up.
Demand: your techs are booked at 115% of their hours (Housecall Pro, last 13 weeks).
Cover: 1.48 on the service calls margin, 54.7%.
Cash: $17,739 over your floor at the tightest week with the hire.
Slowest three months (Apr, Oct, Mar): with one more tech, each would bring in about $16,507 a month, against the $14,076 a month the hire needs to break even.
See the numbers as a table
| Week | Without the hire | With the hire | Floor |
|---|---|---|---|
| Wk 1 | $179,839 | $179,377 | $144,170 |
| Wk 2 | $189,619 | $188,695 | $144,170 |
| Wk 3 | $179,499 | $178,113 | $144,170 |
| Wk 4 | $205,424 | $203,576 | $144,170 |
| Wk 5 | $180,343 | $178,691 | $144,170 |
| Wk 6 | $208,125 | $206,668 | $144,170 |
| Wk 7 | $163,170 | $161,909 | $144,170 |
| Wk 8 | $201,807 | $200,741 | $144,170 |
| Wk 9 | $237,095 | $236,883 | $144,170 |
| Wk 10 | $229,262 | $229,903 | $144,170 |
| Wk 11 | $244,314 | $245,808 | $144,170 |
| Wk 12 | $241,606 | $243,953 | $144,170 |
| Wk 13 | $240,129 | $243,329 | $144,170 |
Revenue the hire must produce
Rules of thumb, which disagree by more than two to one:
- $200,000 a year per service truck (Leach, 2013)
- $343,200 per single-tech truck (Ruth King's hourly build-up)
- $461,958 at five times burdened cost, a stretch goal, not a gate
Trucks: the cost above includes a dedicated truck. We plan the Section 179 and bonus depreciation timing with you. Your CPA files the return.
See the numbers as a table
| Cost | A year | A month |
|---|---|---|
| Base pay | $62,940 | $5,245 |
| Social Security and Medicare | $4,815 | $401 |
| Federal unemployment | $42 | $4 |
| State unemployment | $140 | $12 |
| Workers' comp | $2,455 | $205 |
| Health insurance | $5,400 | $450 |
| Truck (lease, insurance, upkeep) | $12,600 | $1,050 |
| Software seat | $3,000 | $250 |
| Training | $1,000 | $83 |
| All in | $92,392 | $7,699 |
The rest of the picture
The numbers behind the numbers, and anything Frank is working on.
Data quality
Books are clean through the last close. Every number ties to QuickBooks.On track
Books are clean through the last close. Every number ties to QuickBooks.On track
- Every September cost is assigned to a job type.On track
- 2 open jobs are still collecting costs; labor posts at the monthly close.On track
- Field payroll is split by job type through the last close.On track
- Payments received but not yet deposited are shown apart from cash in the bank.On track
- Book and bank agree through the last statement.On track
- No late invoice has an unapplied payment sitting beside it.On track
- Owner draws sit in equity, not expenses.On track
- Your job software shows $156,395 for September, your books show $154,555. The difference is two invoices not yet exported.On track
Recurring base
On track474 customers are on a plan, 19.0% of your customers. Most shops sit under 15%. At 30% the base would bring in $225,000 a year.
Sources: Plan invoices in QuickBooks. Reference: Contracting Business, 2016; Margin One (best-in-class residential).
Revenue per tech and per truck
On trackEach of your seven field people brought in $281,054 over the last 12 months, over the well-run band. Each truck carries $19,887 a year of overhead.
Sources: Steph's Books HVAC margins. Per truck: ShareWillow (observations from 200-plus shops); Leach, ACHR News 2013 ($200K per service truck).
Open jobs
On trackParkview Medical SuitesRooftop unit replacement · Commercial · bid $108,000costs still landing
Complete87%Spent vs budget$62.9K of $72.0KProjected margin33.3%bid 33.3%Next invoice#2 · $54,000Nov 26
Tap to close. Cost groups and every line behind this card sit in the monthly report.
Michael GriffinSystem replacement · Replacements and installs · bid $13,850costs still landing
Complete63%Spent vs budget$5.4K of $8.6KProjected margin38.0%bid 38.0%Next invoiceFinal · $9,695Ready to bill
Tap to close. Cost groups and every line behind this card sit in the monthly report.
Spent against budget is cost to date over the job budget. Labor posts at the monthly close.
Bills you owe
On trackdue Nov 25$52,600
due Oct 10$9,499
due Nov 6$6,400
due Nov 8$4,591
due Oct 18$4,094
See the numbers as a table
| Age | Bills | Amount |
|---|---|---|
| Current | 7 | $70,875 |
| 1 to 30 days late | 3 | $11,452 |
| 31 to 60 days late | 0 | $0 |
| 61 to 90 days late | 0 | $0 |
| Over 90 days late | 0 | $0 |
| Total | 10 | $82,327 |
From Housecall Pro
On trackYour software shows $156,395 for September, your books show $154,555. The difference is two invoices not yet exported.
Ask Frank about a number
Pick the number, ask in your own words. You get a reply by the next business day, and questions never cost extra.
This is a sample shop, so questions here go nowhere. Want this built on your own numbers? Book a call with Frank.

























