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

ChatGPT Automatic Code Review in Gitlab
HTTP Request
Code
Basic LLM Chain
OpenAI Chat Model
If
WordPress or Webflow AI Chatbot with Rantir and OpenAI
HTTP Request
Merge
Postgres
Edit Fields (Set)
Loop Over Items (Split in Batches)
Send Google analytics data to A.I. to analyze then save results in a database or datatable
HTTP Request
Google Analytics
Baserow
Code
Sticky Note
Automated AI image analysis and response via Telegram
Telegram
OpenAI
Merge
Telegram Trigger
Switch
Classify new bugs in Linear with OpenAI's GPT-4 and move them to the right team
HTTP Request
Slack
Linear
OpenAI
If
Supabase Insertion & Upsertion & Retrieval
Edit Fields (Set)
Google Drive
Supabase
Sticky Note
Question and Answer Chain

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