Project: Personal Expense Tracker

# Project: Personal Expense Tracker Build a comprehensive expense tracking application with SQLite database, CRUD operations, reports, and visual charts. ## Project Features - Add, edit, delete expenses - Categorize expenses (Food, Transport, Education, etc.) - Monthly and category-wise reports - Matplotlib visualizations - Budget alerts and warnings - CSV export functionality ## Project Structure ``` expense_tracker/ ├── expense_tracker.py ├── database.db (SQLite) ├── requirements.txt └── reports/ └── monthly_report.csv ``` ## Database Schema ```sql CREATE TABLE categories ( id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL ); CREATE TABLE expenses ( id INTEGER PRIMARY KEY, date TEXT NOT NULL, category_id INTEGER NOT NULL, amount REAL NOT NULL, description TEXT, FOREIGN KEY (category_id) REFERENCES categories(id) ); CREATE TABLE budget ( id INTEGER PRIMARY KEY, category_id INTEGER NOT NULL, limit_amount REAL NOT NULL, month TEXT, FOREIGN KEY (category_id) REFERENCES categories(id) ); ``` ## Implementation Code ```python import sqlite3 import csv from datetime import datetime from collections import defaultdict import matplotlib.pyplot as plt class ExpenseTracker: def __init__(self, db_name='expenses.db'): self.conn = sqlite3.connect(db_name) self.cursor = self.conn.cursor() self.init_database() def init_database(self): """Initialize database tables""" self.cursor.execute(''' CREATE TABLE IF NOT EXISTS categories ( id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL ) ''') self.cursor.execute(''' CREATE TABLE IF NOT EXISTS expenses ( id INTEGER PRIMARY KEY, date TEXT NOT NULL, category_id INTEGER NOT NULL, amount REAL NOT NULL, description TEXT, FOREIGN KEY (category_id) REFERENCES categories(id) ) ''') self.cursor.execute(''' CREATE TABLE IF NOT EXISTS budget ( id INTEGER PRIMARY KEY, category_id INTEGER NOT NULL, limit_amount REAL NOT NULL, month TEXT, FOREIGN KEY (category_id) REFERENCES categories(id) ) ''') self.conn.commit() self.init_default_categories() def init_default_categories(self): """Create default expense categories""" default_cats = [ "Food & Dining", "Transport", "Education", "Entertainment", "Utilities", "Healthcare", "Shopping", "Other" ] for cat in default_cats: try: self.cursor.execute( 'INSERT INTO categories (name) VALUES (?)', (cat,) ) except sqlite3.IntegrityError: pass # Already exists self.conn.commit() def add_expense(self, date, category, amount, description=""): """Add new expense""" try: self.cursor.execute( 'SELECT id FROM categories WHERE name = ?', (category,) ) cat_id = self.cursor.fetchone()[0] self.cursor.execute( '''INSERT INTO expenses (date, category_id, amount, description) VALUES (?, ?, ?, ?)''', (date, cat_id, amount, description) ) self.conn.commit() print(f"Expense added: ₹{amount} for {category}") except Exception as e: print(f"Error adding expense: {e}") def edit_expense(self, expense_id, date=None, category=None, amount=None, description=None): """Edit existing expense""" updates = [] params = [] if date: updates.append("date = ?") params.append(date) if amount: updates.append("amount = ?") params.append(amount) if description: updates.append("description = ?") params.append(description) if category: self.cursor.execute('SELECT id FROM categories WHERE name = ?', (category,)) cat_id = self.cursor.fetchone()[0] updates.append("category_id = ?") params.append(cat_id) if updates: params.append(expense_id) query = f"UPDATE expenses SET {', '.join(updates)} WHERE id = ?" self.cursor.execute(query, params) self.conn.commit() print("Expense updated!") def delete_expense(self, expense_id): """Delete expense""" self.cursor.execute('DELETE FROM expenses WHERE id = ?', (expense_id,)) self.conn.commit() print("Expense deleted!") def get_all_expenses(self): """Retrieve all expenses""" self.cursor.execute(''' SELECT e.id, e.date, c.name, e.amount, e.description FROM expenses e JOIN categories c ON e.category_id = c.id ORDER BY e.date DESC ''') return self.cursor.fetchall() def get_expenses_by_date(self, start_date, end_date): """Get expenses within date range""" self.cursor.execute(''' SELECT e.id, e.date, c.name, e.amount, e.description FROM expenses e JOIN categories c ON e.category_id = c.id WHERE e.date BETWEEN ? AND ? ORDER BY e.date DESC ''', (start_date, end_date)) return self.cursor.fetchall() def get_monthly_summary(self, month): """Get summary for a specific month""" self.cursor.execute(''' SELECT c.name, SUM(e.amount) as total FROM expenses e JOIN categories c ON e.category_id = c.id WHERE strftime('%Y-%m', e.date) = ? GROUP BY c.name ORDER BY total DESC ''', (month,)) return self.cursor.fetchall() def calculate_category_total(self, category, month=None): """Calculate total spending in category""" if month: self.cursor.execute(''' SELECT SUM(amount) FROM expenses WHERE category_id = (SELECT id FROM categories WHERE name = ?) AND strftime('%Y-%m', date) = ? ''', (category, month)) else: self.cursor.execute(''' SELECT SUM(amount) FROM expenses WHERE category_id = (SELECT id FROM categories WHERE name = ?) ''', (category,)) result = self.cursor.fetchone()[0] return result if result else 0 def set_budget(self, category, limit_amount, month): """Set budget limit for category""" self.cursor.execute('SELECT id FROM categories WHERE name = ?', (category,)) cat_id = self.cursor.fetchone()[0] self.cursor.execute(''' INSERT OR REPLACE INTO budget (category_id, limit_amount, month) VALUES (?, ?, ?) ''', (cat_id, limit_amount, month)) self.conn.commit() print(f"Budget set for {category}: ₹{limit_amount}") def check_budget_alerts(self, month): """Check if any category exceeds budget""" self.cursor.execute(''' SELECT c.name, b.limit_amount, SUM(e.amount) as spent FROM budget b JOIN categories c ON b.category_id = c.id LEFT JOIN expenses e ON c.id = e.category_id AND strftime('%Y-%m', e.date) = ? WHERE b.month = ? GROUP BY c.name HAVING spent > b.limit_amount ''', (month, month)) alerts = self.cursor.fetchall() if alerts: print("\nBUDGET ALERTS:") for cat, limit, spent in alerts: excess = spent - limit print(f"⚠️ {cat}: Exceeded by ₹{excess:.2f} (Budget: ₹{limit}, Spent: ₹{spent:.2f})") return alerts def plot_monthly_chart(self, month): """Create pie chart of monthly expenses""" data = self.get_monthly_summary(month) if not data: print("No expenses for this month!") return categories = [item[0] for item in data] amounts = [item[1] for item in data] plt.figure(figsize=(10, 6)) plt.pie(amounts, labels=categories, autopct='%1.1f%%', startangle=90) plt.title(f"Expense Distribution - {month}") plt.tight_layout() plt.savefig(f"monthly_report_{month}.png") print(f"Chart saved: monthly_report_{month}.png") plt.show() def export_to_csv(self, filename="expenses_report.csv"): """Export all expenses to CSV""" expenses = self.get_all_expenses() with open(filename, 'w', newline='', encoding='utf-8') as f: writer = csv.writer(f) writer.writerow(['ID', 'Date', 'Category', 'Amount', 'Description']) writer.writerows(expenses) print(f"Report exported to {filename}") def display_menu(self): """Display main menu""" print("\n" + "="*50) print("PERSONAL EXPENSE TRACKER") print("="*50) print("1. Add Expense") print("2. View All Expenses") print("3. Monthly Report") print("4. Set Budget") print("5. Check Budget Alerts") print("6. Plot Monthly Chart") print("7. Export to CSV") print("8. Exit") print("="*50) def run(self): """Main application loop""" while True: self.display_menu() choice = input("Enter choice: ") if choice == "1": date = input("Date (YYYY-MM-DD) [today]: ") or datetime.now().strftime("%Y-%m-%d") category = input("Category: ") amount = float(input("Amount (₹): ")) description = input("Description: ") self.add_expense(date, category, amount, description) elif choice == "2": expenses = self.get_all_expenses() print("\nAll Expenses:") print(f"{'ID':<5} {'Date':<12} {'Category':<20} {'Amount':<10} {'Description':<20}") print("-"*70) for e in expenses: print(f"{e[0]:<5} {e[1]:<12} {e[2]:<20} ₹{e[3]:<8.2f} {e[4]:<20}") elif choice == "3": month = input("Month (YYYY-MM): ") summary = self.get_monthly_summary(month) print(f"\nMonthly Summary - {month}:") total = 0 for cat, amount in summary: print(f"{cat}: ₹{amount:.2f}") total += amount print(f"Total: ₹{total:.2f}") elif choice == "4": category = input("Category: ") limit = float(input("Budget Limit (₹): ")) month = input("Month (YYYY-MM): ") self.set_budget(category, limit, month) elif choice == "5": month = input("Month (YYYY-MM): ") self.check_budget_alerts(month) elif choice == "6": month = input("Month (YYYY-MM): ") self.plot_monthly_chart(month) elif choice == "7": self.export_to_csv() elif choice == "8": self.conn.close() print("Goodbye!") break else: print("Invalid choice!") if __name__ == "__main__": tracker = ExpenseTracker('expenses.db') tracker.run() ``` ## Real-World Applications in India ### UPI Transaction Tracking Track UPI payments to different merchants and categorize them automatically. ### GST Expense Tracking For small businesses, track expenses with GST categories for tax filing. ## Extension Ideas 1. Add recurring expenses 2. Implement email reports 3. Add expense categories OCR from receipts 4. Multi-currency support 5. Sync with bank statements ## Summary This project teaches database design, CRUD operations, data visualization, and financial management concepts applicable to personal and business accounting.

