Cash Flow Forecast Template for Agencies [Free Excel Download]

Agency founder reviewing a cash flow forecast template in Excel on a laptop
By ACC Finance Team

Cash Flow Forecast Template for Agencies [Free Excel Download]

By ACC Finance Team
Follow Us:

11 min read

Key takeaway A weekly cash flow forecast template is a spreadsheet that shows the cash you expect to receive and pay out each week, and the bank balance left at the end of it. ACC’s free Excel version is built for agencies, with space for retainers, milestone invoices, freelancer costs and a worst-case line for your slowest-paying client. Download it, enter your opening balance, expected income and expenses and update it every Friday.

Most agencies we speak to already have a spreadsheet they call a forecast. It usually has a bank balance at the top, a column for each month, and figures that were last touched during the most recent cash scare. A cash flow forecast template only earns its place if someone updates it every week and the founder checks it before approving any spending.

This article introduces ACC’s free cash flow forecast template excel download, explains which agencies get the most from it, and shows how to use it from the first week. It deliberately avoids repeating the case for forecasting, which we cover in our guide to cash flow forecasting for agencies. Think of that piece as the reasoning (why) and this one as the working tool (how).

Download our 13-week cash flow forecast template now.

Who should use this cash flow forecast template

The template suits any agency that wants a forward view of its bank balance. Our team sees the following situations where it changes decisions most.

Agencies with a bookkeeper or accountant but no finance lead

Plenty of agencies have well-kept books and tidy management accounts every month, yet nobody owns the question of what the bank balance will look like in six weeks. Bookkeepers record what has happened. Accountants file what the law requires. Neither is usually asked to predict when a client will pay.

In that situation, the founder or operations lead ends up carrying the forecast in their head. A cash flow forecast template gives the job a home. It turns unwritten knowledge, such as which clients pay late, when the quarterly VAT payment falls and what payroll looks like, into figures the whole leadership team can see and challenge.

Founders about to hire or take on a large project

A new hire or a big project changes an agency’s cash profile almost immediately, because costs start in week one and additional revenue rarely arrives until weeks later. Founders in this position often ask whether the business can afford the commitment. The more useful question is ‘When will the cash be tightest?’ A forecast template answers that before the contract is signed or the offer letter goes out. We work through an example further down.

Founders preparing for a lender, investor or buyer conversation

Anyone asking for a larger overdraft, a growth loan or investment will be asked for a forward view of cash. Anyone selling will see a buyer’s team probe the same numbers during due diligence, which our guide to what due diligence actually involves covers in detail. Producing a credible forecast within 24 hours feels very different from assembling one under pressure.

A cash flow forecast template that has been updated weekly for a few months also shows a lender what they care about most: that leadership understands its own cash position.

When a template on its own is not enough

A cash flow projection template Excel file works well for agencies with a manageable number of clients and a single trading entity. Once an agency runs several currencies or legal entities, or a pipeline too large for a single line to describe, the template becomes the starting point for a proper financial model rather than the finished article. At that stage it helps to have a finance specialist own it, which is where our fractional CFO work usually begins.

What is inside the cash flow forecast template

The file is one workbook, built so that a weekly update takes minutes rather than an afternoon.

  • Opening balance and start date. Enter these once. The weekly column headings update from the start date.
  • Cash in, by client. Retainers, project payments and one-off fees each get their own rows, with the date the cash is expected to land.
  • Cash out, by category. Payroll, freelancers, software, rent, tax and pass-through costs are listed separately, so you can see which ones move.
  • Known tax and payroll dates. Include VAT, PAYE and corporation tax rows are pre-filled in the file.
  • Confirmed and expected income on separate lines. The closing balance can be read with and without the optimistic items.
  • Closing balance row. It calculates automatically.

Download our 13-week cash flow forecast template now.

What a weekly cash flow forecast does differently

The most common reason agency forecasts fail is not the formulas. It is the rhythm. A forecast refreshed monthly describes a month that has already passed by the time anyone reads it. A weekly cash flow forecast, in which actual receipts and payments replace estimates as each week closes, stays close enough to reality to be trusted. We built our cash flow forecast template excel file around that habit, so that a weekly update is a short routine rather than a project.

Three habits make the difference in practice. The first is to forecast the date cash lands, not the date an invoice is raised. An invoice issued on the last day of the month to a client on 45-day terms is money for the month after next, and for agencies with a handful of large clients, one slipped payment can change the whole picture.

