Build a 13-Week Cash Flow Forecast in Excel with Low-Balance Alerts
You get a 13-week cash flow sheet layout with committed and expected cash split apart, exact running-balance formulas, and red flags for weeks below your minimum.
Prompt
You are a small-business finance analyst who builds 13-week cash flow forecasts in Excel and Google Sheets.
Your job: design a 13-week cash flow forecast I can build today. First ask me these in one message, then wait for my answers:
1. What is my opening cash balance, and what date does week 1 start?
2. What are my regular cash inflows and outflows, with amounts and timing?
3. Which items are committed (invoices sent, signed contracts, bills due) and which are expected or estimated?
4. What minimum cash balance do I never want to go below?
Rules:
- Split inflows and outflows into Committed and Expected lines.
- Use 13 weekly columns (C to O) with week-ending dates in row 2 and the minimum balance in cell B3.
- Give exact formulas for totals, net cash flow and closing balance; each week's opening balance equals the prior week's closing balance.
- Add a conditional formatting rule that turns any closing balance below B3 red, plus a flag row showing BELOW MIN.
- Use only my numbers; label any gap as an assumption.
Output format:
1. Layout table (row, label, contents)
2. Formulas table (cell, formula, purpose)
3. Conditional formatting steps
4. Preview of weeks 1-4 as a table
5. Flagged weeks with one action each
End with a short note on assumptions and missing data. This is not financial advice; see an accountant before borrowing or delaying major payments.Example output
Tips and common edits
Why this works
- Splitting committed from expected cash shows how much of the forecast is certain and how much depends on deals that may slip.
- Linking each opening balance to last week's close creates a true running balance instead of 13 disconnected weeks.
- A minimum-balance cell plus red formatting makes shortfalls visible weeks ahead, with one concrete action per flagged week.
Use this in ChatGPT, Claude or Gemini when cash feels tight or before a big purchase. Have your bank balance, unpaid invoices, payroll dates, rent and loan payments ready.
Common edits
- Change the columns to months for a 12-month forecast instead of 13 weeks.
- Add a best-case and worst-case row that applies a percentage to expected inflows.
Prompt details
- By
- Prompts-GPT editors
- Published
Tags
Did this prompt work?
Keep exploring
More like this
Build a Break-Even and Pricing Calculator Spreadsheet in Excel
You get an Excel layout that separates fixed and variable costs, formulas for break-even and margin at three prices, and a ranking of which inputs move the result most.
Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.
Build Conditional Formatting Rules with Exact Formulas and Rule Order
You get a table of conditional formatting rules with the exact custom formula, the range to apply each one to, colors, and a rule order that avoids conflicts.
Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
Build an Invoice Template in Excel or Google Sheets with Automatic Totals
You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.
Build a Budget vs Actual Variance Analysis That Separates Timing from Overspend
Get a variance table with dollar and percent variances, a materiality filter, timing vs permanent labels, short explanations with next actions, and Excel formulas.