Free template · Excel, Google Sheets, Notion

Your quote tracking spreadsheet,
ready to use.

Every quote you send, its status, the next action, and an alert when one goes too long without a follow-up. Download it, add your quotes, and see at a glance which ones need you today.

  • Free, no email asked
  • Statuses, next action and alerts built in
  • Excel, Google Sheets, Numbers, Notion
Your spreadsheet
Where will you use it?
Currency
Download for Excel (.xlsx)

Then

  1. Open the file in Excel. It also works in Numbers and LibreOffice.
  2. Delete the example rows and add the quotes you have in progress.
  3. Each morning, filter the Alert column.

Direct download. No email, no sign-up.

Preview

Try it before you download it

These are the example quotes from the file. Change a status or mark a quote as followed up: the alerts update exactly as they do in the spreadsheet.

  • In progress$115,5006 quotes
  • To handle today44 quotes
  • Win rate50%1 / 2

Alerts after 7 days without action. Change it in the panel above, or in cell B2 of the file.

QuoteClient · projectAmountStatusFollow-upsLast actionNext actionDays without actionAlertFollowed up
Q-2026-048The BennettsFull kitchen$14,8000—Check it arrived (text)tomorrow1
Q-2026-045Sarah MillerBathroom refit$9,20014 days agoCall: question about the shower4
Q-2026-041Oak Lane PropertiesExterior repainting$23,50019 days ago—9Follow up
Q-2026-037Paul GrantHeat pump$12,40023 days agoSend the adjusted versiontoday3Action due
Q-2026-033Claire DawsonSingle-story addition$48,000118 days ago—18Set a date
Q-2026-029Harbor HotelElectrical upgrade$7,600312 days ago—12Close?
Q-2026-026Julia MooreBuilt-in closet$3,90028 days ago—
Q-2026-021Mark PikeTimber decking$6,300227 days ago—
Scroll sideways to see every column →
Without a spreadsheet

Tired of keeping the spreadsheet up to date?

That’s what Vision sets up for businesses that sell on quotes: inquiries land in one place, every quote gets its follow-up sequence, and it stops as soon as the client answers. Start with the free diagnostic: three minutes to see where your quotes get lost.

Get my free diagnostic ↗
What’s inside

Three tabs, nothing to set up

01 Quotes

One row per quote: 15 columns, statuses in a drop-down list, days without action and the alert calculated for you, and colors on the rows that need you.

02 Dashboard

Quotes and value in progress, quotes to handle today, value won, win rate, and the breakdown by status and by alert.

03 How to use

The routine, what each status and alert means, the follow-up rhythm, and how to adapt the file.

The columns, one by one

ColumnWhat goes in it
Quote #Your quote number, as it appears on the quote.
Date sentThe day the quote went out. The alerts count from here.
ClientName of the client or company.
Phone / emailHow to reach them for the follow-up.
ProjectA few words: “Full kitchen”, “Heat pump”.
Amount (excl. tax)Total of the quote, for the dashboard figures.
StatusPick from the list: To send, Sent, Thinking it over, Postponed, Won, Lost.
Follow-upsHow many times you’ve followed up (0 to 3).
Last actionDate of the last call, text or email with the client.
Next actionWhat you’ll do next: “Call about the shower”.
Next action dateWhen you’ll do it. The alert waits until then.
Days without actionCalculatedCalculated: days since the last action (or since the quote was sent).
AlertCalculatedCalculated: what needs doing on this quote today.
Reason if lostPrice, timing, went elsewhere… After ten lost quotes, a pattern shows.
NotesAnything useful: who decides, constraints, what they liked.

The statuses

  • To sendThe quote is still being priced.
  • SentThe client has it, no answer yet.
  • Thinking it overThe client has replied but hasn't decided.
  • PostponedThe project has been pushed back. Write down when to pick it up again.
  • WonSigned. Well done.
  • LostDecided against you. Note the reason: after ten lost quotes, a pattern shows.

The alerts

  • Action dueThe date of the next action has arrived.
  • Follow upNo action for the number of days set in cell B2 (7 by default).
  • Set a dateThe project is postponed but has no date to pick it up again.
  • Close?Three follow-ups without a reply. Send a closing message.
The guide

How to track your quotes without losing your evenings

Why a tracker changes how many quotes you sign, how to set it up, the routine that makes it work, and when to move beyond a spreadsheet.

