Way 1: without AI (the manual way)
Honest cost: half a day a week.
- Roll the forecast forward: shift weeks, update opening balances.
- Apply the week’s approved receivable and payable changes row by row.
- Re-check which assumptions are still true.
- Answer "which rows changed" every time someone asks.
Updating the forecast by hand means re-checking every row's source before you trust it. The walkthrough below builds a repeatable weekly run with an assistant: refresh the inflows and outflows, record the assumption behind each row, and get the summary drafted - with you verifying the numbers before anyone relies on them.
Pros of doing it manually
- Free except your time - no tools, no accounts.
- You learn the job deeply and control every detail.
- No data leaves your hands.
Cons of doing it manually
- half a day a week - every single time the job runs.
- Quality depends on your energy that day.
- More volume just means more hours; it does not scale.
Way 2: with AI, but without AI Agent Skills (DIY prompting)
A chat assistant genuinely helps here. The catch is that you become the workflow designer. What you have to figure out yourself:
- You must paste the full forecast and the change list each week.
- You must require a change log, or you cannot audit what moved.
- You must keep assumptions explicit in the prompt, or they silently reset.
Here is a starter prompt that works - copy it and bring the inputs listed:
Roll this 13-week cash flow forecast forward one week: [paste forecast]. Apply only these approved changes: [paste]. Keep the assumption visible on every line and give me a change log of what you modified. Do not add new assumptions of your own.More on this prompt: the free ai cash flow forecasting prompt page.
Pros of DIY prompting
- Free, or nearly - any chat assistant works.
- A first draft in minutes instead of hours.
- Fully flexible: tweak the prompt for any edge case.
Cons of DIY prompting
- You become the workflow designer: prompts, test data and output rules are yours to write, test and maintain.
- Output drifts between sessions unless you re-paste the rules every run.
- Nothing is saved for you - sheets, structure and context are rebuilt each time.
Way 3: with AI Agent Skills (free, Free)
The Cash Flow Forecast Agent is this job already designed: fixed evidence rules, output contract, test fixtures and stop points. You ask once:
Hello, update our 13-week cash flow forecast
And a finished, review-ready artifact lands in your own Drive:
| Week | Opening cash | Inflows | Outflows | Closing cash | Assumption |
|---|---|---|---|---|---|
| Week of Sep 15 | $184,000 | $19,500 | $22,400 | $181,100 | Stripe payout on schedule; payroll Sep 19 |
| Week of Sep 22 | $181,100 | $8,000 | $12,700 | $176,400 | Annual prepay expected; rent due Sep 25 |
Sample data shown. Your workspace fills with your real work.
Setup takes about 10 minutes: download, hand the Included files to the assistant you already use (Instinct, ChatGPT, Claude, Gemini or any other assistant that reads files), approve the fictional-data test. Then it runs on a standing cycle or a one-line ask, and stops at every human gate. Full method.
Pros of the ready-made agent
- About 10 minutes to a tested setup, not an afternoon of prompt tuning.
- The same output shape every run - evidence rules and stop points are already designed.
- Runs on a standing cycle or a one-line ask; files land in your own Drive.
Cons of the ready-made agent
- Costs free, where DIY prompting is free.
- The output format is opinionated - you adapt the template rather than rebuild it.
- It still stops and waits for your approval at decision points; it is not zero-touch.
The honest comparison
| Way 1: manual | Way 2: DIY AI | Way 3: free agent | |
|---|---|---|---|
| Time to first result | half a day a week | An afternoon of prompt tuning | About 10 minutes, tested setup |
| Every run after | Same hours, every time | Re-paste the rules, sheet and context each run | One short ask, or a standing cycle |
| Consistency | Depends on the day | Drifts between sessions | Same output shape every run |
| Cost | Your hours | Free, plus your time | Free, files kept forever |
The manual way teaches you the job. DIY prompting is fine for a one-off. The agent wins when the job repeats every week.
More: the Cash Flow Forecast Agent product page · the AI cash flow forecasting guide · AI agents for finance teams
Questions people ask
What is the fastest way to update a 13-week cash flow forecast?
The free ready-made agent: about 10 minutes of setup, then one short ask per run. Manual takes half a day a week; DIY prompting takes an afternoon of tuning plus upkeep.
Can I update a 13-week cash flow forecast without AI?
Yes - the manual steps are on this page. Expect half a day a week each time the job runs.
Is the free agent worth it over DIY prompting?
If the job repeats weekly, yes: you stop rebuilding prompts and re-pasting context every run. For a one-off, DIY prompting is fine and free.
Last updated 13 September 2026 · Reviewed by the AI Agent Skills team.