← back to projects

BayaniRemit

Spring 2026

Relational database and YNAB-style envelope tracker for OFW remittance and household allocation.

Next.jsReact 19TypeScriptPostgreSQLSupabaseTailwind CSSZustandRecharts
BayaniRemit
BATCH #RM-2026-09
$1,200 → ₱67,440
56.20 PHP/USD
Household & Groceries
₱25,00078%
Tuition & Books
₱18,000100%
Medical Emergency
₱14,44042%
3NF SchemaRLS Verified

overview

Overseas Filipino Workers (OFWs) send remittances home every month, yet families often lack a unified system to track how transfer batches are allocated across household needs, tuition, debt, and savings goals. BayaniRemit is a relational database and household envelope budgeting platform built for OFWs and their beneficiaries.

Architected around an 11-table, Third Normal Form (3NF) PostgreSQL schema (profiles, beneficiaries, income_sources, transfer_providers, exchange_rate_snapshots, remittance_batches, envelopes, envelope_allocations, transactions, savings_goals, and audit_log) with Supabase Row Level Security, it pairs strict relational integrity with a clean monochromatic dark fintech interface.

Remitters can split incoming transfer batches across custom household envelopes, log local PHP (₱) expenses against allocations, compare transfer provider fee snapshots, and export chronological audit ledgers to CSV.

architecture & capabilities

11-Table, 3NF Relational Schema

Normalized PostgreSQL database modeling remittance batches, exchange rate snapshots, beneficiaries, and envelope allocations with RLS.

YNAB-Style Household Envelope Budgeting

Splits remittance inflows across dedicated family expense categories with real-time On Track / Over Budget status tracking.

Audit Trail & Ledger CSV Export

Chronological transaction logging across currencies and transfer providers with one-click spreadsheet export.