Managing quotes with Excel: 7 mistakes that cost margin

By Redazione VERC · 26 agosto 2026 · 8 min read

Excel is probably the most widespread management software in Italy. Not officially, but in practice: beneath the installed management systems and the cloud subscriptions, the quoting of a huge number of small and medium businesses lives inside an .xlsx file that someone built years ago and that nobody dares to touch any more.

The point of this article is not that Excel is wrong. It is an extraordinary tool and for many companies it is the right choice. The point is that it has a threshold beyond which it stops saving time and starts costing money, and that threshold is crossed without noticing.

Here are the seven ways it happens.

In brief

• The cost of Excel is not in the time spent filling it in, it is in the errors nobody sees and in the decisions taken on old data.
• File duplication is problem number one: every copy freezes the price list at the day it was made.
• Formulas break silently. A quote with a wrong reference looks exactly like a correct one.
• The warning sign is when someone has to ask which is the good version of the file.
• There is no need to throw Excel away: you need to take the price list out of it, which is the part that does not tolerate multiple copies.

1. The proliferation of copies

The flow is always the same. A quote is needed, you open the master file, you do "save as", you fill it in, you send it to the customer. The file stays in the customer's folder or the year's folder.

From that moment there is a copy of the price list that will never receive another update. If three months later someone reopens it to make a variant, they are using prices that are three months old. If in the meantime the paper has gone up by 12%, that quote goes out below cost and nobody notices until the final job costing, assuming the costing is done at all.

After two years of activity an SME easily reaches hundreds of copies of its own price list scattered across desktops, NAS, shared folders and email attachments. None of them is up to date, all of them look like they are.

Typical cost: margin eroded invisibly on a share of quotes that nobody can quantify, because quantifying it would require the very data that is missing.

2. The formulas that break silently

A row inserted in the wrong place, a relative reference where an absolute one was needed, a VLOOKUP pointing to a range that has been shortened. Excel does not protest: it returns a number.

It is the most dangerous characteristic of the spreadsheet applied to quoting. A calculation error does not produce an error message, it produces a perfectly normal-looking quote with the wrong price inside it. If the price is too high you lose the job and you will never know why. If it is too low you win it, and you discover the problem when the supplier's invoice arrives.

The spreadsheets most at risk are the well-built ones: many chained formulas, references between sheets, hidden cells. The more sophisticated the file, the fewer people are able to verify its integrity, and the longer an error can survive.

3. The shared file that nobody can open

As soon as the users become two, the file on the shared folder goes into conflict. "The document is open in read-only mode", the colleague who goes to lunch leaving it locked, the quotes_MARCO.xlsx copy created to avoid waiting, that nobody will ever merge back into the master.

The cloud versions of Excel and Google Sheets ease the problem, but do not eliminate it. What remains is the absence of granular permissions (who can see the costs and not just the prices?), the impossibility of knowing who changed that cell and when, and no way to stop a user from overwriting a price list by mistake.

4. No history of prices actually charged

The customer calls: "Do me the same job as last year". The hunt for the file begins. In which folder? Under what name? Was it the March quote or the one revised in April? Was the final price the one in the document or the one agreed on the phone and never written down anywhere?

A company that cannot reconstruct in thirty seconds what it charged a customer and at what margin is giving up the simplest commercial lever it has. Worse: it risks redoing the same job at a different price, which with regular customers is a credibility problem before it is a margin one.

5. The quote does not become anything

In Excel the quote is a dead end. When the customer confirms, the data has to be re-entered by hand into the order, then into the delivery note, then into the invoice. Every re-entry is an opportunity for divergence between what you quoted and what you will invoice.

The classic case: the quote provides for 5,000 pieces with the cutting die charged, the invoice goes out without the die because whoever invoiced was looking at the order and the order showed only the unit price. It is lost money that appears in no report, because no report is looking for it.

6. The knowledge lives in a single head

Every well-made quoting spreadsheet has an author, and that author is the only one who really knows how it works. Why that column has a +3%, what the yellow cell at the bottom represents, why for customer X you use the separate sheet.

As long as that person is there, everything works. When they go on holiday, fall ill or leave the company, the file becomes an opaque object that nobody wants to change for fear of breaking it. At that point the company keeps quoting with criteria that nobody is any longer able to explain or update.

It is the most serious risk of the seven, and the only one that stays invisible until it manifests all at once.

7. No aggregated data

How much did we quote last month? How many quotes turned into orders? Which process has the worst margin? Which customer asks for the most quotes and confirms the fewest?

In Excel these questions require opening dozens of files and consolidating them by hand. Which means, in practice, that nobody asks them. The company carries on without knowing its own quote conversion rate, which is one of the three or four numbers that really explain how sales are going.

The real reckoning

Try putting numbers to your own case.

In most small businesses the first row alone is enough to justify a change. The other four are the reason why it is worth doing it well rather than in a hurry.

What to do, without revolutions

The opposite mistake is throwing Excel out overnight. It does not work: the spreadsheet is where the work is, and switching it off before the alternative is up and running means stopping the company.

The approach that works is gradual.

First step: take the price list out of Excel. It is the part that does not tolerate multiple copies. The price list must live in a single place, editable by whoever has the right, readable by everyone. If you work with prices that depend on process and quantity, the right structure is the one described in how to build a price matrix.

Second step: generate the quotes from there. No longer filling in a document, but selecting processes and quantities and letting the price be read from the single source. The copy of the price list disappears, and problem number one disappears with it.

Third step: link the quote to what comes next. Order, job, documents. Every step that does not require manual re-entry is one error fewer.

Fourth step: add the rest when it is needed. Inventory, statistics, a due-date schedule. One module at a time, after the previous one has become part of people's habits.

Excel, at the end of this path, stays in the company. It will keep doing what it is unbeatable at: one-off analyses, simulations, ad hoc processing. It simply stops being the place where the data that has to be true for everyone lives.

If you are evaluating which tool to put in its place, the selection criteria are gathered in how to choose a cloud management system for an SME.