H&J Business Toolkit
Business SKU HJ-006

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