Weekly Cash Flow Forecast Updater with Xero MCP and Claude

FP&A & Reporting

Intermediate2-3 hoursLow

n8nXero MCPClaude (Anthropic API)Google Sheets

Quick Answer

Pull AR aging and AP schedules from Xero MCP weekly, update a Google Sheets 13-week forecast model, use Claude to identify shortfalls and changes, and deliver a cash position summary every Monday morning.

The Problem This Solves

Finance teams manually update cash flow forecasts by exporting Xero data each week and reconciling with their spreadsheet model. This workflow automates the data refresh and adds AI commentary on cash position changes.

About This Workflow

This workflow maintains a continuously updated 13-week cash flow forecast by pulling accounts receivable aging, accounts payable schedules, and bank balances from Xero MCP every Monday. It updates a Google Sheets forecast model with fresh data, uses Claude to identify cash position changes and flag potential shortfalls, and delivers a weekly cash summary to the CFO and finance team. The workflow transforms cash flow forecasting from a manual weekly task into an automated monitoring system.

Tools Required

n8nAutomationView on Finatune Visit Website

Xero MCPData SourceView on Finatune Visit Website

Claude (Anthropic API)AI EngineView on Finatune Visit Website

Google SheetsOutputVisit Website

Step-by-Step Blueprint

Schedule Monday morning trigger

n8n

Create an n8n Schedule trigger to run every Monday at 6am. Cash flow data from the prior week is fully available by Monday morning.

Pull AR aging from Xero MCP

Xero MCP

Add an n8n HTTP node to call Xero MCP and retrieve accounts receivable aging. Request invoices due in the next 13 weeks with expected payment dates.

Pull AP schedule from Xero MCP

Xero MCP

Add an n8n HTTP node to call Xero MCP and retrieve accounts payable due in the next 13 weeks. Include bill due dates and amounts.

Update Google Sheets forecast model

Google Sheets

Add n8n Google Sheets nodes to update the rolling 13-week forecast with the fresh AR and AP data. Overwrite the inflows and outflows for each week based on actual scheduled amounts.

Analyze cash position with Claude

Claude

Add an n8n Claude node. Send the updated 13-week forecast and instruct Claude to identify the lowest cash week, any weeks with negative projected balance, material changes from last week, and recommended actions.

Use this prompt →

Email weekly cash summary

n8n

Add an n8n Email node to send the cash position summary to the CFO and finance team. Include the 13-week forecast table and Claude's commentary on key weeks requiring attention.

Cost Estimate

$50-100/month

n8n Cloud Pro $50/month or self-hosted free. Xero MCP community server free with Xero subscription. Claude API costs minimal for weekly runs. Google Sheets free.