Analysis / Finance and cash planning
Build a thirteen-week cash flow forecast
Use Proforma to build a thirteen-week cash flow forecast. Produce thirteen-week cash flow table and liquidity pressure-week list from your business data.
Finance lead · Founder
Bring this question into Chat
Your starting prompt.
Build a thirteen-week cash flow forecast starting [week]. Combine expected collections, payables, payroll, taxes and other scheduled commitments into weekly receipts, payments and ending cash. Add an alternative collection-delay scenario of [days]. Show missing payment dates and the assumptions used to fill them for review. Identify weeks below [cash threshold] without assuming new borrowing or accelerating receipts automatically.
Copy this starting point, then replace the placeholders with your own inputs.
Method and review
Keep the assumptions visible.
Start with opening cash and dated receipts and payments. Separate recorded cash movements from forecasts, and show which assumptions change the result.
For this task, check
Expected collection dates should reflect customer payment behavior rather than invoice due dates alone.
Before you begin
- Uploaded exports or permitted Data covering the listed inputs
Work with permitted files or queryable data. Verify the result against the original records.
Synthetic illustrative example
See the method in practice.
Synthetic input. Illustrative output checked locally; this is not a live Proforma run or customer result. Opening cash $120,000. Each grouped row supplies identical weekly flows for that range; four checkpoint weeks are shown.
These invented records explain the method. They are not a recorded Proforma run.
| Weeks | Receipts each week | Payments each week |
|---|---|---|
| 1–4 | $10,000 | $15,000 |
| 5–8 | $12,000 | $16,000 |
| 9–12 | $15,000 | $14,000 |
| 13 | $18,000 | $20,000 |
| Checkpoint | Ending cash | $90,000 floor |
|---|---|---|
| Week 4 | $100,000 | Above floor |
| Week 8 | $84,000 | Below floor |
| Week 12 | $88,000 | Below floor |
| Week 13 | $86,000 | Below floor |
Method
Roll each of 13 weeks forward: ending cash = prior ending cash + expected receipts − payments. The displayed rows are checkpoints, not the full weekly ledger. These synthetic dates assume on-time collections; no borrowing is included.
What the result tells you
The lowest weekly cash is $84,000 at week 8. The $90,000 floor is breached from week 7 onward in this projection. Delayed collections require a separate scenario, not an automatic acceleration of receipts.
Take the next step
Make it your investigation.
Copy the prompt above, create or open your Workspace, and paste it into Chat. Add the inputs you have permission to use and adapt the assumptions with your agent.
Start exploringYour prompt is carried by copy and paste. Signing up does not submit it or start this work automatically.
Or start with your own agent
The setup prompt includes this public task. Your agent will help you connect when needed and use the access you approve.