Which clients are actually making you money and which ones are not

A management consultant we work with had twelve active clients and what looked like a solid year. Revenue came in at $340,000. Net profit, after paying all staff and overhead, was $41,000 on the Profit and Loss report (the P&L).

When we asked which clients were most profitable, he pointed to the two largest accounts: a software company paying $96,000 per year and a logistics firm at $84,000. Together they made up more than half of revenue. Both relationships were three years old. On billing rate alone, the software account appeared to be generating roughly 55 percent gross margin on the projected 640 hours.

We built a per-client P&L. The software company was producing 5.6 percent net margin. The logistics firm was at 4 percent, barely above break-even. Three smaller clients, none billing above $28,000 per year, were each clearing more than 30 percent. The account he had been considering dropping had the highest margin in the book.

He had been protecting the wrong accounts.

Why firm-level profit hides client performance

A firm-level P&L tells you whether the business made money. It does not tell you which clients are worth keeping.

A high-margin client and a low-margin client both appear as revenue. Staff costs and overhead pool together under shared expense lines. The software account required 820 actual hours against a 640-hour estimate, absorbed deliverables outside the contract, and occupied the firm’s senior staff every quarter. None of that is visible in firm totals.

Per-client profitability is a separate calculation: revenue from the client, minus the actual cost to serve them in staff time and direct expenses, minus a proportional share of firm overhead. What remains is the client’s real contribution to profit.

Four reasons client margins diverge from billing rate math

Actual hours versus billed hours. Most service firms price on fixed retainers or project fees. If the client requires more time than the original estimate, the extra hours are worked and not invoiced. Over a year, the gap between hours delivered and hours billed is where margin compresses. The software account was priced on 640 projected hours. Actual hours logged were 820. The extra 180 hours were absorbed without an additional invoice.

Scope absorbed without a change order. Clients learn what they can request without triggering a new invoice, especially in long-standing relationships. Extra deliverables, additional revisions, and requests that fall outside the original brief get absorbed. On the software account, roughly $9,200 in additional work was delivered over the year without a change order.

Overhead allocated by actual account usage. Overhead (rent, software, administrative staff, insurance) must be recovered across all clients. When overhead is divided evenly across all revenue dollars, a demanding client looks more profitable than they are. A client requiring weekly calls, frequent last-minute changes, and detailed reporting consumes more overhead than one who sends clear briefs and reviews work on schedule. Allocating overhead in proportion to actual hours consumed produces a more accurate picture.

Support work that does not appear in billing. Project management, internal revision cycles, vendor coordination, and onboarding new contacts when a client’s team turns over rarely appear in billable hour summaries. They do appear in total hours consumed. A client with frequent staff changes can add 10 to 15 percent to actual service hours in coordination overhead alone.

What the per-client comparison showed

The small manufacturing client produced more total profit than the anchor account, at one-quarter of the revenue.

What happens when client margin is not tracked

Two problems develop when a service firm does not measure per-client profitability.

The first is renewal pricing. The consultant had renewed the software account at the same rate for three years because the relationship felt too large to risk renegotiating. The actual cost to serve the account had grown each year as the scope expanded and the team’s time investment increased. The fee had not moved. Margin had compressed from roughly 18 percent to 5.6 percent over the three-year period, and no one had noticed because total revenue continued to grow.

The second problem is capacity allocation. Every hour spent on the software account at 5.6 percent margin was an hour unavailable to clients producing 30 percent. The firm had declined two prospective clients that year because the team was fully booked. Both would have billed at rates above the current blended average. The visible constraint was headcount. The real constraint was where margin was being consumed.

What per-client margin tracking looks like in practice

For service clients we work with, per-client profitability is part of the monthly close rather than an annual exercise.

Every billable staff member logs time by client each week. At month-end, actual hours are compiled and multiplied by the blended staff cost rate. Direct expenses, contractor invoices, and software licenses tied to a specific client are assigned to that client in the books. Overhead is allocated based on each client’s share of total billable hours for the month.

The result is a one-page margin summary ranked from highest to lowest. Any client whose margin has declined by more than five points from the prior quarter is flagged before the next renewal conversation. Renewals that come up on a low-margin account get a pricing review before the contract is offered, not after it is signed.

Best practices for service firm owners

Four practices that keep per-client margin current:

• Set up a class or project in QuickBooks for each active client. Post all direct costs (staff time as a monthly journal entry, contractor invoices, direct expenses) to the client class so revenue and cost tie out in one report.
• Log time weekly, not monthly. End-of-month time estimates are less accurate and harder to reconcile against billing records.
• Allocate overhead quarterly based on actual billable hours by client. As client mix shifts, the fair overhead share per account changes.
• Review the billing rate against actual margin before each renewal, not after. If the current rate does not produce at least 15 percent net after overhead, the renewal needs a pricing conversation.

Three questions worth asking

If per-client profitability has not been measured recently, three questions to bring to whoever manages the books:

1. Can we pull a per-client margin report for the last twelve months, with actual staff hours costed at blended rate and overhead allocated by client?
2. Which clients have renewals in the next ninety days, and what has the margin trend been on each one over the past year?
3. Are we tracking actual hours delivered versus hours billed by client, and can we see that gap in the books?

If those answers require building something from scratch, the existing books are capturing firm totals but not client-level performance. The setup is a one-time project. Once class tracking is in place in QuickBooks, the monthly report runs from the same data that is already being entered.

If you want to know where your margin is actually coming from, send us your current client list and last year’s P&L. We will show you how to add per-client tracking to your existing books.