Build a 13-Week Cash Flow Scenario Brief With AI

Profit on paper does not guarantee enough cash at the right time. A 13-week view helps you see timing pressure early and prepare better questions before making a financial decision.

This guide helps you create a plain-language cash flow scenario brief that shows assumptions, timing pressure, decision triggers, and questions for your accountant or adviser.

What you need

• A verified 13-week cash schedule or spreadsheet
• Opening cash, expected receipts, payroll, taxes, debt, recurring expenses, and planned payments
• An owner or finance professional who can verify inputs and decisions

The workflow

1. Keep calculations in the spreadsheet

Use formulas and a reviewed source of truth for money. Give AI summarized, redacted outputs and assumptions, not banking credentials or unchecked transactions.

2. Create explicit scenarios

Build base, downside, and upside cases by changing named assumptions such as collection timing, sales, or a planned expense.

3. Look for timing, not only totals

A profitable period can still have a cash gap. Identify the lowest week, required buffer, and decisions that must happen before it.

4. Use the brief to ask better questions

AI can explain and surface assumptions. Financing, tax, payroll, and major spending decisions need qualified human review.

Copy this working prompt

Replace every bracketed field with verified information from your business. If you do not know something, write unknown instead of guessing.

Explain and stress-test this verified 13-week cash flow summary. Do not recalculate or provide financial advice.

Business context:
[DESCRIBE REVENUE MODEL, COLLECTION TIMING, AND MAJOR FIXED OBLIGATIONS]

Verified weekly cash summary:
[PASTE WEEK, OPENING CASH, RECEIPTS, PAYMENTS, AND CLOSING CASH FROM THE REVIEWED SPREADSHEET]

Base-case assumptions:
[LIST]

Downside scenario assumptions:
[LIST]

Upside scenario assumptions:
[LIST]

Minimum cash buffer and decision rules already approved:
[LIST OR WRITE NONE]

Return:
1. Plain-language base-case summary
2. Lowest projected cash week in the supplied data
3. Timing concentrations and dependencies
4. Assumptions with the greatest effect
5. Differences among the three scenarios
6. Early warning indicators
7. Decisions that require an owner, accountant, lender, or adviser
8. Questions to ask a qualified finance professional
9. Data gaps and inconsistencies to verify

Use only provided values. Do not infer credit availability, recommend financing, move payment dates, alter payroll or taxes, or present projections as certain.

Run a second-pass review

The first output should not be the final answer. Use this challenge prompt to find weak evidence, hidden assumptions, or avoidable risk.

Audit this brief for arithmetic claims not visible in the supplied summary, hidden assumptions, false certainty, and decisions that require a qualified financial professional.

What good looks like

• Every scenario names its assumptions
• Cash timing pressure is visible
• The brief creates questions instead of pretending to advise

Review before you use it

• Was the spreadsheet verified by the responsible person?
• Are taxes, payroll, and debt handled by qualified professionals?
• Are scenario assumptions dated and owned?

Privacy and judgment guardrails

• Remove passwords, payment details, private health information, and confidential customer data before pasting anything into an AI tool.
• Treat the output as a working draft. A person remains responsible for the decision, promise, price, and final send.
• Do not let AI invent customer quotes, financial figures, legal terms, capabilities, deadlines, or proof.

Your next action

Review the brief beside the actual spreadsheet with your bookkeeper, accountant, or finance lead before acting on it.

If your AI tool still lacks the context to do this well, first Build a reusable business context brief.