Build a 13-week cash flow forecast

Weekly cash in and out from your bank, open invoices and bills, with the weeks below your minimum marked.

  • You start it: When you start it

What it does

The task

Read today's balance of my accounts on the bank site bank. In Xero, read the open sales invoices and the open bills with their due dates. Add the regular payments from this list: recurring. Assume each customer pays delay days days after the due date. Build a forecast in a new Google Sheet with one column per week for the next 13 weeks: cash in, cash out and the closing balance. Mark the weeks with a balance below minimum.

  • It works in any bank site, Xero and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • It runs once, when you start it.

What you give it

BlankWhat to giveExample
bankThe bank with your business accountsNordbank Business
recurringRegular payments with amount and datePayroll 58,000 EUR on the 28th, rent 9,800 EUR on the 1st
delay daysHow many days late customers usually pay10
minimumThe lowest balance you accept50,000 EUR

What you get back

An example run with the example values above. Your run uses your own data.

13-week cash forecast from 2 Nov 2026, start balance 168,210 EUR

WeekInOutClosing
2 Nov24,60031,450161,360
9 Nov18,94014,702165,598

... 2 weeks

30 Nov9,20072,30098,618 (payroll and annual insurance)

... 7 weeks

25 Jan6,50030,10041,780 (below 50,000)

Lowest balance: 41,780 EUR in the week of 25 Jan.

Saved as "Cash forecast 2026-11-02".

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 4 blanks

    Type bank, recurring, delay days and minimum. Tab moves to the next blank.

  3. 03

    Run it

    Run sends it to the agent. Follow each step in the panel, and stop it at any time.

From the terminal

cuiar exec "Read today's balance of my accounts on the bank site Nordbank Business. In Xero, read the open sales invoices and the open bills with their due dates. Add the regular payments from this list: Payroll 58,000 EUR on the 28th, rent 9,800 EUR on the 1st. Assume each customer pays 10 days after the due date. Build a forecast in a new Google Sheet with one column per week for the next 13 weeks: cash in, cash out and the closing balance. Mark the weeks with a balance below 50,000 EUR."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool run_task to run my "Build a 13-week cash flow forecast" template with bank = Nordbank Business; recurring = Payroll 58,000 EUR on the 28th, rent 9,800 EUR on the 1st; delay days = 10; minimum = 50,000 EUR.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Read today's balance of my accounts on the bank site Nordbank Business. In Xero, read the open sales invoices and the open bills with their due dates. Add the regular payments from this list: Payroll 58,000 EUR on the 28th, rent 9,800 EUR on the 1st. Assume each customer pays 10 days after the due date. Build a forecast in a new Google Sheet with one column per week for the next 13 weeks: cash in, cash out and the closing balance. Mark the weeks with a balance below 50,000 EUR."
  }
}
All finance templates
  • Finance

    Prepare the figures for your VAT return

    Sales and input VAT by rate for the period, checked against your sales platforms, with the box values.

    You start it: When you start it
    • Xero
    • Shopify
    • Stripe
    • +1 more: Google Sheets
  • Finance

    Check supplier invoices against purchase orders

    Each invoice matched to its PO and delivery note, with price, quantity and duplicate problems marked.

    You start it: When you start it
    • Google Drive
    • Google Sheets
    • Xero
  • FinanceAsks first

    Create client invoices from your tracked hours

    One draft invoice per client from your hours sheet, with rates and dates, sent after you approve it.

    On a schedule: On the 1st of each month at 10:00
    • Google Sheets
    • Xero
  • Finance

    Compare your budget with actual spending

    Budget against actual for each account, the largest differences first, with the transactions behind them.

    On a schedule: On the 5th of each month at 9:00
    • Xero
    • Google Sheets
  • Finance

    Find card payments that have no receipt

    Each card payment matched to a receipt from your inbox or folder, with the missing ones listed first.

    You start it: When you start it
    • Any bank site
    • Gmail
    • Google Drive
    • +1 more: Google Sheets
  • Finance

    Match Stripe payouts to your bank deposits

    Each payout matched to a deposit, with fees and refunds, and the payouts that did not arrive.

    You start it: When you start it
    • Stripe
    • Any bank site
    • Google Sheets