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
| Blank | What to give | Example |
|---|---|---|
| bank | The bank with your business accounts | Nordbank Business |
| recurring | Regular payments with amount and date | Payroll 58,000 EUR on the 28th, rent 9,800 EUR on the 1st |
| delay days | How many days late customers usually pay | 10 |
| minimum | The lowest balance you accept | 50,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
| Week | In | Out | Closing |
|---|---|---|---|
| 2 Nov | 24,600 | 31,450 | 161,360 |
| 9 Nov | 18,940 | 14,702 | 165,598 |
... 2 weeks
| 30 Nov | 9,200 | 72,300 | 98,618 (payroll and annual insurance) |
|---|
... 7 weeks
| 25 Jan | 6,500 | 30,100 | 41,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
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 4 blanks
Type bank, recurring, delay days and minimum. Tab moves to the next blank.
- 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/mcp2. 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."
}
}Related templates
All finance templatesFinance
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