AI-powered rent reconciliation from bank statements and

This automation streamlines the manual verification of rental payments by processing bank statement CSV files and comparing them against tenant data stored in a local XLSX file. An AI agent (GPT-4o) identifies missing, partial, or unexpected payments, and logs structured alerts for follow-up actions.

## Who it´s for
- Property managers automating rent payment checks
- Landlords managing multiple rental units
- Accountants handling recurring rental income
- Companies preferring local data processing without cloud exposure

## What the automation does
- Monitors a local folder for new CSV bank statement files
- Processes transaction data using an AI agent (GPT-4o)
- Cross-references payments with tenant and lease details from a local XLSX file
- Detects missed, incomplete, or irregular payments
- Generates structured JSON alerts
- Appends findings to an Excel spreadsheet for action

## What´s included
- Ready-to-use n8n workflow with LangChain and OpenAI integration
- File system trigger logic for automatic execution
- Integrations with local file system, OpenAI API, and Excel (XLSX)
- Basic setup and adaptation guide

## Requirements for setup
- OpenAI account with active API key
- Local folder for incoming CSV files
- Local XLSX file containing tenant and property data
- Running n8n instance with file system access

## Benefits and outcomes
- Saves time on manual payment reconciliation
- Reduces human error in payment tracking
- Enables fast identification of non-payments or underpayments
- Maintains clear audit trail in Excel
- Enhances data privacy via local processing
- Scales efficiently across multiple properties

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.