When Spreadsheets Stop Working: How Businesses Can Modernise Quoting and Contracts

How Businesses Can Modernise Quoting and Contracts

At 9:15 on Monday morning, a sales manager needs a revised quote for an important customer. The customer expects it before lunch. The salesperson already has the opportunity open in the company CRM. Customer details, products, and sales notes are all there. Yet the quoting process quickly moves elsewhere. The salesperson opens a spreadsheet for current prices. Another file contains discount thresholds, while the contracts team has its own document template. The requested discount requires management approval, so the salesperson sends an email and waits. Tuesday passes without a decision. By Wednesday, the customer still has no final quote.

This is not a technology failure. It is a process problem. For many growing businesses, spreadsheets remain part of the quoting process long after they stop being practical. They can create delays, duplicate work, and make accurate information surprisingly difficult to find. Eventually, businesses need to consider whether their quoting and contract processes can support the way they actually operate.

Why Spreadsheets Become Difficult at Scale

Spreadsheets are useful because they are flexible. Teams can create formulas, add pricing tables, and adapt them without technical support. However, that flexibility becomes a weakness when several departments depend on the same information. Sales might maintain one pricing file, while finance could have another. Meanwhile, contracts may be created from a separate template. As a result, the same customer or product information can appear in several places.

Every manual handoff creates another opportunity for an error. Someone can use an outdated price or enter the wrong discount. A salesperson might also spend valuable time checking which file contains the latest information. These problems may seem minor individually. However, repeated across hundreds of opportunities, they can create substantial operational costs.

The Problem Is Bigger Than Slow Quotes

A slow quote is often the most visible symptom. The underlying problems can reach much further. Suppose a salesperson accidentally uses an outdated product price. The quote reaches the customer before finance identifies the mistake. The team then needs to correct the quote and explain the change.

Another deal might involve a discount that requires approval. If the approval process depends on email, the sales team may have limited visibility into its progress. Contract creation can introduce further delays. Employees may copy approved information from a spreadsheet into a document, creating another opportunity for errors.

Eventually, sales, finance, and legal teams can spend more time reconciling information than moving deals forward. That can affect productivity, customer experience, and confidence in commercial data.

Start by Mapping One Real Deal

Businesses often try to fix quoting problems by choosing new software first. A better starting point is understanding the existing process. Take one typical deal and follow it from initial pricing through final billing. Where does the salesperson get product information? Where are discounts calculated? Who approves exceptions? How does the contract receive the final figures?

It is also important to identify every point where someone copies information manually. This exercise can expose problems that are difficult to see from a management perspective. Sales teams may highlight approval delays, while finance may identify pricing inconsistencies. Together, these insights provide a clearer picture of what needs to change.

Create One Connected Revenue Process

Once the bottlenecks are clear, businesses can look at ways to connect pricing, quoting, contracts, and billing. Salesforce Revenue Cloud is designed to support these revenue processes within a connected environment. It can help businesses move away from disconnected spreadsheets and repeated data entry.

For organisations considering this transition, experienced Salesforce Revenue Cloud consultants can assess existing workflows and help determine how Revenue Cloud should support them. The important consideration is not simply whether a platform has the right features. The implementation must reflect how the business sells, prices, approves, contracts, and bills. Otherwise, a company can end up transferring an inefficient process into a more expensive system.

Make Routine Approvals Easier to Manage

The three-day discount delay in our opening example is a useful place to look for improvement. Businesses can establish clear rules for standard discounts and define when additional approval is required. Routine deals can then follow a predictable process, while larger discounts can be routed to the appropriate decision-maker with the necessary information attached.

This approach reduces unnecessary email exchanges and gives sales teams greater visibility. However, automation should not remove human judgement. Complex deals may require commercial expertise, negotiation, or senior approval. Technology should handle predictable administration while experienced employees make important decisions.

Reliable Quoting Depends on Reliable Data

A connected revenue process is only as useful as the information behind it. Imagine that a business has three versions of the same product in its pricing spreadsheets. Each version carries a different price. Moving those records into a new platform will not solve the underlying problem.

Businesses should therefore review product catalogues, pricing structures, customer records, and contract information before implementation. Data ownership also needs to be clear. Someone should be responsible for maintaining important commercial information when prices, products, or policies change.

Good data makes processes more reliable. It also creates a stronger foundation for future automation, reporting, and better business decisions.

Modernisation Does Not Mean Replacing Everything at Once

Businesses often hesitate to modernise because they expect a major transformation. A phased approach can be more practical. A company might first address quote creation and discount approvals. Once those workflows operate reliably, it can improve contract management and billing.

This approach reduces disruption and gives employees time to adapt. It also allows leadership teams to measure progress. Faster quote turnaround, fewer pricing errors, and clearer approval visibility can provide useful evidence.

The priority should always be the biggest operational bottleneck. If discounts regularly wait for approval, address that issue first. If contracts require repeated manual data entry, tackle that next.

A Better Process Should Make Growth Easier

Spreadsheets are not inherently a problem. They become a problem when they are asked to coordinate a complex commercial process. The sales team in our opening example did not need more spreadsheets. They needed a clearer path from opportunity to quote, approval, contract, and billing.

That distinction is important. Modernisation should not be about replacing familiar tools simply because newer technology exists. It should address the points where disconnected systems slow people down or create unnecessary risk.

A connected revenue process can help businesses improve pricing consistency, shorten approval cycles, reduce repetitive work, and give teams greater confidence in their data. Most importantly, it can create a process that grows with the business.

When a salesperson can build an accurate quote without searching through multiple spreadsheets, the improvement is easy to understand. When that information can then move smoothly into contracts and billing, the wider business benefits too.

That is the real value of modernising quoting. It is not about abandoning spreadsheets overnight. It is about creating a dependable commercial process that can support the business today and as it grows.

Michael James is the founder of Intelligent News. He loves writing about celebrities and their relationships — including husbands and wives, couples, marriages, and divorces. Take a look at his latest articles to learn more about your favorite stars and their lives.