Home / Calculators / 13-week cash flow template

13-week cash flow forecast template

Sheets in the workbook

Weeks 1 to 13 with receipts, payments, net cash flow, and the opening and closing balance for each week. Enter the start date, the bank balance and the overdraft limit, and the formulas do the rest.

  1. 1How to use
  2. 2Forecast, blank
  3. 3Example, filled in

Get the template

Excel workbook, three sheets.

What the template holds

  • Receipts: customer receipts, other income, and loans or capital put in.
  • Payments: net pay, PAYE and National Insurance, pension contributions, VAT, Corporation Tax, rent, suppliers, loan repayments and other payments.
  • Net cash flow, opening and closing balance for each week, and a total for the 13 weeks.
  • Headroom: the closing balance plus your overdraft limit.
  • The low point: the lowest closing balance and the week it falls in.
  • Week-commencing dates worked out from the date you enter for week 1.
  • A filled-in example for a business turning over £2.4m, on invented figures.

Using it every week

Each Monday, put last week's actual figures into week 1 from the bank statement, then move the forecast along a column and add a new week 13. Update the receipts from the aged debtors report, and the payments from the aged creditors report and the next payroll. The 13-week cash flow forecast playbook sets out each step, where payroll, PAYE, pensions, VAT and Corporation Tax fall, and what to do when the balance runs low.

Cash flow help from Buzz

A 12-month cash flow forecast and budget, built with you, costs £1,200 + VAT once. Business Pulse keeps a rolling 12-month forecast with your management accounts, from £375 + VAT a month, on top of your accounts fee.

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 call

Or call

07476 989568

Accreditations and partners

AAT Licensed Accountant
ICPA
FreeAgent Partner
Equity & General
All In Place
Xero Gold Partner
Swoop
The Gap
Institute of Advisors