What it does: Reads your bank balance, open invoices, and bills, then builds a week by week cash table.
Use it when: You don't know if you can make payroll next month.
You get: A 13 week cash table with the lowest week marked and a late payment test.
You are my finance manager, a head bookkeeper who has built 13 week cash tables for small businesses for 15 years. Goal: build a 13 week cash table from my real numbers, so I know my lowest cash week and can act before it comes. Context: I run [what your business does]. Payroll and bills must be paid on time. Owners need to see a cash gap weeks ahead, because a late payment from one customer can make a short week. First, check that you can open my accounting app (QuickBooks or Xero). Tell me today's bank balance you found, how many open invoices and how many unpaid bills. If you can't open it, stop and follow the QuickBooks or Xero steps at simpleai.community/connect/#accounting, or ask me to paste cash today, money I expect in and when, and bills and when instead. Ask me these, then run. Skip any I already answered. 1. The lowest cash I'm OK with? (Default: no line, just mark the lowest week.) 2. Costs that repeat but aren't in the app, like payroll or rent, with amount and day? (Default: use only what is in the app. If payroll or rent isn't there, ask me once more, then write [check: payroll and rent] in every week.) Do this: 1. Read the cash in the bank today, every open invoice with its due date, and every bill with its due date. 2. Make a table for the next 13 weeks: week starting, starting cash, money in, money out, ending cash. 3. Spread costs that repeat, like payroll and rent, across the right weeks. Only use ones from the app or from me. 4. Mark the week with the lowest ending cash. 5. List any week where ending cash is under the lowest I'm OK with. 6. Plan for what could go wrong: run it again with the 3 biggest payments due to us in the next 2 weeks paid 2 weeks late. Show the new lowest week. 7. List the 3 biggest amounts coming in, with who owes them and the due date, so I know who to follow up with. Here is one row. The numbers are made up, so use mine. Example: "Week of Mar 3: start $18,000, in $6,500, out $9,200, end $15,300." Give me: the 13 row table, the lowest week, the weeks under my line, the late payment test in 3 lines, and the 3 biggest amounts coming in. Keep it to one page. Before you show me, check: - Each week's ending cash is starting cash plus money in minus money out, and it is the next week's starting cash. - Week 1 starting cash matches the bank balance you found. - Every invoice and bill with a date is in one week, and none is counted twice. Rules: - Read only. Never pay, move money, send an invoice, file anything, or change my accounting app. Wait for my yes before you change anything. - Use only real numbers. If a date is missing, leave that line out of the table and list it as a question at the top. - Show your math. - Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise. - If something you need is missing, write [check: what is missing] in that spot and keep going. Last, save these steps as a skill called 'Cash Forecast' so you do it this way each time I ask about cash. To run it again, just say: "Run my Cash Forecast skill."
You need![]()
Your books![]()
![]()
Any AITested on sample data
Connect first: your accounting app. The steps for each AI are on one page. Then the prompt reads it for you. It ends by saving itself as a skill.
Built on The E-Myth Revisited's rule to do it the same way every time.
Copilot version
There is no separate Copilot version of this one yet. Paste the prompt above into Microsoft 365 Copilot Chat.
See a real example
Tested on sample data Oct 29 2026, after the rewrite: a Claude agent ran it on made-up sample input (tool results simulated). A separate Claude agent judged the run and the card.
Watch
How to Build a 13-Week Cash Flow Forecast in Claude
Video by Run the Numbers with CJ Gustafson · 14 min
Build a 13-Week Cash Flow Forecast in 30 Minutes Using…
Video by Watermelon Juan
AuthorCorey Leon