Revenue: Forecast with Confidence

Revenue by Type:

How B2B Agencies Report and Forecast with Confidence

If you run a digital agency or creative studio, you probably already know that revenue is a slippery word. A pound from a retainer client who has been with you for three years is not the same as a pound from a one-off website build, and neither behaves like a pound of pass-through media spend. Yet most agency P&Ls lump them together under Sales and hope for the best.

This post is about pulling those streams apart, reporting on them properly, and using your live accounting data and pipeline to look ahead without needing a crystal ball or a 40-tab spreadsheet. It’s a relaxed approach, but a rigorous one.

Why one big revenue number hides the story

Say you turned over a healthy amount last quarter. Brilliant. But what you really want to know is:

– How much of it will happen again next month without you lifting a finger?
– How much depended on you winning new work this quarter?
– How much was media you bought on a client’s behalf and passed straight through?

Those questions have three very different answers, and they map neatly onto the three revenue types most agencies deal with: retainer, project and media.

The three revenue types, in plain English

Retainers

Retainers are your recurring fees: monthly SEO, social management, ongoing design support, hosting and maintenance, a fixed number of days per month. They’re the backbone of agency cash flow because they’re predictable, and they make your forecast much easier.

When reporting on retainers, track:

– Monthly recurring revenue (MRR) at a point in time
– New, expanded, reduced and lost retainers each month, so you can see movement and not just a total
– Notice periods and contract end dates, which tell you how safe that income really is
– Delivery cost against fee, because a retainer that quietly eats twice its budgeted hours is revenue you’re paying to keep

Projects

Projects are one-off pieces of work with a defined scope: a brand identity, a website build, a campaign launch. They’re often your most profitable work and your most unpredictable, since they depend on the pipeline.

For projects, the useful numbers are:

– Value won, value invoiced and value recognised (more on this below)
– Timing of milestones, since project revenue often arrives in lumps
– Margin by project, comparing the quoted budget with actual time spent
– Work in progress, meaning what you’ve delivered but not yet billed

Media

Media is where agencies get tripped up. If you buy advertising on behalf of clients, the money that flows through can look like huge turnover while your actual earnings are a modest fee or commission on top.

How you present this depends on whether you act as agent or principal in the arrangement. Broadly, if you’re simply arranging the media for the client and they carry the risk, you may only be entitled to recognise your fee or margin as revenue. If you take on the risk and control of the media yourself, gross treatment may be more appropriate. This matters for your accounts, for VAT, and potentially for thresholds that depend on turnover, so it’s worth agreeing the treatment with your accountant rather than guessing.

Whichever treatment applies, report media billings and net media revenue separately in your management accounts. Otherwise, your growth looks amazing right up to the moment you notice margins have collapsed.

Setting up your accounts so the reporting works

You don’t need fancy software, but you do need structure. A few practical tips:

1. Split your nominal codes. Create separate revenue accounts for retainer, project and media income, and a separate one for any pass-through costs. Many cloud packages such as Xero, Briefcase and FreeAgent let you do this in minutes.
2. Use tracking categories or tags. Tag every invoice by client and by revenue type so you can slice the data however you like later.
3. Keep invoicing habits consistent. If retainers go out on the 1st and project milestones whenever someone remembers, your monthly numbers will wobble for no real reason.
4. Reconcile regularly. Live data is only useful if it’s up to date. Weekly bank reconciliation beats a frantic catch-up at quarter end.
5. Deal with accruals and deferred income. If a client pays you upfront for a three-month project, that income should generally be spread across the period you deliver it. Looking at cash received alone can make a quiet month look brilliant and a busy one look terrible.

A simple monthly revenue report worth building

Aim for a one-page view that you can read over a coffee. Something like:

– Revenue by type for the month, against budget and against the same month last year
– Retainer MRR with the movement bridge (new, up, down, lost)
– Project revenue recognised, plus work in progress and unbilled work
– Media billings and net media revenue
– Gross margin by revenue type
– Debtor days and overdue invoices
– Revenue concentration: how much comes from your top three clients

That last one is quietly important. If one client is a large share of your income, your forecast is only as reliable as that relationship, and that’s a risk worth seeing in black and white.

Looking forward: forecasting with live data

