Management reporting for agencies and consultants: billable ratio, hourly rate and client margin (2026)

Management reporting for agencies and consultants: billable ratio, hourly rate and client margin

Specialists on hourly rates earn per hour and lose per retainer. The reporting that fits — from effective rate to account comparison and automation.

What makes management reporting for agencies and consultants different?

Management reporting for an agency or consultancy differs fundamentally from other business models on three points: the earnings model is hours times rate spread across multiple clients at once, the margin dilutes invisibly through retainers and scope creep, and the balance sheet is light — there is no inventory and no work in progress of any substance.

‍

The first point sets the steering level. A specialist in this model does not work full-time for one client, but spreads the week across three, five or ten clients — partly on hourly billing, partly within a fixed monthly retainer. The interesting question is therefore not just “how many hours were billable”, but above all: at which client did they land, and what did they earn per hour there? That is where this model differs fundamentally from staffing and secondment, where one specialist sits full-time with one client for a long period and the margin per placement is fixed.

‍

The second point is the silent margin evaporation. On hourly billing, every extra hour is revenue; within a retainer, every extra hour is margin loss. A team that helpfully does “a little extra” for a client quietly lowers the realized rate — and because the retainer invoice simply gets paid, nobody sees it in the revenue. Only the time registration exposes it.

‍

The third point makes the reporting simpler than project work at fixed prices: there is no work in progress to value. Hours on time-and-materials are invoiced monthly, retainers in advance — revenue follows directly from the time administration. Attention can therefore go entirely to rate, mix and margin per client.

‍

The foundation remains the standard structure of a good management report: summary, P&L, balance sheet, cash flow, variance analysis, KPIs and commentary. The rest of this article fills in that structure for the hourly-rate model: the KPI set, the effective rate, the client margin, group reporting and automation.

Which KPIs belong in the management report of an agency or consultancy?

The management report of an agency or consultancy runs on five to eight KPIs, with billable ratio and the effective hourly rate at the core. This is the set that makes the difference in practice:

• Billable ratio. The share of available hours that lands with clients — per specialist, per team and for the organization as a whole, including the hours without client work.
• Effective realized hourly rate. The actual revenue per client hour spent — across hourly billing and retainers. The KPI that makes scope creep and rate pressure visible.
• Margin per client. Revenue per client minus the employment costs of the hours spent. Shows which accounts carry the firm and which only consume time.
• Retainer versus hourly revenue. The mix between recurring and incidental revenue. More retainer means predictability — provided the effective rate holds up.
• Revenue per FTE. The productivity measure of the whole firm, including the non-billable functions.
• Client concentration. The share of the largest clients in revenue. One cancellation can hit a quarter of an agency’s revenue — you want to see that before the contract ends.
• Pipeline and cancellations. New enquiries, live proposals and announced cancellations — the forward view of a model without an order book.
• DSO. How quickly clients pay — retainer invoices can sit unpaid too, and salaries keep running in the meantime.

Present every KPI as the main article prescribes: level, a trend of at least twelve months and the comparison against budget. The account comparison itself — all clients with revenue, hours and margin — belongs with the report as a fixed appendix, with the outliers summarized on the first page.

How do you monitor the effective hourly rate on retainers?

You calculate the effective hourly rate per client by dividing the period’s revenue by all hours spent — regardless of what the invoice says. On hourly billing that is by definition the agreed rate; on retainers it is where the margin quietly leaks away.

‍

A worked example. A client pays a retainer of EUR 5,000 per month, based on a budgeted 50 hours — an intended rate of EUR 100 per hour. In practice the team spends 65 hours on this client: the effective rate has dropped to EUR 5,000 / 65 ≈ EUR 77. Nothing shows on the revenue line — the invoice is simply EUR 5,000 — but per hour the firm earns almost a quarter less than intended. Multiply that across ten retainer clients and it explains why a busy firm can still have a lean year.

‍

Three setup rules keep this monitoring reliable. First: have all client hours written, including within retainers and including the senior people who “just help out” — without complete hours the effective rate cannot be calculated. Second: report the intended versus the realized rate per client, with an agreed threshold below which action follows: reduce the scope, reprice the retainer or part ways. Third: look at the trend across several months — one busy month is normal, three consecutive months below the intended rate is a renegotiation.

‍

The commentary completes it: which retainers diluted, what was the cause (scope creep, an underestimated budget, too much seniority on the account) and what the action is. That makes the rate conversation a fixed part of the month instead of an annual surprise.

How do you monitor the margin per client?

The margin per client is that client’s revenue minus the employment costs of the hours spent — calculated at the actual cost per hour of the people who did the work, including employer charges. At agencies and consultancies those cost rates differ strongly: an hour of a senior strategist costs a multiple of a junior’s hour, and the account mix drives the margin.

‍

One pitfall deserves special attention at agencies: pass-through costs. Media buying, advertising budgets, print or software purchased for the client’s account are not real revenue — the money only flows through. Whoever lets those amounts run through revenue inflates the top line and artificially depresses the margin; the firm then looks large and margin-poor, while in reality it is compact and healthy. Keep pass-through costs out of net revenue, or show them as a separate line with their own (minimal) margin — and calculate all margin KPIs on the net revenue from own services.

