13-Week Cash Flow Forecast Refresh
Each week, an agent pulls actuals into a 13-week cash flow sheet, rolls the forecast forward, and writes a variance note for the owner to review.
The use case
Owners and fractional CFOs often keep a 13-week cash flow forecast, but updating it weekly is tedious: last week's actual receipts and payments must replace the forecast, open invoices and bills need re-timing, and the window must roll forward. An agent can read bank balances, open receivables, and open payables from the accounting system, update the actuals columns in a copy of the forecast, roll the window by one week, and write a short note on the biggest differences between forecast and actual. The person who owns the forecast reviews the changes, adjusts assumptions, and decides what to share. The agent moves no money and changes no records.
Example workflow
- Every Monday morning, a scheduled trigger starts the refresh.
- The agent reads the prior week's bank activity, open receivables, and open payables from the accounting system using read-only access.
- It writes actuals into a new copy of the forecast sheet, rolls the 13-week window forward, and keeps the owner's assumption cells unchanged.
- It drafts a variance note covering the largest gaps between last week's forecast and actual cash movement, with the line items behind each gap.
- The forecast owner reviews the updated copy, adjusts timing assumptions, and marks it as the current version.
- The agent logs the data pull time, sources used, and the owner's approval in a change log tab.
Tools
- QuickBooks Online or Xero (read-only)
- Google Sheets
- Claude
- Make or Zapier
- Slack or Gmail
- Google Drive
Risks and guardrails
- A data pull misses transactions and understates cash — guardrail: the agent reconciles the ending balance it computed to the bank balance it read and flags any difference before the owner sees the sheet.
- Agent overwrites the owner's assumptions or formulas — guardrail: it works on a dated copy, writes only to designated actuals cells, and leaves assumption cells locked.
- Forecast is treated as financial advice — guardrail: the note describes data differences only; decisions about borrowing, spending, or timing stay with the owner and their advisors.
- Stale forecast gets shared with a lender — guardrail: only versions the owner has marked current are shared, and each copy shows its refresh date.
Related recipe
Weekly KPI Digest from Google Sheets with Source-Cited Numbers: An agent reads your defined metrics from Google Sheets, compares them to last week and targets, and drafts a plain-English digest where every number cites its cell. The owner approves before it goes to Slack or email.
Want it set up for you? Request a quote.
Sources
Written by Agents Lookup. Credits and official pages for the tools this use case names:
- QuickBooks Online MCP server (official page): github.com/intuit/quickbooks-online-mcp-server (checked 2026-11-09)
- Xero MCP server (official page): github.com/XeroAPI/xero-mcp-server (checked 2026-11-09)
- Claude (official page): claude.ai (checked 2026-11-09)
- Make MCP server (official page): developers.make.com/mcp-server (checked 2026-11-09)
- Zapier MCP (official page): zapier.com/mcp (checked 2026-11-09)
- Slack MCP server (official page): docs.slack.dev/ai/slack-mcp-server (checked 2026-11-09)
- Gmail (official page): developers.google.com/workspace/gmail (checked 2026-11-19)
- Google Drive (official page): developers.google.com/workspace/drive (checked 2026-11-19)