payroll sytem

28
Goodafternoon !

Upload: david-saul-yango

Post on 16-Aug-2015

105 views

Category:

Education


1 download

TRANSCRIPT

Goodafternoon!

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

• To the Administration

• To the Accounting Department

• To the proponents

SIGNIFICANCE OF 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

Login Form and Daily Time Record

Daily Time Record of Staff

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