payroll sytem
TRANSCRIPT
A Thesis ProposalPresented to the Faculty of Information
TechnologySt. John Technological College of the Philippines
In Partial Fulfillment of the Requirements for the
Degree of Bachelor of Science in Computer Science
COMPUTERIZED PAYROLL SYSTEM FORST. JOHN TECHNOLOGICAL COLLEGE OF THE
PHILIPPINES
• In less than a generation, computer technology has recolonized business all over the world. This has brought about the changes in the area of business.
• Today computers do much of the works.
• Payroll processing requires careful handling to ensure accurate paychecks and payroll tax compliance.
INTRODUCTION
• Manual payroll calculation means that the payroll is process by hands. Such software has rates embedded in the programming , which eliminates manual calculation of payroll taxes.
• Typically, all that is required to perform manual payroll processing is calculator, blank checks, a typewriter and stationary.
• The employee who handles payroll must have stay abreast of the Philippines Department of Labor and employment laws and the bureau of Internal Revenue payroll tax laws.
• The payroll representative also manually process new hires and termination and calculates payroll taxes.
• SJTCP and some small business conduct they payroll using a manual system. While inexpensive, this method may increase the chances of errors and prove time-consuming for the company with more than a few employees.
• Payroll systems helps payroll representative to manage salary employee , add employee deleting employee, calculating salary and printout of pay slip.
• An economic theory that stipulates that the value of a good or service is dependent upon the labor used in its production. The theory was first proposed by Adam Smith (1723-1790), the founder of modern economics, and was an important concept in the philosophical ideals of Karl Marx. The labor theory of value suggests that goods which take the same amount of time to produce should cost the same.
THEORETICAL FRAMEWORK
CONCEPTUAL FRAMEWORK
Inputting of Employee
Name Time in, Time out
On a Journal
Calculate via Computer in Excel
Pay checkrelease viaaccountant
Figure 1.1: Recording using Journal
-Enter ID number
password and click login
button-Enter ID number
password and click logout
button
-Automatically add The Employee login
and logout information to
database
-The Employee can view their time
record
Figure 1.2 Employee system
-Enter ID number
password and click
login button
-Search Employee-Edit Employee
Time record-View Daily Attendance
-Store and update
database
Figure 1.3 Administration Account
-Enter username
& password
-View Employee time record
-Calculate hour ofwork of allEmployees
-Create, Read, Update & Delete
Employee
-Print pay check for
each Employee
Figure 1.4 Computerized Payroll System
1. What is Computerized payroll system?
2. What can computerized payroll system do to enhance the traditional payroll of SJTCP?
3. What are the benefits of the computerized payroll system?
STATEMENT OF THE PROBLEM
• Monthly calculation• Print monthly wages of employee• Add, delete and edit employee
record• Provides username and password
for employee and administrator or (Head of employee)
• It has ability to edit time record of employee
SCOPE OF THE STUDY
• Does not include yearly record
• Does not include holyday’s additional payment
• Does not include the professor’s salary computation
DELIMITATION OF THE STUDY
• The accounting representative must have knowledge on computing payroll.
• Must have knowledge in computing wages base on DOLE.
• The accounting representative must know basic Microsoft Office Excel.
ASSUMPTION OF THE STUDY
• The research provides a survey questionnaire regarding problem and limitation of manual payroll system then compared payroll system. This research conducts a survey to the accounting staff and to the office staff. The respondents required to answer four questions that may help the researcher to study Computerized Payroll System.
METHODS OF RESEARCH
The data for this research was gathered in the survey questionnaire. The likert scale was use to determine if the respondent is agree to the question. The survey question was given to the office staff and accounting staff after the instructor (thesis adviser) validated the questionnaire.
COLLECTION OF DATA AND GATHERING PROCEDURE
System DevelopmentSystem development and project design shows how the computerized payroll system develops by using waterfall model. The proponent gathers all the information about the SJTCP payroll system, analyze and plan for solution on how payroll works and how dailytime record works. The proponents design and code the program trying every possible way to translate the solution into code finally debugging and maintaining the program.
PROJECT DESIGN
• In a company, 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. The primary mission of the payroll department is to ensure that all employees are paid accurately and timely with the correct withholdings and deductions, and to ensure the withholdings and deductions are remitted in a timely manner.
Computerized Payroll System
• A computerized payroll system performs the same functions that manual methods of payroll do. It stores employee data, such as names, password, picture, position, addresses and pay rates of each person. It calculates payroll taxes and deductions and keeps all data up-to-date after each pay period.
ENHANCEMENT OF PAYROLL SYSTEM
• One of the best features of a computerized payroll system is that it is capable of accurate timekeeping by integrating with the timekeeping system. With a time clock, an employee’s in and out times can be transferred to the payroll software automatically.
THE BENEFITS OF COMPUTERIZED PAYROLL SYSTEM
• A computerized payroll system performs the same functions that manual methods of payroll do. The proponents upgraded the traditional payroll of SJTCP. Computing payroll of SJTCP uses Microsoft excel where the accounting person used formula to compute payroll which take a lot of time to think and assure that it is correct to use. By the enhancement of computerized payroll system, accounting person has the access to use the system and do thin see payroll computation.
SUMMARY OF THE FINDINGS
• The system has an essential role to the accounting, because it has a capability to automatically compute the Total Hours of work of every employee, deductions, gross pay and net pay of the employee.The system can generate daily report of employee’s attendance. The system can also print the outcome of the generated report, payroll report and pay slip report. And the employee has a capability to print and view their attendance record and pay slip record.
CONCLUSION