{"product_id":"n8n-bank-reconciliation-workflow-erp-invoices-slack","title":"n8n Bank Reconciliation Workflow: ERP Invoices + Slack","description":"\u003ch3\u003eAutomatically reconcile bank\/PSP payments to ERP invoices—with Slack approvals\u003c\/h3\u003e\n\u003cp\u003eThis n8n Bank Reconciliation Workflow connects your bank\/PSP and ERP via HTTP APIs to match payments to open invoices. It automatically applies exact matches, routes partial matches to \u003cstrong\u003eSlack\u003c\/strong\u003e for approval, logs outcomes in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and posts a reconciliation summary back to Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule or manually\u003c\/strong\u003e and loads configuration values such as API URLs, matching tolerances, Google Sheets IDs, and Slack channels.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches incoming payment transactions\u003c\/strong\u003e from your bank\/PSP API and \u003cstrong\u003eopen invoices\u003c\/strong\u003e from your ERP\/accounting API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares payments to invoices\u003c\/strong\u003e using deterministic rules: it attempts a \u003cstrong\u003ereference match first\u003c\/strong\u003e, then applies \u003cstrong\u003eamount\/currency plus a date window\u003c\/strong\u003e to classify each payment as matched, partial, or unmatched.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies matched payments\u003c\/strong\u003e by updating the invoice in the ERP via an \u003cstrong\u003eHTTP request\u003c\/strong\u003e, and appends the result to an \u003cstrong\u003eaudit log in Google Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles partial matches\u003c\/strong\u003e by posting candidate invoices to \u003cstrong\u003eSlack\u003c\/strong\u003e for human review, waiting for a decision, then either applying the payment in the ERP and logging it—or flagging it as a rejected exception and alerting Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles unmatched payments\u003c\/strong\u003e by writing an exception row to a Google Sheets exceptions sheet and notifying finance in Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a run-level summary\u003c\/strong\u003e with counts and totals to Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonthly or daily reconciliation of bank\/PSP statements against ERP receivables.\u003c\/li\u003e\n  \u003cli\u003eReducing manual effort by auto-applying exact invoice matches and using Slack approval for partials.\u003c\/li\u003e\n  \u003cli\u003eCreating an auditable trail of matches, exceptions, and outcomes in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e bank\/PSP API (HTTP header auth), ERP\/accounting API (HTTP request), \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes used:\u003c\/strong\u003e if, set, code, wait, slack, switch.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBuilt for n8n users and automation engineers who need reliable ERP invoice reconciliation with clear human-in-the-loop approvals for partial matches.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46018982838451,"sku":"N8N-19552","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BsQtJcfaL3sTaDNTKskIk_yhibunsg.png?v=1789376712","url":"https:\/\/buyflowscripts.com\/products\/n8n-bank-reconciliation-workflow-erp-invoices-slack","provider":"N8N Commerce","version":"1.0","type":"link"}