Excel spreadsheet

12-Month Cash Flow Forecast

See your bank balance a year ahead

Enter the money you expect in and out each month and the forecast shows net cash flow and the closing bank balance for the next 12 months. Any month that dips below zero turns red.

Freefree account needed · no card
Sign up & download free

Create a free account on our client portal (or sign in) to download. No card details needed. How it works

  • Excel .xlsx
  • Google Sheets
  • Numbers
  • LibreOffice

In the download (8 KB zip)

  • 12-Month-Cash-Flow-Forecast.xlsx

What's included

  • 12 months from any start month
  • Money in and money out lines, ready to rename
  • Net cash flow, opening and closing balance each month
  • Negative months highlighted in red
  • Closing balance chart
  • How-to sheet

Perfect for

  • Small businesses and start-ups
  • Bank and loan applications
  • Planning a big purchase
  • Seasonal businesses

Questions

Is it really free?

Yes. You need a free account on our client portal to download it, and that's all. No card details, no subscription.

Why do I need an account?

The account is where your downloads live, so you can download the file again at any time, and it's the same account you'd use for any of our paid templates.

Can I use it in my business?

Yes, for your own business or organisation. Please don't share or resell the blank template. See the licence for details.

How do I get the file?

Press Sign up & download free, create a free account on our client portal (or sign in) and complete the free checkout. No card is needed. The download appears under My downloads straight away.

Want more?

Our full spreadsheets and document packs go further, from £1.69.

Get 12-Month Cash Flow Forecast · Free

You might also like

Excel spreadsheetFree

Simple Monthly Budget

A one-page budget: what you plan to earn and spend, what actually happened, and what's left over. Overspends turn red, and a chart compares budget…

Excel spreadsheetFree

Weekly Timesheet

Enter start and finish times and unpaid breaks for each day. Hours, overtime after your chosen limit and an estimated gross pay figure work…