Agents Lookup

Use cases / Finance & AR

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.

DifficultyAdvanced
Setup time10–16 hours (estimate)
CategoryFinance & AR

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

  1. Every Monday morning, a scheduled trigger starts the refresh.
  2. The agent reads the prior week's bank activity, open receivables, and open payables from the accounting system using read-only access.
  3. 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.
  4. 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.
  5. The forecast owner reviews the updated copy, adjusts timing assumptions, and marks it as the current version.
  6. The agent logs the data pull time, sources used, and the owner's approval in a change log tab.

Tools

Risks and guardrails

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: