A sales tracking template is not about complexity — it’s about not losing track of deals that should close. Most freelancers have lost a project not because the client wasn’t interested, but because the follow-up never happened. A template prevents that.
What to include in your template
Core columns (minimum viable template):
- Client name and company
- Project description (brief — one line)
- Estimated project value
- Stage (Contacted / Proposal sent / Under review / Negotiating / Closed won / Closed lost)
- Proposal sent date
- Last follow-up date
- Next follow-up due date
- Outcome and close date
Useful additions:
- Proposal opened date (from a tracking tool notification)
- Number of follow-up attempts
- Decision maker’s name vs. contact name
- Source of the lead
- Notes on client concerns or objections
Setting up in Google Sheets
Create one row per opportunity. Use a dropdown list for the Stage column (Data → Data Validation → List of items) so you can filter by stage easily. Use conditional formatting to color-code rows: green for Closed won, red for Closed lost, yellow for follow-up overdue.
Add a second tab for closed deals — move won/lost rows there after the outcome is clear. This keeps your active pipeline view clean while preserving your historical data for pattern analysis.
The most powerful column in your tracking template is “Proposal opened date” — filled in automatically when you use a tracking tool. That date tells you when the client was actively considering, which is more useful than when you sent it.
The follow-up date column
This is the column most freelancers skip — and it’s the one that matters most. Without an explicit follow-up due date, follow-up happens whenever you remember it, which is usually too late.
Set follow-up due dates when you create each row:
- Day of proposal send: set follow-up for 3 business days later
- After first follow-up with no response: set another for 5 business days
- After second follow-up: set a final touch for 7 days, then mark low priority
When you open your tracking template, the first thing you should see is any row with a follow-up due date in the past.
Integrating document tracking
A static template only tells you what you’ve done. Document tracking tools tell you what’s happening now. When Waco notifies you that a client opened your proposal this morning, you update the “Proposal opened” date in your template and move your follow-up date to today.
This combination — a simple tracking sheet plus real-time document open notifications — gives you an active pipeline view without the complexity of a full CRM.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
