Daily expenses tracker project ppt7.pptx

Project

1. DAILY EXPENSE TRACKER Presented by Sumaiya Maryam. H iii - b.sc(computer science) Under the guidance of T. Nagasivaparvathi m. sc .,m.b.a., m.phil ., Department of computer science Deen college of arts and science

2. Abstract This project is based on an expense and income tracking system. This project aims to Create an easy, faster and smooth tracking system between the expense and the income. This project also offers some opportunities that will help the user to sustain all financial Activities like digital automated diary. So, for the better expense tracking system, we Developed our project that will help the users a lot. Most of the people cannot track their Expenses and income one way they face a money crisis, in this case daily expense tracker Can help the people to track income-expense day to day and making life tension free. This Project will save time and provide responsible lifestyle. Our project explains about the daily expense Tracker. According to date wise, month wise, year wise Expense. This project shows some ease in adding, editing and deleting the expense details. It also provides a less time-consuming process for viewing, Adding, editing and processing expense of the users.

3. introduction In today’s busy and expensive life, we are in a great rush to make money. But at the end of the day, we broke off. As we are unknowingly spending money on little and unwanted things. So, we have come over with the idea to track our earnings. Daily Expense Tracker (DET) aims to help everyone who are planning to know their expenses and save from it. DET is a website in which user can add expenses on daily basis and its table will get generated and at the end based on user expenses report will be generated. User can select date range to calculate his/her expenses. This system is very much useful for House-Wife to control their Income-expense from Day-to-Day to Yearly Basics. And to keep a watch on their expense. In today’s fast-paced world, where every penny counts, it’s becoming increasingly vital to have a clear understanding of our spending habits. The Daily Expense Tracker (DET) emerges as a beacon of financial empowerment, providing individuals with a robust platform to meticulously monitor their expenditures, thereby fostering a culture of mindful spending and prudent financial management.

4. MODULE DESCRIPTIOn 1. User Register. 2. User Login. 3. Expense Add Expense Manage Expense 4. Income. Monthly Income 5. Expense Report Date wise Report Month wise Report Year wise Report 6. Profile 7. Change password 8. Logout

5. Existing system Existing system does not use the smart concept which are used now a days. In existing, we need to maintain the Excel sheets, CSV etc. files for the user daily and monthly expenses. Disadvantages of Existing System The existing system is not user friendly because data is not maintained efficiently. This project will be an unpopulated data because it has some disadvantages by not alerting a person for each and every Month. But it can used to perform calculation on income and expenses to overcome this problem we propose the new Project.

6. Proposed system Introducing our revolutionary Online Daily Expenses Tracker in PHP, designed to address the shortcomings of existing systems. With a user-friendly interface, this application streamlines expense and income management, eliminating manual calculations. Advantages of Proposed System Financial Awareness: Daily expenses trackers promote a heightened awareness of your financial activities by recording and categorizing every expense and income. Improved Saving Habits: Tracking daily expenses encourages better saving habits as users can visualize their surplus income and allocate it towards savings. Expense Analysis: Detailed reports and visualizations help users analyze spending trends, identifying areas where expenses can be optimized.

7. Software description HTML CSS JS PHP MySQL

8. Software requirements Operating Systems : Windows 10 Front-End Tool : Xampp Back-End Tool : MySQL Server Language : PHP

9. Table structure FIELD DATA TYPE DEFAULT KEY Expense_ID VARCHAR(25) NOT NULL PRIMARY KEY ExpenseDate DATE NULL   ExpenseItem VARCHAR(25) NULL   ExpenseCost INT NULL   FIELD DATA TYPE DEFAULT KEY tbluser_ID_ VARCHAR(25) NOT NULL PRIMARY KEY FullName VARCHAR(25) NULL   Mobile Number VARCHAR(25) NULL   Password VARCHAR(25) NULL   RegDate DATE / TIME NULL   FIELD DATA TYPE DEFAULT KEY IncomeDate DATE NULL   MonthlyIncome INT(15) NULL  

