Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Watch For Bank Statements
  2. Get Tenant Details
  3. Structured Output Parser
  4. Get Bank Statement File
  5. Get CSV Data
  6. Alert Actions To List
  7. Get Property Details
  8. Set Variables
  9. Append To Spreadsheet
  10. OpenAI Chat Model
  11. Reconcile Rental Payments
  12. Error Handler

Similar automations