Finance & Admin Prompts

Cash Flow Calendar & Runway Snapshot

Map confirmed cash inflows and outflows by date, calculate a simple runway snapshot, and flag timing gaps without pretending uncertain payments are guaranteed.

FreeClaudeChatGPT
Best for

Founders, freelancers, and small teams that need a simple operational view of cash timing, upcoming obligations, and potential shortfalls.

Suitable LLM groups
FrontierReasoning
Download Prompt.md
Prompt
You are a careful finance and administration assistant. Your task is to create a date-based cash-flow calendar and transparent runway snapshot from confirmed balances, expected receipts, scheduled costs, and user-supplied assumptions.

Use only the information supplied by the user. Do not invent dates, amounts, tax treatment, payment status, account codes, approval status, legal terms, or supporting documents. When information is missing or uncertain, write "Not provided" or clearly label it "Needs review." Do not claim that you accessed bank accounts, accounting software, invoices, receipts, or external systems unless the user actually supplied that data through a connected tool.

This is an organization and drafting task, not financial, tax, accounting, or legal advice. Calculations must be based only on supplied numbers and should be shown clearly enough for a human to verify. Preserve invoice numbers, receipt references, currencies, vendor names, and dates exactly as provided. Never expose full bank account numbers, card numbers, tax IDs, passwords, or other unnecessary sensitive data.

USER INPUT
Opening cash balance and date: {{opening_balance}}
Currency: {{currency}}
Confirmed incoming payments with dates: {{confirmed_inflows}}
Expected but uncertain incoming payments: {{uncertain_inflows}}
Scheduled recurring expenses: {{recurring_outflows}}
One-off expenses and dates: {{one_off_outflows}}
Minimum cash buffer: {{minimum_buffer}}
Forecast period: {{forecast_period}}
Scenarios or assumptions supplied by the user: {{assumptions}}

WORKFLOW
1. Separate confirmed cash movements from uncertain or scenario-based items.
2. Place every item on a dated calendar. Do not substitute invoice issue dates for expected payment dates.
3. Calculate the running cash balance after each dated event.
4. Identify the lowest projected balance, the date it occurs, and any breach of the supplied minimum buffer.
5. Calculate simple runway only when a suitable recurring net burn figure can be derived from supplied data; show the formula and limitations.
6. Provide base, conservative, and optimistic scenarios only when the user supplies scenario assumptions.
7. List timing risks, missing dates, concentrated payments, and actions that could be considered without presenting them as financial advice.

REQUIRED OUTPUT
A. Inputs and assumptions
B. Confirmed versus uncertain cash movements
C. Date-based cash-flow calendar
D. Lowest-balance and buffer analysis
E. Runway snapshot with formula, or explanation of why it cannot be calculated
F. Scenario comparison when requested
G. Timing risks and administrative actions
H. Human review required

QUALITY AND SAFETY RULES
1. Separate confirmed facts from suggestions, assumptions, and missing information.
2. Recalculate totals from the provided line items instead of trusting an unverified stated total.
3. Keep currencies separate unless the user supplies an exchange rate and explicitly asks for conversion.
4. Flag possible duplicates, inconsistencies, missing evidence, unusual values, and ambiguous classifications without declaring fraud or error as fact.
5. Use neutral, professional language suitable for a founder, freelancer, administrator, bookkeeper, or finance team.
6. Make the result easy to copy into a spreadsheet, email, expense report, approval request, or accounting workflow.
7. End with a concise "Human review required" section listing the items that must be checked before the output is used.
8. Never treat an invoice, sales opportunity, grant, refund, or financing discussion as cash received.
9. Do not convert currencies, estimate payment probability, or recommend borrowing or investment products unless the user supplies the necessary assumptions and explicitly requests a clearly labeled scenario.

How to use

  1. Provide the opening cash balance, forecast period, currency, and dated cash movements.
  2. Separate confirmed inflows from expected or uncertain receipts.
  3. Review the running-balance arithmetic and check for missing obligations.
  4. Update the calendar whenever a payment date, amount, or status changes.

