n8n Cash Position Forecast Workflow (Webhook + APIs)

Project cash flow with an n8n cash position forecast—powered by banking, invoices, and payment schedules

This n8n Cash Position Forecast Workflow exposes a POST webhook that collects banking balances, outstanding invoices, and upcoming payment schedules via HTTP APIs—then returns a day-by-day cash-position projection (with optional FX enrichment) as JSON, including a data-source status audit trail.

What this workflow does

• Receives forecast requests: Listens on a webhook endpoint for POST requests (the “cash-forecast” path).
• Validates inputs: Checks request fields such as horizon days and base currency, then prepares downstream endpoint URLs and parameters.
• Fetches banking data: Calls a banking API over HTTP to retrieve current balances and transaction context for the requested accounts.
• Fetches accounts receivable: Calls an accounts-receivable API over HTTP to pull outstanding invoices and expected collection timing within the forecast horizon.
• Fetches upcoming outflows: Calls a payment-schedules API over HTTP for expected outflows (e.g., AP, payroll, taxes, and recurring payments), and can optionally call an FX/enrichment API.
• Aggregates & projects cash: Combines the results into a daily forecast, computes summary metrics, and returns the JSON response with an HTTP status indicating full or partial data availability.

Use cases

• SaaS operators forecasting runway by combining bank balances, invoice collections, and scheduled payments.
• Automation engineers generating an API-driven cash forecast for finance dashboards and internal tools.
• Teams needing visibility into daily liquidity risk across a configurable horizon in a single webhook call.

Technical details

• n8n workflow nodes: code, wait, webhook, sticky note, http request, respond to webhook.
• Output: Forecast JSON with a data-source status audit trail.
• Integrations: HTTP APIs for banking, accounts receivable, payment schedules, and optional FX/enrichment (replace placeholder httpbin.org URLs with real endpoints).