Personal Finance Tracker

A simple web-based personal finance tracker built with HTML, CSS, PHP, and MySQL. This tool helps users manage their income and expenses, track financial history, and maintain budget clarity through a clean and user-friendly dashboard interface.

---

🚀 Features

• 🔐 User Authentication (Login & Register)
• 📥 Income & Expense Entry
• 📊 Expense History Dashboard
• 📂 Category-wise Breakdown
• 💾 Data Storage in MySQL Database
• 🎨 Clean and Modern UI (Blue-Green Theme)

---

🛠️ Tech Stack

• Frontend: HTML, CSS
• Backend: PHP
• Database: MySQL
• Server: XAMPP / LAMP / WAMP

📊 Database Schema

users Table:

Column	Type
id	INT (PK)
name	VARCHAR
email	VARCHAR
password	VARCHAR

CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255), email VARCHAR(255) UNIQUE, password VARCHAR(255) );

finance Table:

Column	Type
id	INT (PK)
user_id	INT (FK)
type	ENUM('income','expense')
amount	DECIMAL
category	VARCHAR
reason	TEXT
created_at	TIMESTAMP

CREATE TABLE finance ( id INT PRIMARY KEY AUTO_INCREMENT, user_id INT, type ENUM('income', 'expense'), amount DECIMAL(10,2), category VARCHAR(100), reason TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE );

---

Screenshots

Index Page

Registration Page

Login Page

Home Page

Manage Personal Finance - Set Monthly Income

Manage Personal Finance - Add Expenses

Manage Personal Finance - Transaction History fetched from the database

Manage Personal Finance - Pie Chart for expense breakdown

Manage Personal Finance - Pie Chart for Income breakdown (Regular or Bonus)

Manage Personal Finance - A Financial Journal, which categorizes the income, expenditure and savings monthwise

Savings Planner - with progress bar to denote your progress with respect the goal you have set and gives suggestions based on it

Saving Planner - Partner Budgeting (to check the expenditure of each person and get suggestions based on it)

Bill Splitter - to split bills based on the number of people and percentage of split

Cuurency Convertor and Net Worth Calculator

Profile Page for each user

Financial Summary for the current month

Needs Vs Wants

Monthly Expenses Chart

Category wise monthly expense

Personalized Budget Recommedations for every user

---

⚙️ Setup Instructions

1. Clone this repository:

git clone https://github.com/JAIdamodharan/expense-tracker.git

1.	Import finance.sql into your MySQL database using phpMyAdmin or CLI.
2.	Configure database credentials in PHP files (e.g., dashboard.php, login.php, etc.)
3.	Start Apache & MySQL via XAMPP/WAMP/LAMP
4.	Access in browser:

http://localhost/expense_tracker/pages

✍️ Author

Jaishree Third-year Software Engineering Student | VIT Vellore Passionate about Web Development, AI/ML, and Building Real-world Projects