Contract pricing
Customer contract pricing without spreadsheets: quote the agreed price every time
Most B2B teams negotiate special prices and terms for their best customers, then keep those promises somewhere only one or two people can find. This article follows one illustrative account through that workaround, looks at what published research says about price and contract leakage, and shows how Saleslox commercial agreements put the agreed price and terms on every quote and order.
The scenario: forty contract customers and one pricing workbook
Illustrative scenario. Kestrel Industrial Supplies, its people and its numbers are invented to show a common pattern. It is not a Saleslox customer, and no results are claimed for it.
Kestrel Industrial Supplies distributes maintenance parts to manufacturers and food processors. It has nine people in sales, and around forty of its larger customers have a negotiated agreement: fixed prices on the lines they buy most, payment terms such as Net 30 or Net 60, and agreed lead times. The signed PDFs sit in a shared drive. The prices live in a “Contract pricing” workbook, one tab per customer, and several account managers keep their own copy. Finance keys price overrides into accounting at invoice time. Expiry dates are calendar reminders on one person’s account.
A food-processing customer amended its agreement in spring to add a lower price on conveyor belting. The shared workbook was updated; Priya, the account manager, was still using her own copy. In October she quotes belting at the old price. The customer’s procurement team, amendment in hand, push back. She re-issues the quote, but finance keys the order from the first PDF with Net 30 instead of Net 60, and a credit note follows.
Meanwhile another customer’s agreement expired in July. The reminder belonged to a manager who has since left, so that customer is still quoted contract prices that no longer exist, and no renewal conversation has started. Nobody was careless. The agreed price is simply stored everywhere except where prices are actually used.
The problem: a contract price is a promise kept, or broken, on the quote
An agreement promises this customer these prices and terms between these dates. That promise is only kept if it appears correctly on every quote, order and invoice, and in a PDF-and-workbook setup each of those depends on someone copying it by hand. So simple questions get hard: What price does this customer have on this product today? Is the agreement still active? Which terms did we commit to? Which agreements end in the next ninety days? Errors cut both ways. Quote list price to a contract customer and you damage trust; keep applying an expired price and you quietly give away margin.
What teams use today, and what it costs
The master pricing workbook
A pricing workbook is mostly typed-in numbers, copied tab to tab. That is exactly what spreadsheet research flags. In a peer-reviewed audit of 50 operational spreadsheets, Dartmouth researchers found hard-coding, typing a number where a reference belongs, was the most common error type, at 37.7% of error instances. Counting only errors that produced a wrong result, 43 of the 50 workbooks had at least one, with a cell error rate of 0.87% [1]. Across a few thousand contract prices, even that rate puts wrong prices in front of customers.
Personal copies, PDFs and calendar reminders
Every personal copy is a fork that amendments can miss. The signed PDF is the legal truth, but nobody reads a 20-page contract while building a quote. An expiry date in one calendar is invisible to the team and leaves with its owner.
Price overrides keyed after the sale
When finance enters contract prices and terms at invoice time, the customer finds the mistakes. Each costs a credit note, a re-issued invoice and usually a slower payment.
What the leakage adds up to
Small price differences matter. In Harvard Business Review, McKinsey’s Michael Marn and Robert Rosiello estimated that, for a company with average economics across 2,463 Compustat companies, a 1% price improvement with no loss of volume raises operating profit by 11.1%, and a 1% price decrease destroys the same share. They also found wide price bands: for some manufacturers, transaction prices for the same product ranged by 60% [2].
Contract research points the same way. World Commerce & Contracting and Deloitte, drawing on more than 1,200 organisations, put average contract value erosion at 8.6%, from a little over 3% for the best performers to more than 20% for the worst, and trace it to contracting work spread across multiple people and systems with no single point of data [3]. That describes the workbook, the PDF folder and the calendar reminder.
How Saleslox handles contract pricing
The fix is not a better workbook. It is putting the agreement on the customer’s record, where quotes and orders read it directly. The screenshots are real Saleslox screens from a demo workspace on the Enterprise plan; where a feature depends on the plan, we say so.
Step 1: one product catalogue for everyone
Every price starts from the shared product catalogue: name, SKU, category, unit of measure, territory, list price and status, searchable and filterable. One list price per product, not one per tab. The catalogue is on every plan.
Step 2: the agreement is a record with a status, not a tab
In Saleslox, a commercial agreement is a company’s price book for a territory. Its lines reference the shared catalogue, and the Agreements list shows each one’s company, status, territory, dates and payment terms, filterable to Draft, Active, Expired or Cancelled. The key rule: only Active agreements apply their contracted prices, lead times and terms to quotes and orders. Next term’s agreement can wait in Draft, and an expired one stops applying its prices.
Step 3: the agreement sits on the customer
On the company record, the agreement is one tab away, next to Contacts, Activities and Leads. The account manager, sales manager and finance all see the same agreement, so there is no personal copy to drift.
Step 4: quote from the deal, with the contracted price snapshotted
When a deal is ready for pricing, its card on the opportunity board offers Generate quote. Contracted prices from the Active agreement are snapshotted onto quotes and orders when a line is added, so nobody copies a number from a workbook and a quote keeps the price it was built with. Quotes move through visible statuses from Draft and Pending Approval to Accepted or Expired, and accepted quotes link to their order. Quotes and orders are on Pro and Enterprise.
Step 5: regional rules come from the territory
Agreements belong to a territory. On Enterprise, extra territories each have their own country, currency and formats, and quotes, orders and invoices for companies there use that territory’s tax rate and quote approval. Lower plans use the single Global territory. Either way, reps do not memorise regional rules.
Step 6: renewals start from a list, not a memory
Because every agreement has dates and a status, the Agreements list doubles as a renewal list: filter to Active, read the Dates column, and start renewals on time. That is how Kestrel’s July expiry would have surfaced months earlier.
Spreadsheet workaround vs Saleslox
| Task | Spreadsheet workaround | Saleslox |
|---|---|---|
| Where the agreed price lives | Master workbook plus personal copies | Agreement lines referencing the shared product catalogue |
| Is the agreement in force? | Open the PDF and check the dates | Status of Draft, Active, Expired or Cancelled on the list |
| Price on a new quote | Copied by hand from a tab | Snapshotted from the Active agreement when the line is added |
| Payment terms and lead times | Re-typed by finance at invoice time | Applied to quotes and orders from the Active agreement |
| Expired agreements | Still quoted until someone notices | Only Active agreements apply contracted prices |
| Tax and approval by region | Remembered by the rep | Set per territory (extra territories on Enterprise) |
| Renewals | Calendar reminder on one person’s account | Filter the Agreements list and read the dates |
| “What price does this customer have?” | Ask sales ops | Open the company’s Agreements tab |
How to test this on your own accounts
- Pick one customer with negotiated prices and one live opportunity.
- Create their commercial agreement with the contracted lines, dates and terms, and set it to Active.
- Generate a quote from the opportunity and compare each line with the signed contract.
- Filter Agreements to Active and note which end in the next ninety days.
The trial is 30 days of Pro, with no card required. For the rest of the deal, see how to send the quote from the deal or quote to cash without Excel.
Frequently asked questions
What is a commercial agreement in Saleslox?
It is a company’s price book for a territory, with lines that reference the shared product catalogue, plus dates and payment terms. Only Active agreements apply their contracted prices, lead times and terms to quotes and orders.
What happens to an existing quote if the agreement changes later?
Contracted prices are snapshotted onto quotes and orders when a line is added, so a quote keeps the price it was built with.
Do expired agreements still apply contract prices?
No. Only agreements with Active status apply their contracted prices and terms. Draft, Expired and Cancelled agreements do not.
Which Saleslox plans include this?
The product catalogue is on every plan. Quotes and orders are on Pro and Enterprise. Invoices and extra sales territories are on Enterprise. The screenshots are from Enterprise; see compare plans.
Is Kestrel Industrial Supplies a real Saleslox customer?
No. Kestrel Industrial Supplies and every person and number in its story are invented to illustrate a common pattern. No customer results are claimed.
Sources
- Powell, S. G., Baker, K. R. and Lawson, B. (2009). “Errors in Operational Spreadsheets.” Journal of Organizational and End User Computing, 21(3), 24–36. mba.tuck.dartmouth.edu
- Marn, M. V. and Rosiello, R. L. (1992). “Managing Price, Gaining Profit.” Harvard Business Review, September–October 1992. hbr.org
- Deloitte and World Commerce & Contracting (2023). “Upping contract management lifecycle ROI”, summarising The ROI of Contracting Excellence. deloitte.com