Free worksheet · updated 2026-11-09
How to Audit Your Missed Calls in One Week (Free Printable Worksheet)
Most owners guess how many calls they miss. This one-week audit replaces the guess with a count: every missed call, why it was missed, what happened when you called back, and what it was worth. It takes a few minutes a day and works with any phone.
The short answer
To audit your missed calls, pull your phone or carrier call log every day for one week, log each missed call with its time and caller, tag why it was missed (after hours, busy, hung up on hold, or nobody free), call every one back and record the outcome, then count each reason and put a dollar value on the calls that were real leads.
The 7-step missed-call audit
- 1
Pick a normal week and set up the worksheet
Choose seven days that look like a typical week — not a holiday or your slowest season. Print the worksheet below (one row per missed call) or use the on-page log, and keep it next to whoever answers the phone.
- 2
Pull your call log every day
Your phone keeps the record for you. On a mobile, open the phone app's recent calls and filter to missed calls. On a business phone or VoIP system, look for the call history or call-detail report in the admin portal — most can export a spreadsheet. If your plan doesn't show unanswered calls, ask your carrier what it can provide, and keep a tally by hand. Do this daily: some logs only keep a limited history.
- 3
Log every missed call: day, time and caller
Write each one down — including calls that went to voicemail and calls with no message. Note the day, the time and the number or name. Leave nothing out because it 'was probably spam'; you'll sort that out when you call back.
- 4
Tag why it was missed
Give each call one reason: after hours (you were closed), busy (you were on another call or with a customer), hung up on hold, or rang out (it was open hours and nobody was free). The reason tells you which fix you need — longer hours, a second line, or something that answers when you can't.
- 5
Call every one back and log what happened
Return each call as soon as you can — speed matters (see the research below). Record the outcome: booked or sold, they'd already gone elsewhere, you couldn't reach them, or it wasn't a lead. 'Went elsewhere' is the number that hurts most, and the one most owners never see.
- 6
Count by reason: after hours vs busy vs hold
At the end of the week, total each reason. If most misses are after hours, the problem is coverage. If most are busy or rang out during the day, the problem is capacity. Hold hang-ups mean callers are waiting too long.
- 7
Put a dollar value on it
For each call that was a real lead, write down what a new customer like that is usually worth to you. Then run your week's numbers — missed calls, average value and how many call-backs turned into customers — through the missed-call calculator for a monthly and yearly figure. Open the missed-call calculator.
The printable worksheet
Seven days, six rows a day. Print it, keep it by the phone, and fill in a row for every missed call. Day 1 is shown here; the printout has all seven.
One-week missed-call audit
Business: ______________________
Reason codes: A = After hours · B = Busy / on another call · C = Hung up on hold · D = Rang out (nobody free) · E = Other. Outcome: booked · went elsewhere · couldn't reach · not a lead.
Day 1 · date: ____________
| Time | Caller | Reason missed | Called back? | Outcome | Est. value |
|---|---|---|---|---|---|
Day 2 · date: ____________
| Time | Caller | Reason missed | Called back? | Outcome | Est. value |
|---|---|---|---|---|---|
Day 3 · date: ____________
| Time | Caller | Reason missed | Called back? | Outcome | Est. value |
|---|---|---|---|---|---|
Day 4 · date: ____________
| Time | Caller | Reason missed | Called back? | Outcome | Est. value |
|---|---|---|---|---|---|
Day 5 · date: ____________
| Time | Caller | Reason missed | Called back? | Outcome | Est. value |
|---|---|---|---|---|---|
Day 6 · date: ____________
| Time | Caller | Reason missed | Called back? | Outcome | Est. value |
|---|---|---|---|---|---|
Day 7 · date: ____________
| Time | Caller | Reason missed | Called back? | Outcome | Est. value |
|---|---|---|---|---|---|
Prefer to log it here? The on-page worksheet
Add each missed call as you go. The page totals them by reason and hands your numbers to the missed-call calculator in one click.
Saved in this browser only — nothing you type here is sent to us.
Why the call-back and the hold time matter
3 in 4 consumers say they will hang up rather than wait on hold.
Source: Invoca Buyer Experience Benchmark Report (500 US consumers) (2021)
Companies that tried to contact a lead within an hour were nearly 7× as likely to qualify the lead — a meaningful conversation with a decision-maker — as those that tried even an hour later.
Source: Harvard Business Review, "The Short Life of Online Sales Leads" (audit of 2,241 companies) (2011)
More sourced research in our small business phone statistics.
What to do with your results
Hear how an AI receptionist would handle the calls you logged with the free call simulator, see what it costs on pricing, compare options in the alternatives and the buyer's guide, or browse setups by industry.
Common questions
How long should a missed-call audit run?
One full week, seven days in a row. A week catches the difference between weekdays and weekends and between mornings and evenings, and it's short enough that you'll actually finish it. If your business is very seasonal, repeat the audit in your busy season.
Where do I find my missed calls?
In your phone's recent-calls list (filter to missed), or in the call history or call-detail report of your business phone system's admin portal. Many systems can export a spreadsheet. If your plan doesn't record unanswered calls, ask your carrier what it offers and keep a tally by hand for the week.
Should I count calls that went to voicemail?
Yes. A call that reaches voicemail was still not answered. Log it, tag the reason, and note whether the caller left a message — then call back either way.
How do I estimate what a missed call is worth?
Use your own numbers: what a typical new customer spends with you, and how many of the people you called back actually booked. Multiply the missed calls that were real leads by that value. The missed-call calculator does the monthly and yearly math for you.
What should I do with the results?
Match the fix to the reason. Mostly after hours: you need coverage when you're closed. Mostly busy or rang out: you need capacity during the day. Hold hang-ups: shorten the wait. An AI receptionist covers all three by answering every call at once, 24/7 — but the audit is worth doing whatever you decide.
Stop counting missed calls. Answer them.
Ahoya answers every call 24/7, books appointments and texts your team. Free to start, no card.