# See the week your cash runs lowest, months before it arrives

> It shows the exact week your balance would dip below your safety cushion, and which bill causes it.

Keep your bank balance, expected payments and bills in one Drive folder. ChatGPT Work builds an editable cash forecast that flags your lowest week, then refreshes it each month when you add new numbers.

- Page: https://thesolocreators.com/prompts/cash-flow-low-point-forecast/
- Category: Make smarter decisions
- Made for: Small business owners, Consultants, Coaches, Creators
- Works in: ChatGPT
- Time: About 30 minutes to set up, then 10 minutes a month
- Effort: Advanced
- Note: Needs a paid ChatGPT plan (Plus or higher) to run Work on the web. Check every assumption it flags yourself.

## The prompt

Fill in the parts in [square brackets], or leave them and the AI will ask you for them.

```text
Build me an editable cash flow forecast for [YOUR BUSINESS, e.g. my landscaping business] for the next [FORECAST LENGTH, e.g. 13 weeks], week by week.

Use the files in my Google Drive folder [FOLDER NAME, e.g. Cash Forecast]: my starting bank balance, invoices I expect to be paid, regular bills, contractor or payroll payments, loan payments, money I set aside for tax, and planned purchases. Leave my original files unchanged.

Build the workbook with formulas tied to a clear assumptions tab, so I can change a date or amount and see the effect. On a summary tab, show the lowest cash week, the balance that week, and any week below my safety cushion of [SAFETY CUSHION, e.g. $5,000]. Explain in plain words which payments cause the dip.

Before you use any placeholder, list the timing guesses you'd have to make and ask me first. Then give me three what-if scenarios: a big client paying 30 days late, a slow month, and one cost I could move. Don't give investment or tax advice.
```

## Step by step

1. Put your current balance, unpaid invoices, regular bills and planned costs in one Google Drive folder.
2. Connect Google Drive in ChatGPT under Customize, then Plugins, and open Work.
3. Paste the prompt with your safety cushion and forecast length filled in.
4. Answer every timing question it asks before you trust the low point.
5. Ask it to refresh the forecast on the 1st of each month from the updated folder.

## What you'll get

An editable forecast workbook with your lowest cash week highlighted, plain-English reasons for the dip and three what-if scenarios you can tweak.

## Good to know

**Which AI tools does this work in?** It works in ChatGPT. On this page, ChatGPT opens with your prompt already typed in. Needs a paid ChatGPT plan (Plus or higher) to run Work on the web. Check every assumption it flags yourself.

**How long does it take?** About 30 minutes to set up, then 10 minutes a month. It's rated "Advanced". There are 5 steps, listed above.

**What do I need before I start?** Just your details for 4 blanks: your business, forecast length, folder name and safety cushion. You can skip any, and your AI will ask for them.

**What will I get back?** An editable forecast workbook with your lowest cash week highlighted, plain-English reasons for the dip and three what-if scenarios you can tweak.

Idea spotted on the official docs, shared by OpenAI: https://learn.chatgpt.com/codex/use-cases/cash-flow-forecast. The prompt is The Solo Creators' own version.

## Go further

Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Board of Advisors (Convene seven AI advisors who debate your decision, vote, and hand back a stress-tested verdict); Fact Checker (Every quote, number, date, and link in your draft checked against its real source, with the fixes handed back as tracked changes you accept or reject).

From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.