A cash flow forecast shows the money you expect in and out of your business bank account. You set it out week by week or month by month. Each column ends with a closing balance. So you can spot a cash gap weeks before it happens.
This guide shows how to do a cash flow forecast in seven steps. It covers the 13-week and the 12-month view and the UK tax dates to add. It ends with a worked example, a template layout and the common mistakes.
What is a cash flow forecast?
A cash flow forecast is a plan of the cash you expect in and out over a set period. It starts from your bank balance on day one. It shows a closing balance for each week or month. A low or negative balance warns you before the money runs out.
It tracks cash, not profit. A sale counts on the day the customer pays, not the day you send the invoice. The British Business Bank’s guide on how to create a cash flow forecast says the same. You put in figures for when clients will pay.
Profit and cash can move apart. A business can make a profit over the year and still run short in one month. A big customer pays late, or a tax bill lands in that month.
A forecast looks ahead. A cash flow statement looks back at what already happened. A budget is different again, because it’s a fixed target. Our guide to budget vs forecast shows how the two differ.
Should you plan 13 weeks or 12 months ahead?
Use a 13-week cash flow forecast to run the business week by week. Use a 12-month forecast for a loan, a business plan or a big decision. You can keep both. The 13-week view rolls forward each week, and the 12-month view gets a monthly update.
| 13-week forecast | 12-month forecast | |
|---|---|---|
| Columns | 13 weeks | 12 months |
| Detail | Each customer payment and each bill | Monthly totals for each line |
| Main use | Day-to-day cash and the next tight week | Loans, business plans, hiring and big buys |
| Tax dates it shows | Every VAT and PAYE date in the next quarter | A full year of VAT and PAYE, plus Corporation Tax or Self Assessment |
| Update | Every week. Drop the past week and add a new one | Every month, against your real figures |
Thirteen weeks is 91 days, one full quarter. So a 13 week cash flow forecast sees every tax date in the next quarter.
A 12 month cash flow forecast shows the bigger bills. Start Up Loans asks for a 12-month cash flow forecast with every loan application. Start Up Loans is part of the British Business Bank, a development bank owned by the government.
The British Business Bank advises you to plan at least as far ahead as your cash flow cycle. That cycle is the time cash takes to leave your business and come back in. A new business has little history, so its forecast gets less accurate further out. Start short and extend it as real figures come in.
A 12-month forecast is one part of small business financial planning. The other parts are a budget, profit targets and a plan for funding.
How do you build a cash flow forecast step by step?
Pick your period and set one column per week or month, then enter your opening bank balance. List cash in on the date it reaches the bank. List cash out on the date it leaves, tax included. Then work out the net cash flow and closing balance for each column.
Step 1: Choose the period and the columns
Set one column per week for a 13-week forecast, or one per month for 12 months. Add one row for each type of cash in and each type of cash out. A spreadsheet is enough. Set the formulas once, and the totals change when you change a figure.
Step 2: Enter your opening bank balance
Start from the real balance in your business bank account on day one. Add any cash in hand and any other business accounts. Check the figure against your books first with a bank reconciliation. It shows payments still on their way and bank charges you haven’t recorded.
Step 3: List cash in on the date the money arrives
Enter each receipt in the week or month the money lands, not the invoice date. Use each customer’s real habits. Say a customer has 30-day terms but always pays in 45 days. Enter that money at 45 days.
Say you agreed no payment date with a customer. UK law then treats a business payment as late 30 days after the customer gets the invoice. If you deliver later than that, the 30 days run from delivery. See the gov.uk rules on late commercial payments.
Add income from outside sales too. The British Business Bank lists tax refunds, grants, money from owners or shareholders, and royalties or licence fees. A new loan counts in the week the lender pays it out.
Step 4: List cash out on the date it leaves
Enter every payment in the week it leaves your account. Start with fixed costs such as rent, insurance and loan repayments. Then add costs that move with sales, such as stock, materials and card fees.
Put in your own pay. Start Up Loans tells owners to include the salary they need from the business. Drawings and dividends leave the bank too, so they go in as cash out.
Wages go in at their take-home amount on payday. The Income Tax and National Insurance you deduct go to HMRC later. They belong in Step 5.
Step 5: Add your tax payments on their due dates
Each tax bill has a fixed due date. Put each one in the column of its due date, not the month you earned the money. The next section lists the UK dates.
Step 6: Work out net cash flow and the closing balance
Net cash flow is total cash in minus total cash out. The closing balance is the opening balance plus net cash flow. Each closing balance becomes the next column’s opening balance.
A negative closing balance means the account runs dry unless you act. Find the first week the balance drops low. That week is your action date.
Step 7: Check it against real figures and roll it forward
At the end of each week, put the real figures next to the forecast. Find out why each big gap happened, then fix the assumption behind it. Drop the past week and add a new week 13 at the end. That habit turns it into a rolling cash flow forecast.
Which UK tax payments go in your forecast?
Enter each tax bill on its due date. VAT is usually due 1 month and 7 days after each period. Monthly PAYE is due by the 22nd of the next tax month. A company with profits up to £1.5 million pays Corporation Tax 9 months and 1 day after its accounting period.
| Tax | Who pays it | When the cash leaves |
|---|---|---|
| VAT | VAT-registered businesses | Usually 1 calendar month and 7 days after each VAT period ends. Most periods are 3 months |
| PAYE (tax and National Insurance from payroll) | Employers | By the 22nd of the next tax month if you pay monthly. A cheque by post must reach HMRC by the 19th |
| PAYE, quarterly payers | Employers who pay HMRC quarterly | By the 22nd after the quarter ends, for example 22 July for the 6 April to 5 July quarter |
| Corporation Tax | Limited companies with taxable profits up to £1.5 million | 9 months and 1 day after the end of the accounting period |
| Self Assessment | Sole traders and partners | Payments on account by 31 January and 31 July. Any balancing payment by 31 January |
VAT needs care on the cash in line. Your customers pay the VAT to you along with the price. Enter receipts with VAT included, then show the VAT bill as cash out on its due date. HMRC sets the VAT Return deadline, and the payment must reach HMRC by the same date.
The PAYE bill can include the Income Tax you deducted from staff pay, Class 1 National Insurance and CIS deductions. HMRC lists what goes into it on its page to pay employers’ PAYE. For the payroll side, read our guide to PAYE for employers.
Corporation Tax comes once a year, so a 13-week view often misses it. A company with a 31 December year end pays by 1 October the next year. See gov.uk to pay your Corporation Tax bill. Keep it in the 12-month forecast and save towards it each month.
Each Self Assessment payment on account is half of the tax you owed last year. You don’t make them if that tax was less than £1,000. HMRC lists one other exception too.
HMRC explains payments on account in full. 31 January is also the deadline for an online tax return. Paper returns are due earlier, so check when Self Assessment is due.
Cash flow forecast example: a 13-week view
Here’s a cash flow forecast example for a small VAT-registered company with staff on payroll. The forecast starts on 1 April. Its VAT quarter ended on 31 March, so the VAT bill is due on 7 May. PAYE is due on the 22nd, staff get paid on the 28th and rent goes out on the 1st.
The company opens with £4,000 in the bank. Customers normally pay £5,000 a week, VAT included. Regular costs run at £2,500 a week. The figures are for illustration only.
One customer pays £3,000 a week late. So week 3 drops to £2,000 and week 4 rises to £8,000.
| Week | Dates | Opening | Cash in | Cash out | Closing | Big payments that week |
|---|---|---|---|---|---|---|
| 1 | 1-7 April | £4,000 | £5,000 | £4,000 | £5,000 | Rent £1,500 |
| 2 | 8-14 April | £5,000 | £5,000 | £2,500 | £7,500 | None |
| 3 | 15-21 April | £7,500 | £2,000 | £2,500 | £7,000 | None. A customer pays late |
| 4 | 22-28 April | £7,000 | £8,000 | £10,500 | £4,500 | PAYE £2,000, net wages £6,000 |
| 5 | 29 April-5 May | £4,500 | £5,000 | £4,000 | £5,500 | Rent £1,500 |
| 6 | 6-12 May | £5,500 | £5,000 | £7,000 | £3,500 | VAT £4,500 |
| 7 | 13-19 May | £3,500 | £5,000 | £2,500 | £6,000 | None |
| 8 | 20-26 May | £6,000 | £5,000 | £4,500 | £6,500 | PAYE £2,000 |
| 9 | 27 May-2 June | £6,500 | £5,000 | £10,000 | £1,500 | Net wages £6,000, rent £1,500 |
| 10 | 3-9 June | £1,500 | £5,000 | £2,500 | £4,000 | None |
| 11 | 10-16 June | £4,000 | £5,000 | £2,500 | £6,500 | None |
| 12 | 17-23 June | £6,500 | £5,000 | £4,500 | £7,000 | PAYE £2,000 |
| 13 | 24-30 June | £7,000 | £5,000 | £8,500 | £3,500 | Net wages £6,000 |
| Total | 13 weeks | £4,000 | £65,000 | £65,500 | £3,500 |
Cash out in every row includes the £2,500 of regular costs. The big payments column shows what comes on top.
Week 9 is the danger week. Wages and rent leave together, and the balance falls to £1,500. One late £5,000 customer payment that week would take the account £3,500 overdrawn.
The owner sees this eight weeks ahead. There’s time to chase week 9’s receipts early or ask the landlord to move the rent date. An overdraft agreed in advance is another option.
Over the 13 weeks, cash in is £65,000 and cash out is £65,500. Net cash flow is minus £500. So the closing balance is £3,500, which is £500 below the opening £4,000.
The next VAT bill, for April to June, is due on 7 August. That’s after week 13. The forecast picks it up as it rolls forward.
A cash flow forecast template you can copy
Set up your cash flow forecast template with the rows below. Add one column per week or month, plus a total column.
| Row | What goes in it |
|---|---|
| Opening balance | The bank balance on day one, then each column’s previous closing balance |
| Customer receipts | Sales cash, VAT included, in the week the customer pays |
| Other cash in | Grants, tax refunds, loan money paid out to you, money the owners put in |
| Total cash in | The sum of the cash in rows |
| Suppliers and stock | Each bill on the date you’ll pay it |
| Rent, insurance and software | Fixed costs on their payment dates |
| Net wages | Take-home pay on payday |
| PAYE and National Insurance | By the 22nd of the next tax month |
| VAT | Usually 1 month and 7 days after each VAT period ends |
| Corporation Tax or Self Assessment | On its due date |
| Loan repayments and owner pay | Repayments, salary you draw, drawings or dividends |
| Total cash out | The sum of the cash out rows |
| Net cash flow | Total cash in minus total cash out |
| Closing balance | Opening balance plus net cash flow |
What mistakes make a forecast go wrong?
The common mistakes are timing mistakes. Owners enter sales on the invoice date, spend the VAT they collected or forget a tax bill. Some leave out their own pay or never update the forecast. Each one makes the closing balance look healthier than the real one.
- Using invoice dates. Cash counts when it reaches the bank, so enter each receipt on the day you expect the money.
- Treating VAT as yours. Part of each receipt belongs to HMRC, and the VAT bill comes due every period.
- Missing bills outside the window. Corporation Tax on profits up to £1.5 million is due 9 months and 1 day after your year end. So a 13-week forecast often won’t show it. The 12-month forecast must.
- Leaving out your own pay. Start Up Loans says to include the minimum salary you need from the business as a cost.
- Forecasting every month like your best month. Start Up Loans advises conservative sales estimates and planning for quiet and busy periods.
- Never updating it. The British Business Bank says to update your forecast as often as you can.
Cash flow forecasting needs up-to-date books. A forecast built on books three months behind starts from the wrong balance.
When should you get help from an accountant?
Get help when a lender asks for a forecast, or when your closing balance goes negative. Get help when big tax bills meet a growth plan too. The British Business Bank says it’s best to get advice from a qualified accountant first. An accountant may spot gaps you missed.
A loan application is one trigger. Start Up Loans needs a 12-month cash flow forecast with every application.
A negative week is another trigger. The forecast shows the gap, but it doesn’t close it. An accountant can check the dates and the figures, then help you plan the fix.
Growth needs cash first. New staff and stock leave the bank before the extra sales come in. A second pair of eyes on the 12-month forecast shows whether you can fund the gap.
DASA’s business planning work includes cash-flow forecasting and budgeting, with month-by-month figures. Optional quarterly review sessions are part of the offer. Most plans take 7-14 working days.
FAQs
Is a cash flow forecast the same as a cash flow statement?
No. A cash flow forecast looks forward and estimates the cash you’ll receive and pay. A cash flow statement looks back at the cash that moved in a past period. You check last month’s forecast against the statement, and you plan the next weeks with the forecast.
Can you do a cash flow forecast in Excel?
Yes, a spreadsheet works for a small business forecast. Put one column per week or month and one row per type of cash in or out. Add formulas for the totals, net cash flow and closing balance. Then a changed figure updates the whole forecast at once.
Should a cash flow forecast include VAT?
Yes, for a VAT-registered business. Enter customer receipts and supplier payments with VAT included, because that’s the cash that moves. Then enter each VAT bill as cash out on its due date. That shows the true bank balance on each day of the forecast.
What is a rolling cash flow forecast?
A rolling cash flow forecast always looks the same distance ahead. At the end of each week, you drop the week just gone and add a new week at the end. A 13-week rolling forecast always shows the next quarter. A 12-month rolling forecast adds a new month instead.
Get help with your forecast
A forecast works best with clean books and every tax date in place. Bring your bank balance, your customer payment habits and your tax dates. Ask us about a rolling cash flow forecast with month-by-month figures, plus optional quarterly reviews. Talk to us about DASA’s business planning service.
This article gives general information for UK small businesses. It isn’t tax, financial or legal advice. Speak to a qualified accountant or tax adviser about your own situation. Check the current rules with HMRC before you act.
Last reviewed November 2026 by Raqeeb Marzook ACCA, Manager at DASA Accountancy, who also wrote this article.