10. Source code dbconnection.php <? php $con= mysqli_connect ("localhost", "root", "", " detsdb "); if( mysqli_connect_errno ()){ echo "Connection Fail". mysqli_connect_error (); } ?> footer.php <div class="col-sm-12">  <b>< center ><p><font color =”#30a5ff” size=”+”> © developed by Sumaiya Maryam</font><p></ center ></b>  </div> header.php <? php session_start (); error_reporting (0); include('includes/ dbconnection.php '); ?> <a class="navbar-brand" href =" dashboard.php "><span>Daily Expense Tracker</span></a>

11. Sidebar.php <li class="parent "><a data-toggle="collapse" href ="#sub-item-1"> < em class="fa fa- navicon ">& nbsp ;</ em >Expenses <span data-toggle="collapse" href ="#sub-item-1" class="icon pull-right">< em class="fa fa-plus"></ em ></span> </a> < ul class="children collapse" id="sub-item-1"> <li><a class="" href ="add- expense.php "> <span class="fa fa-arrow-right">& nbsp ;</span> Add Expenses </a></li> <li><a class="" href ="manage- expense.php "> <span class="fa fa-arrow-right">& nbsp ;</span> Manage Expenses </a></li> </ ul > </li> Addexpense.php $query= mysqli_query ($con, "insert into tblexpense ( UserId,ExpenseDate,ExpenseItem,ExpenseCost ) value('$ userid ','$ dateexpense ','$item','$ costitem ')"); if($query){ echo "<script>alert('Expense has been added');</script>"; echo "<script> window.location.href ='manage- expense.php '</script>"; } else { echo "<script>alert('Something went wrong. Please try again');</script>"; }

12. Manage- expense.php $query= mysqli_query ($ con,"delete from tblexpense where ID='$ rowid '"); if($query){ echo "<script>alert('Record successfully deleted');</script>"; echo "<script> window.location.href ='manage- expense.php '</script>"; } else { echo "<script>alert('Something went wrong. Please try again');</script>"; }} Montly-income.php $query= mysqli_query ($con, "insert into tblincome ( IncomeDate,MonthlyIncome ) value('$ dateincome ','$income')"); if($query){ echo "<script>alert('Monthly Income has been added');</script>"; } else { echo "<script>alert('Something went wrong. Please try again');</script>"; }}

13. Dashboard.php <title>Daily Expense Tracker - Dashboard</title> //Today Expense $ userid =$_SESSION[' detsuid ']; $ tdate =date('Y-m-d'); $query= mysqli_query ($ con,"select sum( ExpenseCost )  as todaysexpense from tblexpense where ( ExpenseDate )='$ tdate ' && ( UserId ='$ userid ');"); $result= mysqli_fetch_array ($query); $ sum_today_expense =$result[' todaysexpense '];  ?> <h4>Today's Expense</h4> <div class=" easypiechart " id=" easypiechart -blue" data-percent="<? php echo $ sum_today_expense ;?>" ><span class="percent"><? php if($ sum_today_expense ==""){ echo "0"; } else { echo $ sum_today_expense ; }

14. Expense- datewise - reports.php <div class="form-group"> <label>From Date</label> <input class="form-control" type="date"  id=" fromdate " name=" fromdate " required="true"></div><div class="form-group"> <label>To Date</label> <input class="form-control" type="date"  id=" todate " name=" todate " required="true"></div><div class="form-group has-success"> <button type="submit" class=" btn btn -primary" name="submit">Submit</button></div> expense- monthwise - report.php   <form role="form" method="post" action="expense- monthwise -reports- detailed.php " name=" bwdatesreport "> <div class="form-group"> <label>From Date</label> <input class="form-control" type="date"  id=" fromdate " name=" fromdate " required="true"> </div> <div class="form-group"> <label>To Date</label> <input class="form-control" type="date"  id=" todate " name=" todate " required="true"> </div><div class="form-group has-success"> <button type="submit" class=" btn btn -primary" name="submit">Submit</button></div>                          

