Template
Sole Trader Tax Estimator 2026/27
Estimates the Income Tax and National Insurance on your self-employed profit for 2026/27, when it is due, and what to save each month
£12.00
TemplateFeatured
Cash Flow Forecast Template
A 12-month cash flow forecast that shows your bank balance month by month and marks any month you would run short
£12.00
How you’ll receive this product
Available to download as soon as your payment is confirmed
This is delivered digitally. As soon as your payment is confirmed you will get a private link to your files on your order page. Keep the link to that page — it is where your purchase lives.
You receive
- Cash Flow Forecast Template — cash-flow-forecast-template.zip
- Secure Stripe checkout — we never see your card details
- Your files appear on your order page the moment payment clears
About this product
See a tight month coming while there is still time to do something about it.
What it does
- Type what you expect to come in and go out each month, in plain categories - sales, invoices paid, wages, rent, VAT, tax, drawings and more.
- It works out your bank balance at the end of every month for the next 12 months.
- Months where you would be overdrawn turn red; months below the safety level you choose turn amber.
- At a glance: your lowest balance, which month it happens, and how many months are tight.
- A chart of the balance across the year.
- An Actuals sheet for what really happened, and a Difference sheet showing where you were out.
Comes as two files - one with a made-up café’s figures to learn from, and one blank.
Features
- 12-month bank balance, worked out for you
- Overdrawn months in red, tight months in amber
- Lowest balance and when it happens
- Actuals and actual-versus-forecast sheets
- Balance chart
- Works in Excel and Google Sheets
- Example and blank versions
Product questions
Red shows a month where your bank balance is forecast to go below zero. Amber shows a month where it drops below the safety level you choose.
Yes, both. In Excel, just double-click the file. For Google Sheets, upload it to Google Drive and open it with Google Sheets - every formula keeps working.
No. You type only in the yellow cells. The grey cells work everything out for you.
Yes. You get two copies: one filled in with made-up example figures so you can see how it works, and a blank one for your own.
No. You pay once and the spreadsheet is yours to keep and use for as long as you like.
Reviews
No reviews yet. If you have bought this product, yours could be the first.
You might also like
- BusinessDownload
Invoice Chaser
Chases every unpaid invoice on a schedule you set, in your own words, and stops the moment you mark it paid
£29.00 - Software
Mileage & Expenses Log
Log business miles and receipts as you go; it works out your mileage claim at HMRC rates and totals everything by tax year
£19.00
