A cash flow forecast predicts the cash coming into and going out of your business over a set period, and the bank balance that leaves you with. You build one by choosing a period, listing income and outgoings in the periods the cash actually moves, and carrying a running balance forward. Update it as real figures arrive.
At a glance
- What it predicts
- Cash going out of the business and coming back in over a specific period
- British Business Bank method
- 4 steps: period, income, outgoings, running cash flow
- Minimum period
- At least as long as your cash flow cycle
- ICAEW starting point
- The next three months
- Weekly forecasts in a turnaround
- Often 13 weeks, rolling
- Start Up Loans application
- A 12-month cash flow forecast is required
What is a cash flow forecast?
A cash flow forecast is a prediction of the cash coming into and going out of your business over a set period, usually week by week or month by month, and the bank balance that leaves at the end of each one. It shows a shortfall before it happens, while there is still time to act.
The British Business Bank uses much the same definition, and describes cash flow itself as the movement of cash into and out of a business. The point is the bank balance at the end of each week or month. A forecast shows whether there will be enough in the account on the day wages, suppliers, rent and tax fall due, while there is still time to do something about a gap.
This post is general guidance drawn from the sources listed below. Capzy is a credit broker and does not give tax or accounting advice. Your accountant can build or review a forecast from your own figures.
What goes into a cash flow forecast?
Three things go in: the cash you expect to receive, the cash you expect to pay out, and a running balance. Each item is recorded in the period the money actually reaches or leaves the bank account, not when the invoice is raised.
- Cash in: sales receipts, plus non-sales income such as tax refunds, grants, money put in by owners or shareholders, and any loan you draw.
- Cash out: rent, wages, materials and supplier costs, marketing, equipment, loan repayments and tax bills.
- Irregular items: payments that do not fall every month, such as a quarterly VAT bill, are easy to miss and belong in the period they are paid.
ICAEW’s Business Finance Guide suggests testing the inputs with a few questions: how long customers take on average to pay, how long you take to pay suppliers, how much stock you need to hold, when rent is due, and what you will spend on PAYE, VAT and loan repayments. Those timings are also what drive your working capital.
How do you build a cash flow forecast?
You build a cash flow forecast by choosing a period, listing the income and outgoings for each part of it, and working out a running balance. The British Business Bank sets this out as four steps; with a starting balance and a review added, it looks like this:
- Decide the period. It should be at least as long as your cash flow cycle, which can be anything from a few weeks to many months.
- Start with the opening balance. Use the cash actually in the business bank account at the start of the first period.
- List all income. Enter sales in the period you expect to be paid, then add any non-sales income.
- List all outgoings. Include every regular cost, then the irregular ones: tax bills, annual renewals and equipment.
- Work out the running cash flow. Take outgoings from income for each period, add the result to the opening balance, and carry the closing balance forward.
- Update it. Replace forecast figures with actual ones as they arrive, and revisit your assumptions when the business changes.
A spreadsheet with one column for each period is enough. The structure matters more than the tool. If you would rather not start from a blank sheet, Start Up Loans publishes a free cash flow forecast template, listed in the sources at the end of this guide.
What does a simple cash flow forecast look like?
A simple forecast is a table with a column for each period and rows for the opening balance, cash in, cash out, net cash flow and closing balance. The numbers below are made up for illustration only and are not typical figures for any business.
| Feature | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Opening balance | £20,000 | £25,000 | £10,000 |
| Cash in | £50,000 | £40,000 | £60,000 |
| Cash out | £45,000 | £55,000 | £50,000 |
| Net cash flow | +£5,000 | −£15,000 | +£10,000 |
| Closing balance | £25,000 | £10,000 | £20,000 |
In this illustration month 2 includes a quarterly tax payment, so more cash leaves than arrives and the balance falls. Over the three months the business ends where it started, yet a total alone would hide the dip. Seeing it in advance is the reason to forecast period by period.
How do you stress-test a cash flow forecast?
Run the same forecast again with one thing going wrong, and watch the closing balance. The most useful test for most businesses is a large customer paying late, because that is the shock that arrives without warning.
Take the illustration above and suppose £15,000 of month 2’s receipts comes from one customer who pays 30 days late. The figures are again invented for illustration.
| Feature | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Opening balance | £20,000 | £25,000 | −£5,000 |
| Cash in | £50,000 | £25,000 | £75,000 |
| Cash out | £45,000 | £55,000 | £50,000 |
| Net cash flow | +£5,000 | −£30,000 | +£25,000 |
| Closing balance | £25,000 | −£5,000 | £20,000 |
Nothing about the business has changed: the same sales, the same costs, the same position after three months. But for one month the account is £5,000 overdrawn, in the month the quarterly tax bill falls due. That is the gap a forecast exists to find. You might cover it by chasing the customer early, agreeing later terms with a supplier, or arranging a business overdraft before you need it rather than after. If gaps like this keep appearing, our guide to cash flow problems looks at the usual causes.
Other tests worth running: sales 10% or 20% lower than planned, a cost that rises, or a month with no new orders. If the balance stays positive in every version, you have headroom. If it does not, you know which assumption to watch.
How far ahead should a cash flow forecast look?
There is no single correct length: the published guidance gives different horizons for different purposes. ICAEW’s advice is to set forecast horizons that are relevant to your business, with a level of detail to match each one.
| Source | Horizon | Context |
|---|---|---|
| British Business Bank | At least as long as your cash flow cycle | Anything from a few weeks to many months |
| ICAEW Business Finance Guide | The next three months | A starting point for a business beginning to forecast |
| ICAEW | 13 weeks, weekly and rolling | Often used in turnarounds, where cash is tight |
| Start Up Loans | 12 months | Required with an application, alongside a business plan and personal survival budget |
Many businesses keep a detailed short-term view and a broader monthly one. If you are applying for finance, ask what period and format that lender wants before you build it.
Which tax dates belong in a cash flow forecast?
Every tax payment belongs in the forecast in the month it leaves the bank, because tax is the outgoing most often left out. The rules below come from GOV.UK and fix the timing.
| Payment | When it falls due |
|---|---|
| VAT | Usually one calendar month and 7 days after the VAT accounting period ends |
| Corporation Tax | 9 months and 1 day after the accounting period ends, for taxable profits up to £1.5 million |
| PAYE | By the 22nd of the month, or the 19th if paying by post |
| Self Assessment | 31 January, with a second payment on 31 July if you make payments on account |
Sole traders and partners should check whether they make payments on account, because the first year can bring a bill for the balance and the first advance payment on the same day. Our page of UK tax year dates lists the filing deadlines that sit alongside these.
How is a cash flow forecast different from a budget or a profit and loss account?
A cash flow forecast tracks when cash moves, a budget sets out what you plan to earn and spend, and a profit and loss account shows income and costs for a period whether or not the cash has moved yet.
The difference is timing. A sale invoiced this month counts in this month’s profit, but the cash may not arrive until the customer pays. Stock bought ahead of a busy season leaves the bank before any of it is sold. A business can be profitable on paper and still run short of cash, which is why the forecast sits alongside the accounts and does not replace them.
A cash flow statement is different again. It is part of a set of accounts and records the cash that has already moved in a past period. The forecast looks forward; the statement looks back. Comparing the two each month is how you find out which of your assumptions were wrong.
A forecast also pairs well with a break-even point calculation: break-even tells you how much you need to sell to cover costs, and the forecast tells you whether the cash from those sales arrives in time.
How do you forecast cash flow for a new business with no history?
Without past figures, every line is an assumption, so write the assumption down next to the number. A Start Up Loans application asks for a 12-month cash flow forecast alongside a business plan and a personal survival budget, which makes it a useful model even if you are not applying.
- Base sales on something you can point to: quotes, pre-orders, a signed contract or the trading of a similar business, and build up slowly from month 1.
- Put start-up costs in the month you pay them, not spread across the year.
- Assume customers pay later than you hope. For business customers, use the payment terms you will actually offer.
- Include your own drawings or salary, because the business has to fund them.
Then compare the forecast with what really happens each month. A new business learns more from the first three months of actual figures than from any amount of planning.
What do lenders look for in a cash flow forecast?
In general, a lender reads a forecast to judge whether the business can meet repayments in each period, not just across the year. What each lender asks for varies, so treat this list as general practice and not as any lender’s criteria.
- Figures that add up: opening balance, plus cash in, less cash out, equals closing balance in every period
- Assumptions that tie back to your bank statements and accounts, with any expected growth explained
- Tax, payroll and existing debt repayments shown in the periods they fall due
- The new facility shown as cash in when you expect to draw it, and its repayments as cash out afterwards
- Seasonal peaks and dips shown as they happen, not averaged flat
A forecast is one part of an application. Lenders also look at credit history, accounts and security, and a decision is always subject to status and lender criteria. Our guide on how to compare business lenders covers the questions to ask about an offer.
What are the common mistakes in a cash flow forecast?
The most common mistake is entering sales when they are invoiced and not when they are paid. A forecast built that way shows cash you do not yet have.
- Assuming every customer pays on time. Even without agreed terms, GOV.UK says a business payment only becomes late 30 days after the customer gets the invoice.
- Leaving out irregular outgoings such as VAT, Corporation Tax and annual renewals
- Averaging a seasonal business into equal months
- Being detailed on sales and vague on costs
- Building it once and never updating it with actual figures
It also helps to test a worse case, for example lower sales or slower payment, and see whether the closing balance stays positive. If slow-paying customers are the cause of a gap, invoice finance is one way some businesses release cash from unpaid invoices, at a cost and subject to status and lender criteria.
It will be wrong in places. The value is in spotting a shortfall early and in knowing which assumption caused it.
Your forecast shows a gap: can Capzy help?
If the forecast shows a shortfall you cannot close by timing alone, we can introduce you to lenders, and your forecast is one of the first things a good application uses. Capzy is a credit broker, not a lender, and the lender pays us, not you. We do not prepare forecasts or accounts, and we do not give tax or accounting advice.
To see what funding might be available, you can check your funding options with a soft search that does not affect your credit score. A full application to a lender may involve a hard search, and any offer is subject to status and lender criteria.
Sources
- How to create a cash flow forecast in 4 steps, British Business Bank
- Business finance glossary, British Business Bank
- Cash flow forecast template, Start Up Loans
- Business Finance Guide: cash flow forecasts and inventory, ICAEW
- Nine principles for finance professionals, ICAEW
- Send a VAT Return, GOV.UK
- Pay your Corporation Tax bill, GOV.UK
- Running payroll: paying HMRC, GOV.UK
- Self Assessment tax returns: deadlines, GOV.UK
- Late commercial payments: charging interest and debt recovery, GOV.UK
- Invoice finance, British Business Bank
Capzy is a credit broker, not a lender. We get paid by the lender. This page is general information, not financial, tax or legal advice. Finance is subject to status, lender criteria and affordability; rates and terms depend on your circumstances.
