A full-stack financial tracking and analytics platform built with React and Supabase that enables users to manage their personal expenses while providing admin-level financial intelligence across the entire platform.
The system supports:
- Google OAuth & email/password authentication
- Secure user-level data ownership
- Budget vs actual tracking
- Category & time-based analytics
- Admin-only financial oversight
- PostgreSQL Row Level Security (RLS)
| Layer | Technology |
|---|---|
| Frontend | React, JavaScript, Tailwind CSS |
| Backend / Auth | Supabase (PostgreSQL + Auth + RLS) |
| Database | PostgreSQL (via Supabase) |
| Charts | Recharts |
- User signs in using Google OAuth or email/password
- Supabase creates an authenticated session
- A database trigger automatically creates a
profilesrow - A role (
useroradmin) is assigned - User is redirected to the correct dashboard
- Every request is validated at the database level via RLS
Stores user roles and identity mapping.
| Column | Purpose |
|---|---|
| id | Supabase Auth user ID |
| role | user or admin |
| created_at | Account creation time |
Stores all expense records.
| Column | Purpose |
|---|---|
| id | Unique expense ID |
| user_id | Owner of the expense |
| item_name | What was purchased |
| category | Expense category |
| amount | Amount spent |
| expense_date | When it occurred |
| note | Optional description |
| created_at | Record creation time |
Stores category budgets per month.
| Column | Purpose |
|---|---|
| id | Unique budget ID |
| user_id | Budget owner |
| month | Budget month |
| category | Category |
| amount | Budgeted amount |
| created_at | When the budget was created |
- Can access only their own expenses and budgets
- Cannot view or modify any other user’s data
- Can read all expense data
- Cannot modify user records
All permissions are enforced directly by PostgreSQL RLS, preventing:
- Data leaks
- UI bypass attacks
- Unauthorized updates
- Secure authentication (Email/Password + Google OAuth)
- Add, edit, and delete expenses with:
- Item name
- Category
- Amount
- Date
- Notes
- Categorized expense tracking
- Monthly filtering
- Budget vs Actual tracking per category
- Smart insights:
- Overspending / Under-budget
- Top overspent & underspent categories
- Interactive charts:
- Category-wise spending (Pie chart)
- Monthly trend (Line chart)
- View all users’ expenses
- Switch between:
- Monthly analytics
- All-time analytics
- Platform-wide insights:
- Total spend
- Category distribution
- Monthly spending trends
The app computes:
- Monthly totals
- Category-wise totals
- Budget vs Actual variance
- Overspending / underspending
- Trends across time
All calculations are done in the frontend using normalized SQL data fetched securely from Supabase.
| Route | Access | Purpose |
|---|---|---|
/login |
Public | Authentication |
/dashboard |
User | Personal finance dashboard |
/admin |
Admin | Platform-wide analytics |
Login
User Dashboard
Budget vs Actual
Admin Dashboard
