13-Week Cash Flow Forecast Excel Template for Small Business | Weekly Cash Planner with Dashboard and Scenarios

See which week your cash runs short, 13 weeks ahead.

Enter weekly receipts and payments, and the workbook shows your closing balance, the weeks below your minimum buffer and the funding gap, with base / optimistic / conservative scenarios and a one-page dashboard you can share with a bank, partner or accountant. Excel (.xlsx), no macros. Includes a filled example. Planning tool, not financial advice. Not tested in Google Sheets.

WHAT'S INSIDE

• Setup: business name, start date, opening cash, minimum buffer and your currency

• Inputs: 13 weeks, 6 receipt lines and 14 payment lines (rename them to fit your business)

• Forecast: automatic weekly net cash, closing cash and status flags (OK / LOW CASH / SHORTFALL)

• Scenarios: Base / Optimistic / Conservative, with percentages you set yourself

• Dashboard: plain-English verdict, lowest-cash week, peak funding needed and two charts

• Actuals: compare real weekly results against your forecast

• Checks: built-in integrity tests

• Clickable navigation buttons between all tabs

• Bonus: a filled-in Example file so you can see how it works

CHOOSE YOUR CURRENCY

Pick from 21 currencies (USD, EUR, GBP, MRU, AED, SAR, MAD, XOF and more) or plain numbers. The symbol shows on every amount. It changes the display only: there is no exchange-rate conversion.

WHAT YOU GET

Two instant-download Excel files (.xlsx): the blank Template and a filled-in Example.

GOOD TO KNOW

• Made for Microsoft Excel. No macros, no add-ins.

• It is a direct-method cash forecast: you enter cash in and out by week. It is not a full 3-statement financial model.

• Planning tool only. Not accounting, tax or legal advice. Results depend on the figures you enter.

• Example figures are fictional.