Cash Flow Forecast (Excel + Google Sheets)

Cash flow forecast spreadsheet for Excel and Google Sheets: 12 months and 13 weeks ahead, best/base/worst scenarios, runway and low-cash warnings.

See your cash 12 months and 13 weeks ahead, and know about a tight month before it arrives. Works in Microsoft Excel and Google Sheets.

Watch the setup guide & full tour

What’s inside (10 connected tabs)

• Start Here: 6 setup steps, colour key, tab guide
• Dashboard: cash today, lowest point and month, runway, invoices and bills due in 30 days, next 6 months, alerts, 2 charts
• Setup: cash today, minimum buffer, scenario switch with your own %, money-in and money-out lines
• Monthly Forecast: 12 months, opening and closing cash, OK / below buffer / below zero checks
• 13-Week Forecast: starts this Monday, invoices and bills in their exact week
• Receivables: invoices owed, expected date, chance of payment, chase flags
• Payables: bills by due date with flags
• Scenarios: best, base and worst side by side
• Runway: burn rate, months of cash, first month below buffer
• Actuals: forecast vs what really happened, variance and accuracy

Why it helps

• 12-month and 13-week views in one file
• Best / base / worst switch that the whole file follows
• Low-cash warnings before they happen
• Late invoices move into this month automatically
• Formulas only: no macros, no add-ons, no subscription
• Sample data that starts from today’s month

Included

• Cash-Flow-Forecast.xlsx
• Setup Guide PDF
• Setup + full tour video

A planning tool, not financial advice.