D.Y.

PATIL COLLEGE OF ENGINEERING &TECHNOLOGY,

KASABA BAWADA, KOLHAPUR.
(2022-2023)

DEPARTMENT OF DATA SCIENCE

Domain Specific Mini Project Synopsis On

“EXPENSES TRACKER WEB PAGE”

Presented by:-
[Link]. Roll No. Name
1. 32 Mr. Varun Vivek Sangewar
2. 30 Mr. Ashish Kadam
3. 27 Mr. Omkar Rao

Class: SY Division: B Batch:B2

Under the guidance of

Dr. S. A. PATIL

Project Coordinator: Mr.

1
Sr. No Title Page No.

1. Problem Statement 1

2. Introduction 1

3. Existing System 1

4. Objectives 2

5. Proposed Work 2

6. Advantages and Disadvantages 5

7. System Architecture 6

8. Hardware and Software Requirements 6

9. Future Enhancements

10. Conclusion

11. References

INDEX

 Problem Statement:

2
 Keeping track of personal or business expenses can be a tedious and time- consuming task. It
can be challenging to remember all the expenses and maintain accurate records, especially
dealing with multiple payment methods or transactions from different sources. This can lead
to errors, missed deductions, and financial stress. Therefore, there is a need for a web
application that can help individuals and businesses keep track of their expenses efficiently
and accurately.

 Introduction:
Expenses tracking means recording all your expenditures so you have a clear and detailed
understanding of your budget. This is typically done for a certain project or over a certain
period, so you can stay on budget and make any necessary adjustments. For many small
businesses, expense tracking may include fixed expenses like rent and utilities as well as
fluctuation costs like labor, product orders and advertising. It’s especially important to record
one-time and variable costs, as these aren’t always accounted for in the initial budget.

 Expense tracking helps you take control of your finances and stay on budget
 You can organize your expenses into categories like fixed, periodic, and variable
spending
 It’s helpful to regularly review your expense tracking on a per-project or time-frame
system [4]

 Existing System:
While you could use a notebook or a spreadsheet to track your expenses, there are more than
a few tools online that are able to handle all the details and may have a few additional
features thrown in:

 Xpenser: If youre always on the go, Xpenser can be a good option. It allows you to
text your expenses in, helping you ensure that you don’t forget to track your spending
between the store and home.
 Moneytrackin’: For tracking expenses in multiple accounts such as business and
personal. It provides easy management of expenses between those accounts.
 Mint: While Mint only tracks your expenses made through a bank account (checks,
debit cards, credit cards), it does integrate expense tracking with a whole host of other
features including tools to help you analyze your spending.
 Buxfer: Another site that primarily tracks expenses made through bank accounts,
Buxfer also has tools to help organize shared expenses.
 Shoeboxed: You can add expenses by hand to Shoeboxed. [2]

 Objective:

3
 The expenses tracker covers the following issues:

 The primary objective of our expenses tracker is to record all expenses in a systematic
and organized manner.
 It will help you take control of your Finances and understand your spending habits as in
whether it is good spending habit or not.
 An expenses tracker help in setting budget limits for different categories of expenses.
 This web app should be easy to use and a user- friendly interface. This can encourage
regular usage and ensure that all expenses are recorded accurately.
 This tracker should be accessible from anywhere, anytime. This can be achieved through
a mobile app or a web-based platform that can be accessed from any device.
 It is essential to ensure that the expenses tracker is secure and that sensitive financial
information is protected from any unauthorized access.

 Proposed Work:

The project would involve building a web application that allows users to track their
expenses by adding, editing, and deleting transactions. The user interface would be built
using HTML and styled with CSS to make it visually appealing and easy to use.

The first step in developing the project would be to design the user interface using HTML.
This would involve creating a layout that includes different sections for displaying the user's
transactions, as well as forms for adding new transactions and editing existing ones. Once the
basic layout is in place, the next step would be to add styling using CSS. This would involve
selecting colors, fonts, and other visual elements that make the application look professional
and easy to use.

