Simple Payroll System with Dynamic Tax Bracket in PHP using SQLite Free Source Code

Language

Introduction

This is a PHP Project entitled Simple Payroll System with Dynamic Tax Bracket. This simple application manages the company's employees' payroll. The system has a dynamic withholding tax bracket that can be managed by the admin user and this data are being fetched when calculating the employee's payslip/paycheck. The source code can help new programmers to understand how to develop a Payroll system. The application has only a minimum scope but enough to learn with for those who are learning and beginners in PHP Language.

I developed this project using the following:

  • XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
  • PHP Language
  • SQLite Database
  • HTML
  • CSS
  • JavaScript
  • jQuery
  • Ajax
  • Bootstrap
  • Summernote
  • and more...

About the Simple Payroll System with Dynamic Tax Bracket

This simple project can be only accessed by 2 types of users which are the administrator and staff. The admin can manage all the features and functionalities that the project does including the tax bracket while the staff users have only limited permissions. The system enlists/stores the company's departments, designations/positions, and employee lists.

Talking about the computation of payroll, the system can only handle Monthly and Semi-Monthly payroll in each employee. I used 22 working days a month for computing the daily rate and for counting the employee's days of absences. In generating the employees' paycheck, the system user can also add the employee's other earnings such as the allowances and deductions dynamically. For the other earnings, the system user can choose if the additional earnings are taxable or not. The system will get the latest tax data in the system.

Project Features

  • Secure Login/Logout
  • Home Page
  • Manage Department List (CRUD)
  • Manage Designation List (CRUD)
  • Manage Employees List (CRUD)
  • Manage Withholding Tax Bracket Table (CRUD)
  • Generate Employees Payroll
  • Generate Printable Payslip
  • Manage System Users
  • Manage Account Credentials

Some of the System Snapshots

Employee List

Simple Payroll System with Dynamic Tax Bracket

Employee Details

Simple Payroll System with Dynamic Tax Bracket

Payroll Form

Simple Payroll System with Dynamic Tax Bracket

Printable Payslip

Simple Payroll System with Dynamic Tax Bracket

The project source code is free to download on this website. Feel Free to download and modify the source code the way you wanter. Follow the instruction below to run this project.

How to Run

Requirements

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

Installation/Setup

  1. Open your XAMPP/WAMP's php.ini file and uncomment the sqlite3 and gd 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 Simple Payroll System with Dynamic Tax Bracket in a browser. i.e. http://localhost/simple_payroll/.

Default Admin Access

Username: admin
Password: admin123

DEMO VIDEO

That's it! You can now explore the features and functionalities of this Simple Payroll System with Dynamic Tax Bracket project in PHP and SQLite Database. I hope this will help you with what you are looking for and you'll find something useful for your future PHP Projects.

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

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.

FOR YOUR OWN SAFETY, PLEASE:

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.

Comments

Submitted byChris benicio (not verified)on Tue, 10/05/2021 - 22:18

Hello, can we have the database in .sql file?

Add new comment

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
1 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.