Managing Quotes Without Spreadsheets: A Practical Guide

Running quotes without a spreadsheet takes three things: one place where every proposal lives, a status that reflects reality, and a reminder date that fires on its own. Spreadsheets do not fail at arithmetic, they fail because nobody updates them once the quote has been sent. The rest of this guide covers how to build that flow, step by step.

---

Why quotes go missing

A quote is the most expensive document your company produces. It takes thirty minutes to put together, sometimes two hours if you have to work out quantities, discounts and delivery windows. Then you attach it to an email, send it, and the moment you hit send it leaves your field of vision.

What happens next is always the same. The file lands in a shared folder under a name like Quote_Smith_v3_final.pdf. The running number lives in a sheet that only the finance person updates, when they remember. The salesperson keeps the callback date on a sticky note or in their head. Ten days pass, something urgent comes up, and that quote stops existing for everyone except the customer, who has meanwhile received another proposal and made a decision.

The underlying issue is that a quote is not a document. It is a commitment with an expiry date. A PDF has no idea it expires. A spreadsheet only knows if somebody types the date by hand and then checks it every morning, which nobody does for more than a fortnight in a row.

---

The minimum data every quote needs

Before you pick a tool, decide what has to exist for each proposal. Without these fields, any system is just an archive of PDFs.

Field	What it is for	Example
Linked customer or lead	Ties the quote to the record and its history	Smith Ltd
Value and estimated margin	Lets you sort proposals by real priority	8,400 euro, 32% margin
Sent date	The basis for expiry and response time	12 March
Expiry date	Turns the quote into a commitment with a deadline	12 April
Status	Tells the whole team where things stand	Awaiting reply
Owner	Prevents the classic "I thought you were on it"	Marco
Next action and date	The field that rescues forgotten proposals	Call back on 20 March

That last field is almost always missing. "Next action" is not a note, it is a task with a date that has to appear in somebody's calendar. If your system does not create that reminder by itself, you will be back to sticky notes within a month.

---

Setting up the process in seven steps

This is the minimum workflow that holds up even in a three person company. You can put it in place in an afternoon.

1. Define a single entry point. Every request for a quote, whether it arrives by form, phone, email or message, becomes one row in the system. If a request lives in two places, one of them will be wrong within a week. If requests come in through several channels, it is worth reading how to stop losing inbound leads as well.
2. Use one document template. Same layout, same payment terms, same validity clause. A shared template removes half of the internal revisions and makes proposals comparable with each other.
3. Number your quotes automatically. Manual numbering produces duplicates and gaps. An automatic counter closes that problem for good.
4. Always print the validity date on the document. "Valid for 30 days" is not legal boilerplate, it is the lever that lets you call the customer back without sounding pushy.
5. Schedule the follow-up at the moment you send. Not later, not when you have time. You create the callback task as the quote goes out, otherwise you will never create it.
6. Update the status when something happens. Customer replied? Change the status. Asked for changes? New version, status "under revision". The status has to describe reality to somebody looking at the system tonight who was not on the call.
7. Always close the loop, including the losses. A lost quote with the reason written down is worth more than ten proposals left open. It is the only way to understand, six months from now, whether you lose on price, on lead times or on missing follow-up.

---

Quote statuses and who updates them

Statuses exist for one reason: to let anyone understand in ten seconds what is going on. Keep the list short and decide who moves each one.

Status	What it means in practice	Who updates it
Draft	Being prepared, not sent yet	Whoever writes it
Sent	Delivered, waiting for a reply	Sales
Under revision	Customer asked for changes	Sales
Accepted	Written go-ahead from the customer	Sales
Lost	Closed without an order, reason recorded	Sales
Expired	Validity period passed with no reply	Automatic

The automatic "Expired" status is the one that changes daily life the most. The system watches the validity date and moves the quote on its own, so every morning you are looking at the real list of live proposals instead of rebuilding it by hand.

If you are wondering how these statuses relate to your commercial stages, a quote is one specific moment inside a longer journey, the one usually organised into pipeline stages.

---

Follow-up is where deals are won

Plenty of quotes are not lost on price. They are lost because nobody called back. The customer received the document on a day when their head was elsewhere, put it aside meaning to read it properly, and never picked it up again.

A simple, sustainable rhythm looks like this: a short message after three working days to check the document arrived and is clear, a phone call halfway through the validity period to surface any doubts about timing or terms, and a final contact two days before expiry asking whether they need the offer extended. Three touches, none of which feels like pressure, each with a concrete reason behind it.

The difference between the people who do this and the people who do not is not personal discipline, it is whether the reminder appears by itself. When the callback task is created automatically as the quote is sent and lands in the owner's calendar, the follow-up happens. When it depends on remembering, it does not. If you want to apply the same idea to other processes, there is a broader treatment in the guide to automated workflows.

---

From accepted quote to invoice

The moment a customer says yes is also the moment that generates the most pointless manual work. Somebody reopens the PDF, retypes the lines into an order, then retypes them again into the accounting system to raise the invoice. Three transcriptions of the same data, three chances to get an amount or a VAT code wrong.

If the quote is structured as data rather than as a document, that handover becomes a confirmation instead of a copy and paste exercise: the lines, discounts and payment terms are already there, and the invoice is built from the same values. When the cycle is connected to your invoicing software, as with the Fatture in Cloud integration, the fiscal document is generated from data that has already been checked once.

There is a less visible benefit too. When quotes and invoices share a single source, comparing what was sold against what was billed stops being a manual reconciliation job at the end of every quarter.

---

What to review each month

Four numbers are enough, and all of them come straight out of the statuses you defined above.

Acceptance rate is accepted proposals over proposals sent in the period. On its own it says very little, but watched across three or four months it shows whether your changes to pricing or to the document template are having any effect.

Average response time measures the days between sending and the customer's first reaction. When it grows, it usually means you are sending proposals to people who cannot sign them, or that the document is too long to be read quickly.

Value of open proposals is the sum of everything sitting in "Sent". It is the most honest picture of what might land in the coming weeks, and it is only trustworthy if the statuses are genuinely kept current.

Loss reasons are the data nobody collects and that explains almost everything. If half of your lost quotes say "no reply", the problem is not your pricing, it is your follow-up. If most of them say "too expensive", then it is worth revisiting positioning or how the offer is structured, rather than making more phone calls.

---

Frequently asked questions

How long should a quote stay valid? In most cases between 15 and 30 days. A shorter window creates urgency, but it is only credible if your costs really do move. A longer one leaves the proposal hanging for weeks and removes your natural reason to call the customer back.

Should I edit the existing quote or create a new version when the customer asks for changes? Create a new version and keep the old one. It lets you reconstruct the negotiation if an amount is ever disputed and, more usefully, it shows how many revisions you typically need before closing. If it is more than two, the problem is often in how requirements were gathered.

Does it make sense to send quotes over WhatsApp? It makes sense to use WhatsApp to say the quote has been emailed, because it raises the odds of the message being opened. The formal document is better kept on a traceable channel, with verifiable send and receipt dates.

At what volume should I drop the spreadsheet? The number of quotes matters less than the number of people touching the same record. With one person handling everything, a tidy sheet can last a long time. From two people up, or as soon as finance and sales both need to read the same status, the sheet starts drifting away from reality almost immediately.