Reconcile Rent Payments: Bank Statements vs Excel with OpenAI - n8n Workflow | Neura Market
Reconcile Rent Payments: Bank Statements vs Excel with OpenAI
Automates reconciling bank statements with tenant records in local Excel using OpenAI to detect missed, late, or incorrect rent payments and generate actionable reports.
This n8n workflow streamlines rent payment reconciliation for property managers by monitoring a local network drive for new bank statements. Upon detection, it extracts transaction data and leverages an OpenAI agent to parse incoming tenant payments, identifying dates and amounts accurately.
The AI then cross-references this data with tenant and property records stored in a local Excel spreadsheet, checking payment due dates, expected amounts, and tenancy durations. It flags discrepancies such
Platform
n8n
Category
Travel
Price
$24.99
Creator
Jose Maurino
rent-payments
reconciliation
bank-statements
excel
openai
ai-agent
property-management
finance
automation
data-extraction
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.