Automate Rent Reconciliation with AI and Local File Management

This n8n workflow empowers property managers and finance teams to automate the tedious task of rent reconciliation. It begins by securely monitoring a designated local directory for new bank statement CSV files. Once a statement is detected, the workflow efficiently reads its content and then delegates the heavy lifting to an AI agent. This intelligent agent compares incoming transactions against your existing tenant and property data stored in local XLSX files. It can identify discrepancies such as missing payments, incorrect amounts, or overdue rent, even considering tenancy terms and notes. The workflow culminates in the generation of a clear, actionable report that is written back to your local spreadsheet, ensuring your data remains private and secure throughout the process.