13-week cash flow forecast: roll it forward each week, with an AI agent

Short answer: A 13-week cash flow forecast lists expected receipts and payments week by week, starting from today's bank balance, and shows the weeks where cash falls below your minimum and how much to draw on the credit line. Roll it forward every week from fresh AR, AP and bank data, apply the same rules each time, and explain what changed since last week. An AI agent can do the weekly update from the exports.

A 13-week cash forecast is only as good as its last update. Each week the bank balance, the open invoices and the bills change, and small misses add up three months out.

Here is how to build one, from a recent tutorial, then an agent rolling a distributor's forecast forward a week, and three follow-ups that it needed.

The tutorial this is based on

13-Week Cash Flow Forecast in Excel (Free Template) by PK: An Excel Expert, published 5 November 2026 (in English). A 15-minute build of a 13-week forecast in Excel, with a minimum cash line, a credit-line draw and scenarios.

How do you build and update a 13-week cash flow forecast?

  1. Set up 13 weekly columns with the week dates, a line for each kind of receipt and payment, and totals.
  2. Net cash flow is receipts less payments; ending cash is opening cash plus net cash flow.
  3. Link each week's opening cash to the previous week's ending cash.
  4. Compare each week's ending cash with your minimum cash balance and show the cushion and an OK or Short status.
  5. Add summary figures: the lowest week, the weeks below the minimum and an overall status.
  6. Add a credit-line draw that covers any shortfall, and chart ending cash against the minimum.
  7. Add best and worst cases, such as late receipts or customers who don't pay.

Where it usually goes wrong

How an AI agent does it from Slack

We gave the agent four files for a made-up outdoor-goods distributor, Cedar Hollow Outdoor Supply: today's open AR and open AP, the bank balances, and last week's forecast workbook with its payroll calendar, recurring payments and rules. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.

The message in SlackUpdate Cedar Hollow's 13-week cash forecast from today's AR, AP and bank balance (20 Nov), using last week's workbook and its rules, and tell me if we dip below $50k. Don't draw on the line or move any money.
Slack request to update a 13-week cash forecast from four Excel files, and the start of the agent's reply saying no money was moved
The request with the four files. The agent moved no money and drew nothing on the line.

What the agent did

  1. Started from the bank balance of $330,486.30 and placed every open invoice and bill, the payroll calendar and the recurring payments in their weeks.
  2. Left a $96,400 invoice that is 75 days past due out of the base case, as the workbook's rules say, and put it in the best case only.
  3. Got its first forecast wrong: it paid a supplier bill entered twice, left out the annual insurance premium, and missed two payments due on bank holidays. It said cash dipped only in week 13.
  4. Asked to check duplicates, annual items and holiday dates against the rules, it found all three and corrected the forecast: below $50,000 in week 12, lowest in week 13 at $9,898.27.
  5. Said it would need two $25,000 draws on the credit line, and drew nothing.
  6. Asked why the week of 8 February fell from $244,122.46 to $31,418.27, it broke the $212,704.19 down by cause, to the cent.
The agent's answer to a follow-up: a duplicate $18,960 supplier bill, a missing $46,800 insurance premium, and payments moved for Martin Luther King Jr. Day and Presidents' Day
Its first forecast missed three things. Asked to check duplicates, annual items and holiday dates, it found all three.

What it found

What the corrected forecast picked up
What changed the forecastAmount ($)Week
Payroll due on Presidents' Day, paid the Friday before145,300.00Week 12
Invoice 75 days past due left out of the base case96,400.00Best case only
Annual insurance premium, missing last week46,800.00Week 7
Supplier bill entered twice, paid once18,960.00Week 2
Lowest cash, before any draw9,898.27Week 13
Credit-line draws needed50,000.00Weeks 12 and 13
The agent's corrected ending cash for each of the 13 weeks, with week 12 at $31,418.27 and week 13 at $9,898.27, and two $25,000 credit-line draws
The corrected forecast: cash falls below $50,000 in week 12 and needs two $25,000 draws.
The agent's bridge for the week of 8 February: from $244,122.46 in last week's forecast to $31,418.27, broken down by cause
Why the same week fell by $212,704.19 since last week's forecast, cause by cause.

What you still check

Questions accountants ask

Why 13 weeks?

Thirteen weeks is a quarter: far enough ahead to see a shortfall in time to act, near enough that receipts and payments can be placed week by week from real invoices and bills.

Should an overdue invoice be in the forecast?

Set a rule and keep to it. Here invoices more than 60 days past due stayed out of the base case and went into the best case only.

Can the agent update the forecast every week?

Yes. Agents can run on a schedule, so the update and the list of what changed can be ready each Monday. It doesn't draw on the line or move money; it asks first.

Hand this job to an agent

Bring one of your own files to a 30-minute call and watch an agent do it.

Book a 30-min demo