Design and Implementation of Employee Information and Payroll System
(Using Caleb University as a Case Study)
The function of this system is to calculate the payment of the employee and contain the information of each employee in the organization. It stores information and records of all employees in a database. The system will be used by the staffs at the human resource department of Caleb University, Imota Lagos State, to calculate and record the data about the employees.
There are several modules in this system such as the employee’s payment calculation and registration of new employees and to update all employees’ details. The system helps the staffs to check and find information about employees quickly and systematically. The languages used by the researcher for the design and development of the system is JAVA SWING for the front-end and MySQL for the backend.
The system is designed to prevent problems occurred when using the manual system. The methodology used is the development of this system is the V-Shaped methodology. The structure of V-Shaped methodology consists of the stage of planning, analysis, designing, testing, maintenance, and implementation. The scope of the research is focusing more on Caleb University human resource department regarding the payment structure and personal data of the employees. In addition to other existing system, the payroll developed would be able to send pay slips directly to the employees’ email address, print out pay slip with the pictures of the employees including their details and send information of newly registered employees to their email and the school email for reviews and corrections.
Over the last few centuries, human beings have experienced two major revolutions: the industrial revolution and the electronic revolution. The former transformed our society from being agriculturally based, whereas the latter transformed our society from being mechanically based to electronically based. In 21st century a lot of manual technics is now being implemented electronically. Payroll is not an exemption. Implementation of this in Caleb University is the goal of this work.
1.1. Background of the Study
Payroll is a company’s list of its employees. It is mostly being referred to as the company’s records of its employees’ salaries and wages, bonuses, and taxes, company’s department that calculates and pays these and so on. Payroll design, testing and implementation of Caleb University Payroll System (CALPAS) is the goal of this work. The department uses the manual systems of payroll. As employee increases, there is need to have a computerized payroll system. Therefore, the aim of the project is to develop a computerize payroll software for the university.
1.2. Statement of the Problem
Manual systems of payroll always put pressure on people to be correct in all aspect of their work. It is too easy to accidentally switch details and end up with inconsistency in data entry or in hand written orders. It can be time consuming and expensive. The function of this work is to design and implement a payroll system owning to the fact that there exist no automated means of managing employees’ salaries, records and so on in the university
Other problems caused by the manual payroll system are:
i. Inconsistence data entry, prone to errors information.
ii. Cost of training employee on payroll is expensive
iii. Reduction in sharing information and customer services.
iv. It is time consuming and costly in reports production.
v. Data is not secure.
vi. Duplication of data is possible.
This project builds a computerized payroll system that will reduce and take care of problems associated by manual method of managing and processing employees’ salaries, records and so on in the university.
1.3. Aim and Objectives
The aim of this study is to develop a computerized payroll system for Caleb University. The specific objectives are to:
i. design a computerized payroll system for Caleb University Imota Lagos State.
ii. implement the designed payroll system in (i)
iii. evaluate the performance of the implemented payroll system in (ii) qualitatively
1.4. Significance of the Study
This study will aid in reducing errors and fraud associated with the manual processing of employees’ salaries and records, increase speed, and enhance the technology edge in Caleb University, Imota Lagos if successfully implemented. Manual payroll systems in Caleb University will be eliminated with CALPAS in place.
1.5. Scope of the Study
The payroll system is developed for Caleb University only and might not fit into other similar systems perfectly and would be called CALPAS (Caleb University Payroll System).
1.6. Definition of Terms
This section gives a definition and explanation of some of the terms used in the project.
i. Employee Data: This consist of employee’s information in the organization. It consists of the employee identification number, employee name, pay rate, bio data, contact information, payment information, personal information, employment information etc.
ii. Net Pay: This is the total salary amount that would be paid to an employee after all the deductions are subtracted from the gross pay.
iii. Gross Pay: The gross pay is the amount an employee earns before the deductions are subtracted.
iv. Payroll: A payroll is a company’s list of its employees. It term is mostly refers to as the amount of money that a company pays its employees, the company’s records of its employees’ salaries and wages, bonuses, and taxes, company’s department that calculates and pays these etc.
v. Payroll System: This is a software which keeps the organization company’s list or records of its employees. It is often referring to the total amount of money that a company pays to its employees. It is organizing and arranges all the tasks of employee payment and the filing of employee taxes.
vi. Pay Slips: a note given to an employee when salary is being paid, detailing the amount of pay given and the tax and insurance deducted.
vii. Employer: a someone or an organization that employs people in the organization.
viii. Employee: a someone that is employed for wages or salary, especially at nonexecutive level.
ix. W-4 tax form: This is a form filled by an employee to specify his or her tax status to the employer. It tells the employer the amount of tax to withhold from employee’s paycheck.
x. Internal Revenue Service (IRS): A states government agency that is responsible for the collection and enforcement of taxes.
Nabil Mohammed Ali Munassar and A. Govardhan (2010). A Comparison Between Five
Models of Software Engineering.
Gurlal Singh (2014). Implementation and Development of a Proposed Payroll System.
Poonamdeep Kaur, Dr. Dinesh Grover (2012). Computer Based Payroll System Implementation
for E-Governance at Punjab Agricultural University
Asmau Sani Mohammed, Hamman W. Samuel, Malachy Khanoba, Osaetin Evbuoma (2007). Project Report On Payroll System.
Guillermo L. Taboada, Sabela Ramos, Roberto R. Exp´osito, Juan Touri˜no, Ram´on Doallo (2011). Java in the High Performance Computing Arena: Research, Practice and Experience.