Expense Tracking System 💰📊

A full-stack Expense Tracking System built using FastAPI, Streamlit, and MySQL.
This application allows users to add daily expenses, update them, and visualize category-wise expense analytics over a selected date range.

---

🚀 Features

• Add or update daily expenses
• Store expenses in a MySQL database
• View expenses by date
• Analyze expenses by category
• Percentage-based expense breakdown
• Interactive UI using Streamlit
• REST APIs powered by FastAPI

---

🛠️ Tech Stack

• Backend: FastAPI\
• Frontend: Streamlit\
• Database: MySQL\
• DB Connector: mysql-connector-python\
• Data Handling: Pandas\
• API Calls: Requests

---

📂 Project Structure

expense-tracker/
│
├── server.py
├── db_helper.py
├── app.py
├── add_update_ui.py
├── analytics_ui.py
├── logging_setup.py
├── conftest.py
├── requirements.txt
└── README.md

---

🗄️ Database Setup

CREATE DATABASE expense_manager;

USE expense_manager;

CREATE TABLE expenses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    expense_date DATE NOT NULL,
    amount FLOAT NOT NULL,
    category VARCHAR(50),
    notes VARCHAR(255)
);

---

▶️ Running the Application

Start Backend

uvicorn server:app --reload

Start Frontend

streamlit run app.py

---

📜 License

MIT License