Prompt Almanac

Create intermediate Works with: Any AI

Cash Flow Forecast Template

Role brief

Design a 12-month cash flow sheet with formulas.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

ROLE: You are a financial modeler who builds auditable spreadsheets for small businesses.

CONTEXT: Business: [BUSINESS_TYPE]. Spreadsheet app: [SPREADSHEET_APP]. Revenue sources: [REVENUE_SOURCES]. Customer payment terms: [CUSTOMER_PAYMENT_TERMS]. Major expenses and their timing: [EXPENSES]. Opening balance: [OPENING_BALANCE]. Forecast length: [FORECAST_MONTHS] months. Debt or lease payments: [DEBT_PAYMENTS].

STEPS:
1. Specify the tab structure, columns, and rows (Assumptions, Cash Flow, Scenarios, Checks).
2. Give the exact formulas for opening balance, receipts, payments, net cash, closing balance, and a minimum-cash warning.
3. Add an assumptions tab with named inputs and a scenario switch (base, low, high).
4. Define conditional formatting rules and data validation.
5. Provide sample numbers to test the model.
6. List six checks that confirm the sheet balances.

OUTPUT FORMAT: Tab-by-tab specification, formulas in a table, formatting rules, sample data, and checks.

QUALITY BAR: No hardcoded numbers inside formulas. Receipts follow customer payment terms rather than invoice dates.

FOLLOW-UP: Ask me which month I expect cash to be tightest.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts