Agency margins rarely collapse in one dramatic moment. They leak away in ten-minute client calls that never reach a timesheet, in senior people doing junior work, and in projects that quietly outgrow their quoted scope. The best reports for agency margins make those losses visible while there is still time to act.
A standard profit and loss report will tell you what happened last month. That is useful, but it is too late to protect a fixed-fee project that is already consuming its profit. Agency leaders need reporting that connects time, cost, client work and commercial decisions at the point where managers can intervene.
What makes a margin report worth using?
A margin report is only as trustworthy as the time data behind it. If people reconstruct their days on Friday afternoon, the report becomes a polite estimate rather than a management tool. Billable hours disappear, internal work gets allocated to clients by guesswork, and project costs look healthier than they are.
The right reporting stack answers three commercial questions: which clients make money, which work is consuming capacity, and where is revenue being lost. It should also separate a genuinely low-margin client from a profitable client temporarily affected by a complex piece of work. One number without context can prompt the wrong decision.
1. Client profitability report
This is the report every agency owner should be able to read in under five minutes. It compares client revenue against the fully loaded cost of the time spent serving that client, then shows gross margin in pounds and as a percentage.
The useful version goes beyond a monthly client total. It lets you see profitability by project, service line, team and individual period. A digital agency, for example, may find that a retainer looks profitable overall while ad hoc strategy calls and urgent amends are absorbing far more senior time than the fee supports.
Use this report to review pricing, reset service boundaries and decide where senior attention belongs. Do not use it to punish people for working on difficult accounts. A poor margin may be caused by bad pricing, an unclear brief or a client relationship that demands a different operating model.
2. Billable versus non-billable time report
Utilisation is a capacity signal, not a measure of human worth. It shows how much available time is assigned to billable client work versus internal meetings, business development, training, administration and unallocated activity.
For an agency, this report helps distinguish two very different problems. Low billable time may mean there is not enough work in the pipeline. Or it may mean client work is happening but has not been captured and allocated correctly. Traditional timers cannot solve the second problem because they rely on people remembering to start them.
Look at utilisation by team and role, then compare it with a realistic target. Creative directors, partners and operations leads should not be held to the same billable expectation as delivery staff. The point is to identify avoidable drift, not to drive people into performative time logging.
3. Project budget burn report
A project can be busy, praised by the client and heading directly for a loss. The budget burn report compares hours or cost used with progress delivered and revenue earned. It is the early-warning system for fixed-fee work.
A good report highlights projects where 70 per cent of the budget has been spent but only 45 per cent of the work is complete. It should show which phase is burning fastest, whether the issue sits with a particular discipline, and how much approved budget remains.
Review this weekly for active projects. Monthly reporting is too slow when a build, design or engineering package can consume days of unplanned rework in a single week. When the warning appears, managers can rescope, move work to a more appropriate level of seniority, pause for a client decision or raise a change request. Silence is not a recovery plan.
4. Realised rate report
Your rate card is not your realised rate. The realised rate shows the revenue actually earned per hour after discounts, write-offs, overruns and non-chargeable client work. It exposes the gap between what the agency says its expertise is worth and what it truly recovers.
Calculate it by client, project, service and team. A retained client with a modest headline fee can be excellent business if delivery is controlled. A premium-looking project can be poor business if it requires repeated unpaid revisions and partner involvement.
This is also one of the best reports for agency margins when reviewing new work. If a service consistently earns a realised rate below its cost-to-serve threshold, better sales volume will only scale the problem. Change the scope, price, process or staffing model before selling more of it.
5. Work in progress and unbilled time report
Completed work that has not been invoiced is cash and margin at risk. The work in progress report identifies time recorded against clients or projects that has not yet been billed, along with ageing information that shows how long it has been sitting there.
Not all work in progress is a concern. Some firms invoice at month-end or on defined milestones. The problem is unexplained ageing: a project completed six weeks ago, a disputed task, or time that has no clear billing owner. The longer it waits, the more likely it is to be discounted or written off.
Review unbilled time with delivery and finance together. Finance can see the invoice position; delivery can explain whether the work is chargeable, awaiting approval or simply missing context. This turns a historic clean-up exercise into a live commercial control.
6. Write-off and scope creep report
Write-offs are often reported as a single accounting adjustment. That hides the operational cause. A useful write-off report classifies lost time: out-of-scope requests, estimation errors, rework, delayed client feedback, internal mistakes, goodwill gestures or time that was never recorded clearly enough to invoice.
Scope creep deserves its own view because it is usually a process failure before it becomes a financial one. If account managers repeatedly absorb small client requests to preserve goodwill, the agency may be delivering a larger service than it has sold. The client is happy, but the margin is funding that happiness.
This report should lead to practical changes. Improve statements of work, define revision limits, introduce approval gates or equip client leads with a clear escalation route. It should not become a monthly exercise in blaming account teams for trying to protect relationships.
7. Margin forecast report
Historic margin tells you where profit went. A margin forecast tells you where it is likely to go next. It combines contracted revenue, planned capacity, estimated delivery cost, pipeline confidence and active project burn to project margin for the coming weeks or months.
This report matters when staffing decisions are being made. Hiring too early hurts utilisation; hiring too late forces expensive overtime, contractor spend or rushed delivery. A forecast gives leaders a more defensible view than gut feel and a spreadsheet assembled just before the management meeting.
Treat forecasts as scenarios, not promises. A firm with long retainers can forecast with greater confidence than one dependent on project work. Show a likely case and a cautious case, and update assumptions when a deal slips or a client expands scope.
Make reporting a management habit, not a month-end ritual
These reports work best when they have owners and a rhythm. Project leads should review budget burn weekly. Client leads should examine realised rates, scope changes and profitability at regular account reviews. Leadership should use margin forecasts to make staffing and pricing decisions before the pressure becomes urgent.
The data capture method matters just as much as the report design. When accurate client time depends on manual timers and retrospective timesheets, every report inherits the same weakness: human memory. eppiq Timer approaches the issue differently, using client time intelligence to recognise work patterns and allocate time without turning staff into full-time administrators.
Do not wait for a quarterly profit surprise to inspect the economics of your client work. Build a reporting rhythm around the moments when a manager can still change the outcome: before extra work is absorbed, before an invoice is delayed and before a profitable team becomes busy but unprofitable.