TITLE : PERSONAL EXPENSE TRACKER
1. Abstract
I. Problem Formulation:
Managing personal finances manually often leads to confusion, lack of
proper tracking, and difficulty in analyzing spending patterns. Many
people fail to maintain daily expense records due to time constraints and
the absence of an easy-to-use system. Existing tools are either complex,
non-customizable, or paid solutions. Hence, there is a need for a user-
friendly, web-based expense tracker that allows individuals to record,
categorize, and monitor their expenses efficiently in one place.
II. Proposed Methodology:
The proposed system is a Personal Expense Tracker built using the
MERN Stack (MongoDB, [Link], [Link], and [Link]). The
application allows users to securely register, log in, and record expenses
with details such as amount, category, date, merchant, and payment type.
Data is stored in MongoDB and accessed through RESTful APIs
developed with Express and [Link]. The front end, built using React,
provides interactive dashboards and visual charts for users to analyze
spending patterns over time.
III. Results and Conclusion:
The developed application provides a responsive, secure, and interactive
platform for expense management. It successfully tracks user expenses,
displays graphical insights through pie and line charts, and allows
filtering and exporting data. The system minimizes manual effort,
improves financial awareness, and helps users make informed budgeting
decisions. Thus, it serves as an effective digital solution for personal
financial management.
3. Objectives
1. To design and develop a user-friendly personal expense tracking web
application using the MERN stack.
2. To allow users to record, edit, and delete expenses with category and date
filters.
3. To provide secure user authentication using JWT tokens.
4. To display visual insights using interactive charts (category-wise and
monthly expenses).
5. To store and manage data efficiently using MongoDB.
6. To help users analyze spending habits and manage their budgets
effectively.
4. METHODOLOGY
Task 1 – Requirement Analysis:
In this phase, the main goal is to identify user needs and project requirements.
Key features such as user login, expense entry, data categorization, and expense
visualization are defined. The overall project scope and objectives are clearly
outlined before the development begins.
Task 2 – System Design:
This stage focuses on designing the system architecture that connects the
frontend, backend, and database. Diagrams such as the Entity Relationship (ER)
diagram and Data Flow Diagram (DFD) are prepared to understand how data
moves within the system.
Task 3 – Frontend Development:
The frontend of the application is built using [Link]. Components such as the
Login page, Dashboard, Expense Form, and Charts are created. React Router is
implemented to handle page navigation within the single-page application
(SPA).
Task 4 – Backend Development:
In this step, RESTful APIs are developed using [Link] and [Link]. These
APIs handle operations such as creating, reading, updating, and deleting
expenses and managing user information securely.
Task 5 – Database Integration:
MongoDB is used as the database to store all user and expense details.
Mongoose is utilized to create data schemas for the User and Expense models,
which are then integrated with the backend API routes.
Task 6 – Authentication Module:
A secure authentication system is implemented using JSON Web Tokens
(JWT). This allows users to register, log in, and maintain authenticated sessions
while ensuring data privacy and security.
Task 7 – Data Visualization:
The [Link] library is integrated to display visual insights in the form of pie and
line charts. These charts represent monthly spending trends and category-wise
expense summaries to help users analyze their financial habits.
Task 8 – Testing and Debugging:
All modules are tested using tools like Postman for API testing and browser
developer tools for frontend debugging. Any functional or UI-related errors are
identified and corrected to ensure a smooth user experience.
Task 9 – Deployment:
In the final stage, the backend is hosted on cloud platforms such as Render or
Railway, while the frontend is deployed on Netlify or Vercel. The environment
variables are configured, and both parts are connected for live access by end
users.
5. Hardware and Software Requirements
Hardware Requirements:
Component Specification
Processor Intel i3 or higher
RAM 4 GB minimum
Storage 500 MB of free space
Internet Database Connectivity
Software Requirements:
Component Specification
Operating System Windows 10 or above
Frontend [Link], HTML5, CSS3, JavaScript
Backend [Link], [Link]
Database MongoDB
IDE VS Code
Browser Google Chrome
6. Conclusion
The Personal Expense Tracker using the MERN stack provides a simple and
secure way to record and analyze daily expenses. It helps users track spending
patterns through interactive charts and organized data. The system improves
financial awareness and promotes better budgeting habits. Overall, it proves that
modern web technologies can effectively simplify personal finance
management.
7. References
1. Sharma and P. Verma, “Design and Implementation of a Personal
Expense Tracker Application,” Int. J. Computer Applications, vol. 175,
no. 3, pp. 12-16, Oct. 2020.
2. S. Gupta, R. Kumar and L. Singh, “Mobile Expense Tracker: A Real-
time Expense Logging System,” in Proc. 2019 IEEE Int. Conf. on Mobile
Services (MS), Los Angeles, CA, USA, Jun. 2019, pp. 45-50.
3. R. S. Pressman and B. R. Maxim, Software Engineering: A Practitioner’s
Approach, 9th ed. New York, NY, USA: McGraw-Hill, 2020.
4. “Personal Expense Tracker – Manage your daily expenses easily,”
TechGig Blogs, 2023. [Online].
Available: [Link]
[Accessed: Nov. 5, 2025].
5. L. Gowda, “Personal Expense Tracker Using Android and SQLite,”
[Link]. Mini Project Report, Dept. of Computer Science, [Your College
Name], Bengaluru, India, 2025.
6. “ExpenseTrackr Version 2.1,” Android app, XYZ Software Solutions,
2025. [Mobile app]. Available: Google Play. [Accessed: Nov. 5, 2025].
________________ _______________
Signature of Guide Signature of HOD