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?
- Set up 13 weekly columns with the week dates, a line for each kind of receipt and payment, and totals.
- Net cash flow is receipts less payments; ending cash is opening cash plus net cash flow.
- Link each week's opening cash to the previous week's ending cash.
- Compare each week's ending cash with your minimum cash balance and show the cushion and an OK or Short status.
- Add summary figures: the lowest week, the weeks below the minimum and an overall status.
- Add a credit-line draw that covers any shortfall, and chart ending cash against the minimum.
- Add best and worst cases, such as late receipts or customers who don't pay.
Where it usually goes wrong
- A large invoice far past due still forecast to arrive "next week".
- An annual payment, such as an insurance premium, missing because it isn't monthly.
- A payroll or payment date that falls on a weekend or bank holiday and leaves the bank a day or two earlier.
- A supplier bill entered twice in AP.
- A customer's credit balance counted as a receipt.
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.
What the agent did
- 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.
- 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.
- 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.
- 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.
- Said it would need two $25,000 draws on the credit line, and drew nothing.
- 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.
What it found
| What changed the forecast | Amount ($) | Week |
|---|---|---|
| Payroll due on Presidents' Day, paid the Friday before | 145,300.00 | Week 12 |
| Invoice 75 days past due left out of the base case | 96,400.00 | Best case only |
| Annual insurance premium, missing last week | 46,800.00 | Week 7 |
| Supplier bill entered twice, paid once | 18,960.00 | Week 2 |
| Lowest cash, before any draw | 9,898.27 | Week 13 |
| Credit-line draws needed | 50,000.00 | Weeks 12 and 13 |
What you still check
- Whether the $96,400 customer really will pay, before you count on the best case.
- The credit-line draws with the bank, a few weeks ahead of week 12.
- That the duplicate supplier bill is deleted in AP, not just left out of the forecast.
- The forecast's rules each week, so annual items and holiday dates are not missed again.
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