Cash flow forecasting made simple: a one-page plan

Profitable businesses can still run out of cash. A simple cash flow forecast shows you what's coming, so you can act before it's a problem.

Why 13 weeks?

Thirteen weeks is a quarter. It's long enough to spot problems and short enough to be accurate. It also covers a VAT quarter and the main tax dates.

Set it up

In a spreadsheet, put weeks across the top and these rows down the side:

  • Opening bank balance

  • Money in: customer payments, other income, VAT refunds

  • Money out: wages, rent, suppliers, loan repayments, VAT, PAYE, Corporation Tax or Self Assessment, your own drawings

  • Net cash flow for the week

  • Closing balance, which becomes next week's opening balance

Fill it in

  • Start with today's real bank balance

  • Enter money in when you expect to receive it, not when you invoice

  • Put in fixed costs first, then variable costs

  • Don't forget the big, irregular payments, like insurance, annual software and tax bills

Use it every week

Each week, replace the forecast with what actually happened and add a new week at the end. It takes 15 minutes once it's set up.

Warning signs

  • The closing balance dips below zero, or below a safety buffer

  • Customers are paying later than you'd planned

  • Tax bills land in the same week as other big costs

What to do if cash looks tight

  • Chase overdue invoices and offer easy ways to pay

  • Agree payment terms with suppliers

  • Delay non-essential spending

  • Talk to HMRC early about Time to Pay if a tax bill is the problem

  • Speak to your bank before you need an overdraft

Your software can help

Xero, QuickBooks and FreeAgent all have cash flow tools that use your real invoices and bills.

Related reads

How Arvo can help

We can build a cash flow forecast for your business, show you how to keep it up to date and help you plan for tax bills.

Get in touch to arrange a free, no-obligation chat, or call us on 01207 261100.

Previous
Previous

When a customer won't pay: bad debts and getting your VAT back

Next
Next

Started a business since April 2024? Tell HMRC by 5 October