A premium, single-page React financial manager styled with custom Glassmorphic layers and neon accents. Built to run securely and scale seamlessly, this project orchestrates a modern frontend with Supabase BaaS (Backend-as-a-Service).
Key Technical Highlights
- Gemini AI Receipt & Statement Scanner: Automatically parse transactions from statement screenshots or photo receipts. Leverages Google AI Studio (Gemini 2.5 Flash) proxied securely through serverless Supabase Edge Functions to safeguard API credentials.
- Database-Level Audit Logs & Security: High-integrity PostgreSQL database triggers log write actions (INSERT, UPDATE, DELETE). Entirely protected by PostgreSQL Row-Level Security (RLS).
- Customizable Dashboard Layouts: Fully responsive dashboard supporting dynamic widgets layout configurations, persistent to the user’s settings profile.
- PWA Offline-First Sync: Fully configured Progressive Web App. Log transactions offline and let the PWA automatically queue and synchronize events back to the Supabase Postgres instance upon connection restoration.
- Cash Flow Simulator: Predicts monthly balance changes specifically for primary default bank accounts to help avoid unexpected overdrafts.
- Vitest Suite: Direct integration testing targeting RLS policies, trigger calculations, constraints, and double-entry savings transfers.
Architecture & Tech Stack
- Frontend: React 19, Vite, CSS
- Backend & DB: Supabase Kong Gateway, PostgREST, GoTrue Auth, Edge Functions, PostgreSQL 15
- Orchestration: Github Actions, Terraform
- Testing: Vitest, JSDOM