Skip to content
Efidis
Efidis

Customers and salesUpdated 9 min read

Quote follow-up: tracker template, cadence and messages

3D illustration of three envelopes in a row, a calendar with three days marked in lilac and a paper plane.
In this article

To follow up on a quote you need a sheet where every quote has its next contact date, a fixed cadence of four touches (days 2, 5, 10 and 20 after sending) and a different message for each touch. Below are the columns and the formula to copy into Excel or Google Sheets, the four messages, and the math to see how much money is sitting in unanswered quotes today. It's built for companies that sell to other businesses and send more than ten quotes a month.

Why do quotes you've already sent get lost?

A sent quote falls into a blind spot. The customer already has it, so nobody at your company feels it's their move. The salesperson plans to call back "next week," the date lives in their head or their phone, and by the time they remember, the customer has already decided.

There's little data on follow-up with a published method. One source is Hatch's survey of 124 U.S. home improvement call centers with eight or more employees: 75% make the first follow-up on a quote within two days, but 63% contact the customer only once or twice before marking it as lost, and just 14% try four times or more (Hatch, 2024). It's one industry in one country, and Hatch sells follow-up software, so treat it as a signal, not a rule.

It isn't laziness either. In Salesforce's survey of 7,775 sales professionals in 38 countries, selling took up 28% of their week; the rest went to tasks like deal management and data entry (Salesforce, 2022). A follow-up that depends on memory competes with all of that and tends to get pushed back.

The fix is to put the next contact date where everyone can see it and let the sheet calculate it. If you're still building the quote itself, start with the quote spreadsheet, or with the PDF and Word quote template if you send it as a PDF. This sheet picks up where that one ends: after you hit send.

The tracker: columns and formula

One row per quote sent. Here are the columns, with the letter the formula below uses:

ColumnWhat goes inWho fills it in
A. No.The quote numberSalesperson
B. Date sentThe day it went out, formatted as a dateSalesperson
C. CustomerThe companySalesperson
D. ContactWho received it, with phone or emailSalesperson
E. ValueTotal before taxSalesperson
F. SalespersonWho owns the follow-upSalesperson
G. StatusSent, In conversation, Won, Lost or Expired (past its expiration date with no answer)Salesperson, from a dropdown
H. Touches madeHow many follow-ups so far: 0 to 4Salesperson, after each message
I. Agreed dateIf the customer asked you to call on a specific day, that day. Otherwise blankSalesperson
J. Next contactThe date of the next touch, formatted as a dateThe sheet, with the formula
K. Outcome dateThe day it was won, lost or expiredSalesperson
L. Reason lostPrice, timing, no response, bought elsewhere, postponedSalesperson, from a dropdown

The formula for column J, row 2: =IF(OR(G2="Won",G2="Lost",G2="Expired"),"",IF(I2<>"",I2,IF(H2>=4,"",B2+CHOOSE(H2+1,2,5,10,20)))). If the quote already has an outcome, the cell stays blank. If there's a date agreed with the customer, it uses that. Otherwise it adds the right number of days to the send date based on touches made: 2 if you haven't made any, 5 after the first, 10 after the second and 20 after the third. After four touches it stops suggesting a date. It works the same in Excel and Google Sheets.

If you'd rather count business days only, swap the addition for WORKDAY(B2,CHOOSE(H2+1,2,5,10,20)). Then add conditional formatting to column J that turns any date before TODAY() red: those are the quotes someone forgot.

Set up statuses and loss reasons as dropdowns (data validation). If one person types "lost," another "Lost deal" and a third "didn't happen," the formula and the Monday numbers stop adding up. And one rule of use: whoever makes the touch updates the row that same day.

How often should you follow up on a quote?

This four-touch cadence is a starting point, not a proven rule: if your customers decide within a week, tighten it; if they decide in a monthly committee, stretch it. What doesn't change is that every touch has a date and a different purpose. Days count from the send date.

  1. Day 2: confirm it arrivedMake sure the decision-maker has the quote and the file opens. It's the touch most companies already make: in the Hatch survey, 75% follow up within two days (Hatch, 2024).
  2. Day 5: answer one specific questionAsk about a point in the quote that tends to hold up the purchase: the delivery date, a quantity or the payment terms. A specific question gets a short answer.
  3. Day 10: offer an adjustmentRemind them when the prices expire and offer another version: a different quantity, split delivery or other payment terms, within your discount cap. If your quotes are good for 15 days, this touch lands before they expire.
  4. Day 20: close with a questionLet them know you're closing the quote and ask what happened. The answer goes into the Reason lost column, and after about 30 closed quotes it tells you whether you're losing on price, on timing or on being late.