Now for the fun part. Good agency forecasting isn’t about predicting the future perfectly. It’s about building a sensible range from things you already know and being honest about what you don’t.

Start with what’s contracted

Begin with your retainers. Take current MRR, then adjust for known changes: contracts ending, notice already served, price increases agreed, scope changes. This gives you a base layer you can have high confidence in.

Layer on the committed project work

Next, add signed projects with their expected delivery and invoicing schedule. Be realistic about timing. Projects slip, and a milestone you planned for March has a funny habit of arriving in April because a client was slow on feedback. Forecast on when work will be delivered and billed, not when you’d like it to be.

Add the pipeline, weighted by probability

This is where your CRM and accounts need to talk to each other, even if only through a monthly manual check. For each opportunity, record:

– Estimated value
– Likely start date
– A sensible probability based on its stage (an inbound enquiry is not the same as a verbal yes)

Multiply value by probability and you get a weighted pipeline. Don’t treat it as a promise. Treat it as a shaded area on the chart. Over time, compare what you forecast with what actually closed, and your probabilities will get more honest and more accurate.

Treat media separately

Because media is volatile and often client-budget-led, forecast it on its own line. Look at client campaign plans where you have them, and forecast net revenue, not gross billings, so you aren’t flattered by pass-through spend.

Build three scenarios

Rather than one number, build a cautious case, an expected case and an optimistic case:

– Cautious: contracted retainers and signed projects only, plus any known losses
– Expected: the above plus weighted pipeline
– Optimistic: the above with a better win rate and a couple of upsells

The cautious case is the one that matters for decisions like hiring, taking on a lease or paying yourself a dividend. If the business is comfortable in the cautious case, you can sleep well.

Turning the forecast into a budget

A budget is simply a forecast with intent. Once you have your revenue view by type, work down the page:

– Direct costs: freelancers, software, media costs and delivery staff time. Link these to the revenue they support, so costs move when revenue moves.
– Overheads: rent, tools, insurance, admin and marketing.
– Capacity: do you have enough people to deliver the forecast? Agencies often forecast revenue happily and then discover nobody’s available to do the work. Compare forecast hours with available hours each month.
– Cash: convert the profit forecast into a cash forecast. Include VAT quarters, corporation tax, PAYE, pension contributions and the payment terms your clients actually pay on, not the ones in your contracts.

Cash is where agencies get caught out. You can be profitable on paper and still short on the 28th, particularly if you pay freelancers and media suppliers quickly while clients pay slowly.

Keeping it live

The real value comes from rolling the forecast forward rather than filing it away in January and looking at it again next December.

– Monthly: update actuals, refresh the pipeline, and reforecast the next 6 to 12 months.
– Weekly (light touch): check cash, overdue invoices and any big pipeline movement.
– Quarterly: step back and look at trends, margins by revenue type, client concentration and whether your pricing still reflects the work.

Many cloud accounting tools now have forecasting add-ons or integrations that pull live data from your ledger, and this is well worth exploring. Even without them, a well-structured spreadsheet fed by a monthly export does the job nicely.

Common mistakes to avoid

– Reporting only cash received and mistaking it for revenue earned
– Counting gross media as income without considering how it should be treated
– Treating the whole pipeline as certain instead of weighting it
– Forgetting seasonality. Many agencies see slower periods around summer and the festive break, and clients’ budget cycles can create peaks too
– Ignoring churn. Retainers end, so plan on some leaving each year
– Forecasting revenue without forecasting capacity
– Building the forecast once and never revisiting it

Where an accountant helps

You don’t need to do all this alone. A good accountant can help you set up the chart of accounts, get the revenue recognition right (especially for media and prepayments), build a rolling forecast that ties to your live ledger, and sense-check the cash and tax implications of your plans. If you’re making a significant decision such as hiring, investing or taking on a big client, it’s worth running the numbers with someone before you commit.

The takeaway

Separate your revenue into retainer, project and media. Report on each properly. Start your forecast from what’s contracted, add the pipeline with realistic probabilities, and always check your capacity and cash. Do that regularly, with live data, and you’ll spend less time wondering what’s coming and more time doing the creative work you started the agency for.

If you’d like help setting up revenue reporting or a rolling forecast for your agency, the team at Cornel Accountants would be happy to have a chat.