AutomationFlowsAI & RAG › Reconcile Rent Payments with Excel and OpenAI

Reconcile Rent Payments with Excel and OpenAI

Original n8n title: Reconcile Rent Payments with Local Excel Spreadsheet and Openai (local File Trigger)

ByJimleuk @jimleuk on n8n.io

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.

Event trigger★★★★☆ complexityAI-powered17 nodesLocal File TriggerTool CodeOutput Parser StructuredRead Write FileOpenAI ChatAgent
AI & RAG Trigger: Event Nodes: 17 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #2338 — we link there as the canonical source.

This workflow follows the Agent → OpenAI Chat recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json

  

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

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.

Source: https://n8n.io/workflows/2338/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Reconcile Rent Payments With Local Excel Spreadsheet And Openai. Uses localFileTrigger, toolCode, outputParserStructured, readWriteFile. Event-driven trigger; 17 nodes.

Local File Trigger, Tool Code, Output Parser Structured +3
AI & RAG

Localfile Splitout. Uses localFileTrigger, toolCode, outputParserStructured, readWriteFile. Event-driven trigger; 17 nodes.

Local File Trigger, Tool Code, Output Parser Structured +3
AI & RAG

This workflow automates blockchain risk assessment using a multi-agent AI architecture, targeting DeFi developers, blockchain auditors, and Web3 project teams who need rigorous smart contract and toke

Read Write File, Agent, OpenAI Chat +6
AI & RAG

RAG CHATBOT Main. Uses telegram, telegramTrigger, lmChatOpenAi, n8n-nodes-mcp. Event-driven trigger; 87 nodes.

Telegram, Telegram Trigger, OpenAI Chat +8
AI & RAG

CashMate – Your AI-Powered WhatsApp Finance Agent Turn WhatsApp into a smart finance assistant that auto-registers you, logs transactions in natural language, extracts data from receipts and voice not

Tool Code, Output Parser Structured, Tool Calculator +6