Reconcile rental payments with bank statements in a local Excel spreadsheet

• Automate the reconciliation of rental payments with bank statements
• Identify discrepancies in tenant payments efficiently
• Generate alerts for missed or incorrect payments
• Maintain data privacy by using local file storage

Watches for new bank statement files in a specified folder Extracts data from CSV files and processes it Queries tenant and property details from a local Excel spreadsheet Utilizes AI to analyze payment discrepancies Appends results back to the Excel spreadsheet for record-keeping

1. 1
   Import the workflow template into your n8n instance
2. 2
   Configure the local file path for bank statements and Excel spreadsheet
3. 3
   Set up the necessary credentials for AI integration
4. 4
   Run the workflow to start monitoring for bank statements