Automated Bank Statement Reconciliation for Rental Payments

• Automatically reconcile bank statements with rental payments
• Identify discrepancies in tenant payments
• Generate reports on payment issues for property management
• Maintain accurate financial records in Excel

Monitor local folder for new bank statement CSV files Extract data from the uploaded CSV files Use AI to analyze payment discrepancies against tenant records Generate structured reports of identified issues Append findings to an Excel spreadsheet for tracking

1. 1
   Import the workflow template into your n8n instance
2. 2
   Set the local file path for bank statements
3. 3
   Specify the location of the Excel spreadsheet for tenant and property details
4. 4
   Test the workflow by adding a sample bank statement CSV file