{"product_id":"bank-payment-reconciliation-n8n-gpt-4o-mini-google-sheets","title":"Bank Payment Reconciliation n8n: GPT-4o-mini + Google Sheets","description":"\u003ch3\u003eAutomatically reconcile bank payments to invoices in your Google Sheets—daily, with AI assistance\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically matches incoming bank transactions from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to open invoices, marking paid\/partial\/overpaid records, logging every decision, alerting exceptions in \u003cstrong\u003eTelegram\u003c\/strong\u003e, and emailing a weekly aging report via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily at 7:00\u003c\/strong\u003e, reads bank transactions and invoices from separate tabs in a Google Sheets spreadsheet (tabs: \u003cstrong\u003eBank\u003c\/strong\u003e, \u003cstrong\u003eInvoices\u003c\/strong\u003e, \u003cstrong\u003eLog\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eFilters to \u003cstrong\u003enew incoming payments\u003c\/strong\u003e, normalizes key fields, and extracts an \u003cstrong\u003einvoice reference\u003c\/strong\u003e from each payment description.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReference-first matching:\u003c\/strong\u003e matches payments to open invoices by invoice number and classifies each match as:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003ePaid\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003ePartial\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eOverpaid\u003c\/strong\u003e (based on the amount difference)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI matching fallback:\u003c\/strong\u003e for payments without a reference match, sends the transaction details plus the list of open invoices to \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e and only accepts results that meet a \u003cstrong\u003econfidence threshold\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUpdates the relevant rows in Google Sheets (invoice and bank statuses), appends a detailed reconciliation entry (including reasoning and confidence) to the \u003cstrong\u003eLog\u003c\/strong\u003e tab, and sends \u003cstrong\u003eTelegram\u003c\/strong\u003e alerts for partial\/overpaid outcomes.\u003c\/li\u003e\n  \u003cli\u003eIf the AI match is low-confidence or fails, marks the bank entry as \u003cstrong\u003e“Review”\u003c\/strong\u003e, logs the event, and notifies Telegram for manual follow-up—without updating invoices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly (Monday at 8:00)\u003c\/strong\u003e, generates an \u003cstrong\u003eoverdue invoice aging report\u003c\/strong\u003e from Google Sheets and emails it as an \u003cstrong\u003eHTML table\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators reconciling daily bank inflows against outstanding invoices.\u003c\/li\u003e\n  \u003cli\u003eAccounting teams reducing manual matching work and centralizing exceptions in Telegram.\u003c\/li\u003e\n  \u003cli\u003en8n users standardizing invoice payment reconciliation using Google Sheets as the source of truth.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow\u003c\/strong\u003e scheduled: daily \u003cstrong\u003e7:00\u003c\/strong\u003e and Monday \u003cstrong\u003e8:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses nodes\/tools including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and \u003cstrong\u003emerge\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrates with \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e; sends alerts through \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962013966515,"sku":"N8N-19220","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/T7S8b222F6syuiLOTg5L-_EQupVvm5.png?v=1788599279","url":"https:\/\/buyflowscripts.com\/products\/bank-payment-reconciliation-n8n-gpt-4o-mini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}