Customer inquiries can arrive through phone calls, email, social media, website forms, and in-person conversations. A simple inquiry log gives you one reliable place to record each request, track the next step, and make sure promising customers do not disappear in a busy week.
What a customer inquiry log does
A customer inquiry log is a running list of people or organizations that have contacted your business but have not yet completed the next important step. That step might be scheduling an appointment, receiving an estimate, choosing a service, placing an order, or confirming a project date.
The log is not meant to replace every customer record or accounting system. Its purpose is narrower: it helps you manage the period between first contact and a clear outcome.
A useful log should answer these questions quickly:
- Who contacted the business?
- How can you reach them?
- What do they need?
- When did they contact you?
- What did you promise to do next?
- Who is responsible for the follow-up?
- When should the next contact happen?
- What happened to the inquiry?
If you cannot answer those questions in less than a minute, the log is probably too complicated or inconsistently maintained.
Choose a tool you will actually use
The best tool is the one you can update immediately after an inquiry arrives. For many small businesses, a spreadsheet is enough. Google Sheets works well when several people need access, while Microsoft Excel is convenient for a single person or an office already using Microsoft 365.
Other workable options include:
- A paper logbook kept beside the phone.
- A shared document with a simple table.
- A task-management app with one task per inquiry.
- A customer relationship management system if your inquiry volume is growing.
- A website form that sends entries automatically to a spreadsheet.
Avoid starting with a complex system simply because it has many features. If staff members must open several screens, choose from dozens of categories, or enter information customers never provided, updates will be delayed or skipped.
A practical approach is to begin with a spreadsheet for two to four weeks. Once you understand what information you really need, you can add automation or move to dedicated software.
Set up the essential columns
Create one row for each new inquiry and one column for each type of information. Keep the first version small enough that someone can complete it in under two minutes.
Recommended columns include:
| Column | What to record | Example |
|---|---|---|
| Date received | When the inquiry arrived | September 24, 2026 |
| Customer name | Person or organization name | Jordan Lee |
| Contact details | Phone, email, or preferred channel | jordan@example.com |
| Inquiry summary | The customer’s main request | Estimate for fence repair |
| Source | Where the inquiry came from | Website form |
| Status | Current stage | Needs reply |
| Next action | Specific follow-up task | Call after reviewing photos |
| Follow-up date | When the next action is due | September 26, 2026 |
| Owner | Person responsible | Maria |
| Outcome | Final result | Quote sent |
You may also add location, estimated value, service type, preferred appointment time, or notes about access requirements. Add these only if they help someone make a decision or complete a follow-up.
Use a short, consistent set of statuses. For example:
- New
- Needs reply
- Waiting for customer
- Estimate sent
- Scheduled
- Won
- Closed or not a fit
Do not use a different status for every minor situation. “Waiting for customer” can cover several reasons, including waiting for measurements, photos, approval, or a response to a quote.
Capture inquiries consistently
Decide what counts as a new inquiry. A customer asking, “Are you open today?” may not need a full sales record, while someone requesting a service price probably does. Write a short rule for your team, such as: “Log any request that could lead to a sale, appointment, estimate, consultation, or service question requiring follow-up.”
Record the inquiry as soon as practical. If you are on the phone, use a paper note or a quick form and transfer it to the main log before the end of the day. If the inquiry comes through email or social media, copy the important details rather than relying on a message inbox as your only tracking system.
Use neutral, useful notes. Instead of writing “seems difficult,” record an observable detail such as “requested three revisions before approving the estimate.” This keeps the log professional and helps another team member understand the situation.
When information is missing, mark it clearly. For example, write “phone not provided” or “needs address confirmation.” Do not guess at a phone number, budget, deadline, or service requirement.
Write a useful inquiry summary
The summary should be short but specific enough to guide the next conversation. A good summary normally includes the service requested, the relevant location or item, and any stated timing.
Weak summary: “Needs work.”
Better summary: “Homeowner wants a quote for repairing a damaged section of backyard fence before October 15.”
You do not need to write a complete transcript. Record facts that affect the next step, such as:
- The product or service requested.
- The customer’s preferred timing.
- Measurements, quantities, or model numbers.
- Whether photos or documents were received.
- Budget information volunteered by the customer.
- Questions that remain unanswered.
- Any promise your business made.
Keep sensitive information out of general notes unless it is necessary and protected appropriately. A simple inquiry log should not become a storage place for payment card numbers, passwords, medical details, or unrelated personal information.
Assign a clear next action
Every active inquiry should have a next action. “Follow up” is too vague because it does not explain what must happen. Write an action that can be completed and checked off.
Examples include:
- Send the estimate with the standard service terms.
- Ask for the property address and two photos.
- Call to confirm the requested appointment window.
- Check material availability and email an updated price.
- Send the customer three available consultation times.
- Review the inquiry with the technician before replying.
Set a follow-up date that matches the situation. A request for a same-week appointment may need attention today. A customer who is waiting for a renovation decision may reasonably need a reminder in a week or two.
If someone else is handling the inquiry, assign an owner. Shared responsibility often becomes no responsibility. One named person should be accountable for the next step, even when several people contribute information.
Create a simple daily routine
A log only works when it becomes part of normal operations. Use a short routine at three points in the workday:
- During intake: Record the name, contact method, request, and date.
- During follow-up time: Review inquiries due today and complete the next actions.
- Before closing: Add outcomes, move statuses forward, and assign tomorrow’s tasks.
A dedicated follow-up block can be more reliable than trying to respond between every other task. For example, a business might review new inquiries at 10 a.m. and 3 p.m., while urgent requests are handled immediately.
At the end of each day, filter the log for active inquiries with a blank next action or missing follow-up date. These are the records most likely to be forgotten.
Once a week, review older open inquiries. Decide whether each one should be followed up, placed on hold, closed, or transferred into a longer-term marketing list. Do not leave old rows active indefinitely just because nobody wants to make a decision.
Use filters and simple visual cues
A spreadsheet becomes much easier to manage when you can filter by status, owner, or follow-up date. Create views such as:
- Due today.
- Overdue.
- New inquiries.
- Waiting for customer.
- Estimate sent.
- Assigned to each staff member.
Conditional formatting can highlight overdue follow-ups in a noticeable color. Use a separate color for new inquiries and perhaps a neutral color for closed records. Avoid using so many colors that the sheet becomes difficult to read.
You can also freeze the header row, add dropdown menus for statuses, and protect formula columns from accidental edits. If the sheet is shared, agree on one date format and one way to enter phone numbers.
Do not rely on color alone. Someone viewing the sheet in print, on a phone, or with color-vision limitations should still understand the status from the words in the status column.
Follow up without becoming pushy
A follow-up should make it easy for the customer to respond. Refer to the original request, provide the promised information, and ask for one clear next step.
For example:
“Hi Jordan, I’m following up on your request for a fence repair estimate. We can review the photos and send pricing by Friday. Could you confirm the property address and whether the damaged section is approximately 20 feet long?”
If you sent an estimate, do not assume silence means rejection. A polite reminder can ask whether the customer has questions, needs a revised timeline, or has decided to pause the project.
Use the customer’s preferred communication method when possible. A phone call may be best for a detailed service question, while email may be more appropriate for an estimate that needs to be reviewed later. Respect requests not to be contacted through a particular channel.
Set reasonable contact limits. Repeated messages without new information can damage trust. After a suitable number of attempts, mark the inquiry as closed, paused, or unresponsive and keep a brief factual note about the last contact.
Handle common situations
The customer contacts you through multiple channels. Search the name, email address, and phone number before creating another row. If it is the same request, update the existing row and note the additional contact date. Create a separate row only when the person has a genuinely different project.
Several people are involved in one project. Choose one primary contact and record other participants in the notes. If approval must come from someone else, make that part of the next action rather than assuming the primary contact can decide.
The customer is waiting on you. Keep the status as active and assign a due date. “Waiting” should describe what is happening, not remove responsibility from the business.
You receive many inquiries at once. Triage them by urgency, promised response time, appointment availability, and likely fit. Do not automatically prioritize only the largest potential sale; a small request with an immediate deadline may need faster attention.
A request is outside your service area or capability. Mark it as closed or referred, and record the reason briefly. If you regularly receive the same unsuitable requests, improve your website wording, intake form, or service-area information.
Troubleshoot an ineffective log
If inquiries are missing, identify where they enter the business. Review phone messages, website forms, social inboxes, email accounts, and notes from staff. Then decide who is responsible for transferring each source into the central log.
If records contain too little information, improve the intake prompts. A phone script or online form can ask for name, contact information, service needed, location, and preferred timing. Keep optional questions separate from essential ones so customers are not discouraged from submitting a request.
If the log is full of old open rows, add a weekly cleanup rule. Every open inquiry must have a current next action and date. If there is no realistic next step, close or pause the record.
If staff members use inconsistent statuses, publish a short status guide beside the sheet. Define exactly when an inquiry changes from “New” to “Needs reply,” “Waiting for customer,” “Scheduled,” or “Closed.”
If customers receive duplicate replies, assign one owner and check the log before responding. A shared inbox may still be useful, but it should not replace the ownership field.
Protect the information and know the limits
Limit access to people who need the information. Use password protection and the access controls provided by your spreadsheet or business software. Remove unnecessary personal details, and avoid storing sensitive financial or identity information in the log.
Back up important records according to your normal business procedures. Keep a consistent archive or retention policy rather than saving every version forever. If your business has legal, privacy, industry, or customer-record requirements, confirm the appropriate practices with a qualified adviser.
A simple inquiry log has limits. It may not provide automated reminders, detailed sales forecasting, customer history, team permissions, document storage, or reliable reporting at high volumes. When staff spend too much time maintaining the sheet, inquiries are frequently duplicated, or customers require a long history of interactions, consider moving to a CRM or service-management system.
Even then, the basic principles remain the same: capture the inquiry promptly, summarize it accurately, assign one owner, record the next action, set a date, and close the loop with a clear outcome.