Agency finance dashboard: what to track

Realization rate is the share of tracked time that actually reaches an invoice, and it is the number most agency dashboards are missing. Revenue is a lagging indicator that tells you a year is going fine while cash timing and margin mix are quietly eating it. The dashboard an agency needs is not a prettier revenue chart. It is the handful of numbers that show whether the work being done is the work being paid for.

Key Takeaways

Revenue tells you what you billed. It does not tell you when the money arrives, which work is profitable, or how much you did and never charged for.

The five numbers: cash position, realization rate, margin by client, concentration risk, and close rate.

Concentration is the quiet one. A healthy-looking agency can depend on a single account for most of its revenue without anyone noticing until that client leaves.

None of these need a forecasting tool. They need delivery and billing data in the same place, which is the only structural requirement.

Why revenue is the wrong single number

Most agency owners check revenue, and revenue is genuinely a lagging indicator. It confirms money that has already been earned and already been invoiced. By the time it moves, whatever caused the change has been running for weeks.

The reason it is the wrong single number is that three different failures produce the same revenue line. A healthy quarter can be hiding unpaid invoices that will not land until next month, work that consumed far more hours than the retainer covered, and a pipeline that is full of leads that will never close. Revenue looks identical in all three cases. The dashboard's job is to separate them before they turn into a cash problem.

This is the same argument that applies to delivery data. An agency's hours and its invoices live in different systems by default, so the two never meet and neither gets checked against the other. The fix is structural: put them in the same place, and the numbers below become a by-product rather than a project. That is the argument in the agency ops stack, applied to money.

The five numbers

1. Cash position, not revenue. What is actually in the account, and what is owed and by when. Most agencies can tell you their annual revenue to the pound and cannot say what will be in the bank on the next payroll run. The measure that matters is the gap between invoiced and collected, broken down by age, because a sixty day old invoice and a five day old invoice are completely different problems.

2. Realization rate. The percentage of tracked time that got invoiced. This is the most actionable number on the list and the one almost nobody calculates. A 2026 review of 168 engagements across 42 agencies, published by Landing Platform in July, found a median 9% of paid delivery time was delivered and never invoiced. That is one vendor's own customer base rather than a census, so read it as an order of magnitude. Your own number is the one that matters, and the arithmetic behind it is in time tracking and billing.

3. Margin by client, not in aggregate. Which accounts actually produce profit, per project rather than per year. An agency can sit at an acceptable firm-wide average while one client runs at a loss, and the average is precisely what conceals it. Aggregate margin is comfortable information. Client-level margin is decision-grade.

4. Revenue concentration. What share of revenue comes from your top client, and your top three. This is the quiet one. An agency where one client is 40% of revenue does not have a diversified business, it has a partnership with a countdown, and the only moment to notice is before the client leaves. Concentration is not a problem while it is healthy, which is exactly why nobody checks it.

5. Close rate. Deals won as a share of deals pursued, over a consistent window. It is the fastest feedback on whether the pipeline is real. A falling close rate with a full pipeline usually means qualification has slipped, not that the market has dried up, and those two problems have completely different fixes.

What to leave off the dashboard

A finance dashboard fails by trying to show everything. Three categories of number are worth actively excluding.

• Leading indicators you cannot act on. A weighted pipeline value feels impressive and changes nothing this month, because you cannot make a deal close faster by looking at it. Keep it in the CRM, out of the finance view.

• Metrics with no threshold. A number is only useful if you have decided what counts as bad. Utilization of 78% means nothing until you have decided whether your target is 70% or 85%, and that number will differ per agency, per role, and per season. Set the threshold first, or drop the metric.

• Anything that takes more than a minute to reconcile by hand. If a number cannot be read directly from the system without a spreadsheet export, it will stop being updated. A stale dashboard is worse than no dashboard, because it still looks authoritative.

A useful finance dashboard for a small agency fits on one screen and answers about six questions. Anything larger is a report, and reports do not get looked at.

A worked example

A twelve person agency, second year, revenue growing about 40% year on year, and the owner is worried about cash. Here is what each of the five numbers actually says.

• Cash position. Invoices worth 31,000 dollars are outstanding, and 19,000 of that is more than thirty days old, concentrated in two clients. Revenue growth is real, but payroll in three weeks is genuinely tight. Without the ageing breakdown this looks like a healthy quarter.

• Realization rate. Tracked hours versus invoiced hours across the last quarter gives 88%, so roughly 12% of delivery time was never billed. At their blended rate that is real money, and it is money the agency already performed and gave away.

• Margin by client. Two clients are below 40% margin and one is loss-making on a retainer. Combined, they are a meaningful share of revenue. Nobody raised it because the firm-wide average looked acceptable.

• Concentration. The largest client is 38% of revenue. That is a number the owner had never calculated and now wishes they had, three months earlier.

• Close rate. Down from roughly a third to under a fifth, with the pipeline volume flat. That pattern points at qualification rather than demand, which is a fixable pipeline problem rather than a market one.

Notice which of these required a decision versus merely an observation. Four of the five produced a specific action: chase the two late payers, investigate the unbilled hours, renegotiate or decline the loss-making retainer, and fix lead qualification. None of them required a forecasting model. They required the delivery and billing data to be in one place so the numbers could be read directly.

How to build this without a finance hire

The practical sequence, in the order that produces value soonest.

1. Start with cash ageing, not revenue. What is owed, by how old, by which client. This is the fastest thing to assemble and usually the first thing to be uncomfortable, which is why it is first.

2. Calculate realization rate once. One client, one quarter, tracked hours against invoiced hours. It takes an afternoon and it is the number most likely to change behaviour immediately, because it is measured rather than argued about.

3. Break margin down by client. Per project, not per year. This is where you find out that growth has been costing you money on the accounts you were proudest of.

4. Calculate concentration. Two divisions. It takes a minute and it reframes how you think about the largest account.

5. Only then build a recurring view. Once the numbers have been assembled once by hand, automate the ones worth watching and drop the rest. Automating a metric before you have ever calculated it by hand produces a dashboard nobody trusts.

The underlying requirement is the same across all five, and it is not a finance tool. It is that hours, projects, and invoices sit in one system. Where they sit in three, every number above becomes a manual reconciliation, and manual reconciliations are the first thing to stop happening. For the module-level view, see agency analytics and reporting.

The bottom line

An agency finance dashboard does not need forecasting. It needs cash ageing, realization rate, client-level margin, revenue concentration, and close rate, read from one place. Those five numbers cover the failures that close agencies, and every one of them is measurable without a data team. Build them by hand once, keep the ones that change a decision, and let the rest go.