A 13-week cash flow forecast lists, week by week, the cash you expect to receive, the cash you expect to pay out and the balance left in the bank at the end of each week. It is the first thing a finance director builds when cash is tight, and it is the tool we would want every owner-managed business turning over £1m or more to keep every week, tight or not.
Thirteen weeks is one quarter. It covers three payrolls, three PAYE payments, a VAT payment and the run of customer receipts that pays for them. It is short enough to forecast invoice by invoice, and long enough to see a problem while there is still time to do something about it.
The free 13-week cash flow template follows the same layout as this playbook. Open it alongside and fill it in as you go.
Why weekly figures matter
A 12-month forecast works in months. It shows the balance on the last day of each month, and that is the right tool for the year's plan, the budget and a conversation with the bank. It hides what happens inside the month. Payroll goes out at the end of the month, PAYE and pensions on the 22nd, VAT on the 7th and customers pay when they pay. A business can end every month with £50,000 in the bank and still go overdrawn for a week in the middle.
The 13-week forecast finds that week. Keep the 12-month forecast for the year and use the 13-week forecast to run the next quarter. The guide to cash flow forecasting covers the 12-month version.
What you need before you start
Gather these before you open the spreadsheet. With them to hand, the first version takes two to three hours. Each update after that takes under an hour.
- Today's cleared balance on every bank account, taken from the bank's own website, and the overdraft limit
- The aged debtors report from Xero or your accounts software, showing every unpaid sales invoice and its due date
- The aged creditors report, showing every unpaid supplier invoice
- The last payroll summary, split into net pay, PAYE and National Insurance, and pension contributions, with the paydays for the next three months
- Your VAT quarter dates and the amount on the return being prepared
- Loan, hire purchase and lease schedules, with the date and amount of each repayment
- Your Corporation Tax due date and the amount, if it falls in the next 13 weeks
- Three months of bank statements, to find every direct debit, standing order and card payment
- Any one-off payments you know about: equipment, a dividend, bonuses, an insurance renewal
1. Start from the cleared bank balance
Take the opening balance from the bank's website on the Monday morning. The balance in Xero can include payments you have entered that the bank has not yet sent, and receipts you have recorded that have not yet cleared. The forecast starts from the money the bank will let you spend today.
Add every account the business uses for trading: the current account, any second current account, the savings account you move VAT into, and the balance waiting in a card terminal or payment provider. Record the overdraft limit on its own line. The closing balance plus the overdraft limit gives the headroom, the most you could pay out before the bank refuses a payment.
2. Forecast receipts customer by customer
Receipts are the hardest line to forecast and the largest. Work from the aged debtors report. For each invoice over a few thousand pounds, put the amount in the week you expect the customer to pay, based on how that customer has paid over the last six months. A customer on 30-day terms who pays in 52 days goes in at 52 days.
Group the small invoices together and spread them using your average debtor days. The debtor days calculator works that figure out. For weeks 5 to 13, most of the receipts come from sales you have not yet invoiced. Take the sales you expect each week from the order book or the budget, and move them forward by your debtor days.
Be cautious with receipts and complete with payments. A forecast that assumes every customer pays on time will be wrong in the same direction every week, and it will show you a better position than the one you are in.
Record whether each figure includes VAT. Customers pay you the VAT on their invoices, so receipts go in at the gross amount. The VAT then leaves on its own line when the return is paid.
3. Put payroll and the taxes in their weeks
Payroll and tax are the largest fixed payments in the quarter, and the dates are set by law. Put each one in the week it leaves the bank.
| Payment | When it leaves the bank |
|---|---|
| Net pay | On payday. The Full Payment Submission goes to HMRC on or before payday. |
| PAYE and National Insurance | By the 22nd of the next tax month when paid electronically. A tax month runs from the 6th to the 5th. |
| Pension contributions taken from pay | By the 22nd of the month after the deduction, or an earlier date agreed with the scheme. |
| VAT | One calendar month and 7 days after the end of the VAT quarter. Weekends and bank holidays do not move the date. A Direct Debit is collected 3 working days after the deadline. |
| Corporation Tax | 9 months and 1 day after the end of the accounting period, for a company with taxable profits up to £1.5 million. |
An example of how the PAYE timing works: a business that pays its staff on Friday 27 November 2026 has run that payroll in the tax month from 6 November to 5 December. The PAYE and National Insurance on it are due by 22 December. So the November payroll costs you twice in the forecast, once on 27 November and again on 22 December.
If you pay PAYE quarterly, the payment is due on the 22nd after the end of each tax quarter, for example 22 July for the quarter from 6 April to 5 July. Put the whole amount in that week.
4. Add suppliers, rent, loans and everything else
Work through the aged creditors report and put each supplier payment in the week you plan to pay it. If you run a fortnightly or monthly payment run, put the whole run in that week. Use your normal timing for the forecast and leave any stretching of terms out of it until you have agreed it with the supplier.
Then go through the last three months of bank statements line by line and list every regular payment:
- Rent and service charges, including rent paid quarterly in advance
- Loan and hire purchase repayments, from the lender's schedule
- Vehicle and equipment leases
- Insurance, including annual premiums and monthly instalments
- Utilities, phones and software subscriptions
- Credit card bills, in the week the card is settled
- Expenses claims paid to staff
- Dividends and drawings, in the week you plan to take them
Finally, add the one-off payments you already know about: a new van, a deposit on a machine, a bonus, a legal bill. Leave out depreciation, accruals and any other entry in the accounts that does not move cash.
5. Find the low point
For each week, total receipts less total payments gives the net cash flow. The opening balance plus the net cash flow gives the closing balance, which becomes the next week's opening balance. Add the overdraft limit to see the headroom.
Then find the lowest closing balance in the 13 weeks. That week is the one to manage. Set a minimum balance you are prepared to run at, for example one month's net pay plus one PAYE payment, and treat any week below it as a problem to solve now.
A worked example
In this example, a business turning over £2.4m a year has 30 staff paid monthly on the last Friday, VAT quarters ending in January, April, July and October, a year end of 31 March, an overdraft limit of £25,000 and £85,000 in the bank on Monday 23 November 2026.
| Week | Receipts | Payments | Net flow | Closing balance |
|---|---|---|---|---|
| 1, w/c 23 Nov | £52,000 | £66,000 | −£14,000 | £71,000 |
| 2, w/c 30 Nov | £48,000 | £27,500 | £20,500 | £91,500 |
| 3, w/c 7 Dec | £55,000 | £72,000 | −£17,000 | £74,500 |
| 4, w/c 14 Dec | £50,000 | £24,000 | £26,000 | £100,500 |
| 5, w/c 21 Dec | £30,000 | £104,500 | −£74,500 | £26,000 |
| 6, w/c 28 Dec | £12,000 | £55,500 | −£43,500 | −£17,500 |
| 7, w/c 4 Jan | £35,000 | £24,000 | £11,000 | −£6,500 |
| 8, w/c 11 Jan | £58,000 | £24,000 | £34,000 | £27,500 |
| 9, w/c 18 Jan | £60,000 | £44,500 | £15,500 | £43,000 |
| 10, w/c 25 Jan | £52,000 | £66,000 | −£14,000 | £29,000 |
| 11, w/c 1 Feb | £47,000 | £27,500 | £19,500 | £48,500 |
| 12, w/c 8 Feb | £50,000 | £24,000 | £26,000 | £74,500 |
| 13, w/c 15 Feb | £49,000 | £24,000 | £25,000 | £99,500 |
| 13 weeks | £598,000 | £583,500 | £14,500 | £99,500 |
An example on invented figures.
The account goes overdrawn in weeks 6 and 7. Week 5 carries the December payroll, paid early before Christmas, and the PAYE and pension contributions on the November payroll, the quarter's rent and the normal supplier run, in a week when customers are paying less than usual.
Payments in week 5, w/c 21 December
| Net pay for December, paid on 24 December | £42,000 |
| PAYE and National Insurance on the November payroll, due 22 December | £16,000 |
| Pension contributions on the November payroll, due 22 December | £4,500 |
| Quarter's rent | £18,000 |
| Supplier payment run | £20,000 |
| Other overheads | £4,000 |
| Payments in the week | £104,500 |
An example on invented figures.
Week 6 then brings the Corporation Tax for the year to 31 March 2026, due on 1 January 2027, and a loan repayment. The balance falls to −£17,500, inside the £25,000 overdraft with £7,500 to spare. The VAT for the quarter to 31 October, £48,000 due on 7 December, has already gone out in week 3.
Seen on 23 November, there are five weeks to act. The owner in this example asks the two largest customers to pay £15,000 of December invoices in week 4, before the Christmas break, and agrees with the main suppliers to move £10,000 of the week 5 run to week 8. Those two steps keep every week in credit, with £7,500 at the low point. The owner also puts a planned van purchase back to February and sends the bank the forecast.
Quarter-ends, holidays and the weeks around them
The weeks around a quarter-end and the main holidays need extra care.
- VAT lands five weeks after the quarter-end. The VAT on a strong quarter is a large payment at the start of the next one.
- Customers pay in month-end payment runs. If a large customer pays on the last working day of the month, put their receipts in that week and leave the weeks between empty.
- Customers' own year-ends can bring a payment forward or push it back. Ask your largest customers when their year ends.
- Christmas, Easter and August slow receipts for two to three weeks while payroll and rent stay the same.
- Rent paid quarterly in advance puts a quarter's rent into one week.
- Annual bills, such as insurance renewals, software licences and Corporation Tax, sit outside the monthly pattern and are easy to miss.
Updating it every Monday
The forecast is only useful if it is current. Update it at the same time every week, ideally first thing on Monday, and finish within the hour.
- Put in last week's actual figures from the bank statement, line by line, next to what you forecast.
- Note the gaps. Any receipt that did not arrive moves to the week the customer now promises, and the customer goes on the chasing list.
- Roll forward one week. Drop the week just gone and add a new week 13 at the end.
- Refresh the receipts from the latest aged debtors report and new invoices raised.
- Refresh the payments from the aged creditors report, the next payroll and any new commitments.
- Check the low point and the headroom, and write down the action for any week below your minimum balance.
Keep a running record of forecast receipts against actual receipts each week. After a quarter you will know how far to trust the receipts line, and which customers to forecast with more caution.
Acting on what it shows
When the forecast shows a shortfall, act on the levers in the order they bring cash in, fastest first.
- Chase named invoices. Call the customers whose receipts make the difference in the tight week, and agree a payment date with each one. The playbook on debtor control sets out the chase sequence.
- Invoice everything that can be invoiced today, including stage payments and work completed but not yet billed.
- Ask for deposits on new orders and stage payments on long jobs.
- Agree the timing of supplier payments with the suppliers before the week, and keep to what you agree.
- Hold back spending you can choose: equipment, recruitment, dividends and bonuses.
- Talk to the bank before the low point, at least three weeks ahead, with the forecast in hand.
- Speak to HMRC if a tax payment cannot be met. GOV.UK says you may be able to set up a payment plan to pay in instalments, and that HMRC will check the plan is affordable.
Mistakes owners make with cash forecasts
- Starting from the balance in Xero, which includes payments the bank has not yet made.
- Forecasting receipts on your payment terms, when the forecast needs the dates each customer pays.
- Leaving out VAT, or putting VAT in the month of the quarter-end when it leaves five weeks later.
- Forgetting PAYE is a second payment, three to four weeks after payday.
- Missing the annual bills: Corporation Tax, insurance and software renewals.
- Building it once. A forecast left for three weeks no longer matches the bank.
- Putting profit entries in a cash forecast, such as depreciation or accrued costs.
- Keeping it in one person's head. The forecast lives in a shared file that the owner can open at any time.
What good looks like
- Updated every Monday from the bank statement and the debtors and creditors reports.
- Receipts named by customer for every invoice over a set amount.
- Every tax payment in its week, from the dates on GOV.UK.
- The low point, the week it falls in and the headroom shown at the top of the sheet.
- Last week's forecast against what happened, kept for the last 13 weeks.
- An action against every week below the minimum balance, with a name and a date.
- The same figures as the 12-month forecast for the months they share.
The free 13-week cash flow template
The 13-week cash flow forecast template is an Excel workbook with weeks 1 to 13, receipts, payroll, PAYE and National Insurance, pensions, VAT, Corporation Tax, rent, suppliers, loan repayments and other payments, with the closing balance, the headroom and the low point worked out for you. It includes this example, filled in, and a sheet on how to use it.
How Buzz helps with cash flow
A 12-month cash flow forecast and budget, built with you, costs £1,200 + VAT once. Business Pulse keeps a rolling 12-month cash flow forecast alongside your management accounts and a review meeting, from £375 + VAT a month quarterly or £499 + VAT a month monthly, on top of your accounts fee. The Financial Controller service, at £1,500 + VAT a month, invoices and chases your customers, prepares the supplier payment runs and sends a cash alert when your balance falls below a level you set. A one-off cash flow and profit improvement meeting costs £395 + VAT.
The guides on why a profitable business runs out of cash and setting aside money for VAT, PAYE and Corporation Tax cover the causes of a tight quarter. The month-end close and KPI and board pack playbooks show where the forecast sits in the monthly routine.
Sources: GOV.UK, Running payroll: reporting to HMRC (the Full Payment Submission); GOV.UK, Pay employers' PAYE (the 22nd, monthly and quarterly); The Pensions Regulator, Making contributions to your pension scheme (the 22nd); GOV.UK, VAT Returns: deadlines, and Pay your VAT bill by Direct Debit; GOV.UK, Pay your Corporation Tax bill; GOV.UK, If you cannot pay your tax bill on time. Each checked on 19 November 2026.
Questions
How is a 13-week cash flow forecast different from a 12-month forecast?
A 13-week forecast works in weeks and a 12-month forecast works in months. The 12-month forecast shows the balance at each month end and sets the plan for the year, the budget and the bank. The 13-week forecast shows the balance at the end of every week, so it finds the low point inside a month, for example the week when payroll, PAYE and the quarter's rent go out together. It is built invoice by invoice from the aged debtors and creditors reports and updated every Monday. Use the 12-month forecast for decisions about the year and the 13-week forecast to run the next quarter's cash.
Should a cash flow forecast include VAT?
Yes. A cash flow forecast shows the money that moves through the bank, and that money includes VAT. Customer receipts go in at the gross amount, including the VAT on the invoice, and supplier payments go in at the gross amount too. The VAT you owe HMRC then goes in as its own payment, in the week it leaves the bank: one calendar month and 7 days after the end of the VAT quarter, or 3 working days later if HMRC collects it by Direct Debit. A forecast built on figures without VAT shows more money in the bank between quarters than the business will have, and then misses the payment.
How accurate should a 13-week forecast be?
The first four weeks should be close, because the receipts and payments in them are mostly known already: invoices issued, payroll set, tax dates fixed. Weeks 5 to 13 depend more on sales not yet made, so they are less certain. Measure it. Each Monday, put last week's actual receipts and payments next to the forecast and note the gap. If receipts keep coming in below forecast, push your receipt timing back for the customers who pay late. After one quarter of records you will know how far to trust each line, and you can set your minimum balance to cover the usual gap.
What should I do if the forecast shows the bank going overdrawn?
Act straight away, while the week is still some way off. Start with the levers that bring cash in fastest: call the customers whose payments make the difference and agree dates, raise any invoices for work already done, and ask for deposits on new orders. Then look at payments: agree a later date with suppliers before the week arrives, and put back spending you can choose, such as equipment, dividends and bonuses. If the gap remains, take the forecast to the bank at least three weeks ahead. If a tax payment is the problem, GOV.UK says you may be able to agree a payment plan with HMRC.
Who should keep the 13-week forecast up to date?
The person who runs the bookkeeping is best placed to update the figures, because they have the bank statement, the aged debtors and the aged creditors to hand. The owner or finance director reviews it every week and decides the actions. In a business without a finance person, the owner can keep it, and the update takes under an hour once the first version is built. The Buzz Financial Controller service, at £1,500 + VAT a month, keeps the debtors and creditors current, chases customers every week and sends a cash alert when the balance falls below a level you set.
13-week cash flow forecast template
An Excel workbook with receipts and payments for 13 weeks, the closing balance and the low point worked out, and an example filled in with invented figures.
- 1How to use
- 2Forecast, blank
- 3Example, filled in
More guides

