Most freelancers track proposals in their head. They remember roughly who they sent to, vaguely when, and have a general sense of whether the client is “probably going to sign.” This system works fine when you’re sending two proposals a month. It fails badly at five, and catastrophically at ten.
A proposal tracking system doesn’t have to be complicated. It has to be consistent. Whether you use a spreadsheet, a CRM, or dedicated proposal software, the goal is the same: at any moment, you should be able to answer “where does every outstanding proposal stand?” without guessing.
Here’s how to build that system, starting from scratch.
Why tracking proposals matters
The immediate answer is obvious: you don’t forget to follow up. But the deeper value is in the data that accumulates over time.
When you track every proposal — sent, won, and lost — you start to see patterns:
- Which types of projects have the highest close rates?
- Which lead sources produce the best-converting proposals?
- What’s the average time between sending and signing?
- At what dollar amount does your close rate drop?
- How many follow-ups does it typically take to close?
None of this is visible when proposals live in your head or scattered across your inbox. Systematic tracking turns your proposal history into a feedback loop that improves your close rate over time.
The five things every proposal tracker must record
Regardless of whether you use software or a spreadsheet, track these for every proposal:
1. Client name and company Who is this for? Include the decision-maker’s name and company.
2. Proposal value The total dollar amount of the proposed work. You’ll use this to calculate pipeline value and win rate by dollar, not just by count.
3. Date sent When did you send it? This is your baseline for calculating time-to-close and knowing when follow-ups are due.
4. Status Where is this proposal right now? Standard statuses:
- Draft (not sent yet)
- Sent (sent, not yet opened)
- Viewed (confirmed opened by client)
- In Discussion (client has responded, conversation active)
- Signed / Won
- Lost / Declined
- Expired (validity date passed, no response)
5. Follow-up date When is the next action due on this proposal? This is the field that makes the tracker functional, not just historical. If there’s no follow-up date, the proposal will sit and age without action.
Building a spreadsheet tracker
If you’re not using proposal software, a spreadsheet is the practical starting point. Here’s the column structure that works:
| Column | What it contains |
|---|---|
| Proposal # | Sequential number (P-001, P-002…) |
| Client Name | Contact name |
| Company | Company name |
| Project | Brief description (e.g., “Website redesign”) |
| Value | Dollar amount |
| Date Sent | Date proposal was sent |
| Date Opened | Date client confirmed opening (manual — email receipt) |
| Status | Draft / Sent / Viewed / In Discussion / Won / Lost |
| Follow-Up Date | Next action date |
| Outcome Notes | Why won or lost, referral source, notes |
| Lead Source | Referral / cold outreach / inbound / repeat |
Set up one row per proposal. Sort by Follow-Up Date ascending so the most urgent items appear first. Review the tracker every Monday morning.
This takes about 10 minutes per week to maintain and provides a complete pipeline view at a glance.
The Follow-Up Date column is the most important column in the tracker. It converts the spreadsheet from a historical record into an active system. Every open proposal should have a follow-up date in the future. If a row doesn’t have a follow-up date, it’s already being neglected.
What software-based tracking adds
A spreadsheet tracks what you manually enter. Proposal software tracks what the client actually does.
The key addition: real-time open notifications.
When a client opens a proposal sent through software, you get a notification with a timestamp. No need to guess whether they received it. No need to send a “did you get this?” email. You know.
Better tools show more than just open time:
- Section view time: Which sections did the client spend the most time on? Time on pricing page = thinking about budget. Time on your bio section = still evaluating fit.
- Multiple opens: Did the client open the proposal once or four times? Four opens usually means they’re comparing it with something else or showing it to a colleague.
- Device used: Mobile vs. desktop. Knowing they read it on their phone tells you something about how carefully they could have reviewed it.
- Forwarded: Some tools detect when a proposal is opened from a different email than the one you sent to — suggesting it was forwarded to a stakeholder.
This data changes how you follow up. Instead of following up on a fixed schedule, you follow up with context.
How to use tracking data to follow up better
When tracking shows the proposal was just opened
Follow up within 24 hours:
“I see the proposal came through — let me know if you have any questions or if anything needs adjusting before you decide.”
This is a natural, helpful follow-up that doesn’t feel random.
When tracking shows the proposal was opened multiple times but no response
The client is thinking. There’s likely an objection or uncertainty they haven’t voiced.
“I noticed you’ve had a chance to review the proposal. Happy to jump on a quick call to walk through any questions — sometimes it’s faster than email.”
This surfaces the hesitation in a low-pressure way.
When tracking shows the proposal was never opened (5+ days after sending)
Don’t assume they received it:
“Just checking in to make sure the proposal came through — sometimes these go to spam. Happy to resend if needed.”
This is more useful than a generic “following up” email, and it gives the client a graceful way to re-engage if they forgot.
When tracking shows no activity after 14 days
One final note before closing the file:
“I’ll keep this proposal open through [date] in case the timing works out. After that I may not be able to hold the timeline. If this project is moving forward, happy to reconnect.”
Then mark the proposal as Expired and move on.
Tracking win rates and pipeline value
Once you have a few months of data, run these calculations monthly:
Win rate: (Proposals won) ÷ (Proposals sent) × 100 Example: 4 won out of 15 sent = 26.7% win rate
Win rate by value: (Dollar value of won proposals) ÷ (Dollar value of all proposals sent) × 100 This matters because a 25% win rate on $5K proposals is different from a 25% win rate on $30K proposals.
Average time to close: Average number of days from “sent” to “signed” for won proposals This tells you how long your sales cycle is, which helps you plan cash flow.
Average number of follow-ups to close: How many touch points did it take before a won proposal signed? Most freelancers underestimate this. If your average is 1.2 and the industry average is 2.5, you may be giving up too early.
Win rate by lead source: Are referrals closing at 50%? Cold outbound at 10%? This data tells you where to focus your prospecting.
Run these numbers monthly. Share them with yourself. They compound over time into a real competitive advantage.
Integrating your tracker with your workflow
The tracker only works if it’s part of your actual routine, not a separate system you update when you remember.
The simplest integration:
- When you send a proposal: Add a row immediately. Set the first follow-up date for 4 business days from today.
- Every Monday morning: Open the tracker. Filter by Follow-Up Date ≤ today. Take action on every row that appears.
- When a proposal closes (won or lost): Update the status and add outcome notes. What was the reason — price? timing? competitor? This is the most valuable data you collect.
- Monthly: Run your win rate calculations. Look for patterns.
This routine takes 15–20 minutes per week and a few minutes per proposal. The return is a complete view of your pipeline and a closing history that shows you exactly where to improve.
Related reading
- What to do after sending a proposal — the follow-up plan
- Best online proposal builders — tools with built-in tracking
- Proposal win rate benchmarks — what good looks like
Start with the spreadsheet, upgrade when it’s too manual
The spreadsheet version of this system is the right starting point for most freelancers. It costs nothing, takes 10 minutes to set up, and immediately gives you a view of your pipeline you didn’t have before.
When the manual tracking becomes the bottleneck — when you’re spending more than 30 minutes a week updating it, or when you’re losing deals because you didn’t know a client opened the proposal — that’s the signal to move to software.
But start now, with what you have. A simple spreadsheet tracking five fields per proposal is infinitely better than tracking proposals in your head.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
