OWE. / DEBT COLLECT
2026 · WIP
An actively developed cross-platform peer-to-peer loan and debt management ecosystem pairing a native Android mobile application (Kotlin 2.1, Jetpack Compose Material 3, Ktor, and Supabase Kotlin SDK v3) with a Next.js 15, React 19, TypeScript, and Tailwind CSS v4 Web Administration Console. Currently in active development, with an integrated AI Chat System coming soon to assist lenders and borrowers with smart repayment insights, automated reminders, and conversational debt queries.
PROBLEM & GOAL
Informal lending and borrowing between individuals often suffers from disputed balances, lost GCash/bank reference numbers, and forgotten installment dates. Both lenders and borrowers needed a shared, transparent ledger where loan terms, installment schedules, and payment confirmations are mutually verified—backed by an administrative operations console for auditing, support triage, and remote app configuration.
END-TO-END EXECUTION
Engineered a dual-application ecosystem on Supabase. Built OWE_Mobile natively for Android using Kotlin 2.1 and Jetpack Compose (Material 3), featuring a unified Lender ("Money I Lent") and Borrower ("Money I Owe") workflow, automated Flat-Rate (₱) and Percentage (%) installment calculators, 7-day expiring Borrower Invite Codes (DC-XXXXXX), GCash/Maya/Bank payment submission with lender verification, cascading PSGC Philippine address selection, offline LocalDiskCache, and Google AdMob + OWE Pro subscription tiers. Paired it with OWE_Admin in Next.js 15 (App Router, Turbopack, Server Actions) and React 19 for portfolio collection analytics, immutable audit logs, support ticket triage, real-time broadcast announcements, and remote feature flags—with an in-app AI Chat System currently in progress.
- Native Android App (Kotlin 2.1, Jetpack Compose Material 3, Navigation Compose, MVVM)
- Next.js 15 & React 19 Admin Console (App Router, Server Actions, TypeScript, Tailwind CSS v4)
- Supabase PostgreSQL Views (debt_summary), RLS Policies, Auth & Realtime Channels
- Dual Lender & Borrower Engine with 7-Day Expiring Invite Codes (DC-XXXXXX)
- Installment Calculator (Flat Rate ₱ / Percentage %, 3m–24m) & Payment Verification Flow
- Upcoming Roadmap: Integrated AI Chat System for Smart Loan & Repayment Assistance (In Progress)
ROLE MODULE 01 // KOTLIN & JETPACK COMPOSE ANDROID APP (18 SCREENS)
Lender & Borrower
Android app.
Native Android application built with Kotlin 2.1, Jetpack Compose (Material 3), Ktor, and Supabase Kotlin SDK—unifying Lender and Borrower workflows with invite-code loan linking, installment calculation, GCash/Maya payment verification, PSGC address lookup, and OWE Pro upgrades.
Interactive onboarding slide ("01 · BORROW & LEND — Borrow & Lend with Clarity") introducing instant loan creation and invite-code linking.
OWE. sign-in screen featuring the signature owl emblem ("BORROW · TRACK · SETTLE"), email/password login, Remember Me, and password recovery.
Structured account creation capturing Personal Information and cascading Philippine Standard Geographic Code (PSGC) Address Details (Province, Municipality/City, Barangay).
Password reset flow dispatching a 6-digit email verification code via Supabase Auth.
Home dashboard with Money I Lent / Money I Owe mode switcher, Total Outstanding card (₱125,000.00), Total Lent (₱174,620.00), Collected (₱49,620.00), status filters, and active debt progress.
New Debt builder supporting Flat Rate (₱) and Percentage (%) interest, duration chips (3m, 6m, 12m, 24m), monthly Pay Day (1–31), and live Monthly Payment & Total to Collect calculation.
Post-creation screen generating a 7-day expiring Borrower Invite Code (DC-73772B) with direct sharing via Messenger, WhatsApp, SMS, Copy Link, or code regeneration.
Real-time alert center notifying the lender when a borrower accepts and joins a loan record using their invite code.
All Debts tab with All Debts / Money Lent / Money Owed filters, pending invite alert banner, Active/Overdue/Fully Paid counters, and status-badged loan cards.
Lender loan breakdown displaying Borrower info, ₱125,000.00 remaining balance (16% paid), 2 of 12 paid installments (₱12,500.00/mo), next due date, and confirmed GCash payments.
Verified payment history view tracking each installment amount, GCash payment method, reference number, and confirmation status.
Recent Activity stream with category filters (All Activity, Payments, Debts Created, Pending), Collected This Month banner (₱49,620.00 · 9 events), and chronological ledger updates.
Borrower-side All Debts view displaying active and fully paid loans owed to lender Dua Orlina with real-time progress bars.
Borrower loan detail view showing the Lender profile (Dua Orlina), remaining balance, monthly installment schedule, payment history, and Submit Payment CTA.
Borrower payment submission form with auto-filled installment amount, Pay full balance shortcut, Payment Method pills (Cash, GCash, Maya, Bank Transfer, Other), Reference Number input, and installment tracker (Installment 3 of 12).
User profile and settings screen featuring Verified Account badge, Upgrade to OWE Pro banner (₱99/mo for unlimited debts, PDF export & no ads), security controls, and build version.
In-app Change Password bottom sheet dialog validating current and new account credentials.
Direct Help & Support ticket composer allowing users to submit issues straight into the OWE Admin Support Tickets queue.
ROLE MODULE 02 // NEXT.JS 15 & TAILWIND v4 WEB ADMIN CONSOLE (9 SCREENS)
Next.js 15 Admin
web console.
Full-stack operations and analytics console built with Next.js 15 (App Router, Turbopack, Server Actions), React 19, TypeScript, Tailwind CSS v4, and Supabase Service-Role SSR—monitoring portfolio collection health, users, debts, payments, audit trails, support tickets, real-time announcements, and dynamic JSONB app config.
Admin Overview featuring Total Collected (₱49,620.00), KPI cards, Collection Rate radial gauge (28% Collected of ₱174,894.29 portfolio), 6-Month Collections bar chart, Portfolio Health breakdown, Payments by Method (GCash), and Recent Debt Audit Activity.
Paginated user profiles table displaying Full Name, Supabase User UUID, Phone number, PSGC Barangay/Municipality/Province location, and Joined date.
All debt records queried from the PostgreSQL debt_summary view showing Outstanding Balance (₱125,274.29), Overdue count, Total, Paid, Remaining balance, Due Date, and status badges (Awaiting Borrower, Active, Paid).
Master ledger of submitted, confirmed, and rejected borrower payments displaying Amount, Payment Method (GCASH), Reference Number, Date, Status badge, and Proof.
Subscription monitoring module tracking OWE Pro user plans, billing statuses, start dates, and expiration timestamps.
Immutable audit trail logging system-wide events (Invite Code Generated, Debt Joined, Payment Confirmed, Payment Rejected, Debt Paid) with Debt title/UUID, Actor UUID, and timestamp.
Customer support management table with status filter tabs (All, Open, In Progress, Resolved, Closed), user email, ticket message, and live status dropdown actions.
Broadcast composer and history manager for publishing Info, Promo, Warning, and Maintenance banners directly to the Android app via Supabase Realtime.
Dynamic JSONB remote configuration panel (app_config) controlling ads_enabled, free_active_debt_limit, interstitial_cooldown_minutes, maintenance_mode, pro_lifetime_price, and pro_monthly_price in real time.
NEXT CASE STUDY // 03
SCILAB RESERVE 3.0
SUPABASE + FLUTTER DESKTOP + WEB ECOSYSTEM
VIEW NEXT PROJECT →