Expense Tracker
A Desktop Expense Management Application Using Python, Tkinter and SQLite
Project Presentation
Project Overview
Desktop expense management application
Built with Python and Tkinter
SQLite provides local persistence
Supports summaries, chart visualization and CSV export
Problem Statement
Manual expense tracking can be repetitive
Category and monthly totals require manual calculation
Reports can be inconvenient to prepare
A simple local GUI can centralize these tasks
Objectives
Record expenses easily
Store data persistently
View and delete expense records
Generate category and monthly summaries
Export reports to CSV
Technology Stack
Python — application logic
Tkinter — graphical user interface
SQLite — local relational database
CSV — report export
Tkinter Canvas — category chart
System Architecture
User
↓
Tkinter GUI
↓
Python application logic
↓
SQLite database
↘ Reporting / CSV export
Main Modules
Expense Entry
Expense List
Database
Category Summary
Monthly Report
Chart
CSV Export
Expense Management
Add expense with amount, category, date and description
View stored records
Delete selected records
Persistent local storage
Reports & Visualization
Category-wise totals
Monthly report
Simple category chart
CSV export for further analysis
Database Design
SQLite database file
Expenses table stores individual records
Application initializes database automatically
No separate database server required
Testing
Startup test
Add/view/delete tests
Category summary test
Monthly report test
Chart test
CSV export test
Empty database test
Privacy & Limitations
Data is stored locally
No cloud synchronization in the mini version
No authentication
No bank integration
CSV exports may contain financial information
Future Enhancements
Editing expenses
Budgets and alerts
Recurring expenses
Advanced charts
PDF reports
Authentication and cloud sync
CSV import
Conclusion
Demonstrates Python desktop GUI development
Shows SQLite CRUD and persistence
Provides reporting and export
Suitable as a beginner academic mini project
Thank You
Questions & Answers