On this page
  1. Why track your quotes in one place
  2. Set it up in 10 minutes
  3. The routine: 15 minutes, twice a week
  4. When and how to follow up
  5. What the numbers tell you
  6. When a spreadsheet is no longer enough

1. Why track your quotes in one place

A quote that nobody follows up rarely gets signed. Not because the client said no, but because nobody asked. A tracker turns that into a list you can work through:

  • You see every quote in progress, not just the ones you remember.
  • You know which ones need you today. The alert does the counting for you.
  • You learn from the ones you lose. After a few months, the reasons and the win rate show what to fix.

2. Set it up in 10 minutes

No need to rebuild your history. Start with what’s still open:

  • Download the file in the format you use, with your currency and alert delay.
  • Delete the examples (rows 5 to 12) once you’ve seen how they behave.
  • Add your open quotes from the last two months: number, date sent, client, project, amount, status.
  • Fill in the last action for each one, even roughly. The alerts count from there.

From then on, add each new quote the day it goes out.

3. The routine: 15 minutes, twice a week

The file only works if you open it. Pick two fixed slots, Monday and Thursday morning for example, and do this:

  • Filter the Alert column. Handle every flagged row: call, text or email.
  • Update the row right away: last action, follow-ups, and the status if the client replied.
  • Write the next action and its date. That keeps the alert quiet until it’s actually time.

Fifteen minutes is usually enough for twenty or thirty quotes in progress.

4. When and how to follow up

The alerts tell you when. Here’s the rhythm the file is built around:

  • Day 2: check the quote arrived and opens properly.
  • Day 7: call to clear up a doubt. This is often where the project gets unstuck.
  • Day 21: ask where things stand, or close the file politely.

5. What the numbers tell you

The dashboard does the math. Three figures are worth a look every month:

  • Value in progress: the work you could sign in the coming weeks. If it keeps shrinking, the problem is upstream: not enough inquiries, or not the right ones.
  • Win rate: quotes won out of quotes decided. Compare it month to month rather than with other businesses.
  • Reasons for losing: if “price” keeps coming back, look at how the quote is presented before you look at your prices.

6. When a spreadsheet is no longer enough

A tracker is the right tool to start with. These are the signs it’s time for more:

  • You update it on Sunday evenings. The routine has become a chore, and rows fall behind.
  • Several people send quotes. Everyone keeps their own version, and follow-ups overlap or get missed.
  • Follow-ups still slip through. The alert is there, but nobody has time to act on it.

At that point, a CRM or an automated follow-up takes over the reminders, and you only step in when the client replies.

Questions

Your questions about the quote tracker

Is this quote tracker really free?

Yes. The download is direct: no email, no sign-up. You can use it, change it and share it with your team.

Excel or Google Sheets: which should I choose?

Same file, same features. Excel if you mostly work on a computer; Google Sheets if several people update it, or if you want it on your phone.

Does it work in Numbers or LibreOffice?

Yes. Open the .xlsx file: the formulas, the status list and the colors use standard spreadsheet functions.

How do I use it in Notion or Airtable?

Download the CSV version and import it. Then set the date columns to Date and Status to Select, and add the “Days without action” formula given on this page.

Can I add columns or change the statuses?

Add as many columns as you like on the right. The statuses are used by the formulas: to rename one, change it in the drop-down list and in the Alert column formulas, or keep the ones provided.

Why not use a CRM right away?

A CRM is worth it when several people sell, or when you send dozens of quotes a month. Until then, a well-kept tracker and two short sessions a week cover most of the need. What matters is the routine, not the tool.

Other free tools

All free tools →

Further reading

All articles →
Phone on a workshop bench showing an unanswered message screen, next to a folded quote
Pending quotes

Client Not Responding After a Quote? What to Do Next

Your client went quiet after the quote? The 6 most common reasons, the right message for each one, and when to close the file.

8 min read
Phone resting on a job-site stepladder, a new inquiry notification on the screen
First contact

How Fast Should You Reply to a Quote Request?

A quote request lands while you're on site: how to reply fast without dropping everything, realistic response times by request type, and the messages to set up.

8 min read
Your next signature might start here

Where do your customer inquiries get lost?

Three minutes to turn more inquiries into signed projects.

Get my free diagnostic ↗