{"product_id":"n8n-bank-payment-reconciliation-webhook-gmail-data-tables","title":"n8n Bank Payment Reconciliation: Webhook, Gmail \u0026 Data Tables","description":"\u003ch3\u003eReconcile bank payments to open invoices automatically—via authenticated webhook, Data Tables, and a Gmail operator summary\u003c\/h3\u003e\n\u003cp\u003eWith \u003cstrong\u003en8n Bank Payment Reconciliation: Webhook, Gmail \u0026amp; Data Tables\u003c\/strong\u003e, you can ingest bank statement rows through a secured POST webhook, deterministically match them to open invoices, store reconciliation results in \u003cstrong\u003en8n Data Tables\u003c\/strong\u003e, and notify operators with a \u003cstrong\u003eGmail\u003c\/strong\u003e summary—complete with controlled status output back to the webhook caller.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives statement data via Webhook\u003c\/strong\u003e: Accepts a POST webhook containing statement JSON, validates an import token, and returns \u003cstrong\u003e401\u003c\/strong\u003e if authentication fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and prevents duplicates\u003c\/strong\u003e: Builds a normalized statement contract, then loads existing transactions and unresolved review items from \u003cstrong\u003en8n Data Tables\u003c\/strong\u003e to avoid duplicate processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeterministic reconciliation logic\u003c\/strong\u003e: Reconciles each bank row to open invoices using deterministic rules including:\n    \u003cul\u003e\n      \u003cli\u003einvoice-number detection\u003c\/li\u003e\n      \u003cli\u003eexact amount matching\u003c\/li\u003e\n      \u003cli\u003esubset-sum totals for safe multi-row allocations\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates allocations and review items\u003c\/strong\u003e: Generates allocations, queues ambiguous cases into a review queue, and creates paid signals where matching is safe.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePersists results and verifies execution\u003c\/strong\u003e: Writes transactions, invoices, allocations, review rows, paid signals, and a run summary into six Data Tables, then reads back just-written rows to verify expected counts and key sets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBlocks replay and sends operator email\u003c\/strong\u003e: Commits “seen” markers to workflow static data, then sends an operator summary via \u003cstrong\u003eGmail\u003c\/strong\u003e and responds to the webhook with reconciliation counts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically reconcile incoming bank statement feeds to invoice payments without manual spreadsheet work.\u003c\/li\u003e\n  \u003cli\u003eRoute uncertain matches into a review queue while still confirming “safe” paid signals.\u003c\/li\u003e\n  \u003cli\u003eProvide operators with consistent daily\/triggered reconciliation status emails from n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWorkflow nodes\/tech: \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003edata table\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, plus \u003cstrong\u003esticky note\u003c\/strong\u003e for documentation.\u003c\/li\u003e\n  \u003cli\u003eRequired tables (create 6): \u003cstrong\u003eRecon_Bank_Transactions\u003c\/strong\u003e, \u003cstrong\u003eRecon_Invoices\u003c\/strong\u003e, \u003cstrong\u003eRecon_Allocations\u003c\/strong\u003e, \u003cstrong\u003eRecon_Review_Queue\u003c\/strong\u003e, \u003cstrong\u003eRecon_Paid_Signals\u003c\/strong\u003e, \u003cstrong\u003eRecon_Run_Summaries\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869896958131,"sku":"N8N-18420","price":30.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/HnelvdCosFBIMdF-Klgsv_KDMGnr9o.png?v=1787130928","url":"https:\/\/buyflowscripts.com\/products\/n8n-bank-payment-reconciliation-webhook-gmail-data-tables","provider":"N8N Commerce","version":"1.0","type":"link"}