Reconcile rent payments with local Excel spreadsheet and OpenAI
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs on Local File events (add). Along the way it connects OpenAI Chat Model.
How it runs
Trigger: On Local File events (add).
- Set Variables (Edit Fields (Set)): sets 1 field: spreadsheet_location
- Get Bank Statement File (Read/Write Files from Disk): reads a file from disk
- Get CSV Data (Extract from File): extracts data from a file
- Reconcile Rental Payments (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 2 tools (Get Tenant Details, Get Property Details); output parser: Structured Output Parser
- Alert Actions To List (Split Out): splits a list into separate items
- Append To Spreadsheet (Code): runs custom JavaScript code
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Reconcile Rental Payments (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Reconcile Rental Payments (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Local File Trigger
n8n-nodes-base.localFileTrigger - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Read/Write Files from Disk
n8n-nodes-base.readWriteFile - Extract from File
n8n-nodes-base.extractFromFile - Split Out
n8n-nodes-base.splitOut - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
This n8n workflow is designed to work on the local network and assists with reconciling downloaded bank statements with internal tenant records to quickly highlight any issues with payments such as missed or late payments or those of incorrect amounts. This…