--- title: "13-week cash flow forecast template — make it with AI | Dashfridge" description: "A direct-method 13-week cash flow dashboard you can make with Claude, ChatGPT, Gemini or Copilot from your bank balance, AR, AP and payroll. Copy the prompt." url: https://dashfridge.com/templates/13-week-cash-flow site: Dashfridge (https://dashfridge.com) --- [Templates](https://dashfridge.com/templates) · [Finance](https://dashfridge.com/templates#finance) # 13-week cash flow forecast A direct-method 13-week cash flow dashboard you can make with Claude, ChatGPT, Gemini or Copilot from your bank balance, AR, AP and payroll. Below: the live dashboard, the prompt to make yours, and how to keep it current. The Dashfridge team · Updated November 10, 2026 Live sample with made-up numbers · runs locked down, like every dashboard on Dashfridge ## 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. Copy this prompt 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. **Gather the numbers** Export 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. **Paste the prompt** Copy the prompt into Claude, ChatGPT, Gemini or Copilot, fill in the brackets and paste your data under it. 3. **Check it** Tie the totals back to your source reports before anyone else sees it. 4. **Put it on the fridge** Upload 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](https://dashfridge.com/guides/scheduled-refresh). ## Common questions **What is a 13-week cash flow forecast?** A week-by-week forecast of cash in and cash out for the next quarter, built from actual receipts and payments (the direct method) rather than from the income statement. It shows when cash will be tightest so you can act early. **Can AI build a 13-week cash flow?** Yes. Paste your bank balance, AR, AP and payroll schedule into Claude, ChatGPT, Gemini or Copilot with the prompt on this page and it will build the forecast as one HTML dashboard. Check the totals against your bank and AR reports before you share it. **How do I keep the forecast current every week?** Keep it in one place and update the same dashboard each Monday with fresh numbers. On Dashfridge, your AI can send the update to the same dashboard and your team keeps the same link, with every past week kept as a version. ## Get new finance templates A couple of emails a month for people who build dashboards with AI. No spam. ## Make it with any AI. Keep it here. Your team signs in with their company email and always sees the current, certified version. Free for your first 3 dashboards. [ Start free with your work email](https://dashfridge.com/sign-up) ## More templates [Weekly cash position dashboard A one-screen weekly cash dashboard: cash today, AR and AP due, payroll, line of credit and ending cash by week. Copy the prompt into any AI tool.](https://dashfridge.com/templates/weekly-cash-dashboard) [AR aging and collections dashboard An AR aging dashboard with current, 1–30, 31–60, 61–90 and 90+ buckets, DSO and the largest past-due accounts. Make it with any AI tool from your aging report.](https://dashfridge.com/templates/ar-aging-dashboard) [Budget vs. actual dashboard A monthly budget vs. actual (BvA) dashboard by department with variance, % and the owner's explanation. Copy the prompt into Claude, ChatGPT, Gemini or Copilot.](https://dashfridge.com/templates/budget-vs-actual)