Off Prompt

AI Tools for Small Business

Finance

Build a 4-Week Cash Flow Forecast from Invoices and Bills

Use this prompt every Monday after exporting and cleaning your AR and AP reports from your accounting software. Paste your cleaned data above the prompt, then paste the prompt itself to generate a 4-week cash flow forecast, a risk summary, and a list of overdue invoices to chase.

The Prompt

I'm going to give you two data sets from my accounting software. The first is my Accounts Receivable — open invoices with due dates and amounts. The second is my Accounts Payable — bills I owe with due dates and amounts.

My current bank balance is: [insert your balance]

My recurring fixed weekly costs not listed in the AP data are:
- Rent: [amount, due date]
- Payroll: [amount, weekly or bi-weekly]
- Software subscriptions: [amount]
- Any other fixed costs: [amount]

Using this data, build me a 4-week rolling cash flow forecast. Show me:
1. A week-by-week table with: Cash In, Cash Out, Net Cash Movement, and Ending Bank Balance.
2. A plain-English risk summary of no more than 5 sentences. Flag any week where my ending balance drops below [insert your minimum comfortable balance, e.g. $5,000].
3. A list of any invoices more than 14 days overdue that I should follow up on this week.

Treat invoices as likely to be paid within 7 days after their due date unless they are already overdue. Treat all bills as paying on their due date. Do not assume any income beyond what I have provided.

From the guide

Using AI to build a simple weekly cash flow forecast from your invoices and bills so you see a cash shortfall before it hits →

Related Prompts