Product and Service Line Profitability Reporting: Do You Know What's Actually Making Money?
A report published earlier this year found that 21.5% of creative and marketing agencies are losing money, up from 13% just twelve months ago. That's a significant jump, and it's not happening because these businesses are running badly. It's happening because their leaders don't have clear enough visibility into where money is actually being made and lost.
I see this constantly with the firms we work with. Revenue looks fine. The team is busy. But underneath the surface, certain service lines are quietly bleeding cash while others carry the whole business. The problem isn't effort. It's the absence of proper product and service line profitability reporting.
This post is about how to fix that.
Why Revenue Is a Misleading Measure of Business Health
Most finance leaders live and die by top-line revenue. It's easy to track, easy to report, and easy to hide problems behind.
A firm can be generating £5m in revenue with a blended profit margin that looks acceptable on a company-wide P&L. But zoom in, and you might find three service lines genuinely profitable, two breaking even, and two others consuming resources at a rate that would be alarming if anyone was looking closely enough.
Those last two are what I call zombie offerings. They're not dead, so no one pulls the plug, but they're not contributing either. They survive on inertia and the assumption that "we need a full-service offering."
Granular service line profitability reporting makes zombies visible. And once you can see them, you can actually do something about them, whether that's restructuring pricing, reducing the cost base, or making the strategic call to cut them entirely.
Why Most Firms Lack Accurate Service Line Profitability Data
The data exists. It's just not connected.
Your ERP has cost data. Your CRM has revenue and pipeline data. Your project management tool has time and resource data. The problem is these systems were never built to talk to each other in a way that gives you a clean, attributed view of profit margin by service line.
So what happens instead? Someone pulls exports, pastes them into a spreadsheet, applies rough allocation rules for overheads, and produces a report that's already outdated by the time it reaches the leadership team. Decisions get made on incomplete information, and the cycle continues.
The fix isn't complicated in concept, but it does require intent. You need a unified data environment where all of these streams come together, costs are attributed according to rules that actually reflect how your business operates, and the output updates automatically rather than depending on someone's Thursday afternoon.
A data warehouse connected to an EPM layer is typically how we build this for clients. You don't necessarily need to replace your ERP or CRM. You layer on top of what you already have. But you do need to be deliberate about the architecture.
The Most Common Mistake in Profitability Reporting: Getting Cost Allocation Wrong
Getting revenue by service line is relatively straightforward. The hard part, and where the real insight lives, is allocating costs correctly.
Direct costs are obvious. If a consultant spends 80% of their time on a specific engagement, that's where their cost goes. But what about the account management time that supports multiple clients? The sales effort that brought in a deal spanning three service lines? The tech stack you maintain across the business?
These indirect costs don't disappear just because they're hard to assign. If you lump them all into a central overhead bucket and don't push them back down to the service lines, your profitability numbers are fiction. They look cleaner, but they're not telling you anything useful.
This is where we spend a lot of time with clients, defining the right cost allocation methodology for their specific business. There's no universal answer, but there are clear principles: allocate based on actual consumption where you can measure it, use reasonable proxies where you can't, and apply the rules consistently so comparisons over time remain valid.
Once the methodology is embedded in the system, it runs automatically. The manual work falls away and you get financial reports you can actually trust.
Moving From Historical Reporting to Predictive Profit Margin Analysis
Most financial reporting is retrospective. It tells you what happened last month. That's useful context, but it's not enough to run a business on.
When you have clean, granular product and service line profitability data, you can start doing something far more valuable: modelling what could happen. What does our margin look like if we grow service line A by 20% while holding headcount flat? What happens to blended profitability if we reprice service line B? If a key client moves off retainer, which parts of the business feel it most?
These aren't hypothetical questions. They're the questions every leadership team is wrestling with right now. The difference between firms that answer them with confidence and those that answer them with guesswork is almost always the quality of their underlying data and reporting infrastructure.
AI-driven scenario modelling, which we're increasingly building into our EPM implementations, makes this faster and more dynamic. But the prerequisite is always the same: clean, connected, correctly attributed data at the service line level.
What Effective Product and Service Line Profitability Reporting Looks Like
Unified data — ERP, CRM, and operational systems connected into a single environment so you're not manually reconciling spreadsheets each month.
Correct cost attribution — Overheads allocated back to service lines using a methodology that reflects how costs are actually incurred, not just what's easiest to report.
Automated reporting — Monthly (at minimum) profitability reporting that runs without manual intervention, so leadership always has current, reliable information.
Scenario planning capability — The ability to model forward, not just report backward. What-if analysis embedded in your planning process, not bolted on as an afterthought.
This is achievable for most firms without replacing existing systems. It requires an honest assessment of where you are now, a clear picture of the gaps, and a sensible path to close them.
Frequently Asked Questions About Service Line Profitability Reporting
What's the difference between service line profitability and a company-wide P&L?
A company-wide P&L shows the overall health of the business. Service line profitability reporting isolates margins for each individual offering. A P&L might show a net margin that looks acceptable, but it won't tell you which services are driving that result and which are dragging it down.
How often should we run service line profitability reports?
Monthly is the standard we recommend. Quarterly reviews are common, but monthly reporting lets you catch inefficiencies before they become structural problems.
What data do we need for accurate product profitability analysis?
You need direct revenue, variable costs, and correctly attributed overheads for each offering. That typically means integrating data from your ERP, CRM, and time-tracking or project management systems.
Do we need to replace our ERP to implement this?
No. You can build robust profitability reporting by layering an EPM solution over your existing systems. A data warehouse connects the disparate systems and feeds clean, integrated data into your reporting layer.
Where to Start
If you're not sure how mature your current profitability reporting actually is, that's worth understanding before you invest in fixing it.
We built a quick diagnostic for exactly this reason. Take our Finance Function Assessment — it takes about five minutes and gives you a clear picture of where the gaps are and where you'd get the most value from improving your setup.
Or if you'd rather talk it through directly, book a call with our team. We work with CFOs and finance leaders across professional services, legal, financial services, and hospitality, and we're happy to share what we're seeing across the sector.
Propriety Group specialises in EPM and CRM implementation for professional services firms. We help finance teams build the visibility they need to make confident decisions, without replacing the systems they've already invested in.