Most freelancers know roughly which projects they’re working on. But fewer know their close rate, their average deal size, how many proposals are open right now, or which leads have gone cold without a follow-up. A sales tracking document answers all of these questions without requiring a CRM subscription or a dedicated sales operations process.
What a sales tracking document is (and isn’t)
A sales tracking document is a structured record of your sales activity — not your project management, not your invoicing, and not your task list. It tracks the moments between “first contact” and “signed agreement.”
Its job is to answer three questions:
- What opportunities are currently in my pipeline and at what stage?
- What requires my attention this week (follow-ups, proposals to send)?
- What does my expected revenue look like in the next 30–90 days?
It doesn’t replace a project tracker. Once a deal is won, it moves out of the sales tracker and into your project management system.
The eight core fields
1. Prospect name. The person or company name.
2. Source. How they found you: referral, LinkedIn, cold outreach, inbound from website, etc. Tracking source helps you understand which channels produce your best clients.
3. Project type. Branding, development, copywriting, consulting — whatever categories apply to your work. Useful for spotting which types of work you’re winning most and building on it.
4. Estimated value. Your best estimate of the project revenue. Use ranges if you don’t have a number yet (e.g., $3,000–$5,000). This field drives your pipeline value calculation.
5. Current stage. The stage of the sales process: Lead, Discovery Call, Proposal Sent, Follow-Up, Won, Lost. Keep stages simple — too many stages create maintenance overhead.
6. First contact date. When the conversation started. This helps you track how long deals typically take to close.
7. Last contact date. The most recent touchpoint. If this date is more than 7 days ago for an active stage, something needs follow-up.
8. Next action. The specific thing you need to do and when: “Send proposal by Thursday,” “Follow up on Monday,” “Call Thursday afternoon.”
Building the pipeline summary
Add a summary section above your main table. At a minimum:
- Total pipeline value: Sum of estimated values for all active stages
- Weighted pipeline: Pipeline value multiplied by your typical close rate for each stage
- Won this month: Revenue from deals closed in the current month
- Lost this month: Number of lost deals
- Win rate: Won / (Won + Lost) as a percentage
These five numbers give you a dashboard view of your sales health without any additional work beyond maintaining the core fields.
The follow-up layer
The sales tracking document is most valuable as a follow-up system. Every week, review every row where Last Contact is more than 5 business days old and the stage is active. Those are the deals going cold on you.
A cold deal doesn’t always mean the client isn’t interested — it often means you didn’t follow up and they moved on to whoever did.
The Next Action field drives this. Every active row should have a specific next action with a date. If the date has passed, it’s overdue. Update it, do the action, and reset the date.
Connecting the tracker to your proposal and invoice workflow
Your sales tracker and your invoicing process need to be connected, even if they’re separate documents. When a deal moves to Won, the next entry in your tracker should be “Invoice sent on [date]” — so you have a clean record from first contact to payment in one place.
If you’re using a tool like Waco3 for your proposals and invoices, the tracking data is built in — you can see when a client opened your proposal, which gives you richer data for the Last Contact column than just your outbound emails. A client who opened your proposal three times but hasn’t replied is a different follow-up conversation than one who opened it once.
The weekly review habit
Schedule 30 minutes every Monday. In that time:
- Update any statuses that changed (won, lost, stalled)
- Review all Follow-Up rows for overdue actions
- Look at your pipeline value — is it sufficient for next month?
- Set or update the Next Action for every active row
That’s it. Thirty minutes of maintenance gives you a complete picture of your business development, without a CRM, without a sales coach, and without losing track of a single opportunity.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
