Capstone Project: Personal Finance & Expense Tracker0%

Capstone Project: Personal Finance & Expense Tracker

Beginner16 min read•Updated: 2026-09-30

Capstone Project: Personal Finance & Expense Tracker

Personal budget tracking is an essential everyday utility. Without careful bookkeeping, small daily purchases slip by unnoticed until bank balances drop unexpectedly.

In this capstone project, you will build a production-grade Command-Line Expense Tracker. You will integrate Python data structures (lists, dictionaries), floating-point arithmetic, category-based aggregations, budget threshold alerts, and CSV file persistence with the context manager.

Real-World Analogy: The Indian "Ghar Ka Kharcha" Monthly Ledger

In Indian households, the monthly budget diary—affectionately called Ghar Ka Kharcha—keeps finances organized:

Visual Architecture Blueprint

+-------------------------------------------------------------------------+
|                  "GHAR KA KHARCHA" BUDGET ENGINE ARCHITECTURE           |
+-------------------------------------------------------------------------+
|                                                                         |
|   [ User CLI Input ] ──> Title, Amount (₹), Category (Rashan, Rent, etc)|
|           │                                                             |
|           ▼                                                             |
|   [ Validator Layer ] ──> Checks: Amount > 0, Category in allowed set   |
|           │                                                             |
|           ▼                                                             |
|   [ Analytics Engine ]                                                  |
|       ├─ Calculate Total Expenditure                                    |
|       ├─ Group by Category using dict.get() Aggregator                  |
|       └─ Trigger Budget Warning if Total > Monthly Budget Limit (₹)     |
|           │                                                             |
|           ▼                                                             |
|   [ Storage Engine ] ──> Read/Write to expenses.csv via with open()     |
|                                                                         |
+-------------------------------------------------------------------------+

Every purchase is logged under an explicit category (Kirana/Groceries, Utilities, Rent, Dining, Transit). When total spending approaches the monthly limit, the application sounds an alert before overspending occurs.

Project Specification & Architecture

The application requires the following core components:

1
Data Model: An expense entry represented as a dictionary:

 {
     "title": "Milk and Bread",
     "amount": 120.0,
     "category": "Groceries",
     "date": "2026-09-12"
 }

1
Category Aggregator: Computes category totals and percentages of total spending.
2
Budget Alert System: Flags if total expenditures surpass a configurable threshold (e.g., ₹25,000).
3
Storage Layer: Automatically reads from and writes to expenses.csv using comma delimiters and UTF-8 encoding.
4
Formatted Visual Reporter: Generates a formatted text summary report.

Complete Production-Grade Implementation

Here is the modular, fully runnable Expense Tracker script:

1"""
2MSK Python Capstone: Personal Finance & Expense Tracker
3Author: MSK Institute
4"""
5import os
6from datetime import datetime
7 
8DATA_FILE = "expenses.csv"
9MONTHLY_BUDGET_LIMIT = 25000.0  # Alert triggered if expenses exceed this limit
10 
11VALID_CATEGORIES = ["Groceries", "Rent", "Utilities", "Dining", "Transport", "Healthcare", "Miscellaneous"]
12 
13def validate_amount(amount_str: str) -> float:
  """Validates and converts amount string to positive float."""
  try:
      val = float(amount_str)
      if val <= 0:
          return -1.0
      return round(val, 2)
  except ValueError:
      return -1.0
22 
23def load_expenses() -> list:
  """Loads recorded expenses from CSV file into memory."""
  expenses = []
  if not os.path.exists(DATA_FILE):
      return expenses
28 
  with open(DATA_FILE, "r", encoding="utf-8") as f:
      header = f.readline()  # Skip CSV header
      for line in f:
          line = line.strip()
          if not line:
              continue
          parts = line.split(",")
          if len(parts) == 4:
              title, amount, category, date_str = parts
              expenses.append({
                  "title": title,
                  "amount": float(amount),
                  "category": category,
                  "date": date_str
              })
  return expenses
45 
46def save_expenses(expenses: list) -> None:
  """Persists all expenses to CSV safely with context manager."""
  with open(DATA_FILE, "w", encoding="utf-8") as f:
      f.write("Title,Amount,Category,Date\n")
      for item in expenses:
          f.write(f"{item['title']},{item['amount']},{item['category']},{item['date']}\n")
52 
53def add_expense(expenses: list, title: str, amount_val: float, category: str, date_str: str = None) -> bool:
  """Validates and adds a new expense entry."""
  if not title.strip():
      print("[ERROR] Expense title cannot be empty.")
      return False
