Cash flow forecast template

Share your opening cash, money in and money out. Get a cash flow forecast in Excel.

Build
cash
.

Nothing sends until you start, and you can change anything afterwards.

Export formats

  • Excel spreadsheet (.xlsx) Opens in Excel, Numbers, and Google Sheets.

Every export also lands in your Library as an artifact you can revise, share with a link, and pick up again in another chat.

How it works

  1. Share your opening balance, the money you expect in, the bills you expect to pay and when, and say whether you want 13 weeks or 12 months.
  2. askROI builds an Excel workbook: your assumptions on one sheet, the forecast with formulas on another, a summary of the lowest cash point, and a chart.
  3. Download the file and change any assumption to see the forecast update, or keep chatting to add a scenario.

What people use it for

  • Small business cash planning see whether payroll, rent and tax bills are covered month by month.
  • 13 week cash forecasts a weekly view for tight months, a lender or a turnaround.
  • Startup runway when the money runs out at the current burn, and what changes it.
  • Seasonal businesses plan for quiet months and big seasonal bills before they arrive.
  • Before a big spend check a hire, a lease or an equipment purchase against cash, not just profit.

Questions

Is the cash flow forecast template free?

Yes. You can build cash flow forecasts on the free plan. Paid plans raise the usage limits and include more credits for Premium mode.

Weekly or monthly?

Both. Ask for a 13 week forecast to watch cash closely over the next quarter, or a 12 month forecast to plan the year. Every input sits on an Assumptions sheet, so you can change an amount or a date and the forecast recalculates.

How does it show a cash shortfall?

A summary at the top names the lowest closing balance and the week or month it falls in. Any period where closing cash drops below zero, or below the buffer you set, is highlighted, and a chart shows closing cash over time.

Does it connect to my bank or accounting software?

No. It works from the figures you paste or type. It does not read bank feeds or accounting data, so the forecast changes only when you edit it.

What does it not do?

It is a planning spreadsheet, not financial advice. It does not work out tax you owe, and it does not add income, loans or bills you did not mention. Where you name an item without an amount, it leaves an empty input cell for you to fill in.

© 2026 askROI