Month-end close for a small business
How to close the books by working day 10: the reconciliations, accruals and prepayments, the review, and what the management accounts should show.

Debtor control and getting paid faster
Payment terms, invoicing, a chase sequence by day, debtor days, and statutory late payment interest and compensation at the rates on GOV.UK today.

The monthly KPI pack and board pack
The 8 to 12 numbers an owner-managed business should see every month, how to read them, and what a monthly board pack contains, with a worked example.

13-week cash flow forecast template
A free Excel template for the next 13 weeks of receipts, payments and bank balance.

Sample board pack
A six-page monthly board pack to download.

Cash flow forecasting
How to build a 12-month forecast and keep it up to date.

How to read a cash flow forecast
What each line means and where a tight month shows up.

Why a profitable business runs out of cash
Profit is counted when you invoice and cash moves when you are paid. Where the difference goes, how much cash you need, and ways to release it.

How to reduce debtor days
How to work out debtor days, the steps that bring them down, from payment terms to a weekly chasing routine, and the cash a lower figure releases.

Charging interest on late payments
Statutory interest at 8% above base rate, the fixed sums of £40, £70 and £100, when the late payment law applies, how to claim and how to word your terms.

Setting aside money for VAT, PAYE and Corporation Tax
When VAT, PAYE and Corporation Tax are due, how to work out what to move to a tax account each month, and a worked example for a limited company.

