How to reduce quote errors when you finally leave Excel
The five spreadsheet mistakes that cost margin, and the setup that removes them.
Error 1: the formula that broke
A dragged formula stops a row short, a #REF! hides in a subtotal, and the quote is wrong before anyone reads it. Calculated pricing removes the class of error entirely: there are no cell formulas to break, and every line is rounded to the cent so the totals always reconcile.
Error 2: the markup nobody applied
In a spreadsheet the markup is a step someone has to remember. Put the markup on the product itself and it's applied on every line automatically. The selling price is never the bare cost by accident.
Error 3: the rate from two years ago
Copied-forward workbooks carry old rates for years. One catalogue means you change a rate in one place, and every future quote uses it, while sent quotes keep the prices the client actually agreed to.
Error 4: the version you can't find
quotes_FINAL_v7 (3).xlsx is not a version-control system. Numbered revisions are: sending freezes the prices, revising creates a new numbered document, and the previous one stays viewable. You can always show exactly what was sent and accepted, and when.
Error 5: the product left off the buy-list
When products are scattered across tabs, one always gets missed when someone builds the shopping list by hand. An accepted job rolls every product into one consolidated buy-list, quantities and units, to buy against. (It's an internal buy-list, not a purchase order, and it isn't sent to a supplier for you.)