Guide · 3 ways compared

How to update a 13-week cash flow forecast as a finance lead

There are three honest ways to update a 13-week cash flow forecast: manually (about half a day a week), with DIY AI prompting, or with a $19 ready-made agent. This guide compares all three with real pros and cons.

It rolls your approved receivable, payable and planned cash rows into a transparent 13-week forecast: week, opening cash, inflows, outflows, closing cash and the assumption behind each line. Here are the three honest ways to get it done, with real trade-offs.

Way 1: without AI (the manual way)

Honest cost: half a day a week.

  1. Roll the forecast forward: shift weeks, update opening balances.
  2. Apply the week’s approved receivable and payable changes row by row.
  3. Re-check which assumptions are still true.
  4. Answer "which rows changed" every time someone asks.

The 13-week forecast lives in one person's spreadsheet, updated by hand, and every board ask means a late night re-checking which rows are current.

Pros of doing it manually

Cons of doing it manually

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:

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

Cons of DIY prompting

Way 3: with AI Agent Skills ($19, one-time)

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:

WeekOpening cashInflowsOutflowsClosing cashAssumption
Week of Sep 15$184,000$19,500$22,400$181,100Stripe payout on schedule; payroll Sep 19
Week of Sep 22$181,100$8,000$12,700$176,400Annual prepay expected; rent due Sep 25

Sample data shown. Your workspace fills with your real work.

Setup takes about 10 minutes: buy, hand the three 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

Cons of the ready-made agent

Get the Cash Flow Forecast Agent · $19

The honest comparison

Way 1: manualWay 2: DIY AIWay 3: $19 agent
Time to first resulthalf a day a weekAn afternoon of prompt tuningAbout 10 minutes, tested setup
Every run afterSame hours, every timeRe-paste the rules, sheet and context each runOne short ask, or a standing cycle
ConsistencyDepends on the dayDrifts between sessionsSame output shape every run
CostYour hoursFree, plus your time$19 once, 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 $19 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 $19 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.