Cash Flow Forecast: A Simple 13 Week Method for Owners

A cash flow forecast is the one financial document most owners of service businesses know they should keep and very few actually do. That gap matters, because profit and cash are not the same thing, and plenty of firms that look healthy on paper still find a slow month hard to get through.

This guide sets out a simple 13 week method you can build in an afternoon and keep up in half an hour a week. It is general business guidance rather than financial or tax advice, so check the specifics of your own position with your accountant.

Why profit does not pay the bills

Your profit and loss account tells you whether the work you did last quarter made money. It does not tell you whether that money has arrived, or whether it will arrive before the VAT bill, the rent and the salaries go out.

Service businesses are especially exposed to this gap. You deliver the work first, invoice at the end of the month, then wait thirty, sixty or sometimes ninety days to be paid, while your largest cost, your people, is paid every month without fail.

In thirty years of this work, one lesson keeps repeating itself. A business rarely runs out of profit first. It runs out of cash, and usually at a moment the owner could have seen coming.

What a cash flow forecast actually is

A cash flow forecast is a simple table. Down the side you list every type of money coming in and going out, across the top you list the weeks, and at the bottom you track the bank balance you expect at the end of each week.

The discipline that makes it work is timing. The Business Wales guide to cashflow forecasting makes the point plainly in its worked example: income goes in when you expect to be paid, not when you raise the invoice, and costs go in when you will pay them, not when the bill arrives.

Get that one rule right and most of the value follows. Get it wrong and your forecast turns into a second, less accurate profit and loss account.

Why 13 weeks is the right horizon

Thirteen weeks is one quarter. It is long enough to see a problem coming, such as a quiet month after a busy one or a quarterly VAT payment, and short enough that the numbers rest on real invoices, real contracts and real payroll rather than hope.

A twelve month view still has its place for budgeting, planning and conversations with a lender. For running the business week to week, though, a rolling 13 week cash flow forecast is far easier to keep honest.

• Weeks 1 to 4: high confidence. Mostly invoices already issued and bills you already know about.
• Weeks 5 to 8: medium confidence. Work that is booked or in progress, with realistic payment dates.
• Weeks 9 to 13: lower confidence. Pipeline and regular patterns, clearly marked as estimates.

Marking your confidence level matters. It stops a hopeful estimate in week twelve being treated with the same weight as an invoice that is already overdue.

As each week passes, the estimates in the later columns firm up and move forward into the high confidence band. Over a quarter, your cash flow forecast teaches you how reliable your own pipeline really is.

Not sure what is really holding your business back? Book a thirty minute call and we will talk it through with you.

How to build your cash flow forecast in five steps

Step 1: Start with the real bank balance

Open the business bank account today and write down the cleared balance. Not the balance you expect after Friday, and not the figure in your accounting software if it has not been reconciled recently.

Step 2: List the cash coming in

Go through your list of unpaid invoices and put each one in the week you realistically expect the money, based on how that client actually pays rather than on your stated terms. Then add work that is booked but not yet invoiced, and any retainers or regular monthly fees.

Be honest about slow payers. If a client always pays on day fifty, the cash goes in on day fifty, whatever the invoice says.

Step 3: List the cash going out

Payroll and freelancers come first, because they are usually the largest and least flexible costs. Then rent, software, insurance, loan repayments and card payments, followed by the lumpy items owners forget: VAT, PAYE, tax instalments, annual renewals and professional fees.

Your accountant can confirm exactly when your tax payments fall due. Put them in now so they never arrive as a surprise.

Step 4: Calculate the closing balance for each week

Opening balance, plus cash in, minus cash out, gives the closing balance. That closing figure becomes the next week’s opening balance, and so on across all thirteen columns.

Step 5: Set a minimum cash line

Decide the lowest balance you are comfortable holding, for example one month of fixed costs, and agree the figure with your accountant if you are unsure. Any week where the forecast dips below that line is a week that needs action now, while you still have options.

The weekly routine that keeps it honest

A cash flow forecast built once and filed away is worth very little. The value comes from updating it every week, ideally at the same time, so it becomes a habit rather than a project.

The same Business Wales guidance suggests comparing your forecast with what actually happens once you are trading. An actual column next to each forecast week shows where your assumptions were wrong, and that is where the learning is.

1. Update the opening balance from the bank.
2. Mark what was paid and received last week, and move anything late into a later week.
3. Add a new week thirteen at the end, so the view always rolls forward.
4. Look for any week that falls below your minimum cash line.
5. Agree one action for each problem week before you close the file.

Thirty minutes, once a week. That is the whole commitment, and it is usually the most useful half hour in the owner’s week.

What the forecast tells you about the business

After a few weeks, the spreadsheet stops being a spreadsheet and starts being a diagnosis. It shows you patterns that the profit and loss account hides.

• Payment terms that are too generous. If most cash arrives two months after the work, the problem is your terms and your invoicing, not your sales.
• Invoicing that runs late. Work finished on the 3rd but invoiced on the 30th is almost a month of credit you never meant to give.
• Clients who carry too much weight. If one late payer can push you below your minimum line, you have a concentration risk as well as a cash one.
• Service lines that soak up cash. Some work is profitable but pays slowly. Our guide to profit margin by service line helps you see which work genuinely pays for the rest.

These are business problems, not accounting problems. That is why the cash flow forecast belongs with the owner and not only with whoever does the books.

It also changes the quality of your decisions. When a good client asks for extended terms, or a new hire looks tempting, a current cash flow forecast lets you see the effect on the bank balance in week six or week ten before you say yes, rather than finding out afterwards.

What to do when the cash flow forecast shows a gap

A gap in week nine is good news, because you found it in week one. The earlier you see it, the more options you have and the less each of them costs.

• Chase overdue invoices now, starting with the largest and the oldest.
• Invoice finished work the day it is finished, and consider deposits or stage payments for longer projects.
• Review your payment terms for new work and state them clearly in every proposal.
• Move discretionary spending, such as new software or a planned hire, to a week with more headroom.
• Talk to suppliers early if you need more time. Most prefer an early conversation to a late payment.
• If you are considering borrowing, take the forecast to your accountant and your bank before you need the money, not after.

Each of these is general good practice. The right mix for your business depends on your contracts, your clients and your tax position, which is a conversation to have with your accountant.

Start your cash flow forecast this week

You do not need new software to begin. A spreadsheet with thirteen columns is enough, and a rough first version this week beats a perfect one next quarter.

1. Monday: write down your cleared bank balance and your minimum cash line.
2. Tuesday: list every unpaid invoice and the week you honestly expect it to be paid.
3. Wednesday: list every payment due in the next thirteen weeks, including tax and annual renewals.
4. Thursday: calculate the weekly closing balances and highlight any week below your line.
5. Friday: choose one action for each highlighted week and book a weekly thirty minute review in the diary.

If the exercise raises bigger questions about pricing, payment terms or which work to keep, the cash problem is usually a symptom rather than the cause. The Diagnostic looks at commercial performance, operations, positioning and visibility together, so you can see what is really driving the numbers.

You can see how we work across our services, or book a thirty minute consult to talk through what your forecast is telling you.

Ready to find the real cause and a clear next step? Book a thirty minute consult with AD Consults. If the work is not right for you, we will say so on the call.

Frequently asked questions

Ayse Durmush

Thirty years in business and marketing strategy, across Google, Samsung, Apple, Virgin and LEGO, and over a thousand independent businesses advised through NatWest.

All articles by Ayse