Managing customer-specific pricing agreements: how to stay in control as you grow

An account manager calls a customer and agrees to a sharper price on three items. He confirms it by email, adds it to the shared spreadsheet, and asks operations to enter it in the ERP. Three months later he leaves the company. Two years later, that discount is still running. Sound familiar? In almost every B2B company with customer-specific pricing, this is how it goes. Not because people are careless, but because pricing agreements grow faster than the process around them. This article explains why that happens, what it costs, and how to set up pricing agreement management so it scales with your business.

Why pricing agreements get complex so fast

One pricing agreement is simple. The problem is multiplication. A pricing agreement is defined by at least four dimensions:

• Who. One customer, a customer group, a buying group, or an entire country.
• What. One item, an item group, a brand, or the full assortment.
• How much. A fixed price, a discount off the gross list, or a tier that shifts per order quantity.
• When. A term, a promotional period, a season, or “until further notice.”

Those combinations stack up. With 200 customers and 1,500 items, there are theoretically 300,000 possible combinations. In practice you might actually record a few thousand. That’s still a few thousand rows someone has to create, update, and let expire. Once you see that, it makes sense why Excel gets used so much for this. Excel is the only tool where you can quickly edit a thousand rows at once. This makes it appealing at first, but risky later¹.

The lifecycle of a pricing agreement

1. Agree. Sales negotiates and settles on a price.
2. Record. The agreement goes into the system, so orders get the right price.
3. Apply. On every order, the ERP picks up the right price.
4. Monitor. Does the agreement still hold? Has the purchase price gone up? Is the customer hitting the volume they promised?
5. Evaluate. The agreement expires, gets renewed, or goes into the price round.

Steps 4 and 5 are invisible work. No order comes in that beeps when an agreement is outdated. A wrong price doesn’t throw an error, it just gets invoiced quietly. That’s what makes pricing management so treacherous: it can fail silently.

Five signs you’ve outgrown your process

1. The agreement lives in a mailbox. The real agreement sits in an email thread, the system only holds the result. When that employee leaves, the context leaves with them: why this price, what was traded for it, when it was supposed to be revisited?

2. There are two truths. The ERP has prices and there’s a spreadsheet with prices. When they disagree, whoever argues loudest usually wins. The honest answer to “which one is authoritative?” is often: it depends who you ask².

3. Nobody knows who changed what, or when. Someone adjusted a tier back in March. Who, why, and on whose authority is no longer traceable. In a dispute with a customer, you’re empty-handed.

4. Agreements have no end date. A promotional price from a launch period that was never rolled back. A volume discount for a quantity the customer hasn’t hit in three years. This is the most common form of margin leakage we see, and almost nobody measures it.

5. The rules live in someone’s head. There’s a rough idea of when you’re allowed to deviate and who can approve it, but it’s written down nowhere and enforced nowhere. That works while the team is small. Not with ten account managers.

One or two signs is normal. Three or more means your pricing agreements have outgrown the process, and it’s mostly still working because one or two people hold it all in their heads.

How to set it up properly

Separate storage from management

Your ERP is where the price lives and where the order picks it up, but an ERP is built to administer one record at a time, correctly. It’s not built to edit, compare, and run thousands of pricing agreements through an approval process at once.

This is where Excel often gets pulled in. Employees don’t usually choose a shadow administration on purpose, they just look for a place where they can work. So the answer isn’t “no more Excel”, it’s: make sure there’s a workspace that’s actually connected to the source.

Work with rules, not exceptions

Every pricing agreement you record as an individual customer-item line, you’ll also have to maintain individually later. Record as much as possible at the highest level that still holds: a discount at brand level instead of on 80 separate items, a customer group instead of twelve separate customers. Exceptions are fine, just make them deliberate and recognizable as exceptions.

A practical rule of thumb: if 80% of your agreements follow a handful of standard structures, the remaining 20% is manageable enough to actually monitor³.

Give every agreement a start and end date

Make sure no agreement exists without an end date. If you don’t know when it should end, set it to twelve months and let it come back around. An agreement you actively renew is one you still stand behind. An agreement that just silently continues is one nobody remembers anymore.

Record your rules as system rules, not agreements

“Below the minimum price, the commercial manager has to sign off” is a fine rule, but only if the system enforces it. Otherwise it’s just an intention. A few system rules worth recording:

• a floor price per item or item group below which you can’t quote;
• a margin percentage that automatically triggers approval;
• mandate per role: who can give how much discount, up to what amount;
• a mandatory reason logged for every deviation.

The point isn’t to restrict sales. It’s that an account manager can negotiate without hesitation, because they know exactly where their room is, and the exception ends up with the right person.

Make bulk changes routine

The annual price round is the real test. If “5% indexation on all agreements in category X, except these twelve customers” is a three-week project with export files and manual checks, your management isn’t working. It should be an hour’s work, with a preview of what’s about to change before you commit it.

Make sure you can look back

Who changed this price, when, from what value to what value, and who approved it? That’s not just useful in disputes with customers or during an audit, it’s also the only way to learn where your margin is leaking.

Measure a few things

You don’t need a dashboard full of KPIs. Three numbers tell you most of what you need to know:

• What share of your revenue runs under an agreement instead of at list price?
• How big is the average deviation from list price, per customer group and per item group?
• How many agreements are older than two years and haven’t been revisited since?

Start here

If you want to tackle this without spending half a year on it, start with an inventory, not software. Pull every active pricing agreement from your ERP and all your spreadsheets into one list. Find out which ones have no end date, which are older than two years, and which have seen their purchase price rise since. That list is almost always longer than expected, and it makes the conversation concrete: this is what it’s costing us right now.

Only after that does it make sense to ask where you’re going to manage it.

Why we built something for this

We ran into this problem at wholesalers and manufacturers who wanted to improve their forecasting. Increasingly, the pricing side turned out to be even messier than the demand side: pricing agreements scattered across ERP, spreadsheets, and mailboxes, without validity periods and without control.

That’s why Innico includes a full environment for pricing management: edit customer-specific prices and tiers in bulk through a modern interface, with real-time validation, validity dates, approval rules for deviations, and a connection to your ERP, so there’s still one source of truth. If for whatever reason you still need Excel somewhere in your pricing process, importing and exporting is easy through our Excel integration.

Because we also forecast demand per customer and item, you can combine the two: not just seeing which price you agreed on, but also what that agreement is expected to earn or cost you over the coming year.

Banner image by Mika Baumeister on Unsplash