Ask a sales leader who their best customer is, and they'll usually name the account with the biggest order volume — the one that shows up at the top of every pipeline report and gets the VIP treatment at renewal time. Ask finance the same question, and if they've actually done the math, you'll sometimes get a different name entirely. Occasionally you'll get a name that surprises everyone, including the account manager who's been quietly discounting that "big win" customer into negative margin for two years.
This disconnect is common, and it's not because anyone's being sloppy. It's because most companies measure customer value by revenue or gross margin, and neither one captures what's actually happening once you account for everything a customer relationship really costs to serve.
Business Central has the data to close this gap. Most companies just aren't pulling it together the right way.
Why Gross Margin Lies to You
Gross margin — revenue minus cost of goods sold — is the number most sales reports lead with, and it's a reasonable starting point. It's also incomplete in a way that consistently favors your highest-maintenance customers.
A customer who orders in huge, predictable batches, pays on time, and rarely calls support looks identical on a gross margin report to a customer who orders in small, constant, rush-shipped batches, negotiates a discount on every order, and keeps your customer service team on the phone weekly. Same margin percentage. Wildly different actual profitability once you account for the cost of serving each one.
That gap is where true customer profitability lives — and it's a number most companies never calculate because it requires pulling together data that usually sits in separate silos: sales, fulfillment, support, and finance.
What True Customer Profitability Actually Accounts For
1. Real Cost of Goods, Not List Cost
Start with the basics done properly. If your item costing in Business Central isn't accurate — average cost, standard cost, or FIFO layers that haven't been reconciled — every downstream profitability number inherits that error. This sounds obvious, but it's the most common reason customer profitability reports get dismissed as "not trustworthy" internally: the underlying item cost data was never clean to begin with.
2. Discounting, Broken Down by Customer
BC's Customer Discount Groups and line-level discounting capture exactly how much margin each customer's negotiated terms are actually costing you — not in aggregate, but order by order. A customer who looks profitable on paper because of strong list pricing can look very different once every discount, rebate, and special term gets attributed back to them specifically.
3. Fulfillment and Service Cost — The Part Most Companies Skip
This is where the real picture usually changes. A customer who orders frequently in small quantities drives more picks, more packing labor, more freight per dollar of revenue, and more customer service touches than a customer who orders in large, infrequent batches — even if their total order value is identical.
Capturing this requires tagging fulfillment and service costs with the right Dimensions at the point of transaction — customer, order type, shipping method — so those costs can be traced back to specific accounts rather than sitting in an undifferentiated overhead bucket. Most companies never do this, which is exactly why their "profitable" customer list and their "high-maintenance" customer list rarely overlap the way anyone expects.
4. Sales and Account Management Cost
A customer serviced primarily through self-service ordering costs meaningfully less to maintain than one requiring dedicated account management, frequent site visits, or custom pricing negotiations every renewal cycle. Where Jobs or Resource tracking is used for account management time, that cost can be attributed directly rather than absorbed as general sales overhead.
Building the Report
The practical path in Business Central runs through consistent Dimension usage across every relevant transaction type: sales, purchasing, fulfillment, and — where tracked — service and account management time. Once Customer is a reliable dimension across all of these, a report can pull true contribution margin by customer: revenue, minus true cost of goods, minus discounting, minus allocated fulfillment cost, minus allocated service cost.
That's a materially different number than the gross margin line most sales reports already show — and it's the number that actually predicts whether growing a given account grows your profit or just grows your workload.
What Changes Once You Can See It
Once true customer profitability is visible, a few conversations change shape. Sales compensation structured purely around revenue or gross margin can end up rewarding reps for growing accounts that are quietly dragging on profitability — a fixable problem, but only once it's visible. Renewal and pricing negotiations get sharper when you know which accounts have real room to absorb a price increase versus which ones are already thin. And account prioritization stops being driven purely by order size, which is often a weak proxy for actual value.
None of this requires guessing. It requires the data BC already captures being tied together consistently enough to tell the whole story — not just the revenue part of it.
Where to Start
Before building a full customer profitability model, it's worth auditing three things: whether your item costing is actually accurate, whether Dimensions are applied consistently enough to trace fulfillment and service costs back to specific customers, and whether sales, operations, and finance are even looking at the same underlying numbers.
Most companies find the gap is narrower than expected — the data exists, it's just never been assembled into the one report that would change how sales and finance talk about the same customers.