The problem
Property managers juggling fragmented spreadsheets, manual M-Pesa receipt verification, lost maintenance requests, and missed lease renewal notices across multi-unit portfolios.
My responsibility
Built the unified lease tracking database, automated M-Pesa payment matching webhook, maintenance ticket routing engine, and automated tenant reminder sequence.
System route
The architecture below is a readable abstraction of the documented workflow, not a simulated live execution.
- Track unit vacancies, tenant leases, deposit ledgers, and rent due dates in Supabase
- Reconcile incoming bank and M-Pesa payments against tenant invoice balances automatically
- Triage tenant maintenance requests submitted via WhatsApp and route to verified contractors
- Dispatch automated, polite rent reminders, receipt statements, and lease renewal notices
Reliability notes
- M-Pesa payment matching verifies reference codes, exact amounts, and timestamps before marking invoices paid.
- Data isolation ensures property owners and tenants access only their respective lease records.
Operational Architecture & Deep Dive
In production automation, reliability is never an afterthought. Every mission engineered for Property Management System is designed around strict input validation contracts, bounded execution permissions, and deterministic error fallback channels. Unstructured data is parsed into schema-validated JSON before entering downstream business logic, preventing malformed payloads from corrupting state stores or generating cascading failures.
When integrating large language models with operational databases and third-party APIs (Next.js 15, Supabase, n8n), workflows utilize prompt-injection filtering, deterministic routing, and transactional rollback mechanisms. Rather than treating failures as exceptions, the architecture explicitly models failure as a first-class execution path with automated retry policies and real-time alerting.
Evidence currently available
- Database schema design
- Automated payment reconciliation flow
- Tenant messaging dispatcher
Technology used
Zero-Trust Governance & HarLyn Security Standards
Through HarLyn Digital Partners, we review automated systems for security risks using threat modeling, OWASP-aligned checks, and technical data protection site audits led by Nazline Mwita. We store API keys in secure vaults and limit their permissions to reduce exposure.
Evidence Verification & Authorized Review
Client-approved execution recordings, live production endpoints, sanitized payload schemas, and verifiable metric baselines are documented across HarLyn Digital Partners repositories. Teams seeking an in-depth operational audit can explore our fixed-fee 48-Hour Secure Digital Workflow Assessment.