Library / Finance, Invoices & Accounting
Finance, Invoices & Accounting
Reconcile Bank Statement CSVs Against Tenant Records Using OpenAI and Excel
Watches for bank statement CSV files, has an OpenAI agent check payments against tenant and property data in a spreadsheet, and writes flagged discrepancies to an XLSX report.
What it does
## Try It Out! ### This workflow ingests bank statements to analyses them against a list of tenants using an AI Agent. The agent then flags any issues such as missing payments or incorrect amounts which are exported to a XLSX spreadsheet. ### Note: This workflow is intended to work with a self-hosted version of n8n and has access to the local file system. * Watches for CSV files (bank statements) * Imports into AI agent for analysis. * AI agent will query the Excel spreadsheet for tenant and property details. * AI agent will generate report on discrepancies or issues and write them to the Excel file. ### Need Help? Join the [Discord]({{ $env.WEBHOOK_URL }} or ask in the [Forum]({{ $env.WEBHOOK_URL }} Happy Hacking!
The steps
- Watch For Bank Statements
- Get Tenant Details
- Structured Output Parser
- Get Bank Statement File
- Get CSV Data
- Alert Actions To List
- Get Property Details
- Set Variables
- Append To Spreadsheet
- OpenAI Chat Model
- Reconcile Rental Payments
- Error Handler
Similar automations
Finance, Invoices & AccountingFlag Tenant Payment Issues From CSV Bank Statements Using OpenAI12 stepsFinance, Invoices & AccountingReconcile Rent Payments with an Excel Sheet and OpenAI11 stepsFinance, Invoices & AccountingReconcile Rent Payments from Bank Statements with OpenAI11 stepsFinance, Invoices & AccountingExtract bank statement transactions from PDFs into Google Sheets with Gemini7 steps