On this page
- Finding which customers are the most profitable can help you focus your marketing efforts on the right people.
- Finding which customers are least profitable helps you understand who to upsell or let go of.
- By tracking not only the revenue each customer brings, but how much you are spending on them (time & resources) you can develop a persona for your most profitable clients and work on making the others more profitable too.
Two customers can be paying you the same amount but they can leave you with very different levels of profit.
A simple comparison between revenue and the time it takes to service a customer can give you this information. But how can you calculate this at scale?
At NCO, we look at every problem through people, process, and systems. In this case: who tracks the time, how often you review the numbers, and the tools you can use to track profit by customer.
How Best Buy Maximized Profits by Focusing on the Right Customer
In 2004, The Wall Street Journal reported that Best Buy had studied its customers' purchase histories and sorted them into two groups, known internally as angels and devils.
Angels bought new products at full price, added accessories, and needed little support. Devils bought loss leaders, which are items priced at or below cost to bring shoppers into the store, and very little else. Some applied for rebates, returned the products, then bought them back at open-box discounts. Best Buy estimated that as many as 100 million of its 500 million yearly customer visits came from this group.
Best Buy kept its doors open to everyone and changed the terms. It removed devils from its marketing lists, cut the promotions that drew them in, and enforced a 15% restocking fee on returns. It also redesigned pilot stores around its most profitable customer types, and those stores posted sales gains about double those of its other stores (The Wall Street Journal, November 2004).
Why Standard Reports Can't Show Which Customers Cost the Most
Your profit and loss statement (P&L) shows money in, money out, and what's left over for a period. It reports revenue and gross margin, which is what’s left after direct costs like materials and production labor.
It doesn't report cost to serve, the time your team spends supporting a customer outside the core work, such as calls, revisions, returns, and chasing payments. That time sits in overhead, the fixed costs of running your business. These are the costs your standard reports spread evenly across every customer.
Suppose three customers each pay $40,000 a year at a 35% gross margin, producing $14,000 of gross profit each. Your team's loaded hourly cost is $65, meaning wages plus payroll taxes, benefits, and a share of overhead, divided by the hours your team spends on customer work.
| Easy customer | Average customer | Difficult customer | |
|---|---|---|---|
| Revenue | $40,000 | $40,000 | $40,000 |
| Gross profit at 35% | $14,000 | $14,000 | $14,000 |
| Hours of service per year | 20 | 60 | 140 |
| Cost to serve at $65 an hour | $1,300 | $3,900 | $9,100 |
| Profit after cost to serve | $12,700 | $10,100 | $4,900 |
The easy customer is worth about two and a half times the difficult one, and none of your standard reports would show it. At about 215 hours a year, the difficult customer reaches break-even, the point where the profit it brings equals the cost of serving it.
How to Rank Your Customers by Profit
Most of what you need is already in your books and your team's heads. Here is how people, process, and systems bring it into one view.
| Part | What it looks like |
|---|---|
| People | Your accountant pulls revenue and gross profit by customer. Your team estimates the hours each customer takes. |
| Process | Pull the last 12 months. Multiply each customer's hours by your hourly cost, subtract that from gross profit, and rank the results. Repeat this: - Once a year if your revenue is 1M (you can do this quickly and cost effectively at this stage) - Once a quarter if your revenue is 5M (you should meet with your accountant at this stage) - Once a month if your revenue is $5M+ (this could be part of your monthly reporting package, as it is for some of our T5 clients) |
| Systems | QuickBooks has features to track your Profit & Loss by location, customer, and product. Doing this every month might |
If you don't track time today, a rough estimate from your team is good enough to start, since they already know which customers take the most effort. Expect surprises in both directions: a small customer who rarely calls is often producing excellent profit, while a large, well-known account runs close to break-even.
How to Make a Costly Customer Profitable
Best Buy changed the terms for its costly customers, and the same approach works in a smaller business. Work through these steps in order.
Step 1: Reprice
If a customer takes three times the average service time, their price should reflect that. Raise it at renewal and show the hours behind the change.
Step 2: Define the scope
Move the customer onto a plan with defined inclusions and a set rate for extra work. A written scope tells both sides exactly where extra work begins.
Step 3: Adjust the promotions that attract costly customers
This was Best Buy's main move. If a discount brings in the customers who later cost you the most, change or retire that discount.
Example in a Service Business: A General Contractor
Before: A Riverside general contractor with $4.2 million in revenue earned a 25% gross margin after materials, subcontractors, and crew labor.
Its largest repeat customer, a property manager paying $300,000 a year, also took about 900 hours of office time for estimates on jobs it never awarded, verbal change orders, and invoices paid in 75 days.
At a loaded cost of $75 an hour, that customer's $75,000 of gross profit shrank to about $7,500.
The fix: The contractor required a signed, priced change order before any extra work and billed at project milestones on 30-day terms (process). All requests moved into its project management software, replacing calls and texts to the site supervisor (systems). One project coordinator became the customer's single contact, and the owner now reviews profit by customer each quarter (people). At renewal, the contractor raised its rates by 8%.
The result: The customer renewed at about $324,000 a year. Office time fell to about 500 hours, payments now arrive in about 35 days, and profit after cost to serve rose to about $43,500.
Quick Checklist
Answer yes or no to each question.
Systems: Can your accounting software show revenue and gross profit for each customer?
People: Does your team track or estimate the hours each customer takes?
Process: Do you know your team's loaded hourly cost?
Process: Does every customer have a written scope with a set rate for extra work?
Process: Have you checked whether your promotions bring in customers who stay profitable?
If you answered no to two or more questions, now is a good time to get started before your next promotion or round of renewals.
Know What Each Customer Is Worth
If one customer takes far more of your team's time than the rest – talk to our team.
If you’re just starting up we can give you an easy method to get a rough idea of your most profitable customers.
If you have a higher volume of customers or products we can help you standardize this process too.



