Reconcile Rent Payments with Local Excel Spreadsheet and OpenAI n8n Workflow Template

n8n workflow template · 11 nodes · OpenAI

Reconcile Rent Payments with Local Excel Spreadsheet and OpenAI is a free n8n workflow template that starts from the Local File Trigger node and works with OpenAI. It has 11 nodes, 5 of them AI nodes (Code Tool, Structured Output Parser, OpenAI Chat Model and AI Agent). The notes inside the workflow say: “Join the Discord or ask in the Forum!” To run it, you add your own credentials for OpenAI API.

Download JSON How to import into n8n

At a glance

Trigger
Local File Trigger (Watch For Bank Statements)
Nodes
11
Apps
OpenAI
AI nodes
5
Credentials
1 type
Category
AI agents and LLM tools

Apps and integrations

  • OpenAI

Node types used

  • Local File Trigger
  • Code Tool
  • Structured Output Parser
  • Read/Write Files from Disk
  • Extract from File
  • Split Out
  • Edit Fields (Set)
  • Code
  • OpenAI Chat Model
  • AI Agent

How it works

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Try It Out!

This workflow ingests bank statements to analyses them against a list of tenants using an AI Agent. The agent then flags any issues such as missing payments or incorrect amounts which are exported to a XLSX spreadsheet.

Note: This workflow is intended to work with a self-hosted version of n8n and has access to the local file system.

  • Watches for CSV files (bank statements)
  • Imports into AI agent for analysis.
  • AI agent will query the Excel spreadsheet for tenant and property details.
  • AI agent will generate report on discrepancies or issues and write them to the Excel file.

Need Help?

Join the Discord or ask in the Forum!

I'm designed to work self-hosted!

Some nodes in this workflow are only available to the self-hosted version of n8n.

Step 1. Wait For Incoming Bank Statements

Read more about the local file triggers

For this demo, we'll show that n8n is more than capable working with the local filesystem. This gives great benefits in terms of privacy and data security.

For our datastore, we're using a locally hosted XLSX Excel file which we'll query and update throughout this workflow.

Step 2. Delegate to AI Agent to Quickly Identify Issues with Rental Payments

Read more about AI Agents

An AI agent can not only check against agreed amounts and compare due dates but also consider contract exceptions and tenant notes before deciding to take action. In a scenario of 10+ of tenants, this can save a lot of admin time.

For this demo, we're using a remote LLM Model but this can easily be swapped out for other self-hosted LLMS models that support function calling.

Step 3. Generate a Report to Action any Issues

Read more about using the Code Node

After the AI Agent has helped identify issues to action, we can generate a report and update a locally hosted xlsx file. This again helps keep workflows private to nothing senstive goes over the wire.

Though n8n lacks a builtin node for editing local xlsx file, we can tap into the sheetJS library available to the "Code" node.

Warning! Potentially Destructive Operations!

With code comes great responsibility! There is a risk you may overwrite/delete data you didn't intend. Always makes backups and test on a copy of your spreadsheets!

Nodes in this workflow

The 11 nodes in file order (sticky notes excluded). Branches and connections determine execution order in n8n:

  1. Watch For Bank Statements (Local File Trigger)
  2. Get Tenant Details (Code Tool)
  3. Structured Output Parser (Structured Output Parser)
  4. Get Bank Statement File (Read/Write Files from Disk)
  5. Get CSV Data (Extract from File)
  6. Alert Actions To List (Split Out)
  7. Get Property Details (Code Tool)
  8. Set Variables (Edit Fields (Set))
  9. Append To Spreadsheet (Code)
  10. OpenAI Chat Model (OpenAI Chat Model)
  11. Reconcile Rental Payments (AI Agent)

Credentials you need

  • OpenAI API – used by OpenAI Chat Model

Configure your own credentials after importing. Create each credential in n8n, then select it in the node.

How to import into n8n

  1. Download the JSON file with the button above.
  2. In n8n, open a new workflow, select the ... menu and choose Import from File. You can also paste the JSON straight into the editor canvas.
  3. Open each node that shows a warning and select or create its credential.
  4. Read the notes on the canvas, test the workflow with sample data, then activate it.

Do you need somewhere to run it? Read our guide to self-hosted n8n.

Need this customised?

We can adapt this workflow to your apps, data and process, then deploy and support it.

Contact Us