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.
Customer margin after cost to serve, example
Largest account: 22.0% gross margin falls to 9.7% after cost to serve
-
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 -
Account B
Revenue £949K
Gross margin % 26.0%Net margin % 20.0%Points lost −6.0 points
Net margin £189.6K
-
Account C
Revenue £730K
Gross margin % 24.9%Net margin % 18.9%Points lost −6.0 points
Net margin £138.0K
-
Account D
Revenue £584K
Gross margin % 23.1%Net margin % 17.9%Points lost −5.2 points
Net margin £104.6K
-
Account E
Revenue £511K
Gross margin % 28.4%Net margin % 22.0%Points lost −6.4 points
Net margin £112.2K
-
Account F
Revenue £365K
Gross margin % 29.9%Net margin % 23.0%Points lost −6.9 points
Net margin £84.0K
-
Account G
Revenue £219K
Gross margin % 32.0%Net margin % 23.2%Points lost −8.8 points
Net margin £50.8K
Show the numbers
| Account | Revenue | Gross margin | Rebates | Delivery | Debtor days | Credit cost | Net margin | Gross % | Net % |
|---|---|---|---|---|---|---|---|---|---|
| A | £1,825K | £401K | £110K | £84K | 75 | £30.0K | £177.0K | 22.0% | 9.7% |
| B | £949K | £247K | £19K | £28K | 50 | £10.4K | £189.6K | 26.0% | 20.0% |
| C | £730K | £182K | £22K | £18K | 25 | £4.0K | £138.0K | 24.9% | 18.9% |
| D | £584K | £135K | £0K | £24K | 50 | £6.4K | £104.6K | 23.1% | 17.9% |
| E | £511K | £145K | £5K | £25K | 25 | £2.8K | £112.2K | 28.4% | 22.0% |
| F | £365K | £109K | £0K | £23K | 25 | £2.0K | £84.0K | 29.9% | 23.0% |
| G | £219K | £70K | £0K | £18K | 25 | £1.2K | £50.8K | 32.0% | 23.2% |
Wholesale reporting: the numbers that run a B2B business
| KPI | Formula | A good reading | The 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 rhythm | Days 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 wallet | Your 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 account | The 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-full | Order 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 accrual | Qualifying 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
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.