A Tally Sheet for Estimating Your Own Missed Enquiries Honestly

A missed call from an unknown number feels like a lost job. Usually it isn't. Some calls are spam, some are suppliers, and some are people who only wanted a price. A tally sheet kept over a few weeks lets you replace that gut sting with a number you can defend.

Set up the sheet

You need one page, paper or spreadsheet, with five columns:

1. Day and time of the missed call
2. Number (or "withheld")
3. Pile: known, noise, or possible work
4. What happened next
5. Outcome: job, spoke but didn't book, never reached, or unknown

Choose a typical stretch of a few weeks. Avoid holidays and freak weather, or your totals will mislead you. Pull the entries from your phone's call history, and include any business line, landline or voicemail inbox you use. Calls you never logged are the ones memory undercounts.

Fill in the pile column strictly

Be harsh here, because this column decides the whole result.

• Known: suppliers, merchants, family, other trades, and existing customers chasing something already booked. Note existing customers separately. They matter, but they aren't new work walking away.
• Noise: sales calls, wrong numbers, withheld numbers that never came back.
• Possible work: unknown numbers that could plausibly have been a new enquiry.

Only the third pile feeds your estimate. Everything else gets a tick and is left alone.

Chase the evidence for each possible-work call

For every entry in the third pile, fill in the "what happened next" column. Ask yourself:

• Did they leave a voicemail? Lots of people don't, so no message doesn't prove it wasn't a job.
• Did you ring back, and what came of it?
• Did they text, email or message your business page instead?
• Did the same number ring again later?

Then mark the outcome. "Became a job" shows that missed calls can convert. "Spoke but didn't book" is a useful reminder that plenty of callers are only comparing. "Never reached" is where your estimate lives, and it is genuinely uncertain. Leave "unknown" as unknown. Don't promote it to a job because it would be a nice result.

Turn the tally into a cautious guess

Count each outcome at the end of the stretch. Then work through the "never reached" group, and be gloomy about it:

• Think of the last handful of enquiries you did answer. How many ended in a booking? That is a fairer yardstick than your best-ever week.
• Would you actually have been free, and is the caller likely to have been in an area you cover?
• Does the type of job suit what you normally take on?

Write your guess as a range, such as "a few to several", not a single confident figure. Then take the low end for any planning. If the low end still looks worth caring about, you have a reason to act. If it doesn't, you've saved yourself from fixing a problem that isn't big.

The page on an honest estimate of how many missed callers would have booked covers the same cautious approach: build from your own records, sort the calls, check what happened next, and trim the guess.

Keep the sheet useful afterwards

A few habits make the sheet worth repeating:

• Note the time of day. If misses cluster while you're on a roof or under a sink, that tells you where the gap is.
• Log callbacks as you make them. A quick note beside each entry is easier than reconstructing it later.
• Redo it after any change. If you try a different way of handling calls, run the sheet again for a similar stretch and compare like with like.
• Keep the existing-customer notes. Even if they don't count as lost new work, repeated misses from people you already serve are worth knowing about.

What the sheet can't tell you

It can't tell you what a silent caller wanted, and it won't give you a precise figure. What it gives you is a number that comes from your own phone, sorted with honest rules, and trimmed so it doesn't flatter you. That is enough to decide whether missed enquiries deserve more of your attention, and it stops you from treating every unknown number as a job you lost.