💰 Indian Household Expense Tracker (Full Stack)

A full-stack expense tracking platform designed for Indian households.
It helps you manage monthly expenses, household help salaries, advances, absences, overdue payments, and detailed reports — all in one place.

Built with Next.js, Supabase, and Chakra UI, real-time alerts, interactive charts, and a Chatling AI assistant that can answer questions about the web app in natural language.

---

🌐 Live Demo

🔗 hxcal.com (Next.js)

---

🛠️ Tech Stack

Frontend:

• Next.js (React)
• Chakra UI
• Chartjs (charts & graphs)

Backend:

• Supabase (PostgreSQL + Auth + RLS)
• Supabase Functions & Scheduled Edge Functions

Integrations:

• Google Sheets API (data sync)
• Chatling AI Assistant (personalized Q&A)

---

✅ Features

👥 Authentication & Access

• Email/password sign-up & login via Supabase Auth
• Row Level Security to isolate each user’s data

📊 Expense Tracking

• Track expenses by category and subcategory
• Categories include Household Help, Utilities, etc.
• Salaries for household help are recorded as expenses

📅 Absences & Salary Deduction

• Record absences per person
• Option to deduct salary for absences (auto-adjusts monthly salary)
• View absence history for the last 6 months (line chart with month-year format)
• Alerts if someone has more than 2 absences in a month

💵 Advances Handling

• Record salary advances for workers
• Auto-adjust monthly salary after deductions
• Integrated into HelpNavbar

📦 Overdue Payments

• Track overdue payments for:
  • Household Help → Name - Role
  • Utilities → Subcategory name (e.g., Electricity)
• Automatically add overdue payment entries when:
  • A new household help is added
  • A new utility expense is added
• Monthly scheduled function to carry forward unpaid dues
• Overdue section includes:
  • Summary cards → Total, 0–30 days, 30–60 days overdue
  • Grouped & collapsible lists
  • Paid/unpaid toggle with dynamic updates
  • Separate section for paid overdue payments

📈 Reports & Charts

• Monthly expense view by year
• Category-wise and subcategory-wise breakdown for any month/year
• Interactive charts:
  • Click bar chart month → category pie chart → subcategory pie chart
• Powered by Supabase functions with auth.user context

🚨 Alerts

• Show at top of dashboard when:
  • Current month’s expenses exceed 15% of last month’s
  • A person has more than 2 absences this month

🧭 HelpNavbar

• Dropdown to select role/subcategory (e.g., Maid, Driver)
• Lists people under selected role in a styled format
• Manages salary, absences, and advances in one place

📸 Screenshots

🏠 Main Dashboard

Landing page showing expense summary, alerts, and quick stats.
![Dashboard]

---

📊 Category & Subcategory View

Breakdown of expenses by category and subcategory.
![Category & Subcategory]

)

---

📅 Absences (Last 6 Months)

Absence tracking for each household help member over the last six months.
![Absences 6 Months]

---

👥 Household Help Overview

List of all household help with quick info and actions.
![Household Help Overview]

---

🧍 Individual Person Page

Detailed view for a single household help member.
![Individual Person]

---

➕ Adding Absences

Form to add and record absences for household help.
![Add Absence]

---

💰 Salary View

Monthly salary details and payment tracking for household help.
![Salary View]

📝 Add Expenses Form

Form to add new expenses with category, subcategory, and amount.
![Add Expenses]

---

📆 Monthly Expense Breakdown

Chart showing monthly expenses per category for a selected year.
![Monthly Expense Breakdown]

---

🚨 Overdue Payments

List of unpaid household help salaries and utility bills with payment status.
![Overdue Payments]

---

🔐 Sign-In Page

Login with email/password or Google account.
![Sign In]