What's the real formula for client profitability?

Revenue rankings look clean until you run a profitability analysis on the same client list. Top billing doesn’t make a top client, especially one who expands scope, pays in 60 days, and needs senior staff for junior work.

Client profitability analysis for accounting firms is how you build that second list: calculating the true margin each client generates by combining billed revenue, realization rate, and payment speed, rather than stopping at what they pay in total.

A three-input formula makes the comparison consistent and repeatable, so pricing, scope, and off-boarding decisions have numbers behind them instead of gut feel.

A reliable client profitability analysis needs billing, time, and accounts receivable data in one per-client view, not spread across three disconnected systems.

When billing lives in the accounting platform, time sits in a separate tracking tool, and AR ages in yet another report. Nobody sees the complete picture for a single client. Manually reconciling that in a spreadsheet across dozens of clients leads to errors and goes stale between updates.

A connected view changes this. Ignition's Billing Hub centralizes upcoming and past invoices per client, while the Business Insights Dashboard ties that billing data to payment status in real time. Neither replaces your time-tracking system, but together they give you a current, per-client baseline that manual reconciliation can't match at scale.

Your client's realization rate is the billed amount divided by the worked or quoted value, expressed as a percentage. It's the first number to isolate before ranking any client on profitability.

Here's why revenue alone is misleading: A client generating $40,000 a year can still be quietly eroding your margin if discounts, fee write-downs, or unbilled scope additions are pulling that realization rate down. The headline number looks fine; the ratio tells a different story.

Calculate this per client, not across your whole firm. A blended average masks exactly which relationships need attention, which is the entire problem this metric exists to solve.

A client with a healthy nominal margin can still hurt your profitability if they're slow to pay. The carrying cost and admin time of chasing unpaid invoices erode the real profit underneath that headline number.

Think about what an open balance actually costs you: Every day it sits there, you're financing that client's work with your own cash, and every reminder email or follow-up call is unpaid time pulled from your week. It's a hidden tax on what looked like a solid margin.

That's why a 40% margin client who pays in 60 days isn't the same as a 40% margin client who pays in 10. Apply a consistent payment-speed adjustment across your roster so slower-paying clients rank below equally profitable ones who pay fast and clean, rather than sitting side by side on a spreadsheet that only tracks fees.

Once you've built both inputs, you can combine them into a single score that makes every client on your roster directly comparable.

Start with each client's billed revenue for the period, apply the realization rate you've already calculated to get realized value, then subtract delivery cost to reach gross margin. Deduct the time-to-pay drag you've defined for that client, and you've got effective margin: The number that actually tells you what a client is worth to your practice.

Keep this at the individual client level only, never combined into a service-line view. Repeat it on the same schedule each month or quarter so the scores stay comparable and you're not measuring a January snapshot against an October one.

With a profitability score for every client, you can sort your roster by margin quality and payment speed together rather than revenue alone. A client generating high billings who pays slowly lands in a different tier than one billing less who pays fast and clean, and each tier calls for a different response.

That two-axis view produces three groups:

1. Clients with strong margin and fast payment

Clients with a high realization rate and short time-to-pay deserve protection, and the goal is to replicate them wherever you can.

You already have the benchmark you need sitting inside your own roster. That combination is the clearest picture of what a healthy client relationship looks like at your firm. Before writing the pattern off as luck, study what these clients have in common: the service mix, the pricing structure, how the engagement was scoped at signing.

Use those traits as a checklist when pricing new engagements or reviewing renewals, rather than starting each pricing decision from scratch.

2. Clients with strong margin but slow payment

This tier's nominal margin looks healthy, but slow payment quietly erodes the real profitability, so the fix is a collections process, not a pricing conversation.

Ignition lets you collect payment authorization upfront when a client signs a proposal, so charges process automatically once work is delivered. For existing balances sitting in QuickBooks Online or Xero, you can import those invoices into Ignition for automated collection, without requiring you to renegotiate scope or fees.

3. Clients with thin or negative margin

This tier's problem is low realization, not slow payment, so the fix belongs in pricing or scope rather than collections.

Flag these clients for review at the next renewal. Deciding how to reprice, rescope, or offboard is a separate conversation, and one worth approaching with real benchmarks behind it. This guide to pricing and selling services breaks down the mechanics of setting and selling those new terms.

The scores you've built give you an internal ranking, but they won't tell you whether your realization and time-to-pay norms are healthy for your size and market. That's where external benchmarks come in, though they're better used as directional context than a substitute for the per-client math.

Industry benchmarking generally points to a mid-size revenue bracket where firms balance growth momentum with healthy margins more consistently than much smaller or much larger practices. That's context for scale and pace, not a score to optimize against client by client.

Once you're past that bracket, client mix and realization discipline matter more than headline revenue growth. The per-client scores you've built stay the primary basis for your pricing, scope, and collections decisions, with broader key performance indicator benchmarking serving as supporting context.

A margin-by-client ranking built once a year is already stale by the time you read it. The client who looked profitable in January because a write-off hadn't posted, or the one whose 45-day payment lag quietly erased the realization gain, only shows up when billing, realization, and time-to-pay data updates continuously rather than in an annual exercise.

That's the shift worth making: stop treating this as a spreadsheet task and start treating your client list as a live ranking that flags collections risk, renewal timing, and scope drift as they happen.

Ignition's Business Insights Dashboard supports exactly this kind of continuously updated picture. If that visibility is missing from your current client review process, it's the fastest way to get profitability off the spreadsheet and into something you can actually act on week to week.