Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Finance, Invoices & Accounting

Finance, Invoices & Accounting

Match Bank Statements to Tenant Rent with OpenAI

When a bank statement file appears in a local folder, OpenAI reads the CSV, matches payments to tenants and structures the results.

What it does

# Localfiletrigger Workflow ## Overview Automated workflow: Localfiletrigger Workflow. This workflow integrates 12 different services: stickyNote, code, agent, readWriteFile, splitOut. It contains 21 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 21 - Node Types: 12 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Watch For Bank Statements: localFileTrigger - Get Tenant Details: toolCode - Structured Output Parser: outputParserStructured - Get Bank Statement File: readWriteFile - Get CSV Data: extractFromFile - Alert Actions To List: splitOut - Sticky Note: stickyNote - Sticky Note1: stickyNote - Sticky Note2: stickyNote - Sticky Note3: stickyNote - ... and 11 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible

The steps

  1. Watch For Bank Statements
  2. Get Tenant Details
  3. Structured Output Parser
  4. Get Bank Statement File
  5. Get CSV Data
  6. Alert Actions To List
  7. Get Property Details
  8. Set Variables
  9. Append To Spreadsheet
  10. OpenAI Chat Model
  11. Reconcile Rental Payments
  12. Error Handler for bebbf9cf
  13. Error Handler for be01720f
  14. Error Handler for 2aba5f6a

16 steps in total.

Similar automations