A customer asks for a quote. You promise to check a detail. By the end of the day, the request is buried in a message thread. A simple enquiry tracker gives that request a place, an owner and a next step.

This worksheet is for owners of small service businesses, such as repair workshops, cleaning businesses and local studios. It defines a tracker you can first try on paper or in a spreadsheet. It is not a claim that your inbox or messaging accounts are already connected to KernelApps.

Step 1: Choose one place to start

Pick one source of enquiries, such as requests you receive by phone. Manually record those requests for the first version. Avoid trying to combine every inbox before you know what information is useful.

Write the purpose at the top: Every open enquiry has an owner and a next action.

Step 2: Use a small set of fields

Reference: a short identifier, such as ENQ-001, so two similar requests remain distinct.
Customer label: use a fictional name in your trial. Add real contact information only when you need it and have chosen who may see it.
Request: one sentence describing what the person asked for.
Stage: New, Waiting for us, Waiting for customer, or Closed.
Owner: the person responsible for the next step, even if that is always you.
Next action: a specific task, such as “Check the replacement part price.”
Follow-up date: an explicit date in your local business time zone.

Keep contact information separate from the request summary where possible. Do not copy payment card details, passwords or unnecessary personal information into the tracker.

Step 3: Walk through three made-up enquiries

ENQ-001 — Alex: asks for a bicycle brake repair estimate. Stage: Waiting for us. Owner: you. Next action: check the part price. Follow-up: October 27, 2026.

ENQ-002 — Sam: asks for a cleaning quote but has not supplied the property size. Stage: Waiting for customer. Next action: review and send a question about the missing detail. Record when you will follow up if there is no response.

ENQ-003 — Jo: has chosen another provider. Stage: Closed. Record the outcome briefly and remove it from the open follow-up list. Keep any retained customer information according to your business's retention rules.

These are fictional records for a planning exercise. Their dates are examples, not appointments or reminders.

Step 4: Define three useful views

Open enquiries: everything that is not Closed. You should be able to see who owns each next action.

Due today or overdue: open enquiries whose follow-up date is today or earlier in the business's chosen time zone. A future follow-up should not appear here.

Waiting for customer: requests that need an answer from the customer. This is different from work you still owe them.

A due-date list does not send reminders by itself. If you later want notifications, confirm the delivery channel, recipient and timing separately.

Step 5: Check the tracker before using it with customers

Can you find ENQ-001, change its stage and still find that change after reopening your tracker? Does closing ENQ-003 remove it from the open list? Can you tell which dates are overdue without guessing the time zone?

If two people will use the tracker, decide which records each person may see and who can edit them. Write these rules down before adding real customer information.

If an AI assistant later prepares a reply, review the draft yourself. Updating the tracker should not silently send the message or promise an unconfirmed price.

Turn the worksheet into a small app brief

Use this brief when describing the app you want: I run a small service business. I need a private enquiry tracker with a reference, customer label, request, stage, owner, next action and follow-up date. Show open enquiries and overdue follow-ups. Keep closed enquiries out of those views. Let me review changes. Do not send messages or confirm bookings automatically.

KernelApps offers manual app creation during beta, with AI-assisted building by invitation. Create a free account to explore the builder with your worksheet. An account does not automatically connect your existing inbox or calendar; confirm any connection and its permissions before relying on it.

If you are still deciding where AI would help, start with AI for small-business owners. For a related scenario, see turning a support question into a tracked ticket.

Stop Losing Customer Enquiries: Plan a Simple Follow-Up Tracker