Excel & Google Sheets template

See a cash crunch coming — months before it happens.

A 12-month cash flow forecast that tracks money in, money out and your running balance, so you always know where you'll stand.

In the $10 bundle

Comes with 4 more finance templates · 30-day money-back guarantee · Excel + Google Sheets.

12-Month Cash Flow Forecast built-in dashboard showing total cash in, total cash out, net cash flow, ending balance, lowest balance and number of cash-negative months
Actual template screenshot — 12 months of cash in, cash out and running balance, calculated automatically.

01What's inside

Your year, on one screen

Instructions

Quick setup, plain-English steps.

Settings

Opening balance, currency and category labels in one place.

Cash Flow Forecast

The 12-month grid: cash in, cash out and a running closing balance carried month to month.

Categories

Group your inflows and outflows so totals roll up cleanly.

Dashboard

A balance line chart plus cash-in vs cash-out, with low-balance months flagged.

02Why it's worth it

Plan with confidence

  • Spot the dip early — the running balance carries across 12 months, so a shortfall shows up while you can still act.
  • Money in, money out, at a glance — every inflow and outflow rolls into a clear monthly picture.
  • One chart tells the story — a balance line plus cash-in/out bars, read your year in seconds.
  • Low-balance alerts — tight months are flagged automatically instead of catching you by surprise.
  • Excel and Google Sheets — works wherever you keep your numbers, no subscription.

Who it's for: freelancers and small business owners whose income isn't perfectly even month to month — and who want a real answer to "will I be okay in three months?"

03Questions

Before you buy

Do I need accounting knowledge?

No. You enter expected money in and money out; the template does the running-balance math and charts for you.

Can I customise the categories?

Yes. Rename inflow and outflow categories in Settings to match your business.

Does it work in Google Sheets?

Yes. Built in Excel, fully Google-Sheets-compatible — just upload the file.

Know where you'll stand — all year.

The 12-Month Cash Flow Forecast comes in the five-template Finance Toolkit. One $10 download, yours forever.

Get the bundle — $10

30-day money-back guarantee · Excel + Google Sheets · instant download