Service

Customer Profitability Analysis

Revenue ranking and profit ranking are rarely the same list. The account that buys the most can also call support twice a week, take returns, demand split deliveries, hold a deep discount and pay forty days late. Customer profitability analysis works out what each account actually earns you once all of that is counted against it.

An office reception area
8 things this engagement covers, and a 9-step process.

Who it is for

Who this is for.

  • 8 things this engagement covers, listed below with what each one includes.
  • A 9-step process, the same one on every engagement.
  • 6 questions answered on this page.

Overview

Gross margin by customer is easy to produce and usually misleading. It stops at product cost, which is the part most companies already control. The spread between accounts comes from what happens around the sale: how much service they consume, how often they return goods, how they want to be delivered, what they negotiated, and how long they take to pay.

Finalert builds the calculation account by account: gross revenue, discounts and rebates, direct cost, then the cost to serve. The output is a ranked list from most to least profitable, with the drivers visible behind each name, so a repricing or retention conversation starts from a number rather than from an impression.

This analysis is about the account, not the product line or the segment. We take costs that normally sit in one pool and push them out to the customers who caused them, using drivers your commercial team recognises. Then we rank, and the ranking usually contains at least one surprise near the top and one near the bottom.

Customer profitability analysis begins with revenue as the customer actually pays it. List price is a starting point, not an answer. We strip out volume discounts, negotiated rates, promotional pricing, rebates earned and accrued, credits issued, allowances and any free goods or services that were part of the deal. Rebates in particular distort a ranking badly, because they are often accounted for centrally and never land against the account that earned them. Getting to true net revenue per account is frequently the first place the picture changes.

Then comes cost to serve, which is the part most companies never allocate. Support and account management time, pre-sales effort, order handling, freight and delivery including split and expedited shipments, returns and the processing they trigger, warranty and rework, credit control effort, and the financing cost of the payment terms that account actually takes rather than the ones on the contract. Each of these gets a driver: tickets, deliveries, order lines, return units, hours or days outstanding, depending on what your systems can support honestly.

Allocation that your commercial team will accept

Allocation only works if the people affected believe it. So we use drivers that connect visibly to customer behaviour and we avoid allocating on revenue, since spreading cost in proportion to sales guarantees that the biggest account looks the most expensive whatever it does. Where a cost genuinely cannot be traced to an account, we leave it in an unallocated pool and show it rather than smearing it across the list to make the arithmetic tidy.

We also separate the costs that would disappear if the customer left from the ones that would not. That distinction changes every decision downstream. An account below the line on fully absorbed cost can still be contributing usefully to fixed overhead, and dropping it would leave the overhead behind with less revenue to carry it. The analysis shows both views side by side, along with the assumptions behind each, so the discussion is about the right question.

What the ranking is for

The deliverable is a ranked list with the drivers visible behind each account, usually grouped into tiers. The profitable core is worth protecting and understanding. The middle tier is where most of the movement is available, often through service behaviour or terms rather than price. The tail is where the specific conversations live: reprice, change the service model, move the account to a lower-touch channel, or accept it knowingly as a strategic relationship rather than by accident.

The same data answers a concentration question that boards ask and few companies can answer cleanly: how much of your profit, not your revenue, sits with your largest few accounts. We also track the ranking over time, because an account sliding steadily down the list is more informative than its position in any single period. Limits are worth stating: we build and run the analysis, your commercial and finance leadership own the pricing and retention decisions. We do not sign filings, issue audit or attest opinions, give legal advice or act as your accountant of record.

What you get

What the engagement covers.

8 items

  • Net revenue by account

    Revenue restated after discounts, negotiated rates, promotions, rebates earned and accrued, credits and allowances, so each account is measured on what it really pays. Prior period credits are pushed back to the period they relate to.

  • Cost to serve model

    A driver-based model pushing support, account management, order handling and service cost out to the accounts that consumed them, using measures your commercial team recognises.

  • Freight and delivery allocation

    Shipping cost traced by account including split deliveries, expedited shipments, failed deliveries and any delivery terms conceded during negotiation. Where freight is recovered from the customer, that recovery is netted off and shown separately.

  • Returns and rework costing

    Return volumes, credit values, restocking, disposal and the handling effort each return triggers, charged against the account that generated them. Returns are grouped by reason so avoidable ones can be separated from the rest.

  • Payment terms financing cost

    The cost of the terms an account actually takes rather than the ones it agreed, calculated from days outstanding and applied at an agreed financing rate.

  • Discount and rebate impact

    The full value of concessions per account, separated into standing discounts, negotiated exceptions and earned rebates, so the cost of each type is visible. Standing and one-off concessions are trended over time.

  • Ranked profitability register

    Every account ranked from most to least profitable, tiered, with the drivers behind each position visible and both absorbed and avoidable cost views shown. Tiers are agreed with your commercial team first.

  • Concentration and trend view

    How much profit sits with your largest accounts, and how each account's position has moved over recent periods, so a steady slide is caught early.

How it runs

How the work runs.