15. Expense- yearwise - report.php <form role="form" method="post" action="expense- yearwise -reports- detailed.php " name=" bwdatesreport ">  <div class="form-group"> <label>From Date</label> <input class="form-control" type="date"  id=" fromdate " name=" fromdate " required="true"> </div> <div class="form-group"> <label>To Date</label> <input class="form-control" type="date"  id=" todate " name=" todate " required="true"> </div> <div class="form-group has-success"> <button type="submit" class=" btn btn -primary" name="submit">Submit</button> </div> $ret= mysqli_query ($ con,"SELECT year( ExpenseDate ) as rptyear,SUM ( ExpenseCost ) as totalyear FROM tblexpense  where ( ExpenseDate BETWEEN '$ fdate ' and '$ tdate ') && ( UserId ='$ userid ') group by year( ExpenseDate )");

16. User- profile.php $ userid =$_SESSION[' detsuid ']; $ fullname =$_POST[' fullname ']; $ mobno =$_POST[' contactnumber ']; $query= mysqli_query ($con, "update tbluser set FullName ='$ fullname ', MobileNumber ='$ mobno ' where ID='$ userid '"); if ($query) { $ msg ="User profile has been updated."; } else { $ msg ="Something Went Wrong. Please try again."; }}

17. Register.php $ fname =$_POST['name']; $ mobno =$_POST[' mobilenumber ']; $email=$_POST['email']; $password=md5($_POST['password']); $ret= mysqli_query ($con, "select Email from tbluser where Email='$email' "); $result= mysqli_fetch_array ($ret); if($result>0){ $ msg ="This email  associated with another account"; } else{ $query= mysqli_query ($con, "insert into tbluser ( FullName , MobileNumber , Email,  Password) value('$ fname ', $ mobno ', '$email', '$password' )"); if ($query) { $ msg ="You have successfully registered"; } else { $ msg ="Something Went Wrong. Please try again"; }}

18. Screen layout

19. Conclusion Daily expense tracker is a refined system which allows user to efficiently manage his/her expenses with ease. Tracking expenses daily can really help to us save lot of money. Once we start off by tracking our expenses each day, we will be able to get a better idea where you are spending your money, you stay in control and achieve your goals. After making this application we assure that this application will help its users to manage the cost of their daily expenditure. It will guide them and make them aware about their daily expenses. It will prove to be helpful for the people who are frustrated with their daily budget management, irritated because of the amount of expenses and wish to manage money and to preserve the record of their daily cost which may be useful to change their way of spending money. In short, this application will help its users to overcome the wastage of money.

20. Future enhancement A Daily Expense Tracker is a tool designed to help users manage their finances by tracking their daily spending and income. In its current state, the tracker allows users to input their daily expenses, categorize them, and view their total Expenses for the day, week, month, and year. Additionally, users can input their monthly to track their finances inflow. For future Enhancement, several features can be added to make the tracker more comprehensive and user-friendly. User Profile: Allow users to create profile for personalized financial management. Budgeting: Set and Track monthly or yearly Budgets for different categories. Advanced Analytics: Provide Detailed insights into spending patterns and trends Goal Setting: Set and Monitor progress towards financial goals. Reminder System: Set Reminders for recurring Expenses and Income

21. reference BOOK REFERENCE “Complete Reference HTML”, T. A .Powell, 3 rd Edition, Tata McGrawHill Publishing Company Limited, Indian Reprint 2002. “MySQL: The Complete Reference”, VikramVaswani , 2 nd Edition, Tata McGrawHill Publishing Company Limited, Indian Reprint 2009. 3. “PHP: The Complete Reference”, Steven Holzner , 2 nd Edition, Tata McGrawHill Publishing Company Limited, Indian Reprint 2009.   WEBSITE REFERENCE https://www.tutorialspoint.com https://www.phptutorial.net https://www.w3schools.com https://www.studocu.com https://www.researchgate.net https://www.academia.edu