PROJECT REPORT
SMART EXPENSE TRACKER
Name: Anushka Shah
Huzefa Parekh
Enrollment no. : 12302060501003
12302060501013
Course : Python Programming
Introduction:
In today’s fast-paced world, managing personal finances effectively is
essential. The Simple Expense Tracker with Chart is a Python-based
application designed to help users record, manage, and visualize their
expenses efficiently.
It allows users to:
• Add and list daily expenses
• Set a monthly budget
• Export data to CSV format
• Visualize expenses by category and by month using charts
Objectives:
The primary objectives of this project are:
1. To design a simple and user-friendly expense tracker
application.
2. To store all expense records in a local SQLite database.
3. To enable users to set and monitor monthly budget limits.
4. To generate and visualize expense summaries using bar
and line charts.
5. To provide the ability to export expense data for external
analysis.
System Overview:
The system provides a menu-driven console interface that interacts
with the database and visualization modules. Users can perform
CRUD operations (Create, Read, Delete) on expense data and
generate graphical insights through the charting function.
System Features:
Feature Description
Add Expense Record a new expense entry
(category, amount, date, note).
List Expenses View recent transactions in
tabular format.
Set Monthly Budget Define and store a monthly
spending limit.
View Monthly Total Display total spending for the
current month.
Export to CSV Export all expense data into a
CSV file.
Remove an expense entry using
Delete Expense its ID.
Show Ultimate Chart View category-wise and monthly
expense trends
using Matplotlib.
Flow Chart:
Algorithm:
Step 1: Start the program.
Step 2: Initialize or connect to the SQLite database.
Step 3: Display the main menu with options (Add, List, Delete, Chart,
Budget, etc.).
Step 4: Take user input for desired operation.
Step 5: Perform database actions based on user choice.
Step 6: For visualization, fetch aggregated data and plot using
Matplotlib.
Step 7: Repeat menu display until user selects Exit.
Step 8: Stop the program.
Applications:
•Personal expense management
•Student budgeting
•Small business bookkeeping
•Monthly household accounting
Future Enhancement:
•Add user authentication and password protection
•Support for multiple users and cloud backup
•Integration with mobile app interface
•Advanced charts (pie charts, forecasts)
•Email alerts for budget exceeding
•Machine-learning-based expense prediction
Output:
Conclusion:
The Simple Expense Tracker with Chart successfully demonstrates
how Python can be used for effective financial data [Link]
provides all essential functionalities — adding, viewing, deleting,
exporting, and visualizing expenses — in a compact, console-driven
interface.