“I don’t have time. So I only enter the proposals that closed, afterward, just so we at least have the number of closed deals.”
That’s what the manager of an accounting firm said. Notice the built-in surrender: she didn’t drop the tracking out of laziness, she dropped the part that took work. The result is a record that only knows what worked out. Everything that was sent and never came back disappears: it doesn’t become a number, doesn’t become a lesson, doesn’t become something to follow up on.
In 169 meetings with 38 companies, 44 pains were about proposals and quotes. Almost none were about writing the proposal. All of them were about what happens after it goes out.
The proposal isn’t the end of the sale. It’s the start of the part nobody tracks.
The sales process is usually polished right up until it’s sent: there’s a template, a price review, someone checking the customer’s name. The email goes out, and the process ends. Not because anyone decided that, but because nothing exists after it.
What’s left is memory. The salesperson remembers to follow up with the big customer. They don’t remember the eleven who said “I’ll review it and let you know” three weeks ago. And no one in the office can remember on their behalf, because the information lives in one person’s sent email.
Another manager summed up the request in one sentence: “So we don’t leave any company forgotten, close as many proposals as possible. And whatever doesn’t close, understand why.” That’s two requests. A tracker that solves only the first already pays for itself. One that solves both changes the year.
Why the proposal spreadsheet always falls behind
A spreadsheet records state, not movement. It stores that the quote is “open.” It doesn’t store how many days it’s been open, who last talked to the customer, what was agreed. To know that, someone has to type it in, and typing it in is what doesn’t happen on a busy day, because it gives nothing back immediately to whoever is typing.
Hence the cycle: the spreadsheet falls behind, the number stops being trustworthy, people stop opening it, it falls further behind. At the results meeting, someone rebuilds everything from memory and out comes a number that looks nice and means nothing.
The four pieces of information missing from your tracker
Customer, value, and status don’t answer any useful question. Four are missing:
Send date and expiration date. Without the send date you can’t ask “what’s been stalled for more than 15 days?”, the one question that turns a list into actual work. And the expiration date gives you a legitimate reason to go back to the customer without it looking like you’re chasing them.
The next step, with an owner and a date. Not “open.” Something like “call Marina on the 14th.” A proposal with no next step isn’t in progress: it’s abandoned wearing the appearance of being alive.
The loss reason, from a short list. No more than five options, no free text. “Price” alone doesn’t count: it’s what the customer says when they don’t want to explain. Prefer “missed response deadline,” “scope bigger than what we do,” “customer with no approved budget.”
What was proposed, broken down. A delivery company manager explained it this way: “My customers get really confused, because the amounts don’t show there for them, the down payment, the recurring amount.” Storing only the total hides the structure, and the structure is what the customer argues about and what later turns into a billing dispute.
How to build the tracker in one week
- List everything that’s open. Sent emails, notepads, people’s heads. Pull the last 90 days.
- Sort into three piles: alive (responded in the last 15 days), cold (no response), and dead (decided but never recorded). Close out the dead ones now, with a reason. The cold ones are your stalled money.
- Give every live or cold proposal a next step. Name and date. On the first pass, a good chunk of the list won’t have one. That’s the diagnosis.
- Write the closed list of loss reasons. Five, at most, written by you.
- Define the follow-up rule. For example: contact in 2 days, in 7, in 15, and on day 30 the proposal closes with a reason. The rule matters more than the numbers.
- Fifteen minutes a week, just on what’s stalled. Open the cold list and decide, for each one: move forward, close it, or change the next step.
- Only then automate. With a trustworthy record, it makes sense to generate the proposal from the customer record and send an expiration reminder. Automating before that just spreads errors faster.
The three mistakes that turn tracking into theater
Asking for information nobody will read. Every required field is a toll. If it gives nothing back to the salesperson, they’ll fill it in with whatever on a Friday, from memory.
Treating the tracker as oversight. If the stalled list becomes the agenda for individual blame, the proposal disappears from the list before the meeting. At one of our real estate clients, R$ 136 thousand across 37 deals were marked as “won” without being sales at all. The dashboard had been lying for months.
Giving nothing back to whoever fills it in. Show each salesperson their own list of unanswered proposals, by days stalled. The day they open the list on their own, the data cleans itself up.
The three numbers the tracker needs to give you back
How much is stalled, and for how long? It’s usually bigger than the month’s target.
How many out of every ten turn into a sale? It’s not for putting pressure on anyone; it’s for knowing how many quotes to send to close the month.
Why do you lose? If “missed response deadline” tops the list, the problem isn’t price or product. It’s follow-up, the cheapest thing there is to fix.
You can do all of this in a well-built spreadsheet. It’s worth calling for help when the proposal turns into a contract, the contract turns into a work order, and the work order turns into billing: that’s operation design. DualWin has done this for more than five years. Talk to a specialist.
Frequently asked questions
What does a sales proposal tracker need to have?
Beyond customer and value: send date and expiration date, next step with an owner and a date, a loss reason chosen from a short list, and the breakdown of what was proposed, such as down payment and recurring amount.
How often should you follow up on a proposal?
A rule that works: contact in 2 days, again in 7, again in 15, and close it out with a reason on day 30. More important than the exact timing is having one single rule for the whole team.
How do you calculate a proposal conversion rate?
Divide won proposals by the total proposals decided in the same period. The number is useful for estimating how many quotes to send to hit your target, not for putting pressure on a salesperson.
