Why Agency Forecasting Needs More Than a Spreadsheet
Forecasting has to work harder for agencies than it does for most businesses. Project revenue arrives unevenly, with timelines and payment schedules constantly shifting. Retainers feel stable, but they carry real churn and renewal risk. Money comes in through several streams at once: retainers, project fees, incentives, and client budgets tend to move with the seasons rather than your financial year.
Without a forecast you actually trust, you end up guessing at the things that matter most: can we make this hire, should we take this client on, whether billings will land when we expect them to this quarter, what's our real capacity for new business.
Picture a mid-sized agency carrying three live pieces at once: a retainer client due for renewal in six weeks with no confirmed decision yet, a new production job that's just landed with a tight turnaround, and a hire the operations lead has been sitting on for a month because nobody's confident committing to the added cost. None of those decisions is really about the individual client or hires; they're about whether the numbers beneath all three hold up at the same time. That's what actual job forecasting is meant to do, and it's also exactly where a spreadsheet starts to strain.
What good forecasting actually gives you
Done well, forecasting isn't just a finance exercise. It gives you three things agencies consistently say they're missing:
Clearer visibility of future billings and revenue, so decisions are based on data rather than a gut feeling
Stronger strategic financial planning, so resourcing lines up with where growth is actually heading
Reporting that's specific enough to support quick, agile decisions rather than a monthly guess
What this actually looks like day to day
In practice, that means forecasting at the level that matches how the decision is being made, by client, by product, or by job, rather than forcing everything into one flat view. Job forecasts can feed directly into the client-level picture, so a producer updating numbers on a live job isn't creating a second, disconnected version of the truth that finance has to reconcile separately. As work progresses, estimated and actual revenue sit side by side for comparison, under their own forecast revenue category, so client-level and job-level forecasting don't blur into each other.
Setting it up is less involved than it sounds: a forecast header to hold the numbers, categories and groups to organise them, a template so entry stays consistent, and authorisers so the right people sign off before anything goes live. Six steps, each doing one specific job, rather than one large undertaking.
When it's time to move beyond a spreadsheet
Most agencies start forecasting in a spreadsheet, and that's a perfectly normal place to begin. The real question is knowing when it's time to move on. The signs are usually practical rather than dramatic: one missed update to billings or job costs throws the whole forecast out, formulas turn into something only one person can maintain or explain, and modelling a "what if" means duplicating tabs and rebuilding formulas by hand, by which point the moment it was meant to help you catch has usually passed. Once client services, production, and finance are all touching the same file, it stops being clear whose copy is current.
None of that means a spreadsheet is a bad place to start. It just means it's worth knowing what a connected forecast, one built on your real job, billing, and revenue data, actually removes: less manual re-entry, no formulas to babysit, and everyone working from the same version instead of comparing copies.
Why this often traces back to how revenue is recognised
Part of why forecasting gets harder as an agency grows comes down to something underneath the spreadsheet: how the underlying finance system recognises revenue in the first place. Many systems are built around a model in which revenue is recognised when an invoice is raised, and costs are recognised later, when supplier invoices come in. That works fine for a business selling stock. It's a much shakier foundation for an agency, where the real question isn't what was invoiced last month; it's what was actually earned and spent against work that's still in progress. A forecast sitting atop that kind of timing mismatch is only as reliable as the manual adjustments layered over it to close the gap.
Where this fits into Pegasus Edge
Forecasting in Pegasus Edge connects directly to the job costing, billing, and revenue data already in the system, so a forecast reflects what's actually happening rather than a snapshot from whenever someone last updated a file. It's one part of a broader connected platform for agency finance and operations.
If you're reviewing systems or operations this year, talk to us about how Pegasus Edge is evolving to meet the needs of modern agencies.