The second is to keep known commitments visible. Payroll, PAYE, pension contributions and rent are easy to remember. Quarterly VAT is the one that surprises people. HMRC guidance sets the deadline at one calendar month and seven days after the end of the VAT accounting period, so a quarter ending in December puts the payment on 7 February. That date is worth seeing months in advance rather than weeks.

The third is to separate what is confirmed revenue from what is hoped for. Cash from invoices already issued carries a different level of certainty from cash expected from a pitch. Showing them on separate lines means the closing balance can be read with and without the optimistic items.

How to use the cash flow forecast template excel file, step by step

Use the instructions in the Start Here tab on the excel file.

  1. Add your opening cash balance for the period and set your minimum cash buffer. This is the amount which will trigger action status if cash drops below this threshold.
  2. Add your weekly expected income, broken down by retainer, projects, new business and any other cash in.
  3. Add your weekly outgoings. Include staff costs and freelancers, marketing, premises, overheads, loan and finance agreement payments, tax and dividend distributions plus any other one-off costs.
  4. Update the forecast once a week, ideally on the same day. Monday or Friday tend to work best.
  5. Use the Founder Insights tab to review your overall position and decide what action, if any, is required to adjust your cash position.

Mistakes that quietly undermine a cash flow forecast template

A good cash flow forecast template can still produce a misleading forecast. These are the errors our team finds most often when we review an agency’s existing forecast.

The opening balance drifts. If the starting figure is not reconciled to the actual bank balance each week, small differences compound until nobody trusts the closing figures. Check the opening balance against the bank before entering anything else.

Annual or quarterly costs go missing. Software renewals, insurance premiums, bonuses and corporation tax sit outside the monthly accounting routine, so they rarely make it into a forecast built from last month’s bank statement. Walk through the previous twelve months of statements once and list every payment that does not recur monthly.

Pipeline income arrives early. A pitch that is likely to convert in March is not March cash. Allow for the usual gap between winning work, starting delivery, invoicing and being paid, and enter the income when it is expected to land rather than when it is expected to be won.

Variances get overwritten. When actual cash differs from the estimate, the temptation is to change the old figure and move on. Keep a note of the original estimate instead. After a couple of months, the pattern of differences shows which clients, cost categories or assumptions are consistently off, and that is how forecasts become more accurate.

The forecast lives with one person. If the only person who understands the file is on holiday in the week payroll is due, the forecast has stopped being a management tool. A second person who can update it, and a short weekly review with the founder, keeps it in use.

Download our 13-week cash flow forecast template now.

Testing a hire or a large project in a cash flow forecast template

The quickest way to see the value of the template is to run a decision through it before committing. Take an illustrative agency that wins a £60,000 project. Delivery costs, split between team time and two freelancers, run at £4,500 a week for eight weeks, so £36,000 leaves the business over the first two months. The invoice goes out at delivery in week eight, the client pays on 60-day terms, and the £60,000 arrives around week 17.

On the P&L, that project is £24,000 of gross profit and looks like good news from week one. In the forecast, the agency has funded £36,000 of costs before any cash arrives, and that is before payroll for the rest of the team, rent and tax are counted. If opening cash is £45,000 and everything else breaks even, the balance falls to £9,000 by week eight and stays there until the client pays.

Now add a hire costing £6,000 a month all in, starting the same week as the project. The balance dips below zero in week eight, nine weeks before the client pays. The figures are illustrative, but the pattern is one our team sees often in agency client work.

The table below shows the closing bank balance each week for an illustrative agency with £45,000 in the bank, a £60,000 project and a new hire. Project costs are £4,500 a week for eight weeks. The £60,000 invoice is paid in week 17. The hire costs £6,000 a month all in, shown as £1,385 a week. Everything else is assumed to break even. The figures are illustrative.

WeekProject onlyProject plus hire
1£45,000£45,000
2£36,000£33,231
4£27,000£21,462
6£18,000£9,692
8£9,000(£2,077)
10£9,000(4,846)
12£9,000(7,615)
14£9,000(10,385)
16£9,000(13,154)
17£69,000£45,462

Seeing that gap in advance changes the conversation. The founder can start the hire later, ask for a deposit, agree a milestone invoice at week four, or arrange a short-term facility while the business is still in a strong position. None of those options feels comfortable to arrange in week eight.

Download our 13-week cash flow forecast template now.

Sizing your buffer to the slowest payer

The last row worth adding to any cash flow forecast template is a worst-case line, and it is the one most agencies skip. Rather than assuming every client pays on terms, run the forecast again with the slowest-paying client taking an extra 30 days. The gap between the two closing balances is the buffer the business needs to hold. This is the same principle behind the cash cushion that Sunday Treat’s founder Gulliver Moore described to us in a recent podcast episode, built to absorb a slow-paying client rather than an average month. Our article on the working capital cycle for agencies explains how that played out.

