DEVELOPMENT OF AN INFORMATION PROCESSING SYSTEM FOR PAYROLL MANAGEMENT
ABSTRACT
This research project is focused on development of an Information System for Payroll Management a case study of B-Link Enterprise Ikot Ekpene. The payroll units of the enterprise encountered enormous challenges in the preparation of pay slips. The problems included errors in computing payroll records, delayed in payment of salaries and inability to instantly retrieve reports concerning payroll information of employees. To overcome these challenges, a payroll application was developed to compute payroll details and to generate pay slips. This information can be saved to database for future retrieval when needed. The system analysis and design methodology used is Waterfall model. The programming language used is Visual BASIC 6.0. Being a database application, it makes sure needed information concerning the payroll records of employees is easily accessible. It is therefore imperative to make use of automated payroll management system. It is recommended that the case study should make use of automated system to manage payroll information of staff, database administrators and computer programmers should be contracted to develop customized payroll applications to overcome the challenges of the manual system
TABLE OF CONTENTS
Title Page – – – – – – – – i
Certification – – – – – – – – – ii
Dedication – – – – – – – – iii
Acknowledgment – – – – – – – – iv
Abstract – – – – – – – – v
Table of Contents – – – – – – – – vi-vii
CHAPTER ONE: INTRODUCTION
1.0 Introduction – – – – – – – 1-2
1.1 Background of the Study- – – – – – 2
1.2 Statement of Problem – – – – – 2
1.3 Aim and Objectives of the Study- – – – – 2-3
1.4 Scope of the Study – – – – – – – 3
1.5 Significance of the Study – – – – – – 3
1.6 Organization of Research – – – – – – 3-4
1.7 Definition of Terms – – – – – – 4-5
CHAPTER TWO: LITERATURE REVIEW
2.0 Introduction – – – – – – – – 6
2.1 Overview of Information Processing System – – –
2.2 Overview of Payroll Accounting – – – – –
2.3 Employees Concept – – – – – – –
2.4 Payroll Internal control – – – – – –
2.5 Payroll Computation Variables – – – – –
2.6 Steps Involved in Processing Payroll Information – –
CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN
3.0 Introduction – – – – – – – – 18
3.1 Research Methodology – – – – – 18
3.2 System Analysis – – – – – – – – 18
3.2.1 Analysis of the Existing System – — – – 19
3.2.2 Problems of the Existing System – – – 19
3.2.3 Analysis of the Proposed System – — – 19
3.2.3.1 Advantages of the Proposed System – – – 19
3.3 System Design – – – – – – – 20
3.3.1 Input Layout – – – – – – 20
3.3.2 Output Layout – – – – – – 21
3.3.3 Database Design – – – – – – 21
3.3.4 Algorithm – – – – – – – 21-22
3.3.5 Program Flowchart – – – – – 23-27
CHAPTER FOUR: SYSTEM IMPLEMENTATION AND DOCUMENTATION
4.0 Introduction – – – – – – – 28
4.1 System Design Diagram – – – – – – 28
4.2 Choice of Programming Language – – – 28-29
4.3 Analysis of Modules – – – – – 29
4.4 System Requirements – – – – – – 29
4.4.1 Hardware Requirements – – – – – 29-30
4.4.2 Software Requirements – – – – 30
4.5 Implementation – – – – – – – 30-31
CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATIONS
5.0 Introduction – – – – – – – 32
5.1 Constraints of the Study – – – – – – 32
5.2 Summary – – – – – – 32
5.3 Conclusion – – – – – – 33
5.4 Recommendations – – – – – – 33
References – – – – – – 34
Appendix A (Source Code) – – – – – 35-40
Appendix B (Output) – – – – – – 41-46
CHAPTER ONE
INTRODUCTION
I.0 Introduction
An information processing system for payroll management is an information system that helps users to capture, process and store payroll information for easy management. According to (Wikipedia, 2015), payroll is the sum of all financial records of salaries for an employee, wages, bonuses and deductions. In accounting, payroll refers to the amount paid to employees for services they provided during a certain period of time. Payroll plays a major role in a company for several reasons. From an accounting perspective, payroll is crucial because payroll and payroll taxes considerably affect the net income of most companies and they are subject to laws and regulations. A payroll accounting system is a computerized system that enables payroll records to be captured and computed so that it will be easy for retrieval and confirmation of supposed payment salary values for staffs. With computers now driving virtually all business activities, payroll accounting system is one of such systems that make it easy for organizations to perform payroll related information in electronic format as opposed to the manual method. For many businesses, especially service companies, labor costs comprise the largest part of operating expenses. Many labor costs are a result of various complex government regulations, and thus, the payroll accounting system can be quite complex. First of all, it is important to distinguish between employees and contractors as payroll accounting applies only to employees of an organization. Independent contractors are not considered to be employees, and hence, they are not accounted for under a payroll system. Generally speaking, independent contracts render services for a fee and are not under supervision or control of the company.
1.1 Background of the Study
Payroll is one of the major activities in an organization since workers need to be paid daily, weekly or monthly as the case may be. To facilitate easy management of the payroll, an information processing system for payroll management is needed Payroll Management System can handle and manage complex calculations that would otherwise be prone to errors. For example, the complex calculation may take the input, rate or basic salary from the employee detail or transaction entry. The formula programmed in the system will simplify the complex calculation because it is system generated. User just have to key in the required field in the form, then employee’s pay, allowance advanced, deduction and others will be generated.
It is a type of an information processing system. In a broad scope, the term Information processing Systems is a scientific field of study that addresses the range of strategic, managerial and operational activities involved in the gathering, processing, storing, distributing and use of information, and its associated technologies, in society and organizations. The term information systems is also used to describe an organizational function that applies IS knowledge in industry, government agencies and not-for-profit organizations. Information Systems often refers to the interaction between algorithmic processes and technology. This interaction can occur within or across organizational boundaries. An information system is not only the technology an organization uses, but also the way in which the organizations interact with the technology and the way in which the technology works with the organization’s business processes. Information systems are distinct from information technology (IT) in that an information system has an information technology component that interacts with the processes components (Ken, 2001).
1.2 Statement of the Problem
Payroll information poses the following significant problems.
- Payroll information cannot be easily retrieved in the manual system.
- In addition, the manual system is associated with computation errors and they cannot be easily corrected without causing more errors and indecency of the recording material.
- Management cannot get needed information instantly.
- In view of these problems, a payroll accounting system is needed to facilitate the operations of payroll in the civil service sector.
- Aim and Objectives of the study
The aim of the study is to develop an information processing system for payroll management that will facilitate payroll computations with minimal stress and also to facilitate the storage and retrieval of payroll information.
The objectives to realize the aim of this work is as follow;
- To maintain a database of employee payroll records
- To automate the computation of basic payroll information
To provide a system that can be used to easily
DEVELOPMENT OF AN INFORMATION PROCESSING SYSTEM FOR PAYROLL MANAGEMENT
