---
title: Quote follow-up: tracker template, cadence and messages | Efidis
description: A quote tracker with the next follow-up date built in, four ready-to-send messages, and the math to see how much money is sitting in open quotes today.
url: https://efidis.co/en/blog/seguimiento-de-cotizaciones
lang: en
---

# Quote follow-up: tracker template, cadence and messages

*Customers and sales · Efidis team · Updated November 12, 2026*

**In short:** Many companies stop following up early: in a Hatch survey of 124 U.S. home improvement companies, 63% contact the customer only once or twice before marking a quote as lost (Hatch, 2024). Following up takes a sheet where every quote has its next contact date, a fixed cadence of four touches (days 2, 5, 10 and 20) and a different message for each one. The same sheet tells you how much money is sitting in open quotes and which ones nobody followed up on.

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](https://efidis.co/en/blog/plantilla-de-cotizacion-con-ia), or with the [PDF and Word quote template](https://efidis.co/en/blog/formato-de-cotizacion) 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:

| Column | What goes in | Who fills it in |
|---|---|---|
| A. No. | The quote number | Salesperson |
| B. Date sent | The day it went out, formatted as a date | Salesperson |
| C. Customer | The company | Salesperson |
| D. Contact | Who received it, with phone or email | Salesperson |
| E. Value | Total before tax | Salesperson |
| F. Salesperson | Who owns the follow-up | Salesperson |
| G. Status | Sent, In conversation, Won, Lost or Expired (past its expiration date with no answer) | Salesperson, from a dropdown |
| H. Touches made | How many follow-ups so far: 0 to 4 | Salesperson, after each message |
| I. Agreed date | If the customer asked you to call on a specific day, that day. Otherwise blank | Salesperson |
| J. Next contact | The date of the next touch, formatted as a date | The sheet, with the formula |
| K. Outcome date | The day it was won, lost or expired | Salesperson |
| L. Reason lost | Price, timing, no response, bought elsewhere, postponed | Salesperson, 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 arrived.** Make 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 question.** Ask 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 adjustment.** Remind 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 question.** Let 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.

| Touch | Email subject | Message |
|---|---|---|
| Day 2 | Quote [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 5 | A 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 10 | Another 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 20 | Should 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](https://efidis.co/en/blog/indicadores-semanales).

| Number | How to calculate it | In the example |
|---|---|---|
| Money in open quotes | Sum of Value for rows with status Sent or In conversation | US$60,000 across 30 quotes |
| Overdue follow-ups | Rows with Next contact before today: =COUNTIF(J:J,"<"&TODAY()) | 12 quotes, US$24,000 |
| Close rate | Won ÷ (won + lost + expired), for last month's quotes | 15 ÷ 60 = 25% |
| Days to close | Average of Outcome date − Date sent, won quotes only | 12 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](https://efidis.co/en/blog/plantilla-de-cotizacion-con-ia) 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](https://efidis.co/en/servicios/software-a-la-medida) for [sales teams](https://efidis.co/en/sectores/equipos-comerciales).

## Frequently asked questions

### How many times should you follow up on a quote?

Four touches is a good starting point: at 2, 5, 10 and 20 days after sending, each with a different purpose. In Hatch's survey of U.S. home improvement companies, only 14% make four or more attempts before marking a quote as lost (Hatch, 2024).

### How do you follow up without being pushy?

Make every message bring something new: confirming it arrived, a specific question, an adjusted version or a close. And give the cadence an announced end, so the customer knows you won't write forever.

### When should I mark a quote as lost?

When the fourth touch goes unanswered or the quote expires, whichever comes first. Mark it Lost or Expired and record the reason and the outcome date. Reviewing those rows every quarter shows whether you're losing on price, on timing or on not writing back.

### Does it work in Google Sheets, or does it have to be Excel?

Both work. The functions in the sheet (IF, OR, CHOOSE, TODAY, COUNTIF and WORKDAY) exist in both. Google Sheets has the advantage that several salespeople can edit it at once without passing files around.

### Which is better for follow-up, WhatsApp or email?

Whichever channel the customer used to ask for the quote or already replies on. Short touches (confirming, asking) work well on WhatsApp or text; the adjusted version on day 10 usually goes better by email, with the file attached. Either way, log the touch in the sheet.

## Sources

1. [Hatch (Kristen McCormick), "State of the Home Improvement Industry 2024," January 18, 2024](https://www.usehatchapp.com/blog/state-of-home-improvement-industry-2024)
2. [Salesforce, "New Research Reveals Sales Reps Need a Productivity Overhaul" (State of Sales, 5th edition), December 8, 2022](https://www.salesforce.com/news/stories/sales-research-2023/)

## 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.

- [Book my call](https://wa.me/573214646372?text=Hi%2C%20I%20read%20an%20article%20on%20the%20Efidis%20blog%20and%20want%20to%20see%20how%20to%20apply%20it%20in%20my%20company.)
