100's of workflows

Reconcile Rent Payments with Local Excel Spreadsheet and OpenAI

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

This rantir workflow is designed to operate on a local network, helping to reconcile downloaded bank statements with internal tenant records. It identifies issues like missed, late, or incorrect payments and generates a report to highlight these for prompt remedial action.

How it works

       
  • The workflow monitors a local network drive for newly added bank statements.
  •    
  • Once a bank statement is added, it is imported into rantir, where its contents are extracted and analyzed by the AI Agent.
  •    
  • The AI Agent reviews each line item to identify dates and incoming payments from tenants.
  •    
  • Using a locally-hosted Excel ("XLSX") spreadsheet, the AI Agent accesses tenant and property records to determine due dates, amounts, and tenancy durations for each tenant.
  •    
  • By comparing tenant records to the bank statement, the AI Agent identifies missed payments, late payments, or incorrect amounts.
  •    
  • A report is generated and logged in the XLSX file for human review and follow-up action.

Requirements

       
  • A self-hosted version of rantir is required.
  •    
  • OpenAI account for AI model access.

Customizing this workflow

If your organization uses Slack or Teams, consider sending reports to a dedicated channel for increased efficiency. Alternatively, email can also be used for report delivery.

Other Workflows like this one

Your connected stack awaits to automate AI workflows with 24-7 uptime performance and engagement

Ask questions about a PDF using AI
Google Drive
Question and Answer Chain
Binary Input Loader
Embeddings OpenAI
OpenAI Chat Model
Use OpenAI to Dynamically generate a webpage in HTML from a user request
HTTP Request
HTML
OpenAI
Respond to Webhook
Webhook
Automate Screenshots with URLbox & Analyze them with AI
HTTP Request
OpenAI
Merge
Edit Fields (Set)
Sticky Note
Analyze feedback and send a message on Mattermost
Mattermost
Google Cloud Natural Language
If
No Operation, do nothing
Start
Charts and AI Agent Analysis using OpenAI Structured Output and Quickchart
HTTP Request
AI Agent
OpenAI Chat Model
Window Buffer Memory (easiest)
Call rantir Workflow Tool
Write a WordPress post with AI
HTTP Request
Wordpress
Code
Wikipedia
OpenAI

Compare features across plans

Computir Cloud Suite All Access

$99/m

Per team/per month, with 10 GB of data and storage
Everything in Free, and:
Icon
Host up to around 4-5 Applications
Icon
Advanced user roles
Icon
Unlimited AI applications & workflows
Icon
Custom onboarding & Customer management
Icon
Advanced integrations
Icon
International capabilities
Unlimited Team Plan & Custom Integration

$299/m

Per $1K Tokens or 1 TB added, custom integration (per month)
Everything in Professional, and:
Icon
Host up to around 20+ Applications
Icon
Tailored implementation services
Icon
Advanced ERP integration capabilities
Icon
Extra bandwidth and open-source AI models
Icon
Fine-tuning & data logic
Icon
SOX or integration customization
Icon
Dedicated premium support
Cloud Suite

$99/mo

Team Plan

$299

Computir Cloud

AI Application & Automation platform suite
Get access to generate dashboards, websites or content
Chat to Explore Data
Icon

Custom Develop  integrations

Chat to Transform Data
Icon
Direct or Enterprise application connections
Webflow, Wix or Wordpress
+ Acumatica, Microsoft, Netsuite & Sage
+ Oracle & Workday
Rules to automate AI
Basic
Advanced
Advanced

Custom Integrations

Build & Share Live Reports
Icon
Generated
Human-Led
Train Classification Models
Icon
Human-Led
Train Time Series Forecasts
Icon

"I highly recommend Computir, they are a great dev team with quick turn around on all projects and requests. We recently worked with them on updating our website and any changes, updates or modifications I needed were always taken care of quickly!"

Paige J, VP of Marketing, Heavy AI