Updated November 16, 2026.
Quick answer: A call log template is a table with 1 row per phone call. The simplest one has 8 columns: date, time, caller, number, reason, outcome, next step and due date. Copy it below into Notes, Excel or Google Sheets, and fill the row right after you hang up.
We make VoxNote, a call note taker. It appears once, in a section near the end marked "This one is ours." Every template on this page works without it.
Simple daily call log template
Use it for every call, in or out. 1 row per call, even the short ones.
| Date | Time | Caller | Number | Reason | Outcome | Next step | Due date |
|---|---|---|---|---|---|---|---|
| Nov 16 | 9:10 AM | Dana Ruiz, Ruiz Roofing | (555) 010-0142 | Quote for a garage roof | Gave a price range. She wants a site visit | Book the visit | Nov 18 |
| Nov 16 | 11:45 AM | Sam Lee (I called) | (555) 010-0187 | Unpaid invoice | He will pay by Friday | Check the payment | Nov 21 |
Plain text version. For a spreadsheet, paste these lines into cell A1, then split them into columns (steps just below). For Notes, keep 1 line per call.
Date, Time, Caller, Number, Reason, Outcome, Next step, Due date
Nov 16, 9:10 AM, Dana Ruiz (Ruiz Roofing), (555) 010-0142, Quote for a garage roof, Gave a price range and she wants a site visit, Book the visit, Nov 18
Put it in Excel or Google Sheets in 1 minute
- Google Sheets: paste the lines into cell A1, then click Data > Split text to columns. Sheets detects the commas on its own (Google Docs Editors Help).
- Excel: paste the lines into cell A1 and select column A. Click Data > Text to Columns, choose Delimited, tick Comma, then Finish (Microsoft Support).
- Faster: select the table above with your mouse and paste it straight into a sheet. The columns usually carry over.
- Keep the headers visible: in Excel, View > Freeze Panes > Freeze Top Row (Microsoft Support). In Google Sheets, View > Freeze > 1 row.
In this guide
- Client call notes template for 1 call
- Sales and lead call log template
- Call log for brokers and advisors
- How to fill a call log fast
- 5 mistakes that make call logs useless
- When to stop logging calls by hand
- Let the log write itself
- FAQ
Client call notes template for 1 call
A log row tells you a call happened. Call notes tell you what was said. Use this template for the calls that matter: a new client, a complaint, a price, a promise.
| Field | What to write | Example |
|---|---|---|
| Who | Name, company, role. Who called whom | Maria Chen, office manager at Chen Dental. She called me |
| Date and time | When the call started and how long it lasted | Nov 16, 2:05 PM, 12 minutes |
| Context | Why the call happened and what came before | Follow-up on the quote sent Nov 12 |
| What was said | 3 to 5 key points. Use their words for anything important | Price is OK. Worried about the start date. "We can't close the office for more than 2 days" |
| Decisions | What was agreed on the call | Work done over 2 weekends |
| We committed to | What you promised, with a date | Send a revised schedule by Nov 18 |
| They committed to | What they promised, with a date | Sign the quote once the schedule is approved |
| Follow-up | What you send next, and how | Email with the schedule and the quote to sign |
| Next contact | Date and channel of the next call or email | Nov 19, phone |
Plain text version, for Notes or an email to yourself:
Who:
Date and time:
Context:
What was said:
Decisions:
We committed to:
They committed to:
Follow-up:
Next contact:
The 2 commitment lines are the ones people skip. Keep them apart: when "we" and "they" share 1 line, a promise goes missing. If the follow-up is an email, our guide on how to send a professional follow-up email has ready wording. For a wider look at documenting client calls, see client call documentation.
Sales and lead call log template
Sales calls need a few extra columns: where the lead came from, where it stands, what holds it back and what happens next.
| Date | Lead | Company | Lead source | Stage | Need | Objection | Next step | Next step date |
|---|---|---|---|---|---|---|---|---|
| Nov 16 | Alex Brown | Brown Logistics | Website form | Qualified | Track 12 delivery vans | Price is higher than his current tool | Send a 2-month cost comparison | Nov 17 |
| Nov 16 | Priya Shah | Shah Accounting | Referral from Dana Ruiz | Proposal sent | Online booking for 3 staff | Needs her partner's OK | Call both partners | Nov 20 |
Plain text version:
Date, Lead, Company, Lead source, Stage, Need, Objection, Next step, Next step date
How to get the most from it:
- Pick 5 or 6 stage names and keep them, for example New, Contacted, Qualified, Proposal sent, Won, Lost. Fixed values let you filter and count.
- Write the objection in the lead's words. "Too expensive" and "too expensive next to our current tool" call for different answers.
- Every row gets a next step and a date, even if the step is "close as lost".
- Sort by next step date each morning. That is your call list for the day.
Call log for brokers and advisors
Mortgage brokers, insurance brokers and financial advisors often keep a written trace of what they told a client and when. This is a practical format for that kind of record.
It is not a compliance standard. It is not built to meet the rules of any regulator, and it is not legal or compliance advice. Your regulator, your firm or your compliance officer decides what you must record, how and for how long. Check their rules and adapt the columns.
| Date and time | Client name | File number | Topic | Advice or information given | Documents requested | Disclosure made | Follow-up |
|---|---|---|---|---|---|---|---|
| Nov 16, 10:30 AM | J. Martin | 2026-118 | Renewal options | Explained fixed and variable terms. No recommendation yet | Last 2 pay stubs, renewal letter | Told the client how I am paid on this file | Send a comparison by Nov 19 |
| Nov 16, 3:15 PM | K. Osei | 2026-097 | Change of address | Information only | Proof of address | None | Update the file, confirm by email |
Plain text version, 1 block per call:
Date and time:
Client name:
File number:
Topic:
Advice or information given:
Documents requested:
Disclosure made:
Follow-up:
How to keep it useful:
- Write facts, not impressions. "Client said the down payment is a gift from her parents" beats "client seems fine with the gift".
- Keep advice and information apart. "Explained the 2 options" is not the same as "recommended option A".
- Write "None" under Disclosure made when there was none. A blank cell can mean you forgot.
How to fill a call log fast
A log only works if filling it takes less time than skipping it. Aim for under 1 minute per call.
- Open the log before you dial. Fill in the date, time, name and reason before the call starts.
- During the call, write keywords only. Numbers, dates, names and promises.
- Finish the row right after you hang up. Before the next call and before email: outcome, next step, due date.
- Let your phone keep the facts. On iPhone, the Recents list in the Phone app shows the number and time of each call. You do not need to write those during the call.
- Write the next step as a verb and a date. "Send quote Nov 18" beats "quote".
- Use the same words every time. Pick a short list of outcomes, such as Done, Waiting on them, Waiting on me and Lost.
- Review it for 5 minutes at the end of the day. Sort by due date and move anything overdue to the top of tomorrow.
For more on keeping the details in a call log, see logging phone calls without losing the details.
5 mistakes that make call logs useless
- Filling it from memory at the end of the week. By Friday, Tuesday's calls blur together. The details that matter, like a number or a deadline, go first. Same day or not at all.
- No next step, or no date. A row that ends with "discussed options" tells you nothing tomorrow. Every row needs 1 action and 1 date.
- Vague summaries. "Talked about pricing" is not a record. "She accepted $4,200 if we start before Dec 1" is.
- Free text in the columns you sort. If Stage says "hot", "Hot lead" and "very interested" on 3 rows, you cannot filter it. Fix the values for Stage and Outcome.
- Logs in 3 places. A notebook, phone notes and a CRM means none of them is complete. Pick 1 home for the log and keep everything there.
When to stop logging calls by hand
A paper or spreadsheet log is enough for a few calls a week. It is free and private.
Logging by hand starts to fail when:
- You take calls back to back and the row never gets finished.
- You need the exact words later: a price, a promise, a client's instruction.
- You take calls while driving or on a job site, where you cannot write.
At that point you have 3 options:
- A phone system or CRM with call logging. Business phone systems and CRMs with a phone integration usually record the time, number and length of each call. You still write what was said.
- Call recording and transcription. You get every word, then you still read it and pull out the next steps. Check the consent rules where you and the caller live before you record. See our comparison of the best call recording apps for iPhone.
- A call note taker. It writes a summary of each call for you.
Let the log write itself
This one is ours. VoxNote is an iPhone app that takes notes on your phone calls, on the number you already have. Calls you receive reach it through call forwarding, which you set up with your carrier. Calls you make are dialed from the VoxNote app, and the person you call sees your number.
After each call you get:
- A summary of the call
- The full transcript
- A follow-up email draft, ready to edit and send
So every call gets its own written record, and the log writes itself. VoxNote also connects to ChatGPT, Claude, Grok and Meta Muse, so you can ask your AI about past calls, such as what you promised a client last week.
VoxNote takes 5 minutes to set up through the App Store and can be ready before your next phone call. Plans start at $16.99 a month, or $159.99 a year (about $13.33 a month), with a 7-day free trial (pricing).
Who it is not for: if you make a few calls a week, keep the template. VoxNote makes sense when calls are your work, as they are for brokers, advisors, contractors and sales reps. To see what a recap of a full day of calls looks like, read daily phone call summary.
FAQ
What should a call log include?
At minimum: the date and time, who you spoke with, their number, why they called, what came out of the call, the next step and its due date. Sales teams add the lead source, the stage and the objection. Brokers and advisors often add a file number, the advice or information given, the documents requested and any disclosure made.
How do I create a call log in Excel?
Open a blank workbook and type the column names in row 1: Date, Time, Caller, Number, Reason, Outcome, Next step, Due date. Or paste the plain text line from this page into cell A1, then use Data > Text to Columns with Comma as the delimiter. Freeze the top row, then add 1 row per call.
How do I make a call log in Google Sheets?
Open a blank spreadsheet in Google Sheets and paste the header line from this page into cell A1. Click Data > Split text to columns, and Sheets splits the line at each comma. Freeze the first row with View > Freeze > 1 row, then use Data > Create a filter to sort your calls by due date.
How do I create a call log?
Pick 1 place for it: a notebook, the Notes app or a spreadsheet. Choose 6 to 8 columns, starting with date, caller, reason, outcome and next step. Add 1 row right after every call, in or out. Review it at the end of each day and act on anything due.
What is the difference between a call log and call notes?
A call log is a list: 1 short row per call, so you can see all your calls at a glance and sort them. Call notes cover 1 call in detail: what was said, what was decided and who promised what. Most people need both, a log for every call and notes for the calls that matter.
Can I keep a call log on my iPhone?
Yes. The Recents list in the Phone app shows who called and when, but not what was said. Copy the plain text template from this page into the Notes app and add 1 block per call, or keep the spreadsheet version in Numbers, Excel or Google Sheets on your iPhone.
How long should I keep a call log?
There is no single rule. Keep it at least as long as you might need to check what was said, for example until a job is paid or a dispute is settled. Brokers, advisors and other regulated professionals may have set retention periods, so check with your regulator, your firm or your compliance officer. This page is not legal advice.
Can a call log fill itself automatically?
Partly. Business phone systems and CRMs with a phone integration can record the time, number and length of each call, but someone still has to write what was said. Call note takers write it for you. VoxNote, which we make, sends a summary, the full transcript and a follow-up email draft after each call on your own number.
