Using AI to build a simple cash flow forecast for the next 90 days using only the numbers you already have in your head

Most small business owners know they should track cash flow but never build a forecast because the process looks like an accounting project. This post walks you through building a simple cash flow forecast for your small business using ChatGPT{:target="_blank"}, Claude{:target="_blank"}, or Google Gemini{:target="_blank"} — no spreadsheet, no bookkeeper, no accounting background required. The approach works because conversational AI can take plain-language numbers and return a structured month-by-month table you can actually use.

What you need before you start

Tool: ChatGPT (GPT-4o), Claude 3.7 Sonnet, or Google Gemini 2.0 Flash. Any of these three will produce a working forecast. ChatGPT's Advanced Data Analysis{:target="_blank"} feature (available on the Plus plan as of mid-2025) is the strongest option if you want formatted tables and scenario comparisons in one session. Claude 3.7 Sonnet handles multi-turn conversations well when you need to add or correct numbers iteratively. Gemini 2.0 Flash integrates directly with Google Sheets if you want a living document.

Time required: 15–30 minutes for your first forecast. 5–10 minutes for each biweekly update.

Skill level: No coding required. You need to be able to type numbers into a chat window and read a table.

Gather the Three Numbers Your AI Cash Flow Forecast Needs

You already have everything you need. A 90-day cash flow forecast requires exactly three categories of data.

1. Write down your starting cash balance. This is the number in your business bank account right now. One figure.

2. List your expected cash coming in. Include outstanding invoices and their expected payment dates, recurring monthly retainer payments, and any new sales you expect to close. If you bill on net-30 terms, write the date you expect to receive payment — not the invoice date. These are different numbers, and the gap between them is where cash problems start.

3. List your expected cash going out. Fixed costs first: rent, payroll, software subscriptions, loan payments. Then variable costs: contractors, materials, ad spend. Then known one-off items: quarterly tax payments, insurance renewals, equipment purchases. Write down the month each one hits.

That is it. You do not need a P&L statement, a balance sheet, or your accountant's approval to proceed.

Prompt the AI to Build Your Forecast

Open your AI tool of choice. Use the following prompt structure. Copy it directly, replacing the bracketed sections with your actual numbers.

Paste this prompt into your AI:

I need a 90-day cash flow forecast for my small business. Please build it as a week-by-week table for the next 13 weeks, then summarize it month by month. Show your assumptions clearly so I can correct anything that is wrong.

Here are my numbers:

• Starting cash balance: [your amount]
• Cash coming in:
  • [Client/source, expected amount, expected payment date]
  • [Client/source, expected amount, expected payment date]
  • [Repeat for each]
• Cash going out:
  • [Expense name, amount, date or frequency]
  • [Expense name, amount, date or frequency]
  • [Repeat for each]

After building the table, please tell me: (1) the week where my cash balance is lowest, (2) whether my ending balance is higher or lower than my starting balance, and (3) any gaps or risks you can see in these numbers.

The "show your assumptions" instruction matters. It forces the AI to list every number it placed where it did. You can then scan the assumptions list and correct anything it got wrong.

After the AI returns the table, read the assumptions section first. You will almost certainly find one or two items placed in the wrong week.

4. Correct the output. Reply with specific corrections: "Move the $4,200 payment from week 3 to week 5. My client pays on the 15th, not the 1st." The AI updates the table and the running balance recalculates. You do not start over.

5. Run a second scenario. Service businesses billing on net-30 or net-60 terms should run a late-payment scenario. Paste this follow-up:

Now show me the same forecast with this change: assume 30% of my client payments arrive 2 weeks later than the dates I provided. Keep everything else the same and show me how the lowest cash balance point changes.

This single step surfaces the real risk in most service business forecasts. The number that comes back is the one that matters most.

The Blind Spots the AI Will Catch for You

The AI will not catch anything you did not mention. But the structured prompting process forces you to think through categories you normally skip.

The most common items service business owners leave out: quarterly estimated tax payments, annual software renewals that auto-charge, insurance premiums, and the payroll cycle that hits in week 5 of a month (three payrolls in one month instead of two).

After you receive your initial forecast, ask the AI this directly:

Based on what I have shared, what common small business cash outflows might I have forgotten to include? List them as questions I should answer yes or no to.

The AI will return a checklist. Work through it. Add the items that apply.

How to Update Your Small Business Cash Flow Forecast Every Two Weeks

The forecast decays as soon as you build it. Actuals replace estimates. Update it every two weeks.

Because AI tools do not retain data between sessions by default, you need to paste your previous forecast back in when you return. This takes 60 seconds and is the actual process.

6. Open a new session. Paste your previous forecast table into the chat window.

7. Provide the actuals. Type:

Here is my forecast from two weeks ago. Please update it with these actual figures for weeks 1 and 2: [list actual inflows and outflows]. Keep all future weeks as estimated. Show me what changed in the ending balance and whether the lowest cash point has shifted.

The AI returns an updated table in under a minute. You replace the document you had with the new one.

When Something Goes Wrong

The running balance goes negative in week 2 and you know that is wrong. The AI placed a large outflow in the wrong week. Check the assumptions list it generated. Find the misplaced item and reply: "Move [expense name] from week 2 to week 6." Recheck the balance.

The AI combined two separate clients into one payment. This happens when your input listed them on the same line. Reply: "Separate [Client A] and [Client B] into two distinct rows. [Client A] pays $X on [date]; [Client B] pays $Y on [date]." The table updates.

The forecast shows a gap but you are not sure what caused it. Ask directly: "Which single inflow or outflow is most responsible for the low balance in week 8? If I moved that date by two weeks, how much would it change?" This is a one-sentence reply that takes two seconds to type and gives you a clear lever to pull.

What to Do Next

Take the lowest cash balance point the AI identified and set a calendar reminder for two weeks before that date. That is your action window — the point where you still have time to accelerate an invoice, defer a payment, or line up a short-term credit option. If the number is uncomfortably close to zero, read how to use AI to write invoice follow-up sequences that actually get paid.

FAQ

Do I need accounting software to build a cash flow forecast this way? No. The workflow described here uses only the numbers you type into the chat. The AI does not connect to QuickBooks{:target="_blank"}, Xero{:target="_blank"}, or your bank account unless you explicitly set up an integration. That is a privacy feature, not a limitation — your financial data stays in the conversation, not in a third-party system.

How accurate will a simple AI cash flow forecast be for my small business? The forecast is directional, not accounting-grade. Its job is to tell you whether you will have more or less cash in 90 days than you do today, and where the tightest point falls. A U.S. Bank study found that 82% of small business failures cite cash flow problems as a contributing factor. A directional forecast that you actually build and update beats a precise one you never make.

What is the difference between a cash flow forecast and a profit-and-loss statement? A P&L records when work is done or when a cost is incurred. A cash flow forecast records when money actually moves in or out of your bank account. For a service business on net-30 invoicing, those dates can be 30–45 days apart. That gap is exactly what the forecast is designed to surface.

Can I use this for a product business with variable inventory costs? Yes, but add one category to your outflows: inventory purchases. List the date you pay the supplier, not the date you sell the product. The same prompt structure works. Product businesses tend to have more variable outflow timing, so the late-payment scenario step becomes more important.

How often should I update my cash flow forecast? Every two weeks is the useful frequency for most small businesses. Monthly updates catch problems too late. Weekly updates on a 90-day horizon are usually more work than the precision warrants. Biweekly keeps you close enough to reality that the forecast still influences decisions.