How cloud resellers can improve customer-level margin visibility

Talk to ten reseller CFOs and nine will tell you their margin is in good shape. Pull one customer's P&L and at least two will be surprised by what they see. The disconnect isn't a finance problem — it's a visibility problem.

Aggregate margin averages out the customers that are quietly losing money. A reseller earning 18% across the book might be earning 22% on six accounts and 9% on two. Renewal happens one customer at a time. Aggregate visibility doesn't help you in the renewal room.

1. Customer pricing — what you charge them, including the markup applied per service.
2. Provider cost — what AWS or Azure charges you for the usage tied to that customer.
3. Discount allocation — which Savings Plan, Reserved Instance, or commitment benefit applies to that customer's usage, and how much of it.
4. Credit and adjustment treatment — credits, refunds, billing adjustments, and how they flow to the customer.

Most reseller stacks have all four data points. They just aren't joined on the same key — customer_id.

1. Margin distribution. A scatter plot of revenue (x-axis) against margin % (y-axis), one dot per customer, with a horizontal line at your margin floor. Two minutes a week tells you where attention is needed.

2. Margin change. A per-customer waterfall comparing this month's margin to last month's. Big movers (positive or negative) get a conversation.

3. Discount attribution. What share of your SP and RI benefit each customer captured. If a single account is consuming 60% of your commitment, that's a renegotiation lever.

You don't need to build all four data flows in week one. Start with pricing and cost — those two alone, joined on customer_id, will surface most of the misses. Add discount attribution second. Credits and adjustments third.

And put the result somewhere the renewal team actually looks. A margin number that lives in a finance dashboard helps the CFO. A margin number that lives in the CRM helps the renewal owner. Move it from the first to the second and you've changed the company's behavior, not just its reporting.