Pricing spreadsheet or software: what changes and when to switch
A pricing spreadsheet solves the problem for many companies, and keeps solving it while the catalog is short, costs change slowly and a single person decides the price. What it cannot sustain is scale, tax per item and shared decisions.
This page compares the two using criteria that can be measured — items, states, people, hours — and says at what point the math flips. Without the tipping point, a comparison is just a list of adjectives.
Where the spreadsheet still works
Four situations in which changing tools improves nothing — and in which maintaining an integration would cost more than maintaining the file.
- A short, stable catalog
- A few hundred items, with costs that change once or twice a year, fit on one tab and can be checked one by one without anyone getting lost. The work of keeping this by hand is smaller than the work of keeping up any integration.
- One margin rule for everything
- When the company applies the same markup from the first product to the last, there is a single formula, written once and copied down. It is the scenario in which a spreadsheet does exactly what it was invented for.
- One person owns the file
- With a single owner, the file does not diverge, nobody overwrites someone else's column, and the memory of why a price is what it is stays with the person who decides. The fragility shows up when that person goes on vacation, not before.
- One-off, short-lived calculations
- Simulating the effect of a new freight rate, closing a quote, checking the margin on one specific order. For a calculation that is born and dies on the same day, opening a tab is still faster than registering anything.
Where the spreadsheet breaks
None of these is a spreadsheet flaw. They are the price of keeping in a file a decision that now has more inputs, more people and more consequences than the file can handle.
Volume: effort grows along with the catalog
Every new item is one more row to check when the supplier's price list changes. In a catalog with thousands of SKUs, the full review no longer fits in one work cycle, and what is left is sampling: the fast movers get reviewed, and the rest keeps selling at last semester's margin. Volume does not break the formula — it breaks the chance of anyone looking at it.
Tax: the average matches no invoice
A spreadsheet handles tax with a single percentage because it cannot read NCM, CFOP, tax regime and destination state item by item. The average percentage gets the month's total right and the product wrong: whoever has tax substitution pays on entry and does not recover it in the calculation, and whoever sells to another state sets a price using a rate that is not the one for the operation.
Versions: which file is the right one
Prices_2026_v4_final_REVISED.xlsx is the form version control takes in a shared spreadsheet. Two people opening the same file in different copies produce two truths, and the one that goes to the store is that of whoever sent last — not of whoever was right.
Human error: a broken formula still returns a number
A reference dragged the wrong way, a row inserted outside the range, a value pasted over a formula. None of it raises an alert: the cell keeps showing a price that looks like a price, and the error only surfaces at close, after the item has sold for thirty days below cost.
Traceability: nobody knows why the price is what it is
When an item's price is questioned six months later, the spreadsheet cannot say who changed it, when, from what to what, or with whose authorization. Without that trail, fixing it turns into an argument: everyone remembers a different agreement, and the decision is redone from scratch instead of adjusted.
The comparison, criterion by criterion
Seven criteria you can measure. Read each row looking at your own catalog: the decision usually shows up in two or three of them, not in the whole table.
| What is measured | The spreadsheet still copes | From here on it does not |
|---|---|---|
| Items in the catalog | Up to about 300 references, checked one by one without hurry. | Above 2,000, the full check no longer fits in one work cycle. |
| Repricing pace | 1 or 2 reviews a year, with weeks to absorb each one. | A new price list from 3 or 4 suppliers a month, each touching hundreds of rows. |
| Destination states | 1 state, with the same rate applying to the whole catalog. | 2 or more states, with different MVA and tax sharing by state and by NCM. |
| People changing prices | 1 owner, who knows every formula in the file. | 3 or more people deciding, each with the copy they downloaded. |
| Sales channels | 1 channel, with the same commission and freight on everything. | 2 or more channels, where the same item carries different margins per sale. |
| Time for a full round | Up to 2 hours, which fit in a Monday morning. | More than 8 hours, by which time part of the cost has changed again. |
| Age of the price being explained | 1 file and 1 person: the question is answered in a conversation. | 6 months later, nobody can say who approved that discount, or under what rule. |
The tipping point
The question is not whether the spreadsheet is bad. It is whether the operation has outgrown the size at which it was the right tool.
Start with the simplest calculation there is. At twenty seconds per item — the time to find the reference, read the new cost and look at what the formula returned —, a catalog of 2,000 references takes eleven hours per checking round: more than a full working day, with no interruptions and without stopping to understand a single discrepancy. Four rounds a year, which is the calmest pace an operation this size can have, add up to forty-four hours — more than a whole week spent on checking, before any pricing decision is made.
That is the visible part. The other part shows up in the items left out of the last review and in discounts granted below the floor, and nobody measures it until there is something to compare it against. Four signs usually indicate that the tipping point has already passed:
The repricing round has become a project
When passing on a new price list requires coordinating schedules, splitting the file between two people and reserving two days, repricing has stopped being routine. The next symptom is a familiar one: price lists start to be passed on in batches, weeks after they arrived.
Someone finds the error through the result
If the way to find a wrong price is to see the month's margin close below expectations, checking is not happening beforehand — and no formula review fixes that, because the problem is that verification depends on someone remembering to do it.
The answer to "why this price?" is a person
When the only way to find out why an item has that price is to ask whoever touched it, the pricing policy is not written down anywhere: it is spread across memories. It is the point at which one person leaving takes part of the rule with them.
Discounting has become case-by-case negotiation
Without a floor calculated per item, the discount limit becomes the knack of whoever is serving the customer. Two identical sales close with different margins, and the difference shows up in no report — it shows up in the result, mixed in with everything else.
Recognizing two of these signs does not oblige anyone to change tools tomorrow. It does oblige you to stop treating the matter as a lack of time. The next step is knowing what to evaluate: what pricing software does and how to choose one is the page written for that decision — and the migration usually starts with one product group, not the whole catalog.
What RevPrice does with what the spreadsheet left behind
Every limit in the previous section has an answer in RevPrice, the tool Revema Tech develops. The cost comes from the ERP with every invoice that arrives; tax is resolved from the item's master data and the destination state; the margin rule is written down and applies to the entire catalog at once; and every price change keeps its author, date and reason.
What it does not do is replace the decision: pricing policy remains the company's. What changes is that it ends up written in one place, applied to all items at the same time, and checkable afterwards — even by people who were not in the room when the price was set.
Questions from people who still price in a spreadsheet
The questions that come up before any conversation with a vendor — including the ones that have no commercial answer.
How many items can a pricing spreadsheet handle?
The limit is not the file's, it is the checking's. A spreadsheet opens a hundred thousand rows without complaint; what does not scale is someone looking at them. In practice, up to a few hundred items with stable costs, the whole review fits in one morning. Above a few thousand, review becomes sampling — and whatever was left out stays at last quarter's price indefinitely.
Does Excel versus Google Sheets change anything?
It changes collaboration and almost nothing else. A file in the cloud solves divergent copies and keeps an edit history, which is already more than a local file offers. It still does not read cost from the ERP with each invoice, calculate tax per item or block a price that breaks the margin floor — which are the three reasons the calculation goes wrong.
Can you calculate ICMS-ST and MVA in a spreadsheet?
You can, for one item and one state. What does not work is maintaining it: the MVA changes by destination state, by NCM and by protocol, and the spreadsheet would need a support table updated with every change in legislation, cross-referenced with each product's master data. Whoever tries ends up with an average percentage in the formula — and an average tax-substitution percentage matches no real operation.
Can you start with just part of the catalog?
It is the most common path, and it usually starts with the items that weigh most on margin or those whose cost changes most. The chosen group starts being calculated with cost read from the ERP and a written rule, and the rest stays in the spreadsheet while the master data is tidied. Switching everything at once usually runs into the state of the product master data, not the software.
Is the spreadsheet thrown away after the migration?
Rarely, and it does not need to be. It stops being the place where the price is decided and stays useful for what it has always done well: a one-off calculation, a back-of-the-napkin simulation, a quote closed in a hurry. What leaves it is the responsibility for maintaining the pricing policy of the whole catalog.
How much does it cost to stay in the spreadsheet?
The visible cost is time: hours of checking per repricing round, multiplied by the rounds in a year. The invisible one is larger and harder to estimate — the margin points lost on items left out of the last review and the discounts granted below the floor without anything flagging them. That second calculation is the one that usually decides, and it only becomes visible when the first correct margin appears next to the old one.
Further reading
Three reads for those who will stay in the spreadsheet a while longer: the cost the invoice really charges, the tax calculation an average cannot handle and the places where margin leaks.
Want to know where your operation stands?
A twenty-minute conversation is usually enough to place your catalog on the table above — including to conclude that it is not yet time to switch.