Earnings and Expense Tracker App using PHP and SQLite3 Source Code Free Download


This is a simple PHP Project entitled Earnings and Expense Tracker Application. It is a web application that handles multi-users to manage and track their earnings and expenses. The application was mainly developed using PHP Language and SQLite3. It has a simple and pleasant user interface using the Bootstrap v5 Framework. It contains multiple user-friendly features and functionalities for managing the money of the logged-in users.

How does the Earnings and Expense Tracker App work?

The Earnings and Expense Tracker App is a simple web application that was developed mainly to provide possible users with a platform to manage and track their money. Anyone can simply register for the application but in a subject-for-approval state. Once the newly registered users' accounts have been verified and approved by the site management, they will have the privilege to access and use the features and functionalities of the site. Users can set the Starting Amount/Balance on this website. The site contains Earnings and Expenses Management pages which have a CRUD (create, read, update, and delete) and date-wise filtering of the list functionalities. On the home page, users can see the summary of their total earnings, expenses, and balance. Users are only allowed to see and manage their own records.

Features and Functionalities

The Earnings and Expense Tracker App consists of the following features and functionalities:


  • Login Form
  • Home Page
  • User Management
    • Update User Status
    • Update User Type
  • Logout


  • Login Form
  • Registration Form
  • Home Page
    • Total Earnings
    • Total Expense
    • Current Balance
  • Earnings Management
    • Add New Earning Data
    • List All Earnings Data
    • Filter Earnings Data by Date Range
    • Update Earnings Data
    • Delete Earnings Data
  • Expenses Management
    • Add New Expense Data
    • List All Expenses Data
    • Filter Expenses Data by Date Range
    • Update Expenses Data
    • Delete Expenses Data
  • Wallet Management
  • Logout


Here are some of the page interface snapshots of the Earnings and Expense Tracker App:

Home Page

Earnings and Expense Tracker App using PHP and SQLite3

Earnings Page

Earnings and Expense Tracker App using PHP and SQLite3

Expenses Page

Earnings and Expense Tracker App using PHP and SQLite3

Technologies Used

The Earnings and Expense Tracker App was developed using the following technologies:

  • VS Code Editor
  • PHP
  • SQLite3
  • HTML
  • CSS
  • JavaScript
  • jQuery
  • Ajax
  • Google Icons
  • Bootstrap v5 Framework

The Earnings and Expense Tracker App project source code zip file is available on this website and it is free to download. Feel free to download and modify the source code the way you desire.

Note: This Simple PHP and SQLite3 Project Source Code was mainly developed for educational purposes only.

How to Run


  • Download and Install any local web server such as XAMPP/WAMP.
  • Download the provided source code zip file. (download button is located below)


  1. Open your XAMPP/WAMP php.ini file and uncomment the sqlite3 extension. Then, save the file.
  2. Open your XAMPP/WAMP's Control Panel and start Apache.
  3. Extract the downloaded source code zip file.
  4. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
  5. Browse the Earnings and Expense Tracker App in a browser. i.e. http://localhost/php-sqlite-expense-tracker/.

Default Admin Access

Username: admin
Password: sourcecodester&123


That's it! I hope this Earnings and Expense Tracker App in PHP and SQLite3 Source Code will help you with what you are looking for and will be useful for your current and future web PHP projects.

Explore more on this website for more Tutorials and Free Source Codes.

Enjoy =)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Submitted byAkruti Ghaskatta (not verified)on Wed, 04/26/2023 - 20:04

Even after uncommenting sqlite3 the code is not running any solution?

Add new comment