pythonintermediate2 hr est.

Python Expense Tracker Project: Step-by-Step Code & Tutorial

Create a practical Expense Tracker in Python that stores transactions in a JSON file, categorizes expenses, calculates total spending, and filters records by date or category.

Editorial note

Written by TechIdea Curriculum Team

TechIdea Curriculum Team

Our engineers and educators design these projects to simulate real-world tasks and prepare you for technical interviews.

This guide is created to help beginners understand SEO, blogging, AI tools, and online growth in simple English. We focus on practical steps, original examples, and safe website growth methods.

Last updated: 2026-06-05

Before You Begin

1
Understanding of Python dictionaries and lists
2
Familiarity with file handling (open, read, write)
3
Knowledge of Python's json built-in module
4
Understanding of exception handling

Project Architecture

Folder Structure

expense_tracker/
├── tracker.py
├── data.json
└── README.md

Data Flow

[User Action: Add Expense] ➔ [Parse Data Dict] ➔ [Serialize to data.json] ➔ [Calculate Totals / Filters] ➔ [Console Report]

Source Code Breakdown & Implementation

### Step 1: Project Setup Create a folder `expense_tracker` and a file `tracker.py`. Import `json` and `os` built-in modules at the top of the file.

### Step 2: Core Logic Implementation Implement functions to load and save data from JSON. ```python import json import os DATA_FILE = "data.json" def load_data() -> list: if not os.path.exists(DATA_FILE): return [] with open(DATA_FILE, "r") as f: return json.load(f) def save_data(expenses: list): with open(DATA_FILE, "w") as f: json.dump(expenses, f, indent=4) ```

### Step 3: UI & Interaction Implementation Create the console menu and report formatting logic. ```python def add_expense(expenses: list): amount = float(input("Enter amount: ")) category = input("Enter category (Food, Travel, Bills, Other): ") desc = input("Enter description: ") expenses.append({"amount": amount, "category": category, "desc": desc}) save_data(expenses) print("Expense added successfully!") ```

### Step 4: Error Handling & Edge Cases Ensure corrupted JSON files are caught gracefully and invalid numerical inputs don't crash the application.

Real-World Application

Business Use Case

This project simulates a small-scale ETL (Extract, Transform, Load) pipeline, fundamental in data engineering and fintech reporting.

Database Design

Data is persisted as a JSON array of objects, acting as a lightweight NoSQL document store. Each object contains amount, category, and description keys.

Deployment Guide

Can be deployed locally or hosted on an internal server. For cloud execution, refactor the JSON save logic to use an S3 bucket or a managed database like MongoDB.

Complete Solution Code

Compare your approach

Testing Checklist

• Run application and choose option 1 to add a $50 Food expense.
• Verify that expenses.json is created on disk with formatted JSON.
• Add a $30 Transport expense and check summary breakdown percentages.
• Restart script and verify data persists from disk correctly.

Common Bugs

Bug: JSONDecodeError when file is empty.
Fix: Handle exception in load_expenses and return empty list.
Bug: Category matching is case sensitive.
Fix: Use .title() on category strings before saving.