Why a 13 week forecast works when budgets fail.

Annual budgets are useful for setting direction, but they rarely show the timing of cash movements. A 13 week cash flow forecast focuses on the question that matters most when cash is under pressure:

What will our bank balance be each week, and what needs to happen to keep it healthy?

It is short enough to remain accurate, yet long enough to give you time to act before a cash issue becomes a crisis.

For UK SMEs, this approach is particularly valuable because many cash flow pressures are predictable. Payroll dates, VAT quarters, late paying customers, supplier payment terms, and one off HMRC or insurance payments all follow patterns. When you can see these in advance, you move from reacting to managing.

What you’ll need (10 minutes)

Before you build your forecast, gather the information below so it reflects reality rather than assumptions.

• Your current bank balance as your opening cash position.
• A list of invoices or predicted sales you expect to be paid over the next 13 weeks, using realistic payment dates.
• Your regular outgoings, including payroll, rent, software subscriptions, loan repayments and insurance.
• Supplier payments that are already due or expected based on your purchasing cycle.
• Your VAT quarter end and payment due date, if you are VAT registered.
• Any significant one off payments, such as corporation tax, annual subscriptions or bonus payments.

The simple structure (what the spreadsheet should look like)

Keep it simple. Simple is dependable.

Your spreadsheet should contain columns for Week 1 through to Week 13, each showing the relevant week commencing date.

Group your rows as follows:

• Opening cash
• Cash received
• Cash paid
• Net movement
• Closing cash, which then becomes the following week’s opening cash.
• To make the forecast even more practical, add two extra columns on the right.
• Owner, showing who is responsible for managing or following up each item.
• Confidence, rated as High, Medium or Low.

Step by step: build it in 45 to 60 minutes.

Step 1: Set the weekly dates and opening cash.

• Use week commencing Monday dates, or whichever day your business uses to begin the week.
• Enter today’s bank balance as the opening cash balance for Week 1.
• Set the spreadsheet so that Week 1 closing cash automatically becomes Week 2 opening cash.

Step 2: Add cash received (only when money reaches the bank)

This is where many forecasts become unrealistic. Do not record income in the week it is earned. Record it in the week you genuinely expect to receive payment.

If you are accepting card sales, consider the delay between customer placing an order and when you receive the payout from the payment gateway or platform such as Stripe, Square, Shopify, Klarna or TikTok. Also consider the fees such platforms deduct before you receive the payout.

Include the following cash receipts.

• Customer payments, either by key customer or grouped together.
• Subscription income where receipts are predictable.
• VAT refunds where applicable.
• Grants or Research and Development tax credits, but only where the timing is realistic.
• Loan drawdowns or investment funding, but only where these have been formally agreed.

A simple rule applies. If you would not rely on the payment to meet payroll, mark it as Low confidence.

Step 3: Add cash paid (using the actual payment dates)

Cash payments are generally easier to forecast because you have greater control over them.

Include the following.

• Payroll, including employer costs if they leave the bank separately.
• VAT payments in the correct week.
• Rent, business rates and utilities.
• Software subscriptions.
• Marketing expenditure.
• Supplier payments, with key suppliers listed separately where appropriate.
• Loan repayments and interest.
• Tax payments, including corporation tax and PAYE or National Insurance where these are not already included.
• One off costs such as insurance, annual renewals and equipment purchases.

Step 4: Add control levers so the forecast drives action.

This is what turns a spreadsheet into a practical management tool.

For every significant payment, decide whether it is:

• Fixed, meaning it cannot realistically change, such as payroll or VAT.
• Controllable, meaning the timing could be adjusted, such as supplier payments or discretionary spending.
• Accelerated, meaning cash could be brought forward through improved collections, deposits or milestone billing.

When you identify a future cash shortfall, you will immediately know which actions are genuinely available.

Step 5: Add thresholds and alerts.

Set two cash thresholds that act as clear warning levels.

• Your minimum operating buffer, for example one month’s payroll.
• Your critical threshold, which signals that immediate action is required.
• Apply simple conditional formatting to the closing cash balance.
• Green indicates a comfortable position.
• Amber signals that closer attention is needed.
• Red means action is required during that week.