After the user interface is designed and styled, the next step would be to add functionality to
the application. This would involve using JavaScript to create interactive features such as the
ability to add and delete transactions, filter transactions by date or category, and calculate
total expenses. Once the application is fully functional, it can be tested and refined to ensure
that it meets the needs of users and is easy to use. With this expense tracker project,
developers can gain valuable experience with HTML, CSS, and JavaScript, while also
creating a useful tool that can help people manage their finances.

 Advantages and Disadvantages:

The following are advantages of using Expense Tracker:

1. Better understanding of your spending habits. [4]

2. It can help you create a realistic budget that aligns with your financial goals.
3. By identifying areas where you can cut costs and reduce unnecessary expenses, an
expense tracker can help you save money and achieve your financial goals more
quickly.

4
 4. It will help you identify ways to reduce debt and pay off outstanding balances more
quickly.
5. An expense tracker can save you time by automating many of the processes involved
in managing your finances, such as categorizing expenses. [4]

Disadvantages are as follows:

1. Setting up and using an expenses tracker can be time-consuming, especially if you

have a lot of transactions to categorize and record
2. If you are using a digital expenses tracker, technical issues such as data loss or
software crashes can potentially result in lost or incomplete data.
3. If you are manually inputting data into an expenses tracker, there’s always a
possibility of making mistakes or forgetting to log a transaction, which can affect the
accuracy of your financial records.
4. Some people may find that using an expenses tracker is too restrictive or that it
doesn’t work well with their spending habits, leading to frustration and the eventual
abandonment of the tool.

 System Architecture:

In this architecture, the client (i.e., the user's device) sends requests to the web server, which
hosts the web app. The web server handles the requests and responds with HTML, CSS, and
JavaScript files that make up the frontend of the app.

The frontend runs in the user's browser and communicates with the backend server through
HTTP requests. The backend server processes these requests and performs operations on the
database server, which stores the user's data.

The backend server may also interact with external APIs or tools (e.g., payment gateways,
currency conversion APIs, etc.) to provide additional functionality for the user. Overall, this
architecture provides a scalable and modular design for an expense tracker web app that can
easily be extended and adapted to meet changing user needs.

5
 System Requirements:
 Software Requirements:

a. Operating system: Windows 7 and higher versions by Windows or any equivalent

OS.
b. Developing Tool: Visual Basic 6.0
c. Database: My SQL
d. Since we are developing a webpage there are no any specific hardware
requirements as such but there is definitely the need of a GOOD INTERNET
CONNECTION to your device.
e. Computer must have access to network with dedicated browsing app and search
engine installed.

 Future Enhancement:

6
 The current system on which we are is expense tracking and we can further enhance this
project by adding AI based tracking. Future proposal will be a more attractive website as
compared to the current proposal which is in solid color format. In future system, AI will
automatically detect a successful transaction made by your UPI app and mention it in a
spreadsheet which will be more convenient to the users. Apart from these points there can be
various enhancements in the security system of web app. Increasing the number of firewalls
to the data server can be one amongst them which will enhance the security of the financial
data of the user. Taking this to a next level, we can think of merging domain of decentralized
platforms like Metaverse and Decentryland with expenses tracker to give the user a whole
new experience of Virtual Reality in the era of WEB 3.0.

 Conclusion:

In addition to its benefits for individuals, businesses can also benefit from using an expenses
tracker project. By monitoring and categorizing expenses, businesses can gain insights into
their spending patterns, identify areas where they can reduce costs, and improve their
budgeting and financial planning. This can lead to improved profitability and long-term
sustainability for the business. Additionally, using an expenses tracker can also help
businesses to manage cash flow, identify potential tax deductions, and simplify financial
reporting.

Overall, an expenses tracker project can be a valuable tool for anyone looking to improve
their financial management skills. Whether you are an individual looking to take control of
your personal finances or a business looking to optimize your spending, an expenses tracker
can provide valuable insights and help you make informed decisions about your money. With
the availability of various expenses tracker apps and tools, it is easier than ever to get started
with tracking your expenses and taking control of your finances. By adopting an expenses
tracking system, you can improve your financial health, reduce stress, and achieve your
financial goals.

 References:
1. An Introduction to Expense Tracking - LifeHack
2. The 5 Best Expense Tracker Apps of 2023 ([Link])
3. 9 Key Benefits of Expense Management Software | NetSuite
4. What is Expense Tracking? How Will it Help Your Business? ([Link])