CIS deductions and a builder's cash flow
How CIS deductions of 20%, 30% or nothing reduce what a subcontractor banks on each invoice, HMRC deadlines, and gross payment status.

Outsourced credit control and how it works
What an outsourced credit controller does each week, how it runs in your Xero, what it costs against employing one, and the cash it releases.

Cash flow forecasting in Xero
What Xero's short-term cash flow projection shows, what it leaves out, and how to keep a 13-week or 12-month forecast alongside Xero.

Management accounts explained
The contents of a monthly management pack, and how to read it.

KPIs to check every month in a small business
The KPIs an owner-managed business checks each month, how to set targets, leading and lagging measures, and a worked monthly KPI sheet.

Gross margin explained
What gross margin is, how it differs from mark-up, how to calculate it, what moves it and why to check it monthly, with a worked example of the confusion.

Working capital explained
What working capital is, how to calculate it from a balance sheet, the working capital cycle in days, why growth uses cash, and a worked example.

Budget against actual variances explained
How to compare each month's results with the budget, tell favourable from adverse variances, split price from volume and decide which ones to act on.

What management accounts cost and include
Management accounts from £375 a month quarterly or £499 monthly + VAT: what a monthly set contains, what the owner provides and when it should arrive.

Management accounts for a construction company
Management accounts for builders and contractors: work in progress, retentions, CIS deductions, the VAT reverse charge and margin by contract.

