Why Customer Margin Disappears in the Rollup

The plant looks profitable. The customer looks fine. The company pack looks fine. Then someone asks which customers earn their keep after freight, returns, and the costs that only exist when you ship to them.

The rollup cannot say. It averaged those costs into a plant, a region, or a convenient “other.” Customer margin was not calculated wrong. It was hidden. That is a grain problem, not a color problem.

Black-and-white two river currents mixing at a confluence

This is not three meanings of the word margin

When gross, contribution, and the board view share one tile, finance fights itself. That fight is covered in margin definitions that don’t survive a meeting.

This post assumes you can say what margin includes. The remaining failure is where the cost attaches: plant total, product line, customer, or invoice. A cost can be honest at one grain and a lie at another.

Freight out can be real and still vanish when you roll to the plant. Returns can sit in a warehouse bucket that never meets the customer. Allocations can make the P&L balance and the account look average.

A KPI still needs a sentence, because measures nobody can explain are not KPIs. Customer profitability has to name the grain, not just what goes in the bag. “Contribution after outbound freight, at customer, before corporate allocation” is a measure. “Margin” on a rolled plant tile is weather.

Ops manages the plant, sales manages the account, and finance manages the rollup. Each one can look profitable while cash leaks at the join.

Why the rollup hides the customer

The close already produces a plant P&L. A bad account inside a good plant starts an argument, while a plant total keeps the peace. And freight, returns, energy, and SG&A attach at different keys. The model can union the tables and still average the customer away.

None of that is malice. But pricing still uses the average.

The costs of a margin that only works when you roll

Unprofitable customers hide inside a good plant. The plant hit conversion and the region hit the pack. The customer who pays late, returns often, and needs expedited freight never shows up as a decision. You cannot manage an account you cannot see.
Freight, returns, and rebates become mystery allocations. If outbound freight hits the plant, every customer in that plant looks the same. If returns hit a warehouse cost center, the account that caused them keeps its margin. The allocation can be defensible for the close and fatal for pricing.
Mix decisions use the wrong unit. Sales protects a “strategic” account using plant-level contribution, and ops protects a line using plant-level absorption. Both can be locally rational while the company still ships work that does not earn its keep after the costs that follow the customer.
Sign-off never reaches the account. The controller will sign a plant P&L but not a customer number that includes a plug. So customer profitability lives in a side workbook, and finance won’t sign off on the dashboard for the one view commercial actually needs.
Copies fork the grain. Someone needs “margin without the allocation” for a customer meeting, so they export, and now there is a fourth grain. The official rollup still looks clean, so the copies feel justified, and the meeting argues about which file is kinder.
Incentives fight the P&L. Sales paid on plant-loaded margin will fill the plant. Ops paid on conversion will keep the volume. Nobody is paid on customer contribution after dock costs, because the rollup hid the scoreboard.
The pack stays green while cash leaks. Working capital sits in returns, cash sits in freight you did not bill through, and expedites sit in a plant variance. Executives see a healthy rollup while the leak sits one grain down.

A rolled number is not more true because it is bigger. It is often less true because it mixed units.

How to name the grain before you roll

Write the attach rule for every cost in the margin sentence. Say what hits the customer key, what hits the shipment, what hits the plant and must never be averaged into an account, and what is corporate and must stay corporate. If you cannot say it, do not publish customer margin.
Split plant margin from customer margin. They are different products. Plant margin is an operations score and customer margin is a commercial score. One tile that pretends to be both will be used as both, and that is how the rollup wins.
Put freight, returns, and rebates on named lines. Do not bury them in a plug called “other cost.” A commercial review that cannot see outbound freight is not a profitability review. It is a revenue review in a margin costume.
Show the allocation, or refuse it. If you allocate plant energy to customers, the rule belongs in the measure description and on the page. If the rule is “evenly,” say evenly. If you cannot defend it in the room, keep that cost at plant grain. A visible allocation is an argument you can have. A hidden one is a lie the rollup tells.
Do not roll until the grain is honest. Totals are allowed. Totals that reintroduce costs the customer view excluded, or drop costs the plant view included, are how trust dies. The executive pack can show plant and the commercial pack can show customer.
Certify customer profitability as its own semantic product. Give it a steward, a grain, an as-of, and a refresh. A side workbook with last quarter’s freight file is not a product. The semantic model is the product, and customer margin either lives there or it is folklore.
Tie pricing exceptions to customer grain. If a discount needs approval, the approval view should show customer contribution after the costs that follow the order, not the plant average. Otherwise every exception will look cheap.
Give sales and ops the same named lines with different owners. Sales owns the account result, ops owns the plant result, and finance owns the sentences. Stop asking one tile to referee a three-way fight.
Retire the “one margin” that only works at the top. If the rolled tile cannot survive a customer filter, it is not a customer measure. Label it plant, region, or company. Names are cheaper than another quarter of mix theater.

What honest customer margin looks like

The commercial review opens a customer view. Freight, returns, and rebates are visible, and allocations are named or absent. The plant review still has a plant P&L, and it does not pretend that P&L is an account list.

When a leader asks “which customers,” the model answers at the grain the cost follows. Finance will sign the sentence because it does not smuggle a close convention into a pricing meeting.

Executive takeaway

If the plant is profitable, the customer looks fine, the company looks fine, and cash still leaks, the rollup is doing exactly what it does when nobody named the grain.

Margin definitions tell you what goes in the bag. Customer profitability needs the attach rule. Freight, returns, and allocations will hide in any total you refuse to unbundle.

Want to find where customer margin disappears in your rollup? Book a session. We’ll map one attach rule (freight, returns, or the allocation) and the grain the commercial meeting should actually use. Or start with a free Model Health check.