We build the model on one period first and test it on accounts your team already has opinions about, because that is the fastest way to find a flawed driver. The sequence runs as follows.

  1. 01

    Define the customer record

    We agree what counts as one account, resolving duplicates, subsidiaries, buying groups and trading names, so a customer is not counted twice or split in three.

  2. 02

    Build net revenue per account

    Gross revenue is restated after every concession, including rebates accrued centrally, so each account carries the discounts it actually received. Free goods, allowances and promotional support are included in the same restatement.

  3. 03

    Inventory the cost pools

    We list the costs of serving customers, from support and account management to freight, returns and credit control, and size each pool before choosing drivers.

  4. 04

    Select and test drivers

    Each pool gets a driver that can be measured per account from your systems. We test each one on sample accounts to confirm it tracks real behaviour.

  5. 05

    Calculate payment terms cost

    Days outstanding per account are measured against the agreed terms and converted to a financing cost at a rate your finance leadership approves. The rate and the method are documented alongside the result.

  6. 06

    Run the first full model

    The model is calculated across all accounts for a complete period, producing net revenue, direct cost, allocated cost to serve and the resulting profit per account.

  7. 07

    Challenge the outliers

    We take the extremes at both ends to your commercial team. Where a result surprises them, we check the driver before we defend the number.

  8. 08

    Publish the ranking and tiers

    The ranked register is issued with tiers, the drivers behind each position, the unallocated pool and both the absorbed and avoidable cost views. Movement since the previous run is shown beside each account.

  9. 09

    Refresh and track movement

    The model reruns each period and we report movement as well as position, so accounts sliding down the ranking are visible before they reach the bottom.

Our approach

How we approach it.

Allocation is where this analysis gains or loses its credibility. These are the rules we work to so the ranking survives contact with the sales team that has to act on it.

An office window overlooking a downtown skyline

Six commitments shape how service runs here.

Never allocate on revenue

Spreading cost in proportion to sales guarantees the largest account looks the most expensive regardless of behaviour. Drivers have to reflect what the customer actually consumes.

Show the unallocated pool

Cost that cannot honestly be traced to an account stays visible in its own line. We do not smear it across customers to make the numbers add up neatly.

Separate avoidable from absorbed

Both views are published. What would actually stop if the customer left is a different number from fully absorbed cost, and it drives a different decision.

Drivers the sales team recognises

Tickets, deliveries, order lines, returns and days outstanding are arguable in a good way. If an account manager cannot recognise the driver, they will reject the result.

Materiality before precision

We spend the effort on the cost pools big enough to change a ranking and estimate the small ones openly, rather than building a model nobody can maintain.

The commercial call stays yours

We produce the ranking and the drivers behind it. Pricing, retention, service model and exit decisions belong to your commercial and finance leadership. We supply the evidence for those conversations.

Proof

What clients say, and what the work has done.

  • 110+ U.S. businesses served
  • 100% client satisfaction
  • 111 services we run

Finalert is an outstanding accounting, financial advisory and analytics company that delivers a wide range of services and solutions with the highest level of professionalism. Their expert team, with whom I have personally worked, possesses exceptional skills that enable customers to meet their financial and accounting needs seamlessly. Their dedication to excellence and customer satisfaction sets them apart, making them a trusted partner in the industry.

Wajdi Al MowafakDirector, Financial Business · Nonprofit
Recent engagement CWS Global Nonprofit & Humanitarian 50% faster month-end close Real-time grant and donor visibility Audit-ready compliance Read the case study

Questions

Common questions.

The questions commercial and finance leaders raise before they let a model rank their customers from most to least profitable and act on that ranking.

How is this different from gross margin by customer?

Gross margin stops at product cost, which is usually the part you already control. This analysis continues into cost to serve: support time, freight, returns, credit control effort and the financing cost of slow payment. Those costs vary far more between accounts than product cost does, which is why the profit ranking often looks very different from the margin ranking.

How do you allocate cost fairly?

By using drivers that reflect what the customer actually consumed, such as tickets, deliveries, order lines, return units and days outstanding. We deliberately avoid allocating on revenue, because that makes the largest account look the most expensive whatever it does. Anything that cannot be traced honestly stays in a visible unallocated pool rather than being spread across the list.

Should we drop the customers at the bottom?

Not on the absorbed cost view alone. An account that looks unprofitable after full allocation may still contribute to fixed overhead that would remain if it left. That is why we publish the avoidable cost view alongside. Most of the useful action is repricing, changing the service model or moving an account to a lower-touch channel rather than exiting it.

What data do you need from us?

Transaction-level sales with discounts and credits, a customer master clean enough to resolve duplicates and group structures, and whatever you record for support contacts, deliveries, returns and payments. Where a cost pool has no usable driver we say so and either estimate it openly or leave it unallocated rather than inventing precision.

How often should the analysis be refreshed?

Quarterly suits most businesses, with an annual deep review before pricing or contract renewal rounds. What matters as much as the level is the movement: an account drifting down the ranking over three periods is a better early warning than its position in any single one. Once the model is built, each refresh is routine.

What is outside the scope of this work?

We do not set your prices, run the customer conversations or decide which relationships to end. We do not sign filings, issue audit or attest opinions, give legal advice or act as your accountant of record. We build and run the analysis, your commercial and finance leadership own the decisions, and every allocation depends on assumptions and on the quality of your source data.

About Customer Profitability Analysis

Ready for numbers you can build on?

Talk to a Finalert consultant about your books, your reporting, or the decision you are trying to make.

110+ U.S. businesses served

What happens next

  1. A twenty-minute call An accountant on the line, not a salesperson.
  2. A scope and a price, in writing What the work covers, and what it costs.
  3. Onboarding on your schedule We start when you are ready, not before.

Monday to Friday, 8:00am to 5:00pm ET Cleveland and New York