HOACentralPH — Multi-tenant SaaS Platform

thumbnail

date

Nov 19, 2025

slug

hoacentralph-project

status

Published

HOACentralPH — Multi-tenant SaaS Platform

HOACentralPH is a SaaS platform designed for Homeowners Associations (HOAs) in the Philippines. It features a multi-tenant architecture that isolates organization data while serving multiple subdivisions from a single unified codebase.

Product Overview & Problem Statement

Many residential subdivisions and HOAs in the Philippines rely on manual record-keeping, paper receipts for monthly dues, and fragmented chat groups for official announcements. This causes bookkeeping errors, poor payment visibility, and compliance friction.

HOACentralPH provides a centralized portal for HOA officers, board members, and homeowners to manage operations, track dues, handle facility reservations, and issue official notices.

Core Features

Multi-Tenant Architecture & Subdomains

Custom Subdomains: Each HOA organization gets its own dedicated vanity domain/subdomain (e.g., `greenwood.hoacentral.ph`).

Subdivision Landing Pages: Public-facing marketing and information page per HOA.

Isolated Tenant Data: Strict tenant query boundaries ensure no cross-subdivision data leaks.

Financial Management & Dues Tracking

Automated Invoicing: Generate monthly association dues statements automatically.

Payment Processing & Verification: Homeowners submit proof of payment; admins verify and issue digital receipts.

Expense & Budget Reporting: Real-time financial ledger tracking income vs. operational expenses.

Community & Operations

Facility Booking: Amenity reservation system (clubhouse, basketball court, pool) with conflict prevention.

Service Requests & Ticketing: Residents submit maintenance requests or incident reports directly to HOA officers.

Announcement Portal: Broadcast official notices via email (Nodemailer) and dashboard alerts.

Role-Based Access Control (RBAC): Distinct permissions for Super Admins, HOA Board Members, Staff, and Homeowner Members.

Technical Architecture & Tech Stack

Framework: Next.js (App Router)

Language: TypeScript

Styling & UI: Tailwind CSS, shadcn/ui

Database & ORM: Supabase (Postgres) with Drizzle ORM

Authentication: NextAuth.js / Supabase Auth

Transactional Email: Nodemailer

Hosting & Infrastructure: Vercel (Edge Functions & Multi-tenant Routing)

Key Technical Challenges & Solutions

1. Multi-Tenant Subdomain Routing

Using Next.js Middleware, incoming HTTP requests are inspected for custom hostnames/subdomains. The middleware rewrites the internal URL path to match the target tenant route dynamically while preserving clean URLs for users.

2. Tenant Data Isolation with Drizzle ORM & Postgres

Every table contains a `tenant_id` foreign key. Database queries are wrapped in tenant-aware helper functions that automatically inject `WHERE tenant_id = current_tenant`, preventing accidental data exposure across organizations.

Project Status

HOACentralPH is in active development and deployment for initial pilot subdivisions across the Philippines.