---

From Concept to Reality: Project: Personal Expense Tracker

In the professional world, the difference between a good engineer and a great one often comes down to understanding fundamentals deeply. Anyone can copy code from Stack Overflow. But when that code breaks at 2 AM and your application is down — affecting millions of users — only someone who truly understands the underlying concepts can diagnose and fix the problem.

Project: Personal Expense Tracker is one of those fundamentals. Whether you end up working at Google, building your own startup, or applying CS to solve problems in agriculture, healthcare, or education, these concepts will be the foundation everything else is built on. Indian engineers are known globally for their strong fundamentals — this is why companies worldwide recruit from IITs, NITs, IIIT Hyderabad, and BITS Pilani. Let us make sure you have that same strong foundation.

Computational Thinking: The Superpower of Problem Solving

Computational thinking is not about computers — it is a way of thinking that helps you solve ANY problem. It has four key parts:

  THE FOUR PILLARS OF COMPUTATIONAL THINKING: 1. DECOMPOSITION — Break big problems into small ones Problem: "Build a food delivery app" Decomposed: User signup → Restaurant listing → Menu display → Cart system → Payment → Order tracking → Delivery 2. PATTERN RECOGNITION — Find similarities "Traffic gets bad at 9 AM and 6 PM" → Rush hour pattern "Sales spike in October-November" → Festival season pattern "Students score low on Chapter 7" → Difficult topic pattern 3. ABSTRACTION — Ignore irrelevant details Driving directions: You care about turns and distances. You DON'T care about: colour of buildings, brand of cars, type of trees along the road. 4. ALGORITHM DESIGN — Create step-by-step solutions Problem: "Find the cheapest flight Delhi → Bangalore" Algorithm: 1. Get all available flights 2. Filter by date 3. Sort by price (lowest first) 4. Check ratings ≥ 3 stars 5. Return the top result

