12-Month Cash-Flow Forecast
A bank-ready 12-month cash-flow forecast with VAT, actuals and variance built in.
Price: £7.20 was £9.00 Launch offer: 20% off
Price in GBP. Digital download; no VAT is charged unless shown at checkout.
Secure card payment by Stripe. Download links on screen and by email straight after payment. Prefer Etsy? Also on Etsy (opens in a new tab).
- Instant download after payment
- Built for the 2026/27 UK tax year
- Personal or single-business licence (details)
What is included
- Cashflow-Forecast-12-Month.xlsx
- Settings sheet: start month, opening balance, VAT registration and rate
- Assumptions sheet with six sales lines and every common cost line
- Forecast sheet with lowest-balance summary and quarterly VAT position
- Actuals sheet in the same layout
- Variance sheet (forecast vs actual)
- Closing balance line chart
- Quick-start guide and licence
- Formats
- Excel and Google Sheets
- Made for
- Start-ups and Loan applications
- Version
- v1.0
- Delivery
- ZIP download, on screen and by email, instantly
About this template
The forecast a bank, lender or investor expects to see, without building it from scratch. Pick your start month and opening bank balance, type your assumptions (six sales lines, cost of sales, payroll, rent and the usual overheads, loan repayments, capital purchases and drawings) and the Forecast sheet shows receipts, payments, net cash flow and your opening and closing balance for every month. Any month that dips below zero turns red, and the summary tells you your lowest balance and when it happens.
If you're VAT registered, switch it on: VAT is added to sales receipts and VAT-able costs, and the quarterly payment to HMRC lands in the right month. An Actuals sheet mirrors the forecast so you can type real figures as the year goes on, and the Variance sheet shows where you're ahead or behind.
All formulas are Google Sheets safe. Nothing here is tax or financial advice.
Who it's for
UK sole traders, small limited companies and side hustles who want admin done properly without paying for software. If you can type into a spreadsheet or document, you can use it.
- Start-ups
- Loan applications
Frequently asked questions
How do I get the files after paying?
Download links appear on screen as soon as payment goes through and are emailed to you as well. The ZIP includes a quick-start guide; links stay valid for 7 days and the order page issues fresh ones any time.
Do I need Microsoft Excel?
No. The spreadsheets work in Excel 2016 or later and in Google Sheets, which is free. Upload the .xlsx to Google Drive and open it with Sheets; the formulas carry over. There are no macros or add-ins.
Is it up to date for this tax year?
It is built for the 2026/27 UK tax year (6 April to 5 April). Every rate and threshold sits on one Settings sheet, so you can see and change them, and we rebuild the template each April.
Can I use it for more than one business?
The licence covers you or one business you own or run, with unlimited documents. Bookkeepers and agencies working for several clients need a multi-business licence; just ask.
What if something does not work?
Email support@hnjuk.co.uk with your order reference and a screenshot. Faulty files are always fixed or refunded; because these are digital downloads there is no cooling-off refund once downloaded.
Guides to go with it
How to make a 12-month cash flow forecast for a bank loan
Build a 12-month cash flow forecast a UK lender will take seriously: assumptions, payment timing, VAT and tax bills, and the checks to run first.
Sole trader vs limited company: a plain-English comparison
The real differences between trading as a sole trader and running a limited company in the UK — liability, admin, tax, privacy — and how to decide.
Self-assessment expense categories explained
The expense boxes on the self-employment pages of a UK tax return, what goes in each, and the traps that catch sole traders out.
You might also like
BusinessSole Trader Bookkeeping & Self-Assessment Tracker
Log income, expenses and mileage; get an SA103-ready summary and a tax estimate.
Price: £9.60
was £12.00Launch offer: 20% offExcel · Google Sheets
BusinessLimited Company Bookkeeping, Dividend & Corporation Tax Tracker
Sales, expenses, dividends and a corporation tax estimate for a small limited company.
Price: £12.00
was £15.00Launch offer: 20% offExcel · Google Sheets
BusinessInvoice & Quote Template Pack
10 UK invoice templates and 3 quote designs for Excel, Word and Google Sheets that add themselves up.
Price: £4.80
was £6.00Launch offer: 20% offExcel · Google Sheets · Word






