13-week cash flow forecast

Who it's for

Controllers, CFOs and fractional CFOs who need to see the low point coming before it arrives.

What's in it

• Beginning cash, receipts and disbursements by category for 13 weeks
• Net cash flow and ending cash each week
• The lowest week, flagged against your minimum cash policy
• A line chart of ending cash vs. the minimum

The prompt

Works in Claude, ChatGPT, Gemini and Copilot. Fill in the [brackets], then paste your data under it.

Build a 13-week cash flow forecast dashboard (direct method) from the data I paste below.
- Weeks start on Monday. Week 1 is this week.
- Rows: beginning cash; receipts (customer receipts, other receipts); disbursements (payroll and taxes, vendors/AP, rent and software, taxes and other); net cash flow; ending cash.
- Show these tiles at the top: cash today, the lowest ending cash and which week, ending cash in week 13, and our minimum cash policy of [$ AMOUNT].
- Chart ending cash by week with a dashed line at the minimum. Highlight any week within [$ AMOUNT] of the minimum.
- Negative numbers in red. Show $ in thousands.
- Add one sentence under the chart saying where the receipts and payments come from.

My data:
[paste bank balance, AR aging or expected receipts, AP schedule, payroll calendar]

Build it as ONE self-contained HTML file:
- Put all the data inside the file. No API calls, no fetch, no external data.
- Use plain HTML, CSS and JavaScript (inline SVG for charts is fine). If you need a chart library, load it from cdn.jsdelivr.net.
- Add a "data as of" date under the title.
- Make it readable on a laptop and print cleanly to one page if possible.

Data you need

• Today's bank balance
• Open AR with expected pay dates (or your AR aging)
• AP by due date
• Payroll dates and amounts
• Rent, software, taxes and other known payments

Make it and share it

1. 1Gather the numbersExport or copy: Today's bank balance; Open AR with expected pay dates (or your AR aging); AP by due date; Payroll dates and amounts; Rent, software, taxes and other known payments.
2. 2Paste the promptCopy the prompt into Claude, ChatGPT, Gemini or Copilot, fill in the brackets and paste your data under it.
3. 3Check itTie the totals back to your source reports before anyone else sees it.
4. 4Put it on the fridgeUpload the HTML file to Dashfridge, or connect your AI and say "put this on the fridge". Publish it and invite your team.

Keep it current

How often: Weekly, every Monday. Roll the forecast forward one week and compare last week's forecast to actual. Update the same dashboard each time instead of sending a new file, so your team keeps one link and every past version is kept. Your AI can do the refresh for you: see dashboards that update every week.