The seven fields worth keeping
Download the free customer tracker CSV template
| Field | Why it matters |
|---|---|
| Customer name | Find the right conversation |
| Contact information | Reach the customer in their preferred channel |
| Job or request | Remember what they actually need |
| Stage | Know whether it is new, quoted, scheduled, or complete |
| Last contact date | See how recently you spoke |
| Next action and date | Turn a conversation into a clear task |
| Private notes | Remember important, relevant context |
You can add more later, but do not start with 40 columns you will never update.
A practical five-stage system
Use stages that reflect actual decisions:
- New inquiry: someone asked about a job.
- Estimate sent: you gave them a price or scope.
- Awaiting response: the next step depends on the customer.
- Scheduled / in progress: the work is planned or underway.
- Completed / closed: the current request is finished.
Not every request needs every stage. The point is consistency, not bureaucracy.
A five-minute daily routine
Every morning, sort by the next action date. Contact customers who are due for a response; then check upcoming jobs. At the end of the day, update what happened and assign a next step to anything that remains open.
Avoid putting sensitive information in shared sheets unless the access permissions are appropriate. Make sure the people who can see a customer tracker genuinely need access to it.
When to move from a sheet to an app
A spreadsheet is a good starting point. You may outgrow it when one customer has several estimates or jobs, when reminders are easily forgotten, or when mobile access becomes awkward. That is a workflow problem worth solving, rather than a reason to buy more software by default.
If you are evaluating software, here is a checklist for a one-person-business CRM. Pal & Co. aims to bring the customer record, estimates, jobs, reminders, and daily priorities into a more connected view.
Quick questions
Can I use Excel or Google Sheets as a CRM?
Yes. For a small number of active conversations, a well-maintained sheet can work very well.
What is the most important field?
The next action. Contact details alone do not remind you what to do.
Should I keep every lead forever?
Set a sensible retention routine and follow applicable privacy requirements. Remove information you no longer need.
