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
Write a Grant Application Budget Justification
Use this prompt to draft the budget justification section of a grant application. Replace the placeholders with your actual requested amount and itemized costs before running it.
Rewrite Price Increase Letter for a Trade Business
Use this as a follow-up instruction when the AI's draft sounds too corporate or formal for a trade or hands-on service business. Swap in your own business type as needed.
Shorten a Price Increase Letter Draft
Use this as a follow-up instruction when the AI's first draft of the price increase letter is too long and needs to be trimmed.
Price Increase Letter With a Firm, Non-Negotiable Tone
Add this to the base price increase prompt when writing to a client who is a slow payer, difficult to work with, or someone you want to set a firm boundary with around the new rate.