Late payment also has a legal side that many agencies never use. Unless the contract sets a different rate, GOV.UK confirms that business customers owe statutory interest at 8% above the Bank of England base rate on late commercial debts. Few agencies charge it in practice, but modelling the delay at least makes its cost visible.

When the template should lead to a conversation

A template shows what the numbers say. It does not tell a founder what to do about them. If the forecast regularly shows a gap, if the same client keeps stretching terms, or if the assumptions feel like guesses, the next step is a financial conversation rather than a better spreadsheet.

ACC’s Financial Health Check gives an independent, CFO-led review of your cash position, forecasting structure and financial controls before your next stage of growth. Where an agency needs that discipline all year round, our fractional CFO services provide experienced financial leadership and an integrated finance function to run it.

A CFO Perspective

In our client work, the agencies that get the most from a forecast are rarely the ones with the most sophisticated file. They are the ones where someone owns the weekly update, the founder reads it before approving spend, and the assumptions get challenged. ACC’s view is that a simple Excel template used consistently beats a detailed model rebuilt every quarter. Building the forecast is the easy part. Acting on what it shows is where a CFO earns their place.

Start with this week’s numbers

A forecast updated every Friday will tell you more about your agency’s next quarter than any annual budget. Download the file, enter this week’s real figures, and check your cash position before your next hiring or project decision. If the picture is uncomfortable, that is useful information, and it is far cheaper to learn it now than on the day payroll is due.

Frequently Asked Questions

What is a cash flow forecast template?

A cash flow forecast template is a pre-built spreadsheet that records the cash you expect to receive and pay out each week and calculates the closing bank balance. It lets an agency spot funding gaps before they happen without building a model from scratch. A good one separates confirmed income from expected income and shows known tax and payroll dates.

Is there a free cash flow forecast template excel agencies can download?

Yes. ACC provides a free Excel template for agencies, available to download from this page with no form to complete. Setting it up mainly involves entering an opening balance, client payment dates and known costs.

How often should a weekly cash flow forecast be updated?

Update it once a week, ideally on the same day, replacing the previous week’s estimates with actual receipts and payments. Monthly updates mean the forecast describes the past rather than warning about the future. The time spent is small compared with the cost of a surprise shortfall.

Can a cash flow projection template Excel file replace a financial model?

No. A cash flow projection template Excel file covers the next few months of cash movement, which is enough for most agencies day to day. A full financial model also forecasts profit, the balance sheet and returns on investment, and becomes worthwhile when an agency runs several entities or faces larger funding decisions.

This article is intended for general information and does not constitute legal, tax, or financial advice. Every business is different, and founders should take appropriate professional advice based on their specific circumstances.

Follow Us:
Author
Black GBP (£) currency symbol inside a black circle, representing finance, money, and UK currency transactions

ACC Finance Team

ACC Finance Solutions provides fractional CFO leadership to scaling UK service and agency businesses, combining strategic financial leadership with practical commercial judgement to strengthen margins, improve cash flow and support critical decisions around growth, funding and exit.
Date:

Apply for a Financial Health Check

Gain independent clarity on profitability, cash flow, and financial controls before your next stage of growth.
Applications are reviewed to ensure a strong fit.

Find Out More or Become A Guest: 
Speak to us at The Fractional CFO Show

Read our next articles

We compare fractional CFO cost with a full-time CFO salary for agencies, using illustrative figures and clear assumptions, and cover what drives the price, what should be included and why scope matters as much as the numbers. Worked figures included.
By ACC Finance Team
A pricing structure built on projects leaves agencies able to see only weeks ahead. Here is how moving towards recurring revenue changes cash flow, margin and value, with lessons from Rooster Punk's CEO.
By ACC Finance Team
Debt vs equity financing for agency founders: how lenders and investors view an asset-light business, which options suit agencies, and a worked £500k example.
By ACC Finance Team
Mergers and acquisitions look different from the founder's side. Elliott King of FINN Partners explains why he sold Mint Twist, how he ran an agency and a sale at once, and what changed on day one.
By ACC Finance Team
A practical financial modelling framework for agency founders: test a hire, a new service line or an office lease before you commit, using base, upside and downside scenarios.
By ACC Finance Team
Most agencies assume AI is worth it because it feels faster. Here's the payback formula that shows whether it's actually paying back your investment.
By ACC Finance Team