When the customer replies, the cadence stops: move the row to "In conversation" and put the day you'll talk again in Agreed date.

What to say in each follow-up

Four messages, one per touch, to copy and adjust. In email, use the subject line; on WhatsApp or text, send just the message.

TouchEmail subjectMessage
Day 2Quote [No.] for [company]Hi [name], I sent you quote [No.] for [main product] on [day]. Did it come through, and does the person making the decision have it? If it should go to someone else, just let me know who.
Day 5A question about quote [No.]Hi [name], to make sure quote [No.] works as is: does delivery on [date] work for you, or do you need part of the order sooner?
Day 10Another option for quote [No.]Hi [name], the prices on quote [No.] are good until [date]. If the total or the timing doesn't fit, I can put together a version with [a different quantity, split delivery or other payment terms]. Want me to send it?
Day 20Should I close quote [No.]?Hi [name], I don't want to keep filling your inbox, so I'm going to close quote [No.]. Could you tell me in one line what happened: price, timing, you went with another supplier, or the purchase got pushed back? It'll help me quote you better next time.

Each message gives the customer something new to reply to: a confirmation, a question, an option or a close. A "did you get a chance to look?" gives them nothing, which is why it reads as pushy. The last message also puts an end to the cadence: the customer knows you won't keep writing.

Four numbers to check every Monday

With the sheet up to date, four numbers tell you how follow-up is going. They fit on the Monday dashboard.

NumberHow to calculate itIn the example
Money in open quotesSum of Value for rows with status Sent or In conversationUS$60,000 across 30 quotes
Overdue follow-upsRows with Next contact before today: =COUNTIF(J:J,"<"&TODAY())12 quotes, US$24,000
Close rateWon ÷ (won + lost + expired), for last month's quotes15 ÷ 60 = 25%
Days to closeAverage of Outcome date − Date sent, won quotes only12 days

This is a made-up example with round numbers. An industrial supply distributor sends 60 quotes a month to other businesses, with an average value of US$2,000: US$120,000 quoted every month. Of last month's 60, all of which have an outcome, it won 15. Its close rate is 25%.

Today it has 30 open quotes worth US$60,000. Column J shows 12 with an overdue follow-up: 12 × US$2,000 = US$24,000 waiting for someone to write.

If following up wins back one in five, that's 12 ÷ 5 = 2.4 sales, about US$4,800 more a month. One in five is an assumption for the math, not a promise, and we kept it below the 25% close rate so as not to inflate it. Run the same math with your numbers: overdue quotes × average value × the share you think you can win back.

When you don't need this sheet

  • You sell over the counter or with published prices. The customer isn't waiting on a quote: they either buy or they don't.
  • You send fewer than ten quotes a month. A calendar reminder for each one is enough.
  • Your customer decides on the first call. What matters there is responding fast, and the quote template covers that.
  • It's a formal bid whose rules limit contact with the buyer. Follow the bid rules, not the cadence.

When the spreadsheet stops being enough

  • Several salespeople edit the same file and overwrite each other's rows, or each one keeps their own copy.
  • Quotes go out with old prices because the price list lives in another file.
  • To find out whether a customer has open orders or unpaid invoices, you have to ask another department.
  • Touches and statuses get updated on Friday, from memory.

At that point the cadence still works, but the data it needs is scattered: the quote in one sheet, orders in another and receivables with accounting. The next step is having them in one system, where every quote keeps its history and its next contact alongside the customer who received it. That's what we build as custom software for sales teams.

Sources

  1. Hatch (Kristen McCormick), "State of the Home Improvement Industry 2024," January 18, 2024 (opens in a new tab)
  2. Salesforce, "New Research Reveals Sales Reps Need a Productivity Overhaul" (State of Sales, 5th edition), December 8, 2022 (opens in a new tab)
See how we work in sales teams

Frequently asked questions

Make sure every quote gets an answer

Efidis builds your sales team a web and mobile app where every quote has its next step and its history. On the call we'll look at how you follow up today and what to sort out first.