Wholesale and B2B analytics

B2B analytics for wholesalers and distributors shows which accounts should stay on their current terms, which lapsing customers a rep should call this week, and where discounts have drifted below list. Margin is read per customer after rebates, delivery and credit, on one model that reps and finance both use.

Last reviewed

Customer margin after cost to serve, example

Largest account: 22.0% gross margin falls to 9.7% after cost to serve

Example data
  1. Account A

    Revenue £1,825K

    Gross 22.0%Gross margin % 22.0%Net 9.7%Net margin % 9.7%

    Points lost −12.3 points

    Net margin £177.0K

    12.3 points lost to rebates, delivery and 75 days' credit
  2. Account B

    Revenue £949K

    Gross margin % 26.0%Net margin % 20.0%

    Points lost −6.0 points

    Net margin £189.6K

  3. Account C

    Revenue £730K

    Gross margin % 24.9%Net margin % 18.9%

    Points lost −6.0 points

    Net margin £138.0K

  4. Account D

    Revenue £584K

    Gross margin % 23.1%Net margin % 17.9%

    Points lost −5.2 points

    Net margin £104.6K

  5. Account E

    Revenue £511K

    Gross margin % 28.4%Net margin % 22.0%

    Points lost −6.4 points

    Net margin £112.2K

  6. Account F

    Revenue £365K

    Gross margin % 29.9%Net margin % 23.0%

    Points lost −6.9 points

    Net margin £84.0K

  7. Account G

    Revenue £219K

    Gross margin % 32.0%Net margin % 23.2%

    Points lost −8.8 points

    Net margin £50.8K

Example data: an invented wholesaler's seven largest accounts over one financial year. Account B makes £189.6K after cost to serve on half of Account A's revenue, more than A's £177.0K. Credit is costed at an assumed 8% annual cost of borrowing.
Show the numbers
The seven accounts in full, £K, example data
AccountRevenueGross marginRebatesDeliveryDebtor daysCredit costNet marginGross %Net %
A£1,825K£401K£110K£84K75£30.0K£177.0K22.0%9.7%
B£949K£247K£19K£28K50£10.4K£189.6K26.0%20.0%
C£730K£182K£22K£18K25£4.0K£138.0K24.9%18.9%
D£584K£135K£0K£24K50£6.4K£104.6K23.1%17.9%
E£511K£145K£5K£25K25£2.8K£112.2K28.4%22.0%
F£365K£109K£0K£23K25£2.0K£84.0K29.9%23.0%
G£219K£70K£0K£18K25£1.2K£50.8K32.0%23.2%
Credit cost: revenue × debtor days ÷ 365 × 8% a year

Wholesale reporting: the numbers that run a B2B business

KPIFormulaA good readingThe common mistake
Net margin by customer(Gross margin − rebates − delivery cost − credit cost) ÷ revenue × 100, per account. Credit cost is revenue × debtor days ÷ 365 × the annual cost of borrowing. Close to gross margin, with each account that falls well below it named and explained Spreading delivery cost by revenue share. An account taking small drops twice a week then looks as cheap to serve as one taking a full pallet a month.
Realised price against list(Net invoice price after on-invoice discounts ÷ the list price in force on the invoice date − 1) × 100, per customer and product Steady for each customer, and every move traceable to a price agreement someone approved Comparing old invoices with today's price list. After a list increase, every earlier invoice looks like a deeper discount than it was.
Order gap against own rhythmDays since the account's last order ÷ its median gap between orders over the last 12 months Below 1 for an active account. Above an agreed multiple, such as 1.5, the account goes on a rep's call list. One fixed rule, such as 90 days without an order, for every account. A weekly buyer has been gone for months before it fires, and a twice-yearly buyer trips it between every order.
Share of walletYour sales to the account ÷ an estimate of its total spend in your categories, with the estimate's source written beside it Rising on the accounts reps have been asked to grow Showing it as a measured figure. The account's total spend comes from a rep's conversation or a proxy such as outlets or staff, so the ratio is an estimate and is labelled as one.
Debtor days by accountThe account's trade debtors ÷ its credit sales in the period × days in the period Within the payment terms agreed with that account Reading only the company-wide figure. A large account paying weeks late can sit inside a total that looks on terms.
On-time in-fullOrder lines delivered on the promised date at the full quantity ÷ order lines due, counted by line Read by depot and by customer, with late lines and short lines counted apart Measuring against the date the warehouse rescheduled to. The test is the date promised to the customer when the order was taken.
Rebate accrualQualifying sales to date × the rebate rate for the tier the account is expected to reach by year end, booked monthly against that account Close to the rebate actually paid when the year closes Accruing at the tier reached so far. If tiers are retrospective, an account that crosses a tier in the last quarter earns the higher rate on every sale since the year began.

The debtor days row uses the same formula as the finance dashboard, read one account at a time.

A large account can carry the best gross margin in pounds on the ledger and still earn less than an account half its size.

Where wholesale data usually lives

The ERPOrders, invoices, credit notes and price lists. Each account exists as a bill-to, each ship-to and sometimes a buying group, so we agree which level counts as the customer first.
The order portal or EDI feedOrders placed online or by EDI. If they arrive under a different account code, the account's rhythm splits across two codes and looks slower than it is.
The CRMRep ownership, visits and share-of-wallet estimates. When an account changes rep, its history moves with it.
Rebate agreementsTiers, rates and qualifying products. If they live in spreadsheets outside the ERP, they are loaded and dated before any accrual is built.
Delivery and route costsCarrier invoices or own-fleet costs per route or load. They are allocated to each drop by weight, pallets or drops, under a written rule.
The finance ledgerDebtors by account and the cost of borrowing. Its account codes must match the ERP's to read debtor days per customer.

Analytics services for wholesalers and distributors

If you sell through your own shops as well, retail analytics covers like-for-like sales and weeks of cover.

Call lists and customer margins depend on the ERP's invoice lines and the order portal's orders arriving each day, and data monitoring and support checks that they did.

In the example, Account A's rebates come to 6.0% of its revenue, three times Account B's 2.0%. Its delivery cost is 4.6% of revenue, against B's 3.0%.

AI in B2B analytics for wholesalers

AI-led analytics answers "which accounts should my reps call this week?" once your model holds each account's order gap against its own rhythm and its net margin after rebates, delivery and credit. Every answer shows its query.

Questions from wholesalers and distributors

Do you build sales rep dashboards for wholesalers?

Yes. Each rep sees their accounts ranked by net margin, the ones running late against their usual order gap, and realised price against list, all from the model finance reads, so the margins agree.

Can you forecast demand for a distributor?

Yes, by product and depot, from ERP order lines. Large accounts with a fixed rhythm get their own forecast, the rest of the book is forecast in aggregate, and known events such as a contract ending go in as stated adjustments.

Do you do customer analytics for B2B businesses?

Yes. We first agree the hierarchy of account, delivery points and any buying group above them. Then accounts are segmented on net margin and order rhythm, with share of wallet where a rep has an estimate.

How do you put a cost on credit terms?

Multiply the average debtor balance, revenue × debtor days ÷ 365, by your annual cost of borrowing. In the example above, the largest account pays in 75 days on £1,825K of revenue, so its debtors average £375K, and at 8% that costs £30.0K a year.

Where should rebates sit in customer margin?

Against the account that earns them, accrued monthly at the tier it's expected to reach. Booked only when paid at year end, rebates flatter a customer's margin for eleven months.

Which of your accounts cost most to serve?

On the call we look at a year of your invoice lines and rebate agreements and say what allocating delivery and credit cost to each account would take.

Book a call

Free 30 min call