Free download
Format: CSV · File: cashflow-forecast-template.csv
Download Cash Flow Forecast Template — UK Freelancer
No signup required. Free to use, share, and adapt for your own freelance business.
What's inside
12 weeks of rows pre-populated with example figures you can overwrite. Columns: Opening Balance, Invoiced In (expected), Received In (actual), Fixed Costs Out, Variable Costs Out, Tax Buffer (25%), Closing Balance. Notes row at bottom.
How to use it
Download the file, then open it in your preferred tool (Excel, Google Sheets, or Numbers). All fields are editable. Extend rows or add columns as your business grows.
This template is one of 10 free resources in the FreelanceToolkit UK library. All designed for UK freelancers and small businesses in the 2025/26 tax year.
Related on FreelanceToolkit UK
Weekly is standard for freelancers. Enter actuals from the past week, extend one week ahead so you always see 12 weeks forward.
Rule of thumb for a UK sole trader in the basic-rate band. Higher-rate taxpayers should use 30-35%. Limited company directors can use different splits.
Not explicitly — you can add a VAT-buffer column if VAT-registered (15-17% of gross typical). Alternatively track VAT in a separate sheet.
Act now, not later. Options: chase overdue invoices, defer a discretionary cost, factor invoices, or bring an existing project milestone forward.
Yes — CSV imports directly. All calculation cells use SUM formulas that work identically in Google Sheets and Excel.
Related: Weekly vs monthly cashflow review — from FreelanceToolkit UK.