The Proposal Tracking System That Survives a Bad Day
One table. One owner per row. Three follow-ups you do not have to remember. That is the whole system, and it is deliberately boring.
You sent the proposal. You felt good about it. Then a week evaporated, and now you are not sure whether you followed up, whether they replied, or whether the whole thing is sitting in a spam folder having a quiet life without you.
This is not a sales problem. You can sell. You proved that when you wrote the thing.
It is a tracking problem, and tracking problems are the most expensive kind because they are invisible. Nobody sends you an invoice for the deal you forgot to chase. It just quietly does not happen, and you assume the market is slow.
A proposal you never followed up on is not a lost deal yet. It becomes one by default, which is a genuinely infuriating way to lose money.
So here is a proposal tracking system that does not require new software, a subscription, or a version of you with better willpower. It requires one table, one clear owner per row, and a follow-up cadence somebody else can run.
What a Proposal Tracking System Actually Is
A proposal tracking system is a shared table, a written follow-up rule, and a named human who runs it. That is it. The intelligence lives in the process and the people, not in a $79-a-month dashboard with a very confident onboarding video.
Two platforms do this well:
- Notion — flexible, linkable, and it plays nicely with the rest of your business dashboards. This is what I use.
- Google Sheets — lower barrier, instantly shareable, completely sufficient if you have fewer than about twenty live proposals.
Pick the one you already have open. Do not spend a Saturday evaluating both. That is procrastination wearing a productivity costume, and I say that with love and personal experience.
Open Notion or Sheets. Make a table with six columns: Client, Stage, Owner, Deadline, Next Action, Link. Add every proposal you can name from memory. Imperfect is fine. Complete is not the goal yet.
The Eleven Fields Your Tracker Needs
Six columns get you started today. Eleven is the version that still works in six months, when there are more proposals than you can hold in your head and you have stopped being the only person touching it.
- Proposal ID — a unique reference so file names and conversations match. Date plus client code works fine.
- Client — who it is for.
- Owner — the human responsible for this row. If it is only you right now, your name goes in every cell. That changes the day you hire.
- Stage — Draft, Sent, In Review, Won, Lost. Five options. Resist the urge to invent a sixth.
- Value — estimated deal size, so you can tell a $400 job from a $12,000 one at a glance.
- Deadline — the client’s decision date, or yours.
- Last contact — the date of the most recent touch.
- Next action — one specific task. “Follow up” is not a next action. “Email Dana the revised scope” is.
- Link to file — direct link to the document.
- Access level — internal, shared, or restricted.
- Notes — blockers, pricing flags, the objection they raised on the call.
Store the actual proposal files in one shared folder with role-based access, name them the same way every time (YYYY-MM-DD_ClientName_ProposalID), and back it up weekly. Never share the full tracker with a client. It contains your notes about them, and notes about people are rarely improved by those people reading them.
The one view you actually open
Build a filtered “Today” view showing only rows where Next Action is due today or overdue. In Notion that is a filter. In Sheets it is conditional formatting.
That single view is the whole morning routine. Everything else in the table exists so that this one view can be short.
Building It in 30 Minutes
You can have a working version live before your coffee goes cold. Set a timer, because otherwise this becomes a four-hour project about column colours.
- Minutes 1–5: Create the table with the eleven fields. In Notion, use a full-page database. In Sheets, freeze row one.
- Minutes 6–10: Add every current proposal from memory. Get Stage and Deadline right; fill the rest in later.
- Minutes 11–20: Assign an Owner to every single row. No blanks. A row with no owner is a row nobody does.
- Minutes 21–25: Build the “Today” view.
- Minutes 26–30: Create the shared folder and link each row’s file.
If the blank table is the thing stopping you — and for a lot of us it is, because a blank table is just a very organised way of being asked to remember everything at once — do the first pass with someone else in the room. A body doubling session is usually enough to get the first five rows in, and after five rows the momentum does the rest.
The Three-Step Follow-Up Cadence
The default cadence is three touches: a soft nudge at 48 hours, a real call to action at 7 days, and a human escalation at 14 days. Each step has a named owner, so nothing depends on someone noticing.
- 48 hours after sending: short email confirming it arrived, offering to walk through it. If no reply, log it and move to the 7-day step.
- 7 days after sending: email plus a calendar invite for a 15-minute call. If no reply, flag the row for your review.
- 14 days after sending: a phone or video call, not another email. The call replaces the email; do not send both.
- If there is still no reply after the call, mark the row Stale, note the last contact date, and set a 30-day recheck.
When it goes sideways
- No response after all three steps. Mark it Stale and set the 30-day recheck. Do not send a fourth email. Four emails is not persistence, it is a hostage situation.
- Wrong owner assigned. Fix the Owner field immediately and resend step one from the correct person.
- Pricing objection raised. Flag for your review. The VA does not negotiate price. Ever. That is a boundary, not a limitation.
An “Engagement” flag. If a client opens the proposal file more than once in a day, that is a buying signal and it deserves a same-day note from you personally, not the scheduled follow-up from your VA.
What to Hand Off and What to Keep
Delegate the mechanical parts: status updates, follow-up emails, logging, chasing stale rows. Keep the parts that require judgement: pricing, scope changes, and final sign-off.
This split matters more than it sounds. Most people either hand over nothing, or hand over everything and then panic when a VA discounts a project by 30% to be helpful.
The five-step VA onboarding
- Share tracker access — view and edit on assigned rows only.
- Walk through every field definition and the five Stage options.
- Explain the file naming convention and folder structure.
- Hand over the three follow-up templates, already written.
- Set the report cadence: every Friday by 3 p.m., a summary of proposals moved, follow-ups sent, and anything flagged for you.
Run two weeks of shadowing before full handover. A short daily check-in during those two weeks catches the misunderstandings while they are still cheap. After that, get out of the way.
Automate the Reminders, Not the Judgement
The point of automation here is to remove busywork, not to replace the calls that actually win the deal.
- Calendar reminders tied to each row’s Deadline field.
- Conditional formatting that turns a row red when Last Contact is more than seven days ago and Stage is not Won or Lost.
- Saved email templates for the three cadence messages, with merge fields for name and date.
- A nightly one-paragraph summary of what was touched and what needs you tomorrow.
Run the cadence manually for two weeks first. You cannot automate a process you have not yet watched work. Once you know which steps are purely mechanical, automate exactly those and leave the rest alone.
What to Measure Monthly (Not Daily)
Checking a pipeline daily is how you get anxious without getting information. Once a month is enough, and four numbers cover it.
- Win rate — Won ÷ (Won + Lost) for the month.
- Average time in stage — anything stuck in “Sent” longer than 14 days needs attention.
- Aging proposals — open, not Won or Lost, past deadline by 30+ days.
- Conversion by type — group by service category and compare. This is where you find out that one offer converts at 60% and another at 8%.
The 30-minute monthly review
- Your VA sends the one-page summary by the last Friday of the month.
- You review aging proposals and decide: follow up, revise, or close.
- If “In Review” is consistently long, tighten the 7-day step to 5 days.
- Update the templates if the same objection keeps showing up.
- Reassign any rows where the owner changed.
If You Want Help Actually Doing This
Reading a system and running a system are famously different activities. If the gap between them is where you keep getting stuck, there are three sensible sizes of help:
Want a ready-built DIY workspace? The $27 Productivity System gives you task views for priority, due date, status, and time estimate — the structure this tracker plugs into. Best when you want to build it yourself and just need the scaffolding.
Not sure what is actually broken? A $97 Clarity Session is one hour of working session plus a written action plan. Best when the real problem might not be the tracker at all.
Need someone to run it every week? Virtual Executive Assistant support covers tracker setup, SOP writing, and ongoing follow-up management. Starts with a free consultation; packages begin at $1,200/month for a 10-hour minimum and include a 30-day trial.
And if none of those fit, keep the article and spend nothing. The system works whether or not I am involved. That is rather the point of writing it down.
Frequently Asked Questions
What is the simplest proposal tracking system for a small business?
One table with eleven fields, a named owner on every row, and a written three-step follow-up cadence. Notion or Google Sheets both work. You do not need dedicated proposal software until you are running more proposals than one person can read in a sitting.
How often should I follow up on a proposal?
Three times: 48 hours, 7 days, and 14 days. The first two can be email; the third should be a call. After that, mark it stale and set a 30-day recheck rather than continuing to email. Persistence past three touches usually costs more goodwill than it recovers.
What should I delegate to a VA, and what should stay with me?
Delegate status updates, follow-up sends, logging, and chasing stale rows. Keep pricing, scope changes, and final sign-off. The rule of thumb: if the step has a written answer, it can be delegated. If it requires a judgement call about money or scope, it stays with you.
Why do I keep abandoning tracking systems?
Usually because the system asks for more decisions than you have available on an average day, not because you lack discipline. Some adults with ADHD experience difficulty with organisation, planning, and completing large projects, which is consistent with NIMH’s overview of ADHD in adults. That makes a low-decision system useful. It does not mean any particular system will or will not work for you specifically — that part is still an experiment.
Can I use this if I am the only person in the business?
Yes. Put your own name in every Owner cell and run all three follow-up steps yourself. The Owner column looks redundant right now and becomes essential the first time someone else touches the table. Build it in from the start so you are not retrofitting it later.
The System That Sticks Is the One You Can Run Tired
Most people do not lose proposals because they lack discipline. They lose them because the system they picked demands the most decisions at exactly the moment they have the fewest available.
One table. One cadence. One person handling the mechanical steps. You only touch it when a decision is genuinely yours to make. That is not a workaround for a deficiency. That is just good system design, and it works for everybody — it is simply more obviously necessary for some of us.
Start with the smallest version. One table. Three proposals. One follow-up sent. That is a working system. Add the VA, the automations, and the monthly review once the core habit holds.
Then let the system earn the right to get more complicated.
Stop Losing Deals to Silence
Whether you want the DIY workspace, an hour of clarity, or someone to run the follow-ups every week — the next step is here when it is useful.
