Custom Membership Platform

The Challenge

The organization managed member data across scattered spreadsheets, manual payment logs, and disconnected email lists. Staff spent hours reconciling dues payments with membership status, volunteer coordinators couldn't easily track engagement, and email campaigns required tedious manual list exports. Worse, multiple affiliated chapters needed their own branded portals but couldn't afford separate systems.

Our Approach

We built a unified membership platform using React with TypeScript for a modern, type-safe frontend, backed by Supabase's PostgreSQL database with built-in authentication and row-level security. The multi-tenant architecture allows multiple chapters to share infrastructure while maintaining separate branding, member data isolation, and custom configurations—all from a single codebase deployed to Vercel.

Key Features

• Smart Dues Tracking: Automatically calculates membership status based on $25/year threshold, with a grace period (Oct-Dec) where payments count toward both current and next year
• Volunteer Hour Logging: Members log their own hours while coordinators generate engagement reports and recognize top contributors
• Payment Platform Integration: Import donation records from external payment processors with intelligent reconciliation that detects duplicates and matches payments to member profiles
• Constant Contact Sync: One-click export of member segments to email marketing campaigns via OAuth2 integration
• Multi-Chapter Support: Shared database serves multiple organizations with custom branding, colors, social links, and donation URLs per chapter

The Results

• Consolidated 5+ data sources into a single source of truth
• Reduced payment reconciliation time from hours to minutes
• Enabled self-service member registration and profile management
• Provided chapter leaders with real-time membership status dashboards

Technologies Used

React, TypeScript, Vite, Tailwind CSS, Supabase (PostgreSQL), Constant Contact API, Vercel