58 
  if amount_val <= 0:
      print("[ERROR] Expense amount must be a positive number.")
      return False
62 
  matched_cat = None
  for cat in VALID_CATEGORIES:
      if cat.lower() == category.strip().lower():
          matched_cat = cat
          break
68 
  if not matched_cat:
      print(f"[ERROR] Invalid category '{category}'. Allowed: {', '.join(VALID_CATEGORIES)}")
      return False
72 
  if not date_str:
      date_str = datetime.now().strftime("%Y-%m-%d")
75 
  entry = {
      "title": title.strip(),
      "amount": amount_val,
      "category": matched_cat,
      "date": date_str
  }
  expenses.append(entry)
  save_expenses(expenses)
  print(f"[SUCCESS] Logged ₹{amount_val:.2f} for '{title}' under {matched_cat}.")
  return True
86 
87def calculate_total(expenses: list) -> float:
  """Returns the total sum of all recorded expenses."""
  return sum(item["amount"] for item in expenses)
90 
91def category_breakdown(expenses: list) -> dict:
  """Aggregates total spending grouped by category."""
  breakdown = {}
  for item in expenses:
      cat = item["category"]
      breakdown[cat] = breakdown.get(cat, 0.0) + item["amount"]
  return breakdown
98 
99def generate_report(expenses: list, budget_limit: float = MONTHLY_BUDGET_LIMIT) -> None:
  """Prints a detailed financial analytics dashboard."""
  if not expenses:
      print("\n[INFO] No expenses recorded yet.\n")
      return
104 
  total = calculate_total(expenses)
  breakdown = category_breakdown(expenses)
107 
  print("\n" + "="*65)
  print("                MONTHLY EXPENSE SUMMARY REPORT")
  print("="*65)
  print(f"{'TITLE':<20} | {'CATEGORY':<14} | {'AMOUNT (₹)':<12} | {'DATE'}")
  print("-"*65)
  for item in expenses:
      print(f"{item['title']:<20} | {item['category']:<14} | ₹{item['amount']:<10.2f} | {item['date']}")
  print("="*65)
  print(f"  Total Expenditure : ₹{total:,.2f}")
  print(f"  Monthly Budget    : ₹{budget_limit:,.2f}")
118 
  # Budget Warning
  if total > budget_limit:
      excess = total - budget_limit
      print(f"  ⚠️ ALERT: You have EXCEEDED your budget by ₹{excess:,.2f}!")
  else:
      remaining = budget_limit - total
      print(f"  ✅ Budget Status  : Safe (₹{remaining:,.2f} remaining)")
