Excel can be an effective tool for building a quotation, testing a price or modelling an unusual commercial scenario. The challenge starts when the workbook becomes the live system for creating, revising, issuing and tracking quotes.
For a Commercial Manager, the decision is rarely just about producing a better-looking PDF. It is about controlling rates, identifying the current quotation, handling exceptions consistently and understanding what happened after a quote was sent.
This guide compares Excel quotation sheets with quotation software around four practical areas: rate governance, revision history, quote turnaround and win or loss tracking. It also explains where a managed custom application may be a better fit than either a shared workbook or a standard product.
Excel vs quotation software: the practical comparison
| Control area | Excel quotation sheet | Suitable quotation software, when configured for the workflow |
|---|---|---|
| Rate governance | Rates can be held in tabs or lookup tables, but copies, overrides and formula changes may be difficult to control consistently | May centralise product, customer or rate data and restrict changes through configured permissions or rules |
| Revision history | Often depends on filenames, folder structure, saved copies and manual notes | May retain version history or change records, depending on the product and configuration |
| Quote turnaround | Can be quick for a familiar template and a straightforward quote | May provide structured records, guided entry and document generation to make repeatable work easier |
| Win and loss tracking | Outcomes may be recorded in separate spreadsheets, emails or CRM notes | May keep quote status and outcome information with the quotation record for reporting |
| Shared ownership | Can work where one person owns the file and process | Can provide a shared record for users working across commercial, sales, finance and operations teams |
The table is not a claim that every quotation product provides every control. Features such as permissions, approvals, version history, pricing rules and reporting vary by product, plan and configuration. The important question is whether the chosen approach can support the way your business actually prices and issues quotations.
Where Excel remains useful for quotations
Excel is still useful when the work is analytical, temporary or exploratory. A Commercial Manager may use it to:
- Test a proposed pricing scenario.
- Model a one-off commercial assumption.
- Compare alternative rate structures.
- Explore the impact of a discount before it becomes an agreed rule.
- Create a simple quote where one person owns the process.
These are valid uses of a spreadsheet. Excel is flexible, familiar and well suited to calculation-led work.
The risk increases when the same workbook is expected to act as both a flexible analysis tool and a controlled operational record. A live quotation process may involve customer details, current rates, exceptions, document generation, revisions, handoffs and outcome reporting. Those responsibilities can be difficult to manage through shared files and informal conventions alone.
Rate governance: can the team rely on the price used?
A quotation workbook can contain an accurate rate table and still create a control problem. The issue is what happens around that table.
For example, a user may:
- Copy a rate from an older quote.
- Override a price for a customer without recording why.
- Paste over a formula or lookup.
- Work from a local copy with different assumptions.
- Use a discount agreed in an email rather than a visible commercial rule.
Excel can support disciplined pricing where the process is simple and clearly owned. But it relies heavily on people following the same process every time.
A suitable quotation system may provide a more governed route by keeping approved data in one place, limiting who can change certain fields or recording exceptions against the quote. Whether this is available depends on the product and how it has been configured.
The key commercial question is straightforward:
Can the business identify the rate used, who changed it and why that quotation was issued on those terms?
If the answer depends on searching email threads, comparing attachments or asking one experienced colleague, the process may need stronger control.
Revision history: which quotation is current?
Version confusion is one of the most common operational problems with Excel-based quotations. A team may use filenames such as Quote v4, Quote v4 revised and Quote FINAL, while separate PDFs are sent to the customer at different points.
That approach can work for occasional quotations. It becomes less reliable when several people contribute to a quote or when revisions are frequent.
A controlled quoting workflow should help the team answer:
- Which version is the current working version?
- Which version was sent to the customer?
- What changed between versions?
- Was a commercial exception retained or removed?
- Which rates and quantities were used at the time of issue?
Some quotation products provide version history, activity logs or status tracking. Others may not provide the level of traceability required without additional configuration or connected systems. This should be checked during product evaluation rather than assumed.
For businesses with specific quote structures, pricing rules or document requirements, a managed custom application can be designed around the revision points that matter to the commercial process.
Quote turnaround: fast production versus repeatable production
Excel can be fast when an experienced person knows the workbook well. The process often slows down when they need to find current customer details, confirm rates, check calculations, create a PDF, send it for review and update another system afterwards.
The goal is not simply to make quote creation faster. It is to make the process dependable when workload increases, a colleague is unavailable or a new starter needs to follow the same route.
A suitable quotation workflow may improve repeatability by bringing together:
- Customer and contact information.
- Product, service or rate data.
- Quote line items and calculations.
- Defined exception handling.
- Document output.
- Quote status and follow-up information.
A standard product can be a good fit where its existing data structure, document templates and workflow match the business. If users need to keep exporting information back into Excel, maintaining parallel trackers or adapting important commercial rules to suit the software, the fit may be less convincing.
Win and loss tracking: can quote data guide commercial decisions?
A spreadsheet can track won and lost quotations, but the information is often separated from the original quote. One person may update a tracker, another may hold the reason in a CRM note, and a third may have useful context in an email conversation.
That makes it harder to review commercial patterns with confidence. For example, a manager may want to understand whether quotations are lost because of pricing, response time, scope, customer requirements or a recurring product issue.
A quotation system may make this easier if it can record quote status, outcome and reason against the same operational record. The quality of the reporting will still depend on clear definitions and consistent use by the team.
The useful question is not whether a dashboard exists. It is whether the business can connect a commercial outcome to the quotation, assumptions and process that produced it.
Signs that the quotation workbook is becoming a business system
The problem is not necessarily the size of the workbook or the number of people in the company. A small team can need better control when quotations include sensitive rates, changing assumptions or several internal handoffs.
Review the process around the spreadsheet. These signs suggest it may be carrying more operational responsibility than it should:
- Customer, pricing or line-item data is entered more than once.
- Staff rely on filenames, inboxes or folders to identify the latest quote.
- Different people maintain their own copies of rate information.
- Discounts and exceptions are agreed in messages rather than recorded with the quotation.
- Finance, sales, commercial and operations teams reconcile details manually.
- Nobody can easily explain who owns the current price list.
- A revised quote can replace the only clear record of what was previously sent.
- Win and loss information sits outside the quotation process.
These are process-control issues rather than simply spreadsheet skills issues. Training can improve how people use a workbook, but it does not automatically create one controlled record, a clear history of revisions or a defined handoff between teams.
Standard quotation software or a managed custom application?
A standard quotation product can be a sensible option when the business can use its existing workflow without major compromises. It may fit well where the organisation has conventional customer records, straightforward price lists, familiar document formats and reporting needs that the product already supports.
A managed custom application may be more appropriate when the quotation process contains important rules that a generic product cannot represent cleanly. Examples might include:
- Customer-specific pricing structures.
- Bespoke quote line structures or calculation rules.
- Different commercial processes for different service lines.
- Specific document layouts or supporting information.
- Handoffs between commercial, finance and operational teams.
- Reporting that must connect quotation activity with internal delivery information.
- Existing spreadsheet logic that is valuable but difficult to govern in a shared workbook.
Spreadsheet Upgrade provides fully managed custom web applications for business-critical operational Excel workflows. The aim is not to hand a commercial team another tool to build or maintain themselves. It is to replace a fragile live workflow with an application designed around the organisation's records, rules and responsibilities.
For more detail on replacing an operational quotation workflow, see quotation workflow replacement.
A practical decision check
Use this short check to decide what to investigate next.
| Current situation | Practical next step |
|---|---|
| One person creates occasional, straightforward quotes from a stable template | Keep Excel, document ownership and review the template periodically |
| The team needs better consistency but the workflow closely matches an existing product | Compare suitable quotation software against the required records, documents and reporting |
| Multiple people revise quotes, manage exceptions or rely on disconnected trackers | Review how a shared operational record and clearer workflow controls could work |
| Important pricing logic or handoffs do not fit standard software without workarounds | Explore whether a managed custom application is a better fit |
Do not choose a system solely because it has a long feature list. Test the real workflow instead. Take one current quotation and follow it from initial pricing through revisions, issue, follow-up and outcome.
Ask:
- Where does the rate come from?
- Who can change it?
- How is an exception recorded?
- Which version is treated as current?
- Which document was sent to the customer?
- Where is the quote outcome recorded?
- What information must pass to finance or operations?
The answers show whether a better workbook, a standard quotation product or a managed custom application is the more appropriate next step.
Start with a Free Fit Check
A Free Fit Check can help map the quotation workflow before deciding on a replacement approach. Bring examples of the current workbook, the people involved, the rate rules, revision points, document requirements and any handoffs into finance or operations.
The purpose is to understand how the process works in practice and whether a managed custom application is a good fit for the controls your team needs.