These skills are tested in competitive exams like JEE, Olympiads, and even UPSC. When you decompose a physics problem into free body diagrams, you are using decomposition. When you recognise that projectile motion follows the same equations regardless of the object, you are using pattern recognition. Computational thinking is the foundation of all scientific reasoning.

Real-World System Design: Swiggy's Architecture

When you order food on Swiggy, here is what happens behind the scenes in about 2 seconds: your location is geocoded (algorithms), nearby restaurants are queried from a spatial index (data structures), menu prices are pulled from a database (SQL), delivery time is estimated using ML models trained on historical data (AI), the order is placed in a distributed message queue (Kafka), a delivery partner is assigned using a matching algorithm (optimization), and real-time tracking begins using WebSocket connections (networking). EVERY concept in your CS curriculum is being used simultaneously to deliver your biryani.

---

Neural Networks: Layers of Learning

A neural network is inspired by how your brain works. Your brain has billions of neurons connected to each other. When you see, hear, or think something, electrical signals flow through these connections. A neural network simulates this with layers of mathematical operations:

  INPUT LAYER HIDDEN LAYERS OUTPUT LAYER (Raw Data) (Feature Extraction) (Decision) Pixel 1 ──┐ Pixel 2 ──┤ ┌─[Neuron]─┐ Pixel 3 ──┼───▶│ Edges & │───┐ Pixel 4 ──┤ │ Corners │ │ ┌─[Neuron]─┐ Pixel 5 ──┤ └───────────┘ ├───▶│ Face │──▶ "It's a cat!" (92%) ... │ ┌─[Neuron]─┐ │ │ Features │ "It's a dog" (7%) Pixel N ──┤ │ Shapes & │───┘ │ + Body │ "Other" (1%) └───▶│ Textures │───────▶│ Shape │ └───────────┘ └──────────┘ Layer 1: Detects simple features (edges, gradients) Layer 2: Combines into complex features (eyes, ears, whiskers) Layer 3: Makes the final decision based on all features