The don’t get caught out section.

VAT: ringfence it mentally or physically

One of the most common mistakes is treating VAT held in the bank as available cash.

If you are VAT registered, include VAT payments in the exact weeks they are due and treat that money as unavailable. Where possible, transfer VAT into a separate account each week so it cannot be spent unintentionally.

Payment terms: forecast reality, not contract terms.

If your standard terms are 30 days but customers consistently pay after 45 to 60 days, forecast 45 to 60 days. Optimism does not improve cash flow. Better processes do.

Payroll: include the full employment cost

If you only include net salaries and overlook pensions, employer National Insurance or payroll timing, your forecast will regularly be inaccurate. Even if you keep the model straightforward, ensure payroll reflects the actual dates money leaves the bank.

Weekly operating rhythm (the part that keeps it accurate)

A 13 week forecast only delivers value when it becomes part of your weekly routine.

Weekly update checklist (30 minutes)

1. Replace last week’s forecast with the actual movements shown in the bank account.
2. Update expected payment dates for your largest customer invoices using the latest information.
3. Review outstanding receivables and identify which customers need to be contacted this week.
4. Confirm upcoming supplier payments and review any discretionary spending.
5. Check VAT, tax deadlines and any significant one off payments.
6. Agree between one and three actions that will protect cash over the next four weeks.

Weekly meeting agenda (15 minutes)

• What has changed since last week?
• When is the lowest cash point over the next four to six weeks?
• What actions are we taking, and who is responsible for each one?

How to use it to make decisions, not just report

Once your forecast is established, it becomes a practical decision making tool.

• Hiring: If the forecast shows cash falling below your minimum buffer, consider delaying recruitment or using temporary or contract support.
• Collections: If Week 6 shows a cash shortfall, the action belongs in Week 1 or Week 2, not Week 6. Follow up outstanding payments early.
• Supplier management: If a large VAT payment or annual renewal is approaching, plan supplier payments around those commitments.
• Pricing and billing: Deposits, milestone billing and annual upfront payments can all reduce pressure on working capital.

Taking up too much of your time? We can help.

If you want a reliable cash forecasting process without spending hours maintaining it every week, we can help.

Our Outsourced Finance Team can manage the weekly cash routine, improve your collections process and provide a straightforward forecast on which you can rely. We even connect your cash forecast to your accounting system, so your forecast reflects the actual sales invoices and bills, and when they expect to be paid.

Where additional strategic support is needed, our Fractional CFO service connects cash forecasting with hiring, pricing and growth decisions, helping you remain in control as your business grows.

Book a discovery call and we’ll show you exactly what to build, what to monitor and the quickest way to achieve reliable cash visibility within the next two weeks.

FAQ

What’s the difference between a cash flow forecast and a budget?

A budget and a cash flow forecast serve very different purposes. A budget outlines what a company intends to achieve, serving as a fixed financial plan and performance target. It’s your roadmap of what you want to happen. It acts as strict guardrails for resources allocation and accountability. 

A forecast estimates what is likely to happen based on real-time data and current trends. It’s your GPS showing you what is most likely to happen based on reality. Forecasts are frequently revised on a rolling basis as conditions change. 

How accurate should my 13 week forecast be?

It should be accurate enough to identify issues before they become serious. If it is updated every week and broadly reflects reality, its accuracy will improve over time and continue to provide valuable early warning.

Should I forecast using invoices or expected payments?

Use expected payments rather than invoice dates. Your forecast should reflect actual cash movements based on customer payment behaviour and agreed terms.

How do I handle VAT in the forecast?

Include VAT payments as separate cash outflows in the weeks they are due. Where possible, set VAT funds aside internally so they are not accidentally used for day to day spending.

What’s the biggest mistake founders make with 13 week forecasts?

The two biggest mistakes are failing to update the forecast every week and being too optimistic about customer payments. The forecast only works when it reflects reality and becomes part of your regular routine.

Do I need special software?

No. A simple spreadsheet is perfectly adequate. A consistent process will always deliver more value than sophisticated software used inconsistently.