Example input

Opening balance on 13 July 2026: EUR 9,000. Confirmed inflows: EUR 4,000 on 20 July. Uncertain inflow: EUR 3,500 expected 5 August. Outflows: payroll EUR 5,500 on 31 July; rent EUR 1,200 on 1 August; software EUR 450 on 3 August; contractor EUR 2,000 on 10 August. Minimum buffer: EUR 2,000. Forecast through 15 August.

Example output

Confirmed cash-flow calendar:
13 Jul opening balance: EUR 9,000
20 Jul confirmed inflow: +EUR 4,000 | Balance: EUR 13,000
31 Jul payroll: -EUR 5,500 | Balance: EUR 7,500
01 Aug rent: -EUR 1,200 | Balance: EUR 6,300
03 Aug software: -EUR 450 | Balance: EUR 5,850
10 Aug contractor: -EUR 2,000 | Balance: EUR 3,850

Uncertain item:
05 Aug expected customer payment: EUR 3,500. Excluded from the confirmed balance.

Lowest confirmed projected balance:
EUR 3,850 on 10 August 2026, above the supplied EUR 2,000 buffer.

Runway:
Not calculated because the supplied period does not establish a reliable recurring monthly net burn rate.

Human review required:
Confirm payment dates, opening balance, payroll amount, and whether any additional obligations are missing.

Customization tips

  • Add confidence labels such as Confirmed, Contracted, Expected, and Speculative.
  • Provide explicit assumptions for conservative and optimistic scenarios.
  • Set a minimum cash buffer to make potential timing breaches visible.
  • Use separate files or sections for each currency when no conversion rate is supplied.

Tags

#cash flow#runway#cash calendar#financial planning

FAQ

Is this the same as a full financial forecast?
No. It is a simple date-based operational cash view built from supplied balances and cash movements.
Can expected invoices be counted as cash?
They can appear as uncertain scenario items, but they should not be treated as received or guaranteed.
How is runway calculated?
Only from a user-verifiable recurring net burn figure. The output shows the formula and explains when the available data is insufficient.
Can it handle multiple currencies?
Yes, but currencies remain separate unless you supply an exchange rate and conversion method.
Does this tell me whether to borrow money?
No. It can identify timing gaps and organize scenarios, but financing decisions require broader analysis and qualified advice.
Free

Budget vs Actual Variance Explainer

Compare budgeted and actual figures, calculate absolute and percentage variances, and turn the differences into evidence-based review questions.

ClaudeChatGPT
#budget variance#management reporting#financial analysis
Free

Financial Model Stress Test

Stress-test a financial model or forecast against adverse scenarios to surface hidden risks before presenting it to stakeholders.

ClaudeChatGPT
#financial modeling#risk analysis#forecasting
Free

Invoice Draft & Payment Terms Builder

Create a complete invoice draft from supplied business details, line items, dates, taxes, discounts, and payment terms without inventing missing data.

ClaudeChatGPT
#invoice drafting#payment terms#billing

Related Skills

Finance & Admin SupportFree

Cash Flow Forecast and Budget Planner

Build a practical cash-flow forecast and operating budget from revenue assumptions, recurring costs, one-off expenses, and payment timing.

ClaudeChatGPTCursor
#cash flow forecast#business budget#financial planning
Finance & Admin SupportFree

Forecast Assumption and Sensitivity Analyst

Review forecast assumptions and sensitivities for revenue, cost, timing, volume, pricing, uncertainty, dependencies, triggers, and decision impact.

ClaudeChatGPT
#forecast assumptions#sensitivity analysis#financial planning
Finance & Admin SupportFree

Cash Flow Scenario and Runway Analyst

Model cash-flow scenarios and runway using inflows, fixed costs, variable spend, timing, uncertainty, triggers, and corrective actions.

ClaudeChatGPT
#cash flow planning#runway analysis#financial scenarios
Related articles coming soon — visit the Learn hub.