Each connection between neurons has a "weight" — a number that determines how important that connection is. During training, the network adjusts these weights to minimise errors. This is done using an algorithm called backpropagation combined with gradient descent. The loss function measures how wrong the network is, and gradient descent follows the slope downhill to find better weights.

Modern networks like GPT-4 have billions of parameters (weights) and are trained on massive GPU clusters. India's Sarvam AI is training models specifically for Indian languages — Hindi, Tamil, Telugu, Bengali, and more — because global models often perform poorly on Indic scripts and cultural contexts.

Production Engineering: Project: Personal Expense Tracker at Scale

Understanding project: personal expense tracker at an academic level is necessary but not sufficient. Let us examine how these concepts manifest in production environments where failure has real consequences.

Consider India's UPI system processing 10+ billion transactions monthly. The architecture must guarantee: atomicity (a transfer either completes fully or not at all — no half-transfers), consistency (balances always add up correctly across all banks), isolation (concurrent transactions on the same account do not interfere), and durability (once confirmed, a transaction survives any failure). These are the ACID properties, and violating any one of them in a payment system would cause financial chaos for millions of people.

At scale, you also face the thundering herd problem: what happens when a million users check their exam results at the same time? (CBSE result day, anyone?) Without rate limiting, connection pooling, caching, and graceful degradation, the system crashes. Good engineering means designing for the worst case while optimising for the common case. Companies like NPCI (the organisation behind UPI) invest heavily in load testing — simulating peak traffic to identify bottlenecks before they affect real users.

Monitoring and observability become critical at scale. You need metrics (how many requests per second? what is the 99th percentile latency?), logs (what happened when something went wrong?), and traces (how did a single request flow through 15 different microservices?). Tools like Prometheus, Grafana, ELK Stack, and Jaeger are standard in Indian tech companies. When Hotstar streams IPL to 50 million concurrent users, their engineering team watches these dashboards in real-time, ready to intervene if any metric goes anomalous.

The career implications are clear: engineers who understand both the theory (from chapters like this one) AND the practice (from building real systems) command the highest salaries and most interesting roles. India's top engineering talent earns ₹50-100+ LPA at companies like Google, Microsoft, and Goldman Sachs, or builds their own startups. The foundation starts here.

Key Vocabulary

Here are important terms from this chapter that you should know:

💡 Interview-Style Problem

Here is a problem that frequently appears in technical interviews at companies like Google, Amazon, and Flipkart: "Design a URL shortener like bit.ly. How would you generate unique short codes? How would you handle millions of redirects per second? What database would you use and why? How would you track click analytics?"

Think about: hash functions for generating short codes, read-heavy workload (99% redirects, 1% creates) suggesting caching, database choice (Redis for cache, PostgreSQL for persistence), and horizontal scaling with consistent hashing. Try sketching the system architecture on paper before looking up solutions. The ability to think through system design problems is the single most valuable skill for senior engineering roles.

Where This Takes You

The knowledge you have gained about project: personal expense tracker is directly applicable to: competitive programming (Codeforces, CodeChef — India has the 2nd largest competitive programming community globally), open-source contribution (India is the 2nd largest contributor on GitHub), placement preparation (these concepts form 60% of technical interview questions), and building real products (every startup needs engineers who understand these fundamentals).

India's tech ecosystem offers incredible opportunities. Freshers at top companies earn ₹15-50 LPA; experienced engineers at FAANG companies in India earn ₹50-1 Cr+. But more importantly, the problems being solved in India — digital payments for 1.4 billion people, healthcare AI for rural areas, agricultural tech for 150 million farmers — are some of the most impactful engineering challenges in the world. The fundamentals you are building will be the tools you use to tackle them.

Crafted for Class 7–9 • Projects & Applied • Aligned with NEP 2020 & CBSE Curriculum