An agency with 15 clients is almost always sure it knows who the key one is. Usually it's "the biggest by invoice." But an invoice is revenue, not profit. To see who actually brings in money and who works at a loss, you need a per-client P&L — a profit and loss statement broken down by each client.
It sounds complicated, but it really comes down to three steps. Let's walk through how to build it.
What a per-client P&L is
A per-client P&L (profit and loss) is a simple table: how much the client paid you, how much you spent on them, how much is left. That difference is their profitability. Do this for every client and the "overall plus" picture falls apart: some clients feed the agency, others quietly drag it down. For where to start with accounting in an agency overall, see Accounting for a marketing agency: where to start.
Step 1. Gather revenue for each client
Tie every payment to a client: retainers, one-off projects, add-ons. Just don't mix in ad budgets if they pass through you — that's pass-through money, not your revenue. The result: how much each client actually brings in per month.
Step 2. Assign direct costs
Direct costs are what's spent specifically on this client: team hours (in money), contractors, services for their project. Hours are the hardest and the most important part: without them, the P&L lies. Even a rough estimate of how many hours the team spends on a client paints a more realistic picture than an "overall plus."
Step 3. Allocate shared costs
Rent, admin, management salaries — shared costs that also need to be spread across clients, otherwise profit looks overstated. Allocate them proportionally, by revenue or by team hours. That's how you get net profit per client.
What to do with the result
Once the P&L is built, the Pareto principle almost always kicks in: 20% of clients deliver 80% of the profit — as in Client profitability: the 20% that deliver 80%. For the rest, it's a decision: raise the price, revisit the scope, or part ways. For an example of a systematic per-client view, see the case study Management accounting for an agency: a per-client view.
You can build this P&L by hand in Excel, but with 10+ clients it turns into a monthly grind. In Finmap, tagging operations to clients automatically rolls up into each one's profitability — 7 days free.
FAQ
A regular P&L shows the profit of the whole company. A per-client P&L breaks it down for each client separately — you can see who's profitable and who's running at a loss.
Start with an estimate: roughly how many hours a month the team spends on each client. Even a rough estimate gives a more realistic picture than none at all. You can refine it later.
Keep them separate, as pass-through. They're not your revenue and not your cost, so they aren't included in the agency's P&L — otherwise the numbers get distorted.
