TEAM:
ByteBuilders
Granth Dewan (S24CSEU2846)
Jahnvi Rai (S24CSEU2839)
Harshit Poonia (S24CSEU2835)
Lavanya Sharma (S24CSEU2833)
Pratyaksh (S24CSEU2840)
SUBMITTED TO:
SCHOOL OF COMPUTER SCIENCE
ENGINEERING AND TECHNOLOGY, BENNETT
UNIVERSITY GREATER NOIDA, 201310,
UTTAR PRADESH, INDIA
DECLARATION
We hereby declare that the work which is being presented in the report, is an
authentic record of our own work carried out during the period from
Sept ,2024 to Nov, 2024 at School of Computer Science and Engineering
and Technology, Bennett University Greater Noida. The matters and the
results presented in this report has not been submitted by me/us for the
award of any other degree elsewhere.
Granth Dewan
(S24CSEU2846)
Jahnvi Rai
(S24CSEU2839)
Harshit Poonia
(S24CSEU2835)
Lavanya Sharma
(S24CSEU2833)
Pratyaksh
(S24CSEU2840)
Table of Contents
PROBLEM STATEMENT.......................................................................................................4
INTRODUCTION..................................................................................................................5
OBJECTIVE..................................................................................................................................5
FEATURES...................................................................................................................................5
PROBLEM DESCRIPTION.....................................................................................................7
ARCHITECTURE OF THE SYSTEM..........................................................................................8
1. User Interface (UI):.............................................................................................................8
2. Database:...........................................................................................................................8
Key Functionalities:....................................................................................................................8
LIMITATIONS......................................................................................................................9
1. Manual Entry.....................................................................................................................9
2. Lack of Mobile Support......................................................................................................9
3. No Cloud Backup................................................................................................................9
PROJECT STRUCTURE........................................................................................................10
1. Main Application (app.py)................................................................................................10
2. Database (MySQL):...........................................................................................................10
3. Modules...........................................................................................................................10
Transaction Manager.................................................................................................................................10
Summary Generator...................................................................................................................................10
USE CASE SCENARIOS.......................................................................................................11
1. Adding Transactions.........................................................................................................11
2. Monitoring Budget...........................................................................................................11
3. Real-Time Insights............................................................................................................11
ARCHITECTURE OF THE SYSTEM........................................................................................12
Installation and Database Setup for Student Finance Tracker...........................................15
1. Required Software and Libraries...........................................................................................15
2. Setting Up the MySQL Database............................................................................................15
3. Running the Application.......................................................................................................15
4. Key Database Fields..............................................................................................................16
Functionality: The main functionalities will be:........................................................................16
CONCLUSION....................................................................................................................17
PROBLEM STATEMENT
Managing personal finances is a significant challenge for college students, who often juggle
limited income with various expenses. Students may struggle to track their monthly spending
and identify where their money is going, making it hard to maintain a clear financial
overview. Setting realistic budgets and adhering to them can also be difficult, especially with
irregular sources of income like part-time jobs or financial aid.
Without a structured system, students risk overspending or failing to allocate funds for
essential needs such as tuition, rent, and groceries. Saving for short-term goals, like travel or
emergency expenses, is another common challenge. Additionally, students may lack financial
literacy, leading to poor decision-making regarding spending, saving, or even taking on
unnecessary debt.
The manual effort involved in tracking finances can be tedious, prone to errors, and
demotivating. Furthermore, a lack of automation and secure data storage adds to the
complexity of managing personal finances effectively. A tailored financial management
solution is essential for college students, addressing these challenges by helping them
calculate their monthly income and expenses, set spending limits, and gain better control over
their finances—all while ensuring their data is secure and privacy is maintained.
INTRODUCTION
Managing finances is a crucial life skill, especially for students who need to balance limited
resources with numerous expenses. The Student Finance Tracking System is a Python-
based application designed to assist students in tracking and managing their finances
effectively. By logging income and expenses, categorizing transactions, and setting spending
limits, the application empowers students to monitor their financial health, plan budgets, and
make informed financial decisions.
The system features a user-friendly graphical user interface (GUI) built using Tkinter,
combined with a MySQL database backend for data storage and management. Our Student
Finance Tracker emphasizes real-time updates, automated balance calculations, and category-
specific spending alerts to help users stay financially disciplined.
OBJECTIVE
The primary objective of the Student Finance Tracker is to provide students with a user-
friendly tool for:
Logging income and expense transactions.
Categorizing and summarizing transactions to identify spending habits.
Setting and monitoring budget limits for better financial control.
Generating real-time updates on their financial status, including balances and
warnings for overspending.
FEATURES
1. Add Transactions:
Users can record their income and expense transactions with details such as amount,
category, and date. Transactions are classified as either income (e.g., part-time job
earnings, scholarships) or expenses (e.g., food, transportation).
2. Category Management:
Each transaction is categorized into predefined areas such as food, transportation,
stationery, entertainment, or others. Spending recommendations are provided for each
category based on preset limits.
3. Transaction History:
The application displays a detailed history of transactions, including the date,
category, amount, and type (income/expense), for easy reference.
4. Summary and Balance Tracking:
Users receive an up-to-date summary of total income, expenses, and balance. A low-
balance warning is triggered if the balance falls below a defined threshold, promoting
financial prudence.
5. Spending Limits and Warnings:
The tool monitors category-wise spending and issues alerts if expenditure in a
category exceeds the recommended limit, ensuring students stay within budget.
6. Monthly Summaries:
The application provides monthly overviews of income and expenses, helping
students track financial trends and adjust their spending habits.
PROBLEM DESCRIPTION
Students often struggle to monitor their daily expenses and maintain a balance between
income and expenditure. Some key issues include:
Difficulty in tracking where money is spent.
Lack of discipline in adhering to spending limits.
Poor financial planning leading to a shortage of funds.
The Student Finance Tracker resolves these problems by offering a simple, intuitive platform
for recording transactions, setting budgets, and receiving spending insights.
ARCHITECTURE OF THE SYSTEM
1. User Interface (UI):
Built using Python's tkinter library, the GUI is intuitive and responsive. It includes
fields for transaction input, balance display, and category-based summaries.
2. Database:
The application uses MySQL to store financial data, ensuring data persistence and
reliability. Each transaction is recorded with details such as date, amount, type, and
category.
Key Functionalities:
o Add Transactions: Records income and expenses with validation for correct
data entry.
o Summarize Finances: Provides an overview of income, expenses, and
remaining balance.
o Monitor Spending: Tracks expenditures across categories and warns of
overspending.
LIMITATIONS
While the Student Finance Tracker is effective in its purpose, there are a few limitations:
1. Manual Entry: Users need to input transactions manually, which can be prone
to errors.
2. Lack of Mobile Support: Currently designed for desktop use, the
application does not support mobile devices.
3. No Cloud Backup: Financial data is stored locally, making it vulnerable to
system failures.
PROJECT STRUCTURE
1. Main Application (app.py):
The entry point of the application, handling the GUI and interactions.
2. Database (MySQL):
Stores transaction data persistently for efficient querying and reporting.
3. Modules:
Transaction Manager: Handles addition, deletion, and querying of transactions.
Summary Generator: Generates monthly summaries and category-wise breakdowns.
USE CASE SCENARIOS
1. Adding Transactions:
A student logs a ₹500 stipend under "Income" and ₹200 spent on food under
"Expense." The system updates the balance and alerts the student if they are nearing
the limit for the food category.
2. Monitoring Budget:
A student checks their monthly summary and realizes they’ve exceeded their
entertainment budget. This helps them adjust future spending to avoid overspending.
3. Real-Time Insights:
With a single click, students view their current balance, total income, and expenses,
along with recommendations for staying within their spending limits.
ARCHITECTURE OF THE SYSTEM
Installation and Database Setup for Student
Finance Tracker
1. Required Software and Libraries
To run the Student Finance Tracker, ensure the following software and libraries are installed:
Python (version 3.8 or higher)
MySQL Database (for data storage)
Python Libraries:
o tkinter (for GUI development, included in Python's standard library)
o mysql-connector-python (for connecting Python to the MySQL database)
Install the mysql-connector-python library using the following command:
pip install mysql-connector-python
2. Setting Up the MySQL Database
1. Create a MySQL Database
Open your MySQL client or command line interface and execute the following
commands to create the database and table:
2. CREATE DATABASE CollegeFinance;
3. USE CollegeFinance;
4.
5. CREATE TABLE finances (
6. id INT AUTO_INCREMENT PRIMARY KEY,
7. date DATE NOT NULL,
8. category VARCHAR(255) NOT NULL,
9. amount DECIMAL(10, 2) NOT NULL,
10. type ENUM('Income', 'Expense') NOT NULL
11. );
12. Database Connection Configuration
Update the connection credentials in the connect_db function of the Python script:
13. conn = mysql.connector.connect(
14. host="localhost",
15. user="root",
16. password="your_password",
17. database="CollegeFinance"
18. )
Replace your_password with the password for your MySQL root user or the
appropriate user credentials.
3. Running the Application
After setting up the database:
1. Save the provided Python code as a .py file (e.g., student_finance_tracker.py).
2. Run the file using the following command:
3. python student_finance_tracker.py
4. Key Database Fields
The finances table has the following fields:
Date of Transaction: The date the transaction occurred (DATE type).
Category: The category of income/expense (e.g., Food, Rent, etc.).
Amount: The transaction amount (DECIMAL type).
Type: The nature of the transaction, either Income or Expense (ENUM type).
By completing these steps, you will have a fully functional environment to run and use the
Student Finance Tracker application developed by Team Byte Builder.
Functionality: The main functionalities will be:
Add an income or expense transaction
View the summary of income/expenses
View a category
Calculate remaining balance
CONCLUSION
The Student Finance Tracker by Team Byte Builder is an essential tool for students aiming
to manage their finances effectively. By offering a blend of transaction tracking, budget
monitoring, and real-time insights, the application promotes financial responsibility and
better decision-making.
Future enhancements could include:
Integration with mobile platforms for on-the-go access.
Cloud-based data storage for enhanced security and backup.
Advanced analytics to provide deeper insights into spending patterns.
The Student Finance Tracker lays the foundation for students to develop lifelong financial
management skills while addressing their immediate budgeting needs.
