ServicesWorkAboutBlog
Toggle theme
All work
AI & Automation

Smartland Water Sewer Bot

2-3 MonthsAutomation
Video Preview

Click to Play Demo

About this project

Property management companies were dealing with a tedious and error-prone utility billing process. Every day, staff had to manually log into multiple utility provider portals, pull water and sewer billing data for each property, identify unpaid balances, validate edge cases like occupancy changes or proration, and then process charges. As portfolios grew, this workflow became unmanageable and prone to missed or incorrect billing. To solve this, we built a multi-service automation platform that fully streamlines water and sewer billing operations. Each day, the system automatically logs into utility provider websites and retrieves the latest billing data across all managed properties. It then identifies accounts with outstanding balances and flags them for further processing. Before any charge is applied, the platform runs a series of validation checks—verifying occupancy status, checking bill stability over time, and applying proration rules where necessary. This ensures only accurate and eligible charges are processed. Once processing is complete, the system generates a consolidated email report summarizing all activity and sends it to the operations team for oversight. In parallel, a web-based dashboard provides real-time visibility into all properties, flagged accounts, historical charges, and billing receipts—giving staff full control and transparency in one centralized interface. The result is a fully automated billing pipeline that eliminates manual portal work, reduces billing errors, and brings consistency and clarity to utility charge management at scale.

Tech Stack
Node.jsExpress.jsPythonNext.js 14React 18TypeScriptPostgreSQLSequelize ORMPuppeteerSelenium WebDriverBeautifulSoupPyTesseractOpenCVRedux ToolkitMaterial-UI v6Tailwind CSSGmail APIGoogle Drive APITwilionode-cronAxiosDockerNixpacks
Project Info
ClientVictor
Timeline2-3 Months
CategoryAI & Automation
TypeAutomation
Key Capabilities
  • Daily automated login to Cleveland Water and NEORSD portals for billing extraction
  • Automated scraping of balance, bill amount, due date, and statement date with PDF parsing and OCR support
  • Automatic flagging of accounts with past-due balances and inactive bill detection
  • Three-step validation pipeline including occupancy check, bill stability verification, and proration calculation
  • Automated daily email summary report for processed, skipped, and failed accounts
  • AppFolio integration with automated login and Twilio-based two-factor authentication handling
  • Automated storage of billing receipts and documents in Google Drive
  • Real-time dashboard showing properties, flagged accounts, charge history, and receipts
  • Ignored property management and inactive account tracking
  • End-to-end automated charge processing workflow
Project GalleryClick to enlarge

Want results like these?

Let's architect a solution engineered for your domain.

© 2026 Exitech EngineeringSan Francisco · New York · Austin