‍

Keep overhead out of the margin per client here too: office, sales and internal functions belong at organization level, in a separate line of the P&L. Allocated at client level they pollute every comparison — and that comparison is exactly the steering instrument: the same service, the same team level, and yet structurally different margins? Then the difference sits in price, scope or hours, and that is worth a conversation.

‍

In the management report this works as a layered table: margin per client in the appendix, per team or service in the KPI block, and the accounts below the margin threshold named in the commentary, with an action attached.

How do you structure the management report for an agency or consultancy?

The management report for an agency or consultancy follows the seven fixed sections from the main article on the good management report — each with its own interpretation:

1. Summary. One page with the billable-ratio and rate trend as a chart, the largest account movements and the three messages of the month.
2. Profit and loss statement. Net revenue from own services (pass-through costs separate), employment costs as the dominant cost line, and overhead. Show month and year-to-date next to budget and last year; one-offs separately.
3. Balance sheet. Light: receivables with an ageing analysis, retainers invoiced in advance as a separate item, and the cash position. No inventory, no work in progress.
4. Cash flow. Retainers invoiced up front help the cash position; time-and-materials hours follow a month later. Set the fixed salary obligations against the receipts rhythm.
5. Variance analysis. Split the revenue deviation into hours (billable ratio) and price (effective rate), and per client: which accounts carried the deviation? Compare against budget and last year.
6. KPIs. The set from this article as trends: billable ratio, effective rate, client margin, retainer mix, revenue per FTE, concentration, pipeline, DSO.
7. Commentary. The story: which retainers diluted, which accounts grew or left, how the pipeline is filling.

As a fixed appendix, the account comparison runs along: all clients with revenue, hours spent, effective rate and margin, sorted by size. A short weekly rhythm fits alongside: written hours and billable ratio per team, so a slipping week does not only show up in the monthly figures.

‍

For delivery, the norm from the main article applies: within 5-10 working days after month-end, with a month-end close in which the time registration is complete and approved before revenue is determined — in this model, the time administration is the revenue administration.

Multiple entities or labels: how do you report at group level?

Agencies and consultancies often grow in structure too: a label per discipline (strategy, creative, media, finance), sometimes a separate payroll entity, and a holding on top. For reporting, that means two levels at once: the consolidated group picture for management and investors, and the figures per label for steering.

‍

Clients care little about that structure: specialists from several labels work on one account, and the hours are recharged internally. Those internal recharges are revenue in one entity and costs in another — at group level they must cancel out, otherwise group revenue double-counts internal hours and no client margin is right anymore at consolidated level. Management fees from the holding and the recharge from a payroll entity fall under the same elimination. How elimination and consolidation work structurally is covered in consolidation for SME CFOs and the deep-dive on multi-entity consolidation.

‍

Finstack automates this for groups of 1 to 50 entities: every entity connects through its own accounting package, charts of accounts are mapped to one group chart, and the engine recognizes the intercompany recharges automatically — without setting up separate IC accounts. The result: a consolidated P&L and balance sheet next to the figures per label, with every line clickable through to the source booking.

‍

For the management report this means the KPI set from this article runs on both levels: billable ratio, rate and client margin per label and for the group as a whole, without double counting — and without the month-end close having to wait for the merging. Keep client names consistent across the group, so a shared account can still be assembled at group level.

How do you automate reporting from your accounting system?

The figures for the report come from two layers: the time registration (written hours per client and per specialist) and the accounting (revenue, employment costs, receivables, cash). The automation gain sits mainly on the financial side, and it can be made directly.

‍

Dutch agencies and consultancies typically run on Exact Online or — often via the accountant — Twinfield, and internationally on Xero. Finstack connects these packages directly via API, read-only and at transaction level: the actuals refresh automatically every day, with a manual refresh at any moment. With multiple entities, the consolidation from the previous section runs along automatically.

‍

Reporting then happens wherever the team wants to work. The Finstack dashboards show revenue, employment costs, receivables and the consolidated figures in real time, clickable through to the source transaction. Whoever builds the management report in their own Excel or Google Sheets model — for example to place hours and effective rates from the time registration next to the financial figures — uses the 2-way integration: the financial actuals refresh in the existing model in one click. You can also share dashboards and reports with stakeholders such as management, investors and the accountant, by giving them access to Finstack, with access rights set per user.

‍

The effect on the rhythm: the financial side of the management report is ready on day one instead of after days of collecting, and the time shifts to what counts — the rate and account conversation. Finstack starts from EUR 39 per month for the first entity: live in 5 minutes, set up within a day.

The 3 most common mistakes in agency reports

Three patterns we see again and again at agencies and consultancies. Each costs margin or cash; each is preventable with the right setup.

Sources and provenance

• Finstack — Reporting & insights (dashboards, Excel/Sheets sync): finstack.io/solutions/reporting-insights
• Finstack — Integrations with Exact, Twinfield, Xero and other packages: finstack.io/solutions/integrations
• Finstack Help Center — Sources & connections (sync frequency, security): help.finstack.io
• Finstack — Pricing (from EUR 39/month): finstack.io/pricing

Last reviewed: 25 July 2026 · Next review: October 2026