Palm AI · All articles · Features · Contact

How to calculate share of wallet in a builders' merchant or any trade business

The formula takes ten seconds. Knowing what each customer could spend in total is the hard part, and it's where most merchants get stuck. Here's how to work it out, down to sub-category level.

By Jonathan Pritchard · 2 November 2026 · 5 min read

A building site interior with stacked bags of plaster on a wooden floor, a ladder in the foreground and insulation hanging between the ceiling joists

Photo by Brett Jordan on Unsplash

Share of wallet is the percentage of a customer's total spend that you win. The formula takes ten seconds. Working out the bottom half of it is where most merchants, wholesalers, hire businesses and foodservice suppliers get stuck.

The formula

Share of wallet (%) = your sales to the customer ÷ the customer's total spend on what you sell × 100

If a plumber spends £2,000 a month with you and £5,000 a month in total on the products you stock, your share of wallet is 40%. The other £3,000 is going to someone else.

It works the same way in every trade business. A builder buying from a builders' merchant, a contractor hiring equipment from a tool hire depot, and a restaurant ordering from a foodservice wholesaler all have a total spend, and you have a slice of it.

The problem: you can only see your own sales

Your system knows exactly what each customer buys from you. It knows nothing about what they buy elsewhere. That's why most businesses default to the numbers they can see (sales, margin, order frequency) and treat a big account as a good account.

A £50,000 customer who could be spending £200,000 is a 25% account with a huge gap. A £10,000 customer who spends everything with you is at 100%, with nowhere left to grow. Sales alone can't tell them apart.

Three ways to estimate the denominator

Ask them. A conversation or a short survey will give you a rough figure. It works for your top twenty accounts and falls apart across five hundred.

Apply a rule of thumb. Many merchants assume a roofer should spend roughly a set amount a year and measure against that. It's quick, but one blunt number ignores the size of the business, the type of work and the region.

Model it. Build a picture of what a customer of that type, size and activity should be spending, category by category, and compare it with what they actually buy from you. This is the approach that scales.

Why sub-category level changes everything

Most share of wallet figures are a single percentage per customer, and a single number hides the story. Take this illustrative example. A plumber shows 40% overall. Look inside and pipe and fittings might be close to 90%, while boilers and cylinders are close to zero. That's one product group going elsewhere, not a loyalty problem across the board.

The same applies in other sectors. An illustrative restaurant account might be well covered on dairy and dry goods but buying fresh produce entirely from another supplier. A contractor might hire from you but buy small tools from someone else.

Once you can see the gap at sub-category level, the conversation changes from "we'd like more of your business" to "you don't buy your boilers from us. Can we talk about that?"

How Palm AI does it

If you integrate your transactional data with Palm AI (we can connect to your current systems via API), we start from what each customer buys from you, down to sub-category. We then compare that with our own dataset of what customers of that type should be spending, which is refreshed daily where the data allows. The result is an estimated share of wallet for every account, with the gap broken down category by category and sub-category by sub-category.

Because the dataset is refreshed monthly, the estimate moves as customers change. It isn't a one-off analysis that's out of date by the time you read it.

Two things to watch for

Natural gaps aren't leakage. A self-builder who orders quarterly isn't buying elsewhere between orders. That's just their pattern. Measure against the customer's normal cadence, not a weekly ideal.

There's no universal "good" number. A sensible target for a plumber isn't the same as one for a landscaper or a restaurant. Compare each account with its own type.

Share of wallet vs market share

Market share is your slice of the whole market. Share of wallet is your slice of each customer. Grow the second first. It's the faster route, because you're selling to people who already know and trust you. Our guide to share of wallet for wholesalers covers why it matters, our basket analysis guide shows how to spot the gaps, and the glossary has the short version.

Where this fits with the data you already have

You don't need a data team to start. You need your transaction history and a sensible estimate of what each type of customer should spend. That's what Palm AI's analytics does for you, account by account. If you'd like to see your own share of wallet by customer and sub-category, get in touch.