Call Tracking Sheet Template: The 10 Columns

The ten columns, and the job each one does

A blank grid is easy to find. Deciding what the grid is for is the part that takes a minute, so here is the reasoning behind each column rather than just the heading.

• Date and time. Separate columns. Time is what lets you sort the sheet by hour later and see when the phone actually rings, which is a different question from how many calls you get.
• Caller. A name if you got one, and the word Unknown if you did not. An empty cell reads as a row somebody forgot to finish.
• Number. One format throughout, country code included, or sorting and de-duplicating the column will not work and you will count the same person twice.
• Found us via. The tracking column. Their words, not a tidied category: the van, your sign, the school group. Tidy it into Referral and you throw away the only part that tells you what to repeat.
• Wanted. One line on what they were ringing about. This is what tells you whether a source sends you the work you want or the work you keep turning down.
• Answered. Yes or No, in its own column rather than buried in the outcome. On its own it is the most useful column in the sheet, because every comparison you draw is only as good as the share of calls that produced a row at all.
• Outcome. What the call turned into: booked, quoted, not for us, no contact yet. Keep the list of words short and reuse them exactly, so the column can be counted instead of read.
• Call back by. A date, or a dash if nothing is owed. A sheet with this column sorts into a day's work; a sheet without it is a diary you reread.
• Owner. One name. Two people half-owning a callback is the most common way a tracked call still gets dropped.

Copy the sheet, columns already named

The header row with three worked rows: one call that went well, one nobody reached, and one closed on the spot.

Date	Time	Caller	Number	Found us via	Wanted	Answered	Outcome	Call back by	Owner
2026-11-01	09:14	J. Mercer	+1 555 0142	Google search	Quote, two rooms	Yes	Quote to send	2026-11-04	Sam
2026-11-01	12:36	Unknown	+1 555 0188	Unknown	Unknown	No	No contact yet	2026-11-02	Sam
2026-11-01	15:02	R. Okafor	+1 555 0117	Van sign	Callback on invoice	Yes	Closed on the call	-	Priya

If you would rather tick the columns you want and download the file ready-made, the generator builds it.

Call log template: pick your columns, download the sheet.

Three rules that keep the sheet worth reading

Nothing here is about the spreadsheet. All three are about the ten seconds after the phone goes down, which is where tracking sheets are won and lost.

• Ask the source on the call, never afterwards. Reconstructed sources are guesses, and guesses pollute the one column you are keeping the sheet for.
• Write the row before the next thing. What survives a delay is the number and the time, which you could recover from a handset anyway. What evaporates is the source and what they wanted.
• Give every row a verdict. No row is finished until Outcome and Call back by are filled, with a dash standing for nothing owed. Blanks are where tracked calls go to die.

Why the sheet flatters your good hours

Here is the problem nobody mentions when they hand over a template. A tracking sheet exists to compare sources, and a comparison needs the same chance of being recorded on both sides. Rows are typed by whoever picked up, so a source that rings mid-morning at a desk gets a row nearly every time, and a source that rings at lunchtime, during a job, or ten minutes after you lock up gets one only when somebody later notices a number on a handset and goes back to write it in.

So the sheet does not simply undercount. It tilts, in favour of whichever source happens to arrive when you are free, and the decision you take from it, more of that advert, drop that listing, is tilted the same way. The fix is not a column. It is making the record happen even when nobody is free to make it.

Missed calls: what happens to the ones that never get a row.

Let the call write its own row

ReadyToTalk is the AI front office for your existing number. Calls ring through to you or your team as they do now; when you do not pick up, the AI answers, you are told who called, and a voicemail reaches you as text. A keypad menu can answer and route instead, if you would rather. None of it fills the sheet in for you, but it means an unanswered call leaves something behind to paste in, so the quiet hours stop being blank.

Three ready wordings, by the gap they cover. Each one can be set up on your number as it is written here.

When you are already on a call. A fixed text to the caller you missed, asking for the thing you would otherwise have to ring back to ask.

Set this up with ReadyToTalk to send it to the callers you miss, at the founding price of $19.99 a month plus usage.

Outside opening hours. An out-of-office message the number answers with, then the voicemail comes to you as text.

Set this up with ReadyToTalk to answer your calls with it while you're out, at the founding price of $19.99 a month plus usage.

When you want the reason before you speak. A keypad menu that sorts callers by what they want, so the Wanted column is already answered.

Set this up with ReadyToTalk to answer your calls with this menu, at the founding price of $19.99 a month plus usage.

Set up in under a minute. No credit card. You can also hear it answer your own phone first, or read what usage costs before you change anything.

Call tracking, defined

Call tracking is attributing an incoming call to whatever made it happen, and following it to an outcome. The industrial version buys a separate number per advert and matches calls to numbers automatically. The spreadsheet version asks the caller and writes it down. The second is free, works for a handful of sources, and is accurate exactly as often as the rows get written.

If what you actually want is the calls filed per client with what was agreed on each, that is a different sheet with different columns.

Client phone log: the same calls, filed per client.