The Financial Dashboard for an ATO or Aeroclub: Metrics That Matter vs. Metrics That Just Fill Excel
Last month I closed a four-week block on financial resilience: stress testing, sensitivity analysis, zero-based budgeting, scenario planning. Together those tools ask “is the business designed to survive what could happen?” and answer it in a structured way.
Today opens a new block — operational dashboards and metrics — and the question shifts. We move from “is the structure right?” to “is the operation, week by week, actually doing what the structure assumes?”. The exercise that bridges the two is the financial dashboard: the small set of numbers that, looked at every Monday morning, tells you whether the operation is on track, drifting, or in trouble.
Most flight schools and aeroclubs I’ve worked with already have something they call a dashboard. It’s usually a spreadsheet. It usually has thirty rows. Nobody reads it on Monday morning. The owner glances at it monthly when the accountant sends it. By that point, anything that’s gone wrong has already been wrong for three weeks.
The fix isn’t a bigger spreadsheet. It’s a smaller one — built around the discipline that every metric on it has to (a) drive a decision, (b) have a defined threshold, and (c) have a named owner. Anything that fails those three tests doesn’t belong on the dashboard. It belongs in a folder that nobody opens.
What a dashboard is for
A dashboard isn’t a record of what happened. That’s what the management accounts are for. A dashboard is a forward-looking instrument: it tells you, at a glance, whether the operation is heading where you want it to go, in time to do something about it if the answer is no.
In aviation terms, the management accounts are the flight log. The dashboard is the instrument panel. The flight log tells you where you’ve been; the instruments tell you what’s happening now and what to do about it. A pilot who only consults the flight log mid-flight wouldn’t last long. Yet that’s how many aviation operators run their finances — looking at last month’s profit while flying through this month’s cash crunch.
The dashboard exists to close that gap. It pulls a small number of forward-leaning metrics into a single view that’s reliable enough to drive Monday-morning decisions, and concise enough that the owner — who has fifteen other things to do that day — actually looks at it.
The six (or so) numbers that earn their place
After running this exercise with dozens of training operations, I’ve converged on roughly six core metrics that earn their place on almost any ATO or aeroclub dashboard. The exact list varies; the categories are stable.
1. Hours flown, week-to-date and month-to-date, vs. plan. This is the single most important leading indicator for a training operation. Revenue follows hours; if hours are down, revenue is following them in a few weeks. Track WTD and MTD against the planned figure for the same window. Gap of more than 10% is a flag.
2. Revenue MTD and YTD, vs. plan. The lagging counterpart to hours flown. If hours flown is roughly on plan but revenue is below — that’s a pricing discount, a billing slippage, or a service mix shift. Different problem from low hours, requiring different action.
3. Cash balance and runway in days. Not just the balance — the runway. If your fixed cost base is 32,000 € a month, your runway is cash balance ÷ (32,000/30). 28 days of runway means something concrete and actionable; “62,000 € in the bank” doesn’t, until you do that division. Put both numbers on the screen.
4. Fleet availability. Aircraft on line vs. aircraft in maintenance, AOG, or otherwise unavailable. For a four-aircraft school this might be “3 of 4 — D-EFGH AOG day 4 awaiting part”. Fleet availability is the single biggest operational determinant of revenue capacity, and it’s also the thing that operators routinely under-track because it doesn’t appear on the P&L until two weeks later as missing revenue.
5. Receivables over 30 days, with names and amounts. Collections discipline is the single largest source of cash drift in flight schools. A “trade receivables” line on a balance sheet is invisible. “8,200 € from three students past 30 days, oldest at 51 days” is actionable.
6. Pipeline for next intake / next month. The leading indicator that doesn’t appear on any standard accounting report. Number of confirmed sign-ups for the next cohort, number of qualified leads, deposits received. If the pipeline is below threshold, you have eight weeks to act; if you wait until intake day to find out, you have eight days.
That’s six. Some operators add a seventh — instructor utilisation rate, maintenance reserve balance, or compliance-deadline countdown. Beyond eight, the dashboard stops being a dashboard and starts being a report. The point is intentional smallness.
What does NOT belong on the dashboard
This is at least as important as what does. The standard mistake is to add metrics because they’re available, not because they’re useful. A few things I routinely see on operator dashboards that I routinely remove:
EBITDA, year-to-date. EBITDA is a useful annual metric and a critical valuation metric. It’s not a Monday-morning operational metric. By the time EBITDA shows a problem, the problem has been visible in hours flown, revenue, and cash for weeks.
Detailed expense line items. “Insurance premiums YTD” doesn’t change between Monday and Friday and shouldn’t take up space. Expenses should be reviewed at the monthly close, not on the weekly dashboard. The exception is variable costs that swing meaningfully — fuel cost per hour is worth tracking; office supplies is not.
Year-on-year vanity comparisons that don’t drive decisions. “+8% YoY” is satisfying to look at, but unless it leads to a decision, it’s noise. The right comparison is to plan, not to last year, because plan is what you committed to and last year is irrelevant context.
Anything you can’t refresh weekly. A metric that updates monthly cannot be a weekly dashboard metric, by definition. Either find a weekly proxy or move it to the monthly review.
Compound or derived metrics that nobody intuits. “Operating efficiency ratio of 1.34” means nothing to most owners. Hours flown vs. plan, in absolute numbers, means everything. Use the most concrete metric you can get away with.
The discipline of thresholds
A number without a threshold is decoration. The discipline is to define, for each dashboard metric, the level at which it triggers a response.
For Meridian, an example threshold table:
| Metric | Green | Amber | Red | If Amber/Red |
|---|---|---|---|---|
| Hours flown WTD vs plan | ≥ 95% | 85–95% | < 85% | Operations review on Tuesday |
| Cash runway (days) | ≥ 35 | 20–35 | < 20 | Cash conservation protocol |
| Fleet availability | 4/4 | 3/4 | ≤ 2/4 | Wet-lease activation |
| AR > 30 days | < 5,000 € | 5–12,000 € | > 12,000 € | Collections intensification |
| Pipeline next intake | ≥ target +10% | target ±10% | < target −10% | Marketing acceleration |
Each colour has a defined response. Amber doesn’t mean “look at it later”; it means a specific predefined action is triggered this week. Red means escalation, often involving calls or commitments that can’t wait until next week’s review.
The thresholds matter because without them the dashboard’s job — driving decisions — collapses. The owner looks at the screen, notes that a number is “a bit low”, makes a mental note to think about it, and moves on to the next thing. Three weeks later the number is critical and nobody has acted. The threshold prevents this drift by making “a bit low” mean a specific, named action this week.
The discipline of named owners
Each metric needs an owner. For a small ATO this often means the same person — the owner — owns most of them. That’s fine; the discipline is having the names written down, so that ownership is explicit rather than diffuse. A dashboard where every metric is implicitly “the owner’s responsibility” is one where, in practice, most metrics are nobody’s responsibility because everything is the owner’s.
In larger operations, distributing ownership is essential. Hours flown can be owned by the head of operations. Cash balance and AR by the office manager. Fleet availability by the maintenance lead. Pipeline by whoever runs marketing or admissions. Each owner is responsible for monitoring the metric, surfacing changes, and triggering the predefined response when thresholds are crossed.
The other purpose of named ownership is that it forces discussion. If hours flown is owned by the head of operations and is amber three weeks running, the owner of the operation needs to have a specific conversation with a specific person. Without named ownership, that conversation either doesn’t happen or happens in a vague way that doesn’t change behaviour.
How a Meridian Monday actually goes
Let me make this concrete. Imagine the owner of ATO Meridian opens the dashboard at 8:30 on a Monday morning. The view is one screen. It shows:
- Hours flown last week: 68 vs plan 72. Amber.
- Revenue MTD: 48,000 € vs plan 50,000 €. Amber-ish.
- Cash balance: 62,000 €. Runway: 28 days. Green.
- Fleet availability: 3 of 4. D-EFGH AOG day 4 awaiting part. Amber, with note from maintenance lead.
- AR > 30 days: 8,200 €, three students named. Amber.
- Pipeline next intake (September): 14 confirmed vs. target 12. Green.
The dashboard alone tells the owner: hours flown is short, fleet is partly to blame, AR is creeping. None of these are red, but three are amber. The predefined responses kick in: maintenance lead reports on D-EFGH part ETA; office manager calls the three AR students this week; head of operations reviews scheduling for the rest of the month to see if the lost hours are recoverable.
That’s twenty minutes of structured Monday morning that produces three concrete actions. Compare to the alternative — looking at last month’s accounts when they arrive on the 15th — and the two operating modes are not remotely the same.
What to do at month-end (and what NOT to)
The weekly dashboard is one of two reporting layers. The monthly close is the other. Distinguishing them is essential: putting too much on the weekly dashboard makes it unmanageable; putting too little on the monthly review makes it unnecessary.
Monthly close should include: full management accounts, EBITDA YTD vs plan, cost line review (especially against the zero-based budget), payroll detail, ratio analysis (current ratio, days sales outstanding, asset turnover), comparison vs same month prior year for context. This is where the strategic conversation happens — about pricing, capacity, structural cost.
Weekly dashboard is operational. Monthly review is strategic. They are not the same exercise dressed up differently.
Tooling — boring is good
The dashboard does not require sophisticated software. The best dashboards I’ve seen for small flight schools are:
- A single spreadsheet, refreshed manually each Monday morning, with conditional formatting for the threshold colours.
- A printed sheet posted in the operations office every Monday.
- A shared screen in the operations area showing the same six numbers all week.
What matters is reliability and refresh discipline. A beautiful Power BI dashboard that nobody updates because the data pipeline broke is worse than a printed sheet that gets updated by hand at 8:00 every Monday by whoever opens up. Pick the simplest tooling that the operation will actually maintain.
I make this point because I’ve seen operators spend three months building elegant BI infrastructure, then quietly stop refreshing it after week six. The shorter the path between data and screen, the better the chance the dashboard becomes a habit rather than a project.
The owner-pilot version
For an owner-pilot with a single aircraft, a dashboard sounds excessive — and often is, in the formal sense. But the underlying discipline is identical. The four numbers I’d track:
- Hours flown this month vs. the rolling annual plan
- Cost per hour to date (real, including reserves and amortisation, not just fuel)
- Maintenance reserve balance — what’s accumulated for the next big bill
- Days since last flight — leading indicator of underutilisation
A note in a paper notebook, monthly, with thresholds defined privately (“if days-since-last-flight goes above 30, talk to my CFI about getting back in”), is a perfectly serviceable owner-pilot dashboard. The principle — small set of forward-looking numbers, with thresholds, looked at on a regular cadence — is the same.
What comes next in this block
This is the first of a five-week block on operational dashboards and metrics for aviation businesses. Next week I cover fleet renewal: when it’s an expense and when it’s an investment — applying NPV thinking to the decision that owners often treat as a feeling. Then a piece on what business can learn from cockpit design (because dashboards aren’t a bookkeeping topic; they’re a human-factors topic). Then a piece on why pilots underuse their technical knowledge in business, and finally one on economies of scale lessons from low-cost airlines.
A good dashboard is the operational counterpart to the strategic resilience tools we covered last month. The stress test, sensitivity analysis, ZBB, and scenario planning tell you the operation is structurally sound. The weekly dashboard tells you the operation is, this week, actually behaving in line with that structure — and gives you time to act when it isn’t.
Most aviation businesses have either too much reporting or too little. The fix is rarely “add another dashboard”. It’s usually “throw out the noise and keep the six numbers that drive Monday morning”. That sounds simple. In my experience, doing it well is the difference between an operation that gets managed and one that just gets reacted to.
At AYRAM we routinely help aviation operators design and stand up the right reporting cadence — both the weekly dashboard and the monthly review — as part of broader strategic engagements or as a standalone advisory piece. As independent buy-side advisors with no commissions, no software partnerships, and no transactional incentives, the dashboard we help you build is the one your operation actually needs, not the one that’s most convenient to sell.
If your Monday mornings still depend on last month’s accounts, that’s a gap that’s costing you decisions. We’d be glad to be the conversation that closes it.