ABSTRACT
This project is aimed at creating an
application for the financial calculation and develops of employees pay checks. The payroll system is designed using Visual
Basic 6.0 Microsoft application. The system consists of eight processes at zero
diagram computerized payroll system with three files for data storage.
Computerized payroll system is one of the
earliest commercial applications of the computer system in an organization and
is still among the most important application in the world. It involves
business transaction, in which the employee salaries are proceeding in an
organization.
But
with the implementation of computerized payroll system, the work is very easy.
It is now a big relief to the company, management and also the workers. A
computerized payroll system tool is designed to ease the daily routines of an
organization.
TABLE
OF CONTENTS
CHAPTER
ONE: Introduction
1.1
Statements of Problem
1.2
Aims and Objectives of a Payroll
1.3
Significance of the Research
1.4
Scope of Study
1.5
Research Methodology
1.6 Definition
of Terms
CHAPTER
TWO: Literature Review
2.1
Historical Background of the Organization
2.2
General Overview of Payroll computation
2.3
Existing System
CHAPTER
THREE: System Analysis Design
3.1
System Analysis
3.1.1 System Description
3.1.1.1
Source Data Collection
3.1.1.2 Recording the Data
3.1.1.3 Processing
the Data
3.1.1.4 Producing Output
3.1.2 System Evaluation
3.1.3 The Way out
3.2 System Design
3.2.1
Overview of the New System
3.2.2
Output Design
3.2.3
Input Screen (User Interface)
3.2.4
Database Design
3.2.5 Process Design
CHAPTER
FOUR: System Implementation and Documentation
4.1 System Implementation
4.1.1 Choice of
Programming Language
4.1.2 Choice of
Database Application Package
4.2 System
Requirement
4.2.1 System
Testing
4.2.2
System Documentation
CHAPTER
FIVE: Summary of Findings
5.1
Summary
5.2
Achievement
5.3
Limitation
5.4
Problems Encountered
5.5
Recommendation
5.6
Implication of a payroll system
5.7
Conclusion
Reference
Appendices
CHAPTER ONE
1.0 INTRODUCTION
Payroll is an accounting activities dealing with preparation and
payment of employee salaries for services rendered .A lot of items or elements
form a typical payroll session and these include: Basic Salaries, Allowance and
Deductions.
A payroll system involves
all the calculations of amount due to an employee, comprising wages etc. Salaries
differ in accordance with certain factors such as level of education, technical
skills required for task, and so on. All monies are paid to the employee as
salary is obtained after all deductions have been made from the gross pay for
that month. The gross pay is the Basic Salary plus Allowances. The amount left
after deducting all the deductions from the gross pay is called the net pay;
this is the employee’s salary for the month ended. This may be deposited into the
employee’s account or given to him in cash. He can collect his pay slip from
the Accounts Department.
1.1STATEMENT OF THE PROBLEM
The recurring reports about
paying ghost workers salaries have been so disturbing and as such call for some
way of curbing the situation if it cannot be totally removed. It is on this
note that the need for this project came about in order to design and develop a
formable computerized payroll system. This system shall be developed using the
modern software development tools-such as-Visual Basic 6.0.
1.2AIMS AND OBJECTIVES
The aims and objectives of
this project are as follow:-
The designing of payroll system software to produce paychecks for
the employees.
a) To handle all collections
including deductions and account billings for the employees.
b) To provide access to employee profile.
c) Putting up a suitable environment for the management and workers.
1.3 SIGNFICANCE
OF THE RESEARCH
The significance of the research includes:
a) Helping to overcome and
reduce the problems of the manual method of payroll preparations.
b) Support for the day-to-day
administrative tasks.
c) Recording and reporting
on accounting data.
d) Minimization of errors
when preparing paychecks (i.e. increased accuracy).
1.4 SCOPE
OF THE STUDY
An employee payroll system covers large information about the employees
in the organization. Apart from the basic salaries, the employee is entitled to
some allowances and certain taxes, which will be deducted from employee
salaries. These are some of the allowances an employee is entitled to:
·
Housing Allowance
·
Transport Allowance
·
Feeding Allowance
·
Medical Allowance
Apart from above benefits an employee is entitled to loans in the
organization; there are also deductions, from the employee salary to make it a complete
payroll system. These deductions are:-
·
Income Tax
·
Union
·
Insurance
The Income Tax is included in the deductions because an employee
has to pay government tax which will be deducted from his salary, also
insurance for his/her properties (i.e. car insurance, house insurance etc), Union
are also deductible.
At the end of the month, a payslip will be issued to the employee
with full details of all expenses the employees made for that month ended.
An employee payroll system as earlier said is limited to basic salary;
total allowances deductions, net pay to get the gross pay. Any other expenses
will no longer reflect because the above are the income an employee will earn.
1.5 RESEARCH
METHODOLOGY
This is the process where investigations will have to be carried
out about the system to be designed in this case- a payroll system. You ask the
organization question to know the problems of the existing payroll system they
are using, whether manual or automated.
There are different ways which you can obtain information from the
organization, and the methods are: Interview Method, or Questionnaire or Direct
Observation Method:
Interview Method: - Interviews are conducted in the whole of the departments within
the organization to gather facts or information about the organization. This
type of method is based on face to face interview with staff of the company
that works in the Accounts Department especially.
Questionnaire Method: - This process has been found to be reliable to work on your
research.
Sample Questionnaire:
1.
What existing business
problems could computerization solves or minimize?
2. What type of information does the
organization need from the computerized payroll system in order to answer
business or management questions and make management decisions?
3. Is funding available for computerization?
4. What is the current information technology
capacity of the organization and can it support computerization?
5. How will computerization contribute to
achieving organizational goal?
6. What are the causes of waste of time in the
current payroll system?
7. Is the likely impact worth the cost of
implementing the new system?
Personal Observation Method: - Time was taken in going from
department to the other observing what went on in each department.
Examples
of the Observations are as follow:
I.
How total hours worked is
calculated.
II.
How dedicated are made.
III.
How the paycheck finally
arrive.
1.6 DEFINITIONS OF TERMS
We need to understand some terms as related to our topic so as to
aid better understanding of the use
within the write up. We define them as follow:-
1. Management: - Management is the core
of all operations in any organization. It is very central to all organizational
activities. Management therefore, is the process by which superiors and
subordinates create, direct, maintain and operate purposeful modern
organization through systematic, coordinated and cooperative effort, so as to
accomplish the desired objectives.
It is a
social process that consists of planning, controlling, coordinating,
motivating, directing, staffing, etc.
2. Organization: - Organizations are formal, social unit of system of behaviors
designed to enable humans and their machines to accomplish specific goals.
3. Manager: - This is a person who is in charge of running a business or a
similar organization, According to Henry Mint big, the role includes the
behavior that is expected of a person in fulfilling a job. In managerial job,
there are several roles that are required from a manager. They include:
§ The leader role
§ The person role
§ The spokesmen role
§ Disturbance handler role
§ The resource allocator role etc
4. Monthly Salary: - This is the actual amount that the employee is entitled to
earn in the month. This is known as the Basic Salary.
5. Tax: - This is the compulsory amount that goes to the state treasury from
the employee’s salary, and it is used by the government to provide social
services such as water, light and hospital for its people or citizens.
6. Gross Pay: - This is the total amount due to the employee before any
deductions.
7. Net Pay: - This is the amount due to the employee after all deductions have
been removed.
8. Project Design: - The phase where you create a blueprint about the software
(i.e. how it will look like and the phases of design), you decide what software
to use to design your project and what software is suitable to use for the
object.
9. Feasibility Study: - This is the phase for establish whether or not the proposed
system is desired for the organization before resources are committed in full
scale on the project.
10. Conversion and
Project Operation: - After the design phase,
you cannot test before you convert; you
run it for the organization to know its usefulness if it is possible or
suitable; you then convert from the old system to the new system and also check
the operations of the software if there are any recommendations for the
organization for adjustments.
Buyers has the right to create
dispute within seven (7) days of purchase for 100% refund request when
you experience issue with the file received.
Dispute can only be created when
you receive a corrupt file, a wrong file or irregularities in the table of
contents and content of the file you received.
ProjectShelve.com shall either
provide the appropriate file within 48hrs or
send refund excluding your bank transaction charges. Term and
Conditions are applied.
Buyers are expected to confirm
that the material you are paying for is available on our website
ProjectShelve.com and you have selected the right material, you have also gone
through the preliminary pages and it interests you before payment. DO NOT MAKE
BANK PAYMENT IF YOUR TOPIC IS NOT ON THE WEBSITE.
In case of payment for a
material not available on ProjectShelve.com, the management of
ProjectShelve.com has the right to keep your money until you send a topic that
is available on our website within 48 hours.
You cannot change topic after
receiving material of the topic you ordered and paid for.
Login To Comment