Draft a simple cash flow forecast
A practical way to use AI for this job in a small business, with a prompt you can copy.
The prompt
Help me build a simple 12-week cash flow forecast in a spreadsheet. Starting balance: [amount]. Regular income: [list]. Regular costs: [list]. One-off costs: [list with dates]. Give me the column layout and formulas.
Replace everything in [square brackets] with your own details. Don't paste in anything you wouldn't want stored by the AI provider.
Steps
- Gather real numbers.
- Run the prompt.
- Build the sheet and check formulas with a simple example.
- Update it weekly.
My verdict
Great for building the template. The numbers have to come from you.
More finance use cases
- Explain your profit and loss in plain English
- Write a polite overdue invoice reminder
- Categorise expenses from a bank export
Next: Write a checklist for a repeat job · All finance · Want a bot to do this automatically? See bot setup guides.