Reconcile bank statements to invoices with GPT and Sheets
Task · Bank reconciliation
Time saved · 3-6 hrs per month (estimate, not measured)
Steps
- Open the template from the source link
- Connect the listed apps with your own credentials
- Edit the AI prompt, filters and thresholds for your process
- Run on test data, then switch on with human review of outputs
Prompt / template
Match each bank line to an open invoice by amount, date (±5 days) and reference. Return matched, partial or unmatched with a reason.
Source · https://n8n.io/workflows/10581
Last checked · 2026-10-16
Affiliate slot · n8n — placeholder, not a live link yet (https://n8n.io/affiliates/). Try n8n