126 
  print("\n--- Spending Breakdown by Category ---")
  # Sort categories by spending descending
  sorted_breakdown = sorted(breakdown.items(), key=lambda x: x[1], reverse=True)
  for cat, amt in sorted_breakdown:
      pct = (amt / total) * 100 if total > 0 else 0
      bar = "█" * int(pct // 5)
      print(f"  {cat:<14}: ₹{amt:<9.2f} ({pct:>5.1f}%) {bar}")
  print("="*65 + "\n")
135 
136# --- Automated Demonstration & Verification ---
137if __name__ == "__main__":
  # Clean up past file for pristine test run
  if os.path.exists(DATA_FILE):
      os.remove(DATA_FILE)
141 
  app_expenses = load_expenses()
143 
  print("=== Recording Monthly Expenses ===")
  add_expense(app_expenses, "House Rent", 12000.0, "Rent", "2026-09-01")
  add_expense(app_expenses, "Kirana & Vegetables", 4850.50, "Groceries", "2026-09-04")
  add_expense(app_expenses, "Electricity Bill", 2150.00, "Utilities", "2026-09-06")
  add_expense(app_expenses, "Family Dinner Outing", 2600.00, "Dining", "2026-09-08")
  add_expense(app_expenses, "Metro SmartCard Recharge", 1000.00, "Transport", "2026-09-10")
  add_expense(app_expenses, "Pharmacy Medicines", 1450.00, "Healthcare", "2026-09-11")
151 
  print("\n=== Generating Initial Report (Under Budget) ===")
  generate_report(app_expenses, budget_limit=25000.0)
154 
  print("=== Adding Large Purchase to Test Budget Threshold Alert ===")
  add_expense(app_expenses, "Air Conditioner Repair", 3500.00, "Utilities", "2026-09-12")
157 
  print("\n=== Generating Final Report (Budget Exceeded) ===")
  generate_report(app_expenses, budget_limit=25000.0)
160 
  print("=== Reloading from Disk to Verify CSV Persistence ===")
  reloaded_expenses = load_expenses()
  print(f"Total reloaded items from CSV: {len(reloaded_expenses)}")

Expected Output

1=== Recording Monthly Expenses ===
2[SUCCESS] Logged ₹12000.00 for 'House Rent' under Rent.
3[SUCCESS] Logged ₹4850.50 for 'Kirana & Vegetables' under Groceries.
4[SUCCESS] Logged ₹2150.00 for 'Electricity Bill' under Utilities.
5[SUCCESS] Logged ₹2600.00 for 'Family Dinner Outing' under Dining.
6[SUCCESS] Logged ₹1000.00 for 'Metro SmartCard Recharge' under Transport.
7[SUCCESS] Logged ₹1450.00 for 'Pharmacy Medicines' under Healthcare.
8 
9=== Generating Initial Report (Under Budget) ===
10 
11=================================================================
12                MONTHLY EXPENSE SUMMARY REPORT
13=================================================================
14TITLE                | CATEGORY       | AMOUNT (₹)   | DATE
15-----------------------------------------------------------------
16House Rent           | Rent           | ₹12000.00   | 2026-09-01
17Kirana & Vegetables  | Groceries      | ₹4850.50    | 2026-09-04
18Electricity Bill     | Utilities      | ₹2150.00    | 2026-09-06
19Family Dinner Outing | Dining         | ₹2600.00    | 2026-09-08
20Metro SmartCard Rech | Transport      | ₹1000.00    | 2026-09-10
21Pharmacy Medicines   | Healthcare     | ₹1450.00    | 2026-09-11
22=================================================================
23  Total Expenditure : ₹24,050.50
24  Monthly Budget    : ₹25,000.00
25  ✅ Budget Status  : Safe (₹949.50 remaining)
26 
27--- Spending Breakdown by Category ---
28  Rent          : ₹12000.00  ( 49.9%) █████████
29  Groceries     : ₹4850.50   ( 20.2%) ████
30  Dining        : ₹2600.00   ( 10.8%) ██
31  Utilities     : ₹2150.00   (  8.9%) █
32  Healthcare    : ₹1450.00   (  6.0%) █
33  Transport     : ₹1000.00   (  4.2%) 
34=================================================================
35 
36=== Adding Large Purchase to Test Budget Threshold Alert ===
37[SUCCESS] Logged ₹3500.00 for 'Air Conditioner Repair' under Utilities.
38 
39=== Generating Final Report (Budget Exceeded) ===
40 
41=================================================================
42                MONTHLY EXPENSE SUMMARY REPORT
43=================================================================
44TITLE                | CATEGORY       | AMOUNT (₹)   | DATE
45-----------------------------------------------------------------
46House Rent           | Rent           | ₹12000.00   | 2026-09-01
47Kirana & Vegetables  | Groceries      | ₹4850.50    | 2026-09-04
48Electricity Bill     | Utilities      | ₹2150.00    | 2026-09-06
49Family Dinner Outing | Dining         | ₹2600.00    | 2026-09-08
50Metro SmartCard Rech | Transport      | ₹1000.00    | 2026-09-10
51Pharmacy Medicines   | Healthcare     | ₹1450.00    | 2026-09-11
52Air Conditioner Repa | Utilities      | ₹3500.00    | 2026-09-12
53=================================================================
54  Total Expenditure : ₹27,550.50
55  Monthly Budget    : ₹25,000.00
56  ⚠️ ALERT: You have EXCEEDED your budget by ₹2,550.50!
57 
58--- Spending Breakdown by Category ---
59  Rent          : ₹12000.00  ( 43.6%) ████████
60  Utilities     : ₹5650.00   ( 20.5%) ████
61  Groceries     : ₹4850.50   ( 17.6%) ███
62  Dining        : ₹2600.00   (  9.4%) █
63  Healthcare    : ₹1450.00   (  5.3%) █
64  Transport     : ₹1000.00   (  3.6%) 
65=================================================================
66 
67=== Reloading from Disk to Verify CSV Persistence ===
68Total reloaded items from CSV: 7

Best Practices & Comparison: Do's and Don'ts

Practice	Bad Pattern	Gold-Standard Pattern
Amount Handling	Treating amount as a string	Parse with `float(val)` and validate `val > 0`
Category Typing	Accepting random unvalidated strings	Match against a whitelist of valid categories
Grouping	Writing complex multi-level loops	Use `breakdown[cat] = breakdown.get(cat, 0.0) + amt`
CSV Formatting	Writing without commas or header	Explicit header row + comma-separated columns
Currency Display	Printing raw unformatted floats (`24050.5`)	Format currency nicely: `₹{amt:,.2f}`
Budget Warnings	Hardcoding static limits inside functions	Configurable threshold parameter with default value

Quick Revision Summary Cheat Sheet

Summing List of Dictionaries: sum(item['amount'] for item in expenses) cleanly computes totals in $O(n)$ time.
Dictionary Aggregation Pattern: groups[key] = groups.get(key, 0) + val is the classic Python idiom for histogram-style grouping.
Sorting Dictionary by Values: sorted(dict.items(), key=lambda pair: pair[1], reverse=True).
Currency Formatting: f"₹{amount:,.2f}" automatically introduces thousands-commas and rounds to 2 decimal places.
CSV Handling: Strip newline characters with .strip() and split columns with .split(",").

Interactive Quiz• Knowledge Check

Practice Quiz

Question 1

In the aggregation idiom breakdown[cat] = breakdown.get(cat, 0.0) + amt, what is the role of 0.0?

Question 2

How does the expression sum(item["amount"] for item in expenses) calculate the total expenditure?

Question 3

What does f.readline() do when executed on the first line of a CSV file before reading data rows?

Question 4

What is the output of f"₹{24050.5:,.2f}" in Python?

Question 5

Why should float(amount_str) always be guarded inside a try...except ValueError block?

Practice Challenge

Scenario: Daily Average & Highest Spending Category Identifier

Enhance the Expense Tracker with two financial intelligence functions:

1
identify_highest_category(expenses):

Computes category totals.
Identifies and returns a tuple (category_name, amount) corresponding to the largest expenditure.

1
daily_average(expenses):

Collects all unique transaction dates into a set.
Computes and returns the average expenditure per active day (total_amount / len(unique_dates)).

Starter Code

1sample_expenses = [
2    {"title": "Groceries", "amount": 1500.0, "category": "Groceries", "date": "2026-09-01"},
3    {"title": "Metro", "amount": 200.0, "category": "Transport", "date": "2026-09-01"},
4    {"title": "Electricity", "amount": 2200.0, "category": "Utilities", "date": "2026-09-02"},
5    {"title": "Dining", "amount": 1100.0, "category": "Dining", "date": "2026-09-03"},
6]
7 
8# TODO: Implement identify_highest_category(expenses) and daily_average(expenses)

Complete Solution

1sample_expenses = [
2    {"title": "Groceries", "amount": 1500.0, "category": "Groceries", "date": "2026-09-01"},
3    {"title": "Metro", "amount": 200.0, "category": "Transport", "date": "2026-09-01"},
4    {"title": "Electricity", "amount": 2200.0, "category": "Utilities", "date": "2026-09-02"},
5    {"title": "Dining", "amount": 1100.0, "category": "Dining", "date": "2026-09-03"},
6]
7 
8def identify_highest_category(expenses: list) -> tuple:
9    if not expenses:
10        return ("None", 0.0)
11    
12    breakdown = {}
13    for item in expenses:
14        cat = item["category"]
15        breakdown[cat] = breakdown.get(cat, 0.0) + item["amount"]
16        
17    highest_cat = max(breakdown.items(), key=lambda pair: pair[1])
18    return highest_cat
19 
20def daily_average(expenses: list) -> float:
21    if not expenses:
22        return 0.0
23    
24    unique_dates = {item["date"] for item in expenses}  # Set comprehension for unique dates
25    total = sum(item["amount"] for item in expenses)
26    return round(total / len(unique_dates), 2)
27 
28# Test analytics
29top_cat, top_amt = identify_highest_category(sample_expenses)
30avg_spend = daily_average(sample_expenses)
31 
32print(f"Top Spending Category : {top_cat} (₹{top_amt:.2f})")
33print(f"Daily Average Spend   : ₹{avg_spend:.2f} across unique active days")

Expected Output

1Top Spending Category : Utilities (₹2200.00)
2Daily Average Spend   : ₹1666.67 across unique active days

🚀 What's Next?

In the next lesson, we will continue your Python learning journey with Basic Student Management System (16: Projects).

👉 Continue to Next Lesson: Basic Student Management System →

Next Lesson

Basic Student Management System

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
Quiz Application	Basic Student Management System

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next

PreviousPrevNext

MSK Institute • Shikohabad

Loading Page Content...

Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...

Connecting serverPlease wait...

💻 Practical Labs🚀 Free Demo📜 Verified Certificates

Basic Student Management System

Capstone Project: Personal Finance & Expense Tracker

Beginner16 min read•Updated: 2026-09-30

Study Materials Cheatsheet

Capstone Project: Personal Finance & Expense Tracker

Personal budget tracking is an essential everyday utility. Without careful bookkeeping, small daily purchases slip by unnoticed until bank balances drop unexpectedly.

Real-World Analogy: The Indian "Ghar Ka Kharcha" Monthly Ledger

In Indian households, the monthly budget diary—affectionately called Ghar Ka Kharcha—keeps finances organized:

Visual Architecture Blueprint

+-------------------------------------------------------------------------+
|                  "GHAR KA KHARCHA" BUDGET ENGINE ARCHITECTURE           |
+-------------------------------------------------------------------------+
|                                                                         |
|   [ User CLI Input ] ──> Title, Amount (₹), Category (Rashan, Rent, etc)|
|           │                                                             |
|           ▼                                                             |
|   [ Validator Layer ] ──> Checks: Amount > 0, Category in allowed set   |
|           │                                                             |
|           ▼                                                             |
|   [ Analytics Engine ]                                                  |
|       ├─ Calculate Total Expenditure                                    |
|       ├─ Group by Category using dict.get() Aggregator                  |
|       └─ Trigger Budget Warning if Total > Monthly Budget Limit (₹)     |
|           │                                                             |
|           ▼                                                             |
|   [ Storage Engine ] ──> Read/Write to expenses.csv via with open()     |
|                                                                         |
+-------------------------------------------------------------------------+

Project Specification & Architecture

The application requires the following core components:

1
Data Model: An expense entry represented as a dictionary:

 {
     "title": "Milk and Bread",
     "amount": 120.0,
     "category": "Groceries",
     "date": "2026-09-12"
 }

1
Category Aggregator: Computes category totals and percentages of total spending.
2
Budget Alert System: Flags if total expenditures surpass a configurable threshold (e.g., ₹25,000).
3
Storage Layer: Automatically reads from and writes to expenses.csv using comma delimiters and UTF-8 encoding.
4
Formatted Visual Reporter: Generates a formatted text summary report.

Complete Production-Grade Implementation

Here is the modular, fully runnable Expense Tracker script:

1"""
2MSK Python Capstone: Personal Finance & Expense Tracker
3Author: MSK Institute
4"""
5import os
6from datetime import datetime
7 
8DATA_FILE = "expenses.csv"
9MONTHLY_BUDGET_LIMIT = 25000.0  # Alert triggered if expenses exceed this limit
10 
11VALID_CATEGORIES = ["Groceries", "Rent", "Utilities", "Dining", "Transport", "Healthcare", "Miscellaneous"]
12 
13def validate_amount(amount_str: str) -> float:
  """Validates and converts amount string to positive float."""
  try:
      val = float(amount_str)
      if val <= 0:
          return -1.0
      return round(val, 2)
  except ValueError:
      return -1.0
22 
23def load_expenses() -> list:
  """Loads recorded expenses from CSV file into memory."""
  expenses = []
  if not os.path.exists(DATA_FILE):
      return expenses
28 
  with open(DATA_FILE, "r", encoding="utf-8") as f:
      header = f.readline()  # Skip CSV header
      for line in f:
          line = line.strip()
          if not line:
              continue
          parts = line.split(",")
          if len(parts) == 4:
              title, amount, category, date_str = parts
              expenses.append({
                  "title": title,
                  "amount": float(amount),
                  "category": category,
                  "date": date_str
              })
  return expenses
45 
46def save_expenses(expenses: list) -> None:
  """Persists all expenses to CSV safely with context manager."""
  with open(DATA_FILE, "w", encoding="utf-8") as f:
      f.write("Title,Amount,Category,Date\n")
      for item in expenses:
          f.write(f"{item['title']},{item['amount']},{item['category']},{item['date']}\n")
52 
53def add_expense(expenses: list, title: str, amount_val: float, category: str, date_str: str = None) -> bool:
  """Validates and adds a new expense entry."""
  if not title.strip():
      print("[ERROR] Expense title cannot be empty.")
      return False
58 
  if amount_val <= 0:
      print("[ERROR] Expense amount must be a positive number.")
      return False
62 
  matched_cat = None
  for cat in VALID_CATEGORIES:
      if cat.lower() == category.strip().lower():
          matched_cat = cat
          break
68 
  if not matched_cat:
      print(f"[ERROR] Invalid category '{category}'. Allowed: {', '.join(VALID_CATEGORIES)}")
      return False
72 
  if not date_str:
      date_str = datetime.now().strftime("%Y-%m-%d")
75 
  entry = {
      "title": title.strip(),
      "amount": amount_val,
      "category": matched_cat,
      "date": date_str
  }
  expenses.append(entry)
  save_expenses(expenses)
  print(f"[SUCCESS] Logged ₹{amount_val:.2f} for '{title}' under {matched_cat}.")
  return True
86 
87def calculate_total(expenses: list) -> float:
  """Returns the total sum of all recorded expenses."""
  return sum(item["amount"] for item in expenses)
90 
91def category_breakdown(expenses: list) -> dict:
  """Aggregates total spending grouped by category."""
  breakdown = {}
  for item in expenses:
      cat = item["category"]
      breakdown[cat] = breakdown.get(cat, 0.0) + item["amount"]
  return breakdown
98 
99def generate_report(expenses: list, budget_limit: float = MONTHLY_BUDGET_LIMIT) -> None:
  """Prints a detailed financial analytics dashboard."""
  if not expenses:
      print("\n[INFO] No expenses recorded yet.\n")
      return
104 
  total = calculate_total(expenses)
  breakdown = category_breakdown(expenses)
107 
  print("\n" + "="*65)
  print("                MONTHLY EXPENSE SUMMARY REPORT")
  print("="*65)
  print(f"{'TITLE':<20} | {'CATEGORY':<14} | {'AMOUNT (₹)':<12} | {'DATE'}")
  print("-"*65)
  for item in expenses:
      print(f"{item['title']:<20} | {item['category']:<14} | ₹{item['amount']:<10.2f} | {item['date']}")
  print("="*65)
  print(f"  Total Expenditure : ₹{total:,.2f}")
  print(f"  Monthly Budget    : ₹{budget_limit:,.2f}")
118 
  # Budget Warning
  if total > budget_limit:
      excess = total - budget_limit
      print(f"  ⚠️ ALERT: You have EXCEEDED your budget by ₹{excess:,.2f}!")
  else:
      remaining = budget_limit - total
      print(f"  ✅ Budget Status  : Safe (₹{remaining:,.2f} remaining)")
126 
  print("\n--- Spending Breakdown by Category ---")
  # Sort categories by spending descending
  sorted_breakdown = sorted(breakdown.items(), key=lambda x: x[1], reverse=True)
  for cat, amt in sorted_breakdown:
      pct = (amt / total) * 100 if total > 0 else 0
      bar = "█" * int(pct // 5)
      print(f"  {cat:<14}: ₹{amt:<9.2f} ({pct:>5.1f}%) {bar}")
  print("="*65 + "\n")
135 
136# --- Automated Demonstration & Verification ---
137if __name__ == "__main__":
  # Clean up past file for pristine test run
  if os.path.exists(DATA_FILE):
      os.remove(DATA_FILE)
141 
  app_expenses = load_expenses()
143 
  print("=== Recording Monthly Expenses ===")
  add_expense(app_expenses, "House Rent", 12000.0, "Rent", "2026-09-01")
  add_expense(app_expenses, "Kirana & Vegetables", 4850.50, "Groceries", "2026-09-04")
  add_expense(app_expenses, "Electricity Bill", 2150.00, "Utilities", "2026-09-06")
  add_expense(app_expenses, "Family Dinner Outing", 2600.00, "Dining", "2026-09-08")
  add_expense(app_expenses, "Metro SmartCard Recharge", 1000.00, "Transport", "2026-09-10")
  add_expense(app_expenses, "Pharmacy Medicines", 1450.00, "Healthcare", "2026-09-11")
151 
  print("\n=== Generating Initial Report (Under Budget) ===")
  generate_report(app_expenses, budget_limit=25000.0)
154 
  print("=== Adding Large Purchase to Test Budget Threshold Alert ===")
  add_expense(app_expenses, "Air Conditioner Repair", 3500.00, "Utilities", "2026-09-12")
157 
  print("\n=== Generating Final Report (Budget Exceeded) ===")
  generate_report(app_expenses, budget_limit=25000.0)
160 
  print("=== Reloading from Disk to Verify CSV Persistence ===")
  reloaded_expenses = load_expenses()
  print(f"Total reloaded items from CSV: {len(reloaded_expenses)}")

Expected Output

1=== Recording Monthly Expenses ===
2[SUCCESS] Logged ₹12000.00 for 'House Rent' under Rent.
3[SUCCESS] Logged ₹4850.50 for 'Kirana & Vegetables' under Groceries.
4[SUCCESS] Logged ₹2150.00 for 'Electricity Bill' under Utilities.
5[SUCCESS] Logged ₹2600.00 for 'Family Dinner Outing' under Dining.
6[SUCCESS] Logged ₹1000.00 for 'Metro SmartCard Recharge' under Transport.
7[SUCCESS] Logged ₹1450.00 for 'Pharmacy Medicines' under Healthcare.
8 
9=== Generating Initial Report (Under Budget) ===
10 
11=================================================================
12                MONTHLY EXPENSE SUMMARY REPORT
13=================================================================
14TITLE                | CATEGORY       | AMOUNT (₹)   | DATE
15-----------------------------------------------------------------
16House Rent           | Rent           | ₹12000.00   | 2026-09-01
17Kirana & Vegetables  | Groceries      | ₹4850.50    | 2026-09-04
18Electricity Bill     | Utilities      | ₹2150.00    | 2026-09-06
19Family Dinner Outing | Dining         | ₹2600.00    | 2026-09-08
20Metro SmartCard Rech | Transport      | ₹1000.00    | 2026-09-10
21Pharmacy Medicines   | Healthcare     | ₹1450.00    | 2026-09-11
22=================================================================
23  Total Expenditure : ₹24,050.50
24  Monthly Budget    : ₹25,000.00
25  ✅ Budget Status  : Safe (₹949.50 remaining)
26 
27--- Spending Breakdown by Category ---
28  Rent          : ₹12000.00  ( 49.9%) █████████
29  Groceries     : ₹4850.50   ( 20.2%) ████
30  Dining        : ₹2600.00   ( 10.8%) ██
31  Utilities     : ₹2150.00   (  8.9%) █
32  Healthcare    : ₹1450.00   (  6.0%) █
33  Transport     : ₹1000.00   (  4.2%) 
34=================================================================
35 
36=== Adding Large Purchase to Test Budget Threshold Alert ===
37[SUCCESS] Logged ₹3500.00 for 'Air Conditioner Repair' under Utilities.
38 
39=== Generating Final Report (Budget Exceeded) ===
40 
41=================================================================
42                MONTHLY EXPENSE SUMMARY REPORT
43=================================================================
44TITLE                | CATEGORY       | AMOUNT (₹)   | DATE
45-----------------------------------------------------------------
46House Rent           | Rent           | ₹12000.00   | 2026-09-01
47Kirana & Vegetables  | Groceries      | ₹4850.50    | 2026-09-04
48Electricity Bill     | Utilities      | ₹2150.00    | 2026-09-06
49Family Dinner Outing | Dining         | ₹2600.00    | 2026-09-08
50Metro SmartCard Rech | Transport      | ₹1000.00    | 2026-09-10
51Pharmacy Medicines   | Healthcare     | ₹1450.00    | 2026-09-11
52Air Conditioner Repa | Utilities      | ₹3500.00    | 2026-09-12
53=================================================================
54  Total Expenditure : ₹27,550.50
55  Monthly Budget    : ₹25,000.00
56  ⚠️ ALERT: You have EXCEEDED your budget by ₹2,550.50!
57 
58--- Spending Breakdown by Category ---
59  Rent          : ₹12000.00  ( 43.6%) ████████
60  Utilities     : ₹5650.00   ( 20.5%) ████
61  Groceries     : ₹4850.50   ( 17.6%) ███
62  Dining        : ₹2600.00   (  9.4%) █
63  Healthcare    : ₹1450.00   (  5.3%) █
64  Transport     : ₹1000.00   (  3.6%) 
65=================================================================
66 
67=== Reloading from Disk to Verify CSV Persistence ===
68Total reloaded items from CSV: 7

Best Practices & Comparison: Do's and Don'ts

Practice	Bad Pattern	Gold-Standard Pattern
Amount Handling	Treating amount as a string	Parse with `float(val)` and validate `val > 0`
Category Typing	Accepting random unvalidated strings	Match against a whitelist of valid categories
Grouping	Writing complex multi-level loops	Use `breakdown[cat] = breakdown.get(cat, 0.0) + amt`
CSV Formatting	Writing without commas or header	Explicit header row + comma-separated columns
Currency Display	Printing raw unformatted floats (`24050.5`)	Format currency nicely: `₹{amt:,.2f}`
Budget Warnings	Hardcoding static limits inside functions	Configurable threshold parameter with default value

Quick Revision Summary Cheat Sheet

Summing List of Dictionaries: sum(item['amount'] for item in expenses) cleanly computes totals in $O(n)$ time.
Dictionary Aggregation Pattern: groups[key] = groups.get(key, 0) + val is the classic Python idiom for histogram-style grouping.
Sorting Dictionary by Values: sorted(dict.items(), key=lambda pair: pair[1], reverse=True).
Currency Formatting: f"₹{amount:,.2f}" automatically introduces thousands-commas and rounds to 2 decimal places.
CSV Handling: Strip newline characters with .strip() and split columns with .split(",").

Interactive Quiz• Knowledge Check

Practice Quiz

Question 1

In the aggregation idiom breakdown[cat] = breakdown.get(cat, 0.0) + amt, what is the role of 0.0?

Question 2

How does the expression sum(item["amount"] for item in expenses) calculate the total expenditure?

Question 3

What does f.readline() do when executed on the first line of a CSV file before reading data rows?

Question 4

What is the output of f"₹{24050.5:,.2f}" in Python?

Question 5

Why should float(amount_str) always be guarded inside a try...except ValueError block?

Practice Challenge

Scenario: Daily Average & Highest Spending Category Identifier

Enhance the Expense Tracker with two financial intelligence functions:

1
identify_highest_category(expenses):

Computes category totals.
Identifies and returns a tuple (category_name, amount) corresponding to the largest expenditure.

1
daily_average(expenses):

Collects all unique transaction dates into a set.
Computes and returns the average expenditure per active day (total_amount / len(unique_dates)).

Starter Code

1sample_expenses = [
2    {"title": "Groceries", "amount": 1500.0, "category": "Groceries", "date": "2026-09-01"},
3    {"title": "Metro", "amount": 200.0, "category": "Transport", "date": "2026-09-01"},
4    {"title": "Electricity", "amount": 2200.0, "category": "Utilities", "date": "2026-09-02"},
5    {"title": "Dining", "amount": 1100.0, "category": "Dining", "date": "2026-09-03"},
6]
7 
8# TODO: Implement identify_highest_category(expenses) and daily_average(expenses)

Complete Solution

1sample_expenses = [
2    {"title": "Groceries", "amount": 1500.0, "category": "Groceries", "date": "2026-09-01"},
3    {"title": "Metro", "amount": 200.0, "category": "Transport", "date": "2026-09-01"},
4    {"title": "Electricity", "amount": 2200.0, "category": "Utilities", "date": "2026-09-02"},
5    {"title": "Dining", "amount": 1100.0, "category": "Dining", "date": "2026-09-03"},
6]
7 
8def identify_highest_category(expenses: list) -> tuple:
9    if not expenses:
10        return ("None", 0.0)
11    
12    breakdown = {}
13    for item in expenses:
14        cat = item["category"]
15        breakdown[cat] = breakdown.get(cat, 0.0) + item["amount"]
16        
17    highest_cat = max(breakdown.items(), key=lambda pair: pair[1])
18    return highest_cat
19 
20def daily_average(expenses: list) -> float:
21    if not expenses:
22        return 0.0
23    
24    unique_dates = {item["date"] for item in expenses}  # Set comprehension for unique dates
25    total = sum(item["amount"] for item in expenses)
26    return round(total / len(unique_dates), 2)
27 
28# Test analytics
29top_cat, top_amt = identify_highest_category(sample_expenses)
30avg_spend = daily_average(sample_expenses)
31 
32print(f"Top Spending Category : {top_cat} (₹{top_amt:.2f})")
33print(f"Daily Average Spend   : ₹{avg_spend:.2f} across unique active days")

Expected Output

1Top Spending Category : Utilities (₹2200.00)
2Daily Average Spend   : ₹1666.67 across unique active days

🚀 What's Next?

In the next lesson, we will continue your Python learning journey with Basic Student Management System (16: Projects).

👉 Continue to Next Lesson: Basic Student Management System →

Next Lesson

Basic Student Management System

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
Quiz Application	Basic Student Management System

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next