DESIGN AND IMPLEMENTATION OF A COMPUTERIZED PAYROLL SYSTEM

DESIGN AND IMPLEMENTATION OF A COMPUTERISED PAYROLL SYSTEM (A CASE STUDY OF NIGERIAN CHRISTIAN INSTITUTE)

Payroll is a critical operation for every organization to pay employee accurately their salary and enrollments on time.
[1]The idea of taking control of employees pay calculations are quite tedious if done manually and require more effort and time mainly for big organizations. Hence if this process is automated, it would be of great benefit as it would require less time to calculate the salary of the employees. The software for payroll management system service on the cloud is provided as a solution in this paper.
[2] This system provides multiple user data access. Each user like employee or HR or admin can login into the software by writing username and password which are allocated to them from the company. It involves keeping track of hours worked and is capable of keeping a record of employee data including their pay, allowances, deductions and taxes on monthly bases so that fresh definitions are reflected from the month onwards, which leaves all the past data intact.
[3] The proposed payroll system is advantageous as it provides a user friendly environment and also increases security and minimizes human calculation errors. 
This paper discusses the design and implementation of a Payroll system database application with WAMP SERVER database. It also discusses the issues of selecting appropriate database model, interface design, and system deployment. A projection of record growth in relation to student population and system requirement was carried out in the study. Finally it discusses the applicability of the system in academic institutions. The Programming language used in developing this application is Visual Basic.net 2012. It runs in Windows 98 to Latest windows 8. Also Crystal report must be installed to view the report of the patient diagnosis information.

 

INTRODUCTION

BACKGROUND OF THE STUDY

A payroll is a company's list or records of its employees, which is often used to refer to the total amount of money that a company pays to its employees. 
A payroll system is software which organizes and arranges all the tasks of employee payment and the filing of employee taxes (Wikipedia). These tasks may include keeping tracking of hours, calculating wages, withholding taxes and deductions, printing and delivering checks and paying employment taxes to the government. Payroll software plays several roles for the user, the employees and the company, such as: giving you supper easy ways to manage employee calendar (e.g, sick leave, absences and overtime), gives you latest tax updates you when by notifying you when the updates arrive, allows you to quickly and easily generate payslips for all your employees, serves as a reminder. Payroll also makes deductions from employees’ wages for taxes, wage garnishment, health and life insurance, spending accounts and retirement investments. Payroll works with your accounting department to ensure that wage deductions and other payroll expenses are paid and properly reported.

1.2. Statement of Problem
Manual systems of payroll always put pressure on people to be correct in all aspect of their work.  With manual systems the level of service is dependent on individuals and this puts a requirement on management to run training continuously for staff to keep them motivated and to ensure they are following the correct procedures.  It can be all too easy to accidentally switch details and end up with inconsistency in data entry or in hand written orders.  This has the effect of not just causing problems with customer service but also making information unable be used for reporting or finding trends with data discovery.  Reporting and checking that data is also a problem and can be time consuming and expensive.  
Other problems caused by the manual payroll system are:

  1. Inconsistency in data entry, room for errors, miskeying information.
  2. Large ongoing staff training cost.
  3. System is dependent on good individuals.
  4. Reduction in sharing information and customer services.
  5. Time consuming and costly to produce reports.
  6. Lack of security of data.
  7. Duplication of data entry.

1.3. Objective of Study
The objectives of this study is to design a computerized payroll system for an organization,

  1. To design a computerized system for calculating basic salary and allowance of staff.
  2. To design a computerized payment platform.
  3. To design a system that accurately stores employee data and retrieves payment history when needed.
  4. To design a computerized system for tracking vacation time, maternity and paternity leave.

SCREEN SHOTS OF THE APPLICATION

1.4. Significance of the study
The study will aid in reducing errors, fraud, increase speed and also aid growth in organizations if successfully implemented. Manual payroll systems in organizations will be totally eliminated with this computerized system in place. The study will also serve as a guide to other student researchers who may want to conduct further research on the subject matter. Findings and recommendations from this system will aid in developing newer versions to serve optimally.
1.5. SCOPE/LIMITATION OF THE STUDY
The scope of this study is centered on the design and implementation of an epayroll system.
Limitation
Financial constraint- Insufficient fund tends to obstruct the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet, questionnaire and interview).
Time constraint- The researcher will at the same time engage in this study with other academic work. This consequently will cut down on the time devoted for the research work.

 

1.6. DEFINITION OF TERMS
A payroll: is a company's list or records of its employees, which is often used to refer to the total amount of money that a company pays to its employees. 
A payroll system: is software which organizes and arranges all the tasks of employee payment and the filing of employee taxes.
Payslips: a note given to an employee when they have been paid, detailing the amount of pay given and the tax and insurance deducted.
Employer: a person or organization that employs people.
Employee: a person employed for wages or salary, especially at nonexecutive level.
W-4 tax form: is a form completed by an employee to indicate his or her tax situation (exemptions, status, etc.) to the employer. The W-4 form tells the employer the correct amount of tax to withhold from an employee's paycheck.
Internal Revenue Service (IRS):  A United States government agency that is responsible for the collection and enforcement of taxes. 
Social Security Administration (SSA): is an independent agency of the United States federal government that administers Social Security, a social insurance program consisting of retirement, disability, and survivors' benefits.