Rental Payment Reconciliation and Alert System

Property managers and landlords with multiple tenants Watches for bank statement CSV files, uses AI to check payments against tenant data, flags missed or incorrect rents, and adds alerts to an Excel report. Install self-hosted n8n. Set up an Excel file with tenant, property, and alert sheets. Point the workflow to your file paths and folder. Add OpenAI API credentials. Drop CSV bank statements into the watched folder to trigger. Self-hosted n8n for local file access. OpenAI API key. Excel file at /home/node/host_mount/reconciliation_project/reconcilation-workbook.xlsx with sheets: tenants, properties, alerts. CSV bank statements in /home/node/host_mount/reconciliation_project. Edit AI prompt for specific rules. Add tools for more data sources. Change file paths or formats. Swap OpenAI for local LLM. Key Technologies: n8n LocalFileTrigger,OpenAI GPT-4o,XLSX/SheetJS for Excel handling,n8n AI Agent,n8n Code Node Automation Value: Cuts manual check time for 10+ tenants from hours to minutes Spots issues like missed payments or over/under amounts that humans might miss Keeps sensitive financial data local for privacy Auto-updates reports to track actions needed Best Practices: Always backup Excel files before runs—workflow includes auto-backup but test thoroughly Use self-hosted n8n for local data privacy, especially with financial info Test AI prompts with sample data to fine-tune flagging accuracy Monitor for CSV format changes; add validation if needed Limit to recent statements to avoid overload; adjust prompt for date ranges