Setting up monthly management reports in Xero
How to set up monthly management reports in Xero: the ledger work first, then the Management Report pack, budget variance, tracking and commentary.

How to price for profit
What a price change does to profit, worked through.

Turnover up, profit down
Why sales can rise while profit falls, and where to look.

How to set an annual budget for your business
Six steps to next year's budget, a month-by-month worked example, seasonality, wage rises from April 2026, and reforecasting during the year.

Break-even point explained
How to work out break-even in sales and in units from fixed costs, variable costs and contribution margin, with a worked example and the margin of safety.

What a price rise does to profit
How a small price rise flows straight to profit, how many customers you could lose and still be better off, and how much more you must sell after a discount.

Job costing for small businesses
How to cost each job with materials, labour at a loaded hourly rate, subcontractors and overheads, compare quoted with actual, and value work in progress.

What does a part-time finance director do?
What a part-time or fractional finance director does, the first three months, how it differs from a financial controller, and what one costs.

Finance manager or financial controller?
What a finance manager does, what a financial controller adds, the month-end close, deadlines, how to choose, and what each costs to employ or outsource.

Month-end close checklist
The steps to close the books within five working days: bank, ledgers, accruals, prepayments, payroll, VAT, stock, fixed assets and a final review.

In-house or outsourced bookkeeper?
What employing a bookkeeper costs once National Insurance, pension and holiday cover are added, what an outsourced service covers, and how to switch.

