{"product_id":"reconcile-invoice-payments-in-n8n-with-forms-xlsx-merge","title":"Reconcile Invoice Payments in n8n with Forms \u0026 XLSX Merge","description":"\u003ch3\u003eReconcile Open Invoices vs. Bank Statements in n8n (with Forms + XLSX Merge)\u003c\/h3\u003e\n\u003cp\u003eThis workflow lets you upload an \u003cstrong\u003eOpen Invoices .xlsx\u003c\/strong\u003e and a \u003cstrong\u003eBank Statement .xlsx\u003c\/strong\u003e via an \u003cstrong\u003en8n Form\u003c\/strong\u003e, then automatically matches bank credits to invoices and returns a \u003cstrong\u003estyled HTML reconciliation report\u003c\/strong\u003e—showing exact matches, partial discrepancies, unpaid invoices, and unmatched deposits.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects files\u003c\/strong\u003e: Receives two uploaded .xlsx files through an n8n Form submission—one for \u003cem\u003eOpen Invoices\u003c\/em\u003e and one for the \u003cem\u003eBank Statement\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts spreadsheet rows\u003c\/strong\u003e: Uses “Extract from file” to convert both spreadsheets into structured items for processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches credits to invoice IDs\u003c\/strong\u003e: Compares each bank \u003cstrong\u003ecredit\u003c\/strong\u003e transaction to invoices by checking whether the bank \u003cstrong\u003eReference \/ Description\u003c\/strong\u003e contains the \u003cstrong\u003efull invoice ID\u003c\/strong\u003e or the \u003cstrong\u003elast three digits\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates amounts\u003c\/strong\u003e: Evaluates whether the credited amount matches the invoice \u003cstrong\u003eTotal Amount Due\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies results\u003c\/strong\u003e: Groups outcomes into:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003eExact matches\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003ePartial matches\u003c\/strong\u003e (amount discrepancies)\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eUnpaid invoices\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eUnmatched deposits\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an HTML dashboard\u003c\/strong\u003e: Renders a printable, styled reconciliation report and shows it as the form completion response, including summary metrics like totals collected and match rate.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFinance teams reconciling customer payments against an \u003cem\u003eOpen Invoices\u003c\/em\u003e export.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators reducing manual matching of bank credits to invoice references.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing invoice payment reconciliation using n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: Code, Form, Form Trigger, Extract from file, Merge, and supporting workflow elements (e.g., Sticky Note).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpected spreadsheet columns\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eOpen Invoices: \u003cstrong\u003eInvoice ID\u003c\/strong\u003e, \u003cstrong\u003eTotal Amount Due\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eBank Statement: \u003cstrong\u003eCredit\u003c\/strong\u003e, \u003cstrong\u003eDebit\u003c\/strong\u003e, \u003cstrong\u003eValue Date\u003c\/strong\u003e, \u003cstrong\u003eReference \/ Description\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf your headers or invoice\/reference formats differ, you can update the matching code logic to fit your exports.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938255560883,"sku":"N8N-19010","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/NrJ-Fo56lwfwGsYElwA1_BiXV1eOa.png?v=1788340834","url":"https:\/\/buyflowscripts.com\/products\/reconcile-invoice-payments-in-n8n-with-forms-xlsx-merge","provider":"N8N Commerce","version":"1.0","type":"link"}