Which Project Actually Makes Money: Profitability Analytics for Agencies
Most agency owners ask their finances just one question: "Are we in the black?" A "yes" is reassuring, but it changes nothing. The far more useful questions are different: which project earned the most, which client is dragging the team down, which service line is worth growing. Those answers don't come from a top-line report — they come from profitability analytics, a look at the money across different breakdowns.
The good news: you don't need a CFO or complex dashboards to get it. You need two habits in your bookkeeping and an understanding of what to look at. Let's break down which profitability views actually drive decisions and how to read them.
Why an "overall profit" isn't analytics
Overall profit is a result, not a tool. It tells you what happened, but not why or what to do next. Two agencies with identical profit can be in completely different shape: one stands on three healthy clients, the other survives on a dozen — half of them loss-making — and stays afloat thanks to a single large project.
Analytics begins where you break that overall result into its parts: by project, by client, by service line, by month. Each breakdown answers its own question and leads to its own decision.
Two habits, without which there's no analytics
All profitability analytics rests on two simple things. The first is tagging every transaction to a client and a project. The second is accounting — at least roughly — for team hours in money terms, because in an agency that's the main cost. Without the first, you can't break anything down; without the second, profit across every view will be overstated.
This isn't bureaucracy, it's the foundation. Once these two habits have been running for even a month, all the breakdowns below assemble almost on their own. For how to quickly check the profitability of a single project, see Which project is actually profitable.
Breakdown 1. By project — what to take on and what to turn down
Profitability by project shows you which types of work pay off. It often turns out that big "showcase" projects with endless revisions bring in less than quick, standard orders. That's a direct signal for where to point sales and which projects to decline. For how to calculate project profitability without the usual mistakes, see Project profitability: how to count it right.
Breakdown 2. By client — who feeds you and who "eats" the team
Profitability by client almost always follows the Pareto principle: a small share of clients delivers most of the profit, while some run at a loss. Once you see this, you make concrete decisions: whom to raise prices for, whose scope to cap, whom to part ways with. More on this in P&L by client and Client profitability: the 20% that deliver 80%.
Breakdown 3. By service line — where to grow
If an agency offers several types of services (SMM, paid ads, production, design), it's useful to see each line's profitability separately. One line may be the workhorse, another may exist mostly to round out the offering. This is a strategic view: it tells you where to invest the team and training.
Breakdown 4. Over time — a trend, not a snapshot
One month is a snapshot, but decisions are made on the trend. Look at profitability month by month: is the margin growing, is a particular client slipping from profit into loss, is servicing an account getting more expensive. A trend catches a problem while you can still fix it, not after the fact.
From numbers to decisions
Analytics only matters when action follows. Spotted a loss-making client — negotiate on price or scope. Spotted a profitable type of project — chase more of them in sales. Spotted a line's margin dropping — dig into why. If nothing changes after you review the numbers, it isn't analytics, it's reporting for reporting's sake.
You can pull all these breakdowns together by hand in Excel, but that's hours of stitching tables every month. In Finmap you tag transactions to clients and projects, and profitability by project, client, and service line assembles automatically — try it free for 7 days.
Frequently asked questions
By client — it most often reveals hidden losses and yields the fastest decisions. After that, the breakdowns by project and by service line are the most useful.
No. It's enough to tag transactions to clients and projects and to account for team hours. The breakdowns assemble from that data without separate BI systems.
Once a month is enough to see the trend and react in time. The key is consistency: decisions are made on the trajectory, not on a single month.
With the by-client breakdown for the last month. It almost always surfaces a few loss-making clients right away that no one suspected.
