Reconcile rent payments with local Excel spreadsheet and OpenAI
This n8n workflow is designed to work on the local network and assists with reconciling downloaded bank statements with internal tenant records to quickly hi...
🔌 Nodes & Integrations Used (7)
📖 Implementation & Setup Guide
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 assistant can then generate a report to quick flag attention to ensure remedial action is taken.
How it works
* The workflow monitors a local network drive to watch for new bank statements that are added. * This bank statement is then imported into the n8n workflow, its contents extracted and sent to the AI Agent. * The AI Agent analyses the line items to identify the dates and any incoming payments from tenants. * The AI agent then uses an locally-hosted Excel ("XLSX") spreadsheet to get both tenant records and property records. From this data, it can determine for each active tenant when payment is due, the amount and the tenancy duration. * Comparing to the bank statement, the AI Agent can now report on where tenants have missed their payments, made late payments or are paying the incorrect amounts. * The final report is generated and logged in the same XLSX for a human to check and action.
Requirements
* A self-hosted version of n8n is required. * OpenAI account for the AI model
Customising this workflow
If you organisation has a Slack or Teams account, consider sending reports to a channel for increased productivity. Email may be a good choice too.
Want to go fully local?
A version of this workflow is available which uses Ollama instead. You can download this template here: https://drive.google.com/file/d/1YRKjfakpInm23F_g8AHupKPBN-fphWgK/view?usp=sharing
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Reconcile_rent_payments_with_local_Excel_spreadsheet_and_OpenAI.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....