How to run a monthly board meeting
Who attends a board meeting in an owner-managed company, what goes in the board pack, a standard agenda, the decisions and actions log, and the minutes.

Replacing a bookkeeper who has left
Keeping payroll, VAT and the books running when your bookkeeper goes.

The cost of employing a financial controller
What a finance manager, financial controller and finance director cost to employ in 2026 to 2027, with National Insurance and pension, against Buzz fees.

How much a part-time finance director costs
A part-time finance director from Buzz costs £2,000 + VAT a month with the finance team included, against £128,508.40 a year to employ one.

Fractional CFO, part-time FD or interim FD
What a fractional CFO, a part-time finance director, an outsourced CFO and an interim FD each are, and how to choose one for your business.

What a bank wants to see in a business plan
What a lender reads in a business plan: the amount and purpose, ability to repay, forecasts, assumptions, security, guarantees and the people running it.

Bank loan covenants explained
The financial covenants in a bank loan, how interest cover, debt service cover and net debt to EBITDA are worked out, and how to see a breach coming.

Cash flow forecast for a lender
The forecast a bank or lender asks for, and what they check in it.

Preparing your business for financial due diligence
What a buyer's or investor's financial due diligence asks for, how normalised profit and add-backs work, and how long before a sale to start preparing.
Talk to us
Tell us about the business and what is taking up your week, or book 30 minutes with Peter. He will come back within 48 hours with the level that fits and a fixed monthly fee.
Book a callOr call
07476 989568Accreditations and partners








