Reconcile bank payments with ERP invoices, Google Sheets, and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 20 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects Google Sheets and Slack.
How it runs
Trigger: On a schedule (every hour) (plus 1 other trigger).
- Set Configuration Parameters (Edit Fields (Set)): sets 11 fields: paymentsApiUrl, invoicesApiUrl, ledgerApiBaseUrl…
- Fetch Payment Transactions (HTTP Request): calls an HTTP API
- Fetch Open Invoices (HTTP Request): calls an HTTP API
- Reconciliation Matching Engine (Code): runs custom JavaScript code
- Route by Match Status (Switch): routes items into 3 branches
- Build Run Summary (Code): runs custom JavaScript code
- Update Invoice as Paid (HTTP Request): calls an HTTP API (PATCH)
- Notify Finance for Manual Review (Slack): uses Slack
- Create Exception Record (Code): runs custom JavaScript code
- Post Reconciliation Summary (Slack): uses Slack
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if
From the author
Quick overview This workflow runs on a schedule (or manually) to reconcile bank/PSP transactions against open invoices from an ERP via HTTP APIs, auto-applying exact matches, routing partial matches to Slack for approval, logging unmatched payments as…