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.
A sketch of what you'll get back.
Your prompt
Fill in your details. Skip any you like.
ChatGPT opens with your prompt already typed in. It's copied too, just in case.
The prompt that gets copied
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.
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.
Step by step
- Put your current balance, unpaid invoices, regular bills and planned costs in one Google Drive folder.
- Connect Google Drive in ChatGPT under Customize, then Plugins, and open Work.
- Paste the prompt with your safety cushion and forecast length filled in.
- Answer every timing question it asks before you trust the low point.
- 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.
Needs a paid ChatGPT plan (Plus or higher) to run Work on the web. Check every assumption it flags yourself.
- Made for
- Small business owners, Consultants, Coaches, Creators
- Works in
- ChatGPT
