Family · 5 min read

Pricing and margin: the staircase between the tariff and what you keep

Published by Variance Works - Updated 22 August 2026

A price list says one number. The bank receives another. Between the two sits a staircase of discounts, rebates, returns, freight and commissions - each step owned by someone different, and most of them invisible in a revenue report.

The staircase under a price

Ask four people in a company what a product sells for and you will get four answers, all of them honest. The catalogue says 100. Sales invoiced 92 after the negotiated discount. Finance paid a 6 rebate at year end and took back 2 in returns. Logistics spent 3 shipping it, and the marketplace kept a commission.

Nobody lied. They were standing on different steps. The trouble starts when a margin discussion mixes the steps up, because the person who can act is different at each one: a list price is a marketing decision, an invoice discount is a sales one, a rebate is a contract, freight is an operation.

These four analyses walk down that staircase one step at a time, and they keep the steps apart on purpose.

Four analyses, four owners

Price realization measures the first step: what was invoiced at list price against what was actually invoiced, and how that gap moved. It answers whether your discipline on the invoice held.

Pocket margin walks the whole staircase: on-invoice discount, off-invoice rebates, returns, cost of goods, freight, commissions and the named costs of serving a customer. It answers what is actually left.

Promotion ROI steps outside the staircase to ask a different question: what a campaign added, measured against a reference you choose. It is the only one of the four that compares against something that did not happen.

Assortment health zooms out from the price to the portfolio: which products carry the sales, which ones only carry the list, what arrived and what stopped.

How this differs from a margin bridge

A margin bridge explains why margin moved between two periods: price, cost, volume, mix, arrivals, stops. This family explains what a price becomes on its way to the bank, inside a single period as much as across two.

That is not the same question, and the two are worth reading in that order. The bridge tells you the margin fell by 216 and that cost carried part of it. Pocket margin tells you which of the seven steps under the price moved, and by how much. One narrows the search; the other ends it.

What your export needs

All four read one ordinary sales export - period, product, quantity, net revenue - plus whatever each step needs:

• A gross revenue column unlocks price realization, and the discount effect in the bridge.
• One column per deduction - rebates, returns, freight, commissions, cost to serve - unlocks pocket margin.
• A campaign column and a group column unlock promotion ROI.
• Three periods or more unlock assortment health.
• A unit cost is what turns revenue into margin, everywhere.

In a monthly review the file is dropped once and mapped once. Every analysis then reads the same copy, in your browser, without asking for it again.

What none of them will do

None of them proposes a price. Setting a price needs a view of demand, of competitors and of what a customer would have paid. A sales file holds none of the three. These four describe what already happened.

None of them calls a gap recoverable. The distance between list price and net price is an accounting fact that has already occurred. Calling it money left on the table assumes you could have sold at list, which nothing in the file can establish.

None of them proves a cause. Promotion ROI compares against a reference you select, and says so on every screen and in every export.

None of them sees your stock. Assortment health describes sales and margin patterns. Stock, availability, shelf space and supplier lead times are not in a sales export, so no conclusion that needs them is offered.

Questions

Which one should I run first?

Price realization, if you have a gross revenue column. It is the cheapest to map and it usually settles the argument about whether the problem is on the invoice or after it.

Can I run all four on one file?

Yes, if the file carries the columns each one needs. In a monthly review they share one mapping, and each result can be added to a single review pack.

Does my file leave the browser?

No. The whole calculation runs in the page, on your machine. There is no upload, no account, and no server that could hold your figures. How to verify that in two minutes.