Customer Profitability: Which Clients Really Make You Money
Your biggest client is not always your best client. Once you count the extra hours, the endless revisions, the discounts and the late payments, some accounts that look great on a sales report quietly cost you money. Customer profitability analysis shows you who really pays the bills, so you can look after them, reprice the rest and plan next year with clear eyes.
Key takeaways
- Customer profitability means revenue from a client minus every cost of serving them, not just the direct costs on the invoice.
- The hidden "cost to serve" includes extra time, revisions, support, rush jobs, discounts and slow payment.
- A simple spreadsheet with one row per client is enough to see who makes you money and who does not.
- Unprofitable clients can often be fixed through repricing, rescoping or clearer terms before you consider letting them go.
Most small business owners have a gut feeling about which clients are a joy and which ones are a drain. The trouble is that gut feelings are easy to argue with, especially when the draining client also happens to be the one with the biggest invoices. Putting real numbers next to each name ends the argument. Sometimes it confirms your hunch. Sometimes it surprises you completely.
The weeks before the holidays are a good moment for this review. Projects slow down, you are probably sending renewal quotes or planning January rates, and you can still decide what next year's client list should look like. A quick note: this article is general information about business finance, not financial, legal or accounting advice. If you are rethinking contracts or pricing in a big way, a qualified accountant or adviser can help.
Why revenue is not the same as profit
Sales reports rank clients by revenue, because revenue is easy to see. It sits right there on every invoice. Costs are harder to see, because many of them are spread across your week: a phone call here, an extra round of edits there, a chase email for an overdue payment. None of these show up next to the client's name unless you go looking.
That is how a business ends up working hardest for the clients who pay it least. A client paying a large monthly retainer who also demands constant changes, weekend replies and custom reports can earn you less per hour than a smaller client who signs off on the first draft and pays on time. Customer profitability analysis makes those differences visible.
You might already know your overall margins, or have looked at the economics of a single sale. This review goes one level further, asking a simple question about each relationship: after everything, did this client leave us better off?
What goes into customer profitability
The calculation has three parts. Keep each one simple at first. You can always refine it later.
Revenue from the client
Add up what the client actually paid over the period, usually the last 12 months. Use net figures: subtract discounts, credits, refunds and any work you wrote off. If a client was invoiced for more than they paid, count what you collected.
Direct costs
These are costs you can tie straight to the client's orders or projects: materials, products you resold, subcontractors and freelancers you hired for their work, shipping, travel to their site and any software or licenses bought just for them.
Cost to serve
This is the part most owners skip, and it is usually where the surprises hide. Cost to serve includes:
- Time: hours spent by you and your team on meetings, calls, emails, revisions and account management, valued at an internal hourly cost.
- Rework: extra rounds of changes beyond what you quoted.
- Rush jobs: overtime, express shipping or rearranged schedules to meet tight deadlines.
- Support: help desk tickets, training and "quick questions" that add up.
- Payment friction: time spent chasing invoices, plus the cash flow strain of waiting.
- Small, frequent orders: ten small orders take more handling than one large one of the same total.
Pro tip
If you do not track time by client yet, start now, even roughly. Time tracking apps such as Toggl Track, Harvest and Clockify let you tag hours by client in a few clicks. Check current features, pricing and privacy policies before you choose one. A month of tracked time will tell you more than a year of guessing.
How to calculate profit per client step by step
Here is a practical routine you can finish in an afternoon for a client list of up to 20 or 30 names.
- Choose your period. The last 12 months works well because it covers seasonal ups and downs.
- List your clients. Export invoices from your bookkeeping system and total net revenue per client.
- Add direct costs. Match materials, subcontractor bills and other direct costs to each client.
- Estimate hours. Use time records if you have them. If not, estimate hours per month per client with your team, and be honest about calls, emails and revisions.
- Set an internal hourly cost. Divide your yearly team costs (including a fair salary for yourself) by the hours your team realistically works. This gives you a rough cost per hour to value time.
- Calculate profit per client. Revenue minus direct costs minus (hours times internal hourly cost).
- Calculate margin per client. Profit divided by revenue. This lets you compare a small client with a large one fairly.
- Note the soft factors. Add a column for payment speed, referrals, stress level and strategic value. Numbers come first, but they are not everything.
Example
Imagine Sam, who runs a three-person design studio. These numbers are made up for illustration. Client A paid $48,000 last year, with $6,000 of freelance costs and about 600 hours of studio time. Client B paid $18,000, with $1,000 of direct costs and about 150 hours. Sam's internal cost is $50 an hour. Client A's profit is $48,000 minus $6,000 minus $30,000, or $12,000, a 25% margin. Client B's profit is $18,000 minus $1,000 minus $7,500, or $9,500, a margin of about 53%. Client B earns Sam almost as much profit with a quarter of the hours. That changes how Sam thinks about winning more clients like B.
A customer profitability template you can copy
Paste these columns into a spreadsheet, one row per client. The figures below are made-up examples, using an internal cost of $50 an hour.
| Client | Net revenue (example) | Direct costs (example) | Hours | Time cost at $50/hr | Profit | Margin | Pays on time? |
|---|---|---|---|---|---|---|---|
| Client A (retainer) | $48,000 | $6,000 | 600 | $30,000 | $12,000 | 25% | Usually late |
| Client B (projects) | $18,000 | $1,000 | 150 | $7,500 | $9,500 | 53% | Yes |
| Client C (small orders) | $9,000 | $2,500 | 160 | $8,000 | Minus $1,500 | Minus 17% | Yes |
Sort by margin, then by profit. The clients at the top deserve your best attention. The ones at the bottom deserve a closer look. Add a "revenue per hour" column (net revenue divided by hours) if you want a single number that is easy to compare across very different clients.
Sorting clients into four groups
Once your table is filled in, plot each client on two simple questions: are they large or small in revenue, and are they high or low in margin? You get four groups, each with a different plan.
Large and profitable: protect them
These are the clients that carry your business. Check in regularly, deliver consistently and ask what else they need. Make sure you are not overly dependent on any single one, though, because losing them would hurt.
Small and profitable: grow them
These clients are efficient and easy to serve. Ask whether they could buy more from you, and look for more clients just like them. Their profile is a great guide for your marketing.
Large but unprofitable: fix them
The revenue is real, but so is the strain. These clients usually need repricing, a tighter scope or a better process, not a goodbye. Small changes here can make a big difference to your year.
Small and unprofitable: rethink them
These clients use time you could spend elsewhere. Set a minimum order or project size, move them to a simpler packaged offer, or kindly refer them to someone better suited.
Common mistake
Firing a client based on one bad month. Profitability swings with project timing, a launch or a one-off problem. Look at at least six to twelve months of data, and talk to the client about what is going wrong before you decide anything.
What to do with clients who cost you money
Ending a relationship is the last option, not the first. Try these fixes in roughly this order.
- Reprice at renewal. A new year is a natural point to update rates. Explain the change simply and give notice.
- Tighten the scope. Define what is included, how many revisions you offer and what counts as extra work. Then quote extras separately.
- Change how you work together. Replace daily ad hoc calls with one weekly check-in, or batch small requests into a single monthly order.
- Set clearer payment terms. Ask for deposits, shorter payment windows or automatic card payments for clients who are often late.
- Set a minimum. A minimum order value or project fee stops tiny jobs from eating your margin.
- Move them to a package. A fixed, standard offer is cheaper to deliver than a fully custom service.
- Part ways kindly. If nothing works, give plenty of notice, finish current work well and, if you can, recommend another provider.
A script for the pricing conversation
"We have really enjoyed working with you this year. As we plan for next year, we have reviewed how our time is spent, and the current scope takes considerably more hours than we priced for. From February, we would like to move to [new rate or package], which covers [what is included]. Happy to talk through the options so it works for both of us."
Your customer profitability action plan
- Export the last 12 months of net revenue by client
- Match direct costs to each client
- Estimate or pull tracked hours per client
- Work out your internal hourly cost
- Calculate profit and margin for every client in the template
- Sort clients into the four groups
- Choose one fix for each unprofitable client and plan the conversation
- Start tracking time by client so next year's review is easier
Frequently asked questions
How often should I review customer profitability?
A full review once a year works for most small businesses, ideally before renewal or rate-setting season. A lighter quarterly check on your largest clients helps you catch problems early.
What if I sell to hundreds of customers, not a few clients?
Group them instead of analyzing each one. Look at profitability by customer type, sales channel, order size or region. You will often find that one segment, such as very small online orders, costs far more to serve than another.
Should I keep an unprofitable client who sends referrals?
Possibly. Referrals, a well-known name for your portfolio or a foothold in a new market all have value. Write that value down next to the numbers, then decide on purpose. Even then, try to improve the terms.
How accurate do my time estimates need to be?
Rough is fine to start. You are looking for big gaps between clients, not precision to the minute. If the results surprise you, track time properly for a month or two to confirm before making major changes.
Related reading
The bottom line
Customer profitability analysis puts a real number next to every client: revenue minus direct costs minus the time and effort it takes to serve them. Fill in the template, sort clients into four groups and you will quickly see who to protect, who to grow and who needs new terms.
Use the quieter days before the new year to run your numbers and plan one or two conversations for January. Working with clients who truly pay their way is one of the fastest routes to a calmer, more profitable business.
