Daily Expense Tracker Using PHP and MySQL

• Admin login and logout in this final year project
• Admin dashboard with total users, total expenses, total income, and net balance
• Today’s platform expense overview
• Monthly platform expense overview
• Six-month income vs expense chart
• Fourteen-day daily expense trend chart
• Category-wise expense split chart
• Recent expense transaction list
• Top spender list
• Over-budget user alerts
• System statistics overview
• Admin profile view
• Admin profile update
• Admin password change
• User CRUD management
• Add new user with Indian address details
• Edit user details
• Reset user password
• Delete user and related records
• Activate/deactivate user accounts
• Expense category CRUD management
• Add expense category
• Edit expense category
• Enable/disable expense category
• Delete category if not in use
• Income category CRUD management
• Add income category
• Edit income category
• Enable/disable income category
• Delete category if not in use
• Payment mode CRUD management
• Add payment mode
• Edit payment mode
• Enable/disable payment mode
• Delete payment mode if not in use
• View all user expenses
• Filter expenses by user
• Filter expenses by category
• Filter expenses by date range
• Filter expenses by today/month/year
• View expense summary
• Delete wrong expense records
• View all user income records
• Filter income by user and date range
• View income summary
• Delete wrong income records
• Budget limit management
• Set overall user budget
• Set category-wise user budget
• Edit budget limit
• Delete budget limit
• View over-budget users
• View budget progress bars
• Manage user remarks and notes
• Delete user remarks
• Generate platform expense reports
• Generate platform income reports
• Generate monthly summary reports
• Generate user-wise comparison reports
• Print admin reports

• User registration in this final year project
• User login and logout
• Inactive account login restriction
• User dashboard with today, weekly, monthly, and yearly expense summary
• Monthly income summary
• Monthly balance summary
• Budget alert and over-budget warning
• Six-month income vs expense chart
• Seven-day spending trend chart
• Category-wise expense chart
• Recent expense and income transaction list
• Account statistics
• User profile view
• User profile update
• Change password
• Expense CRUD management
• Add expense record
• Select expense category
• Select payment mode
• Enter expense amount
• Add expense date
• Add description and remark
• Quick amount buttons such as ₹100, ₹250, and ₹500
• Edit expense record
• Delete expense record
• Filter expenses by category, payment mode, and date
• View expense summary with pagination
• Income CRUD management
• Add income record
• Select income category
• Enter income amount
• Add income date
• Add description and remark
• Edit income record
• Delete income record
• Filter income by date and category
• Monthly analytics summary
• Category-wise expense breakdown
• Payment mode usage breakdown
• Six-month financial trend
• Budget management
• Set monthly budget
• Set category-wise budget
• Edit existing budget
• View budget progress bars
• View safe/warning/danger budget status
• Search records by keyword
• Search expenses and income records
• View personal history
• View last 100 expense records
• View last 100 income records
• View fourteen-day expense trend
• Generate personal expense report
• Generate personal income report
• Print/download personal reports

• Public landing page
• Hero section with Register and Login CTA buttons
• Feature highlights for expense, income, budget, reports, and admin panel
• “How It Works” section
• Four-step guide: Register → Add Records → Set Budget → Analyze
• Statistics preview in Indian Rupees
• Admin login quick link
• Indian market branding
• Responsive design for desktop, tablet, and mobile
• Complete daily expense tracker source code
• Suitable for final year project, major project, and minor project
• Project report content can be prepared from included modules
• Admin Panel and User Panel included
• Indian Rupee ₹ / INR formatting
• Asia/Kolkata timezone support
• Indian states dropdown
• Indian payment modes support
• Payment modes include UPI, Cash, Debit Card, Credit Card, Net Banking, PhonePe, Paytm, and Google Pay
• Chart.js analytics dashboards
• Category-wise expense analytics
• Payment-mode analytics
• Monthly budget monitoring
• Over-budget warning system
• Printable reports with browser print/save as PDF support
• Flash success/error messages
• Pagination support
• Search and filter support
• PDO prepared statements
• Password hashing using password_hash() and password_verify()
• PHP session-based authentication
• Separate admin and user sessions
• Output escaping using htmlspecialchars()
• One-click database installer
• Indian sample seed data included
• Useful for viva, source code review, project report writing, and project demonstration

• Copy the project folder into:

  C:\xampp\htdocs\Daily Expense Trakcer Project V2\

• Start Apache and MySQL from XAMPP.

• Edit database configuration:

  config/database.php

• Set database details:

  define('DB_HOST', 'localhost');
  define('DB_NAME', 'daily_expense_tracker');
  define('DB_USER', 'root');
  define('DB_PASS', '');

• Set application URL:

  define('APP_URL', 'http://localhost/Daily%20Expense%20Trakcer%20Project%20V2');

• Open database installer:

  http://localhost/Daily%20Expense%20Trakcer%20Project%20V2/database/install.php

• Click Install Database.

• The installer will create:

  daily_expense_tracker

• Delete database/install.php after successful installation.
• Open homepage:

• http://localhost/Daily%20Expense%20Trakcer%20Project%20V2/

• Open user login:

• http://localhost/Daily%20Expense%20Trakcer%20Project%20V2/user/login.php

• Open admin login:

• http://localhost/Daily%20Expense%20Trakcer%20Project%20V2/admin/login.php

• Email: [email protected]
• Password: admin123
• Name: Rajesh Kumar
• Login URL: /admin/login.php

Sample User Account

• Email: [email protected]
• Password: user123
• Name: Amit Sharma
• City: Mumbai, Maharashtra
• Login URL: /user/login.php