Computerized Payroll System of Capiz Electric Cooperative

Nowadays all establishment are becoming modernized, they use modern technologies to make their transaction fast, easy, and accurate in order to avoid waste of time and for the sake of safety and security. It also helps human to solve and understand complex problem and analysis such us the computational need of humans. Especially to business establishment or corporation processing enormous data and complex transaction. Payroll is an example of a complex transaction because it is a critical business operation dealing with numerous accounts and produce plenty and confidential files. Payroll is encompasses every employee of a company who receives a regular wages or other compensation due to each. Applying manual procedure on a Payroll transaction involving the vast beat answer in that problem would be computer because computers can simulate enormous data and can process complex transaction in a fast and efficient way. It can generate numerous accounts and data accurately.

A Computerized Payroll System will not only provide accurate calculation and fast process of Payroll transaction but it will secure data through security implementation and accordingly arrange files provided by a well designed database that will produce a paperless environment. Capiz Electric Cooperative is Government regulated by ERC. Capiz Electric Cooperative is headed and managed by a General Manager from National Electrification Administration (NEA). Capiz Electric Cooperative if formed by the National Electrification Administration last June 07,1971 and registered with NEA last June 16, 1971.Several projects were proposed and granted by NEA and the cooperative rapidly expanded.

February 16, 1978, National Electrification Commission (NEC) certificate of franchise NO. 004 issued to Capiz Electric Cooperative the license to operate electric light and power for 50 years in area comprising Roxas City and the sixteen town of Capiz namely Panay, Panitan. Pontevedra, Maayon, President Roxas and Pilar, Ivisan, Sapian, Jamindan, Mambusao, Sigma, Dao, Cuartero, Dumarao, Dumalag Tapaz and the City of Roxas. Capiz Electric Cooperative has six Area Offices: Roxas City, President Roxas, Mambusao, Dao, Dumalag and the main office is in Timpas, Panitan. Presently, Capiz Electric Cooperative (CAPELCO) is practicing the manual process on their Payroll System. It has separate manual process for the Regular Employees and J.O (Job-Order) employees. The total number of employees in Capiz Electric Cooperative is 339 – 299 regular employees and 40 job-order employees.

Statement of the Problems
1. Time consuming process of payroll preparation
The Capiz Electric Cooperative still using the manual method of payroll process. A lot of jobs are assigned to the payroll maker and accounting clerk, with cause’s inconvenience to their services. In this method, it will need more time and manpower to complete the payroll of each employee. 2. Laborious payroll process

Nobody could admit the inescapable fact that what makes the manual procedure take a long time to finish the task is due to the many steps and processes to undergo. There is the collection of data such as DTR, REMITTANCES, and individual manual calculation of payroll. Individual data is transferred through sheets, encoding and double checking after calculating. All this process requires labor and effort to complete the task. 3. Misposting and understating of employee’s data

The logical process of manual procedure result to too much time consumption. It often times result in misposting and understating of each employees data of plenty of files that is hard to accommodate. Objectives of the Study

This study is intended to design and develop a Computerized Payroll System for Capiz Electric Cooperative for calendar year 2010. Specifically, this study aims: 1• To minimize the effort of the bookkeeper in processing the Payroll Slip and Payroll Form. 2• To make an efficient and accurate computation of Payroll. 3. To create a well-arranged database and to implement strong security of the system for data security.

Significance of the Study
To Accounting Department and Payroll Maker of Capiz Electric Cooperative The proposed system will help the accounting section of Capiz Electric Cooperative especially the Payroll maker/bookkeeper and the Finance Officer. It will help to lessen the time and effort of the payroll maker/bookkeeper preparing payments of employees. The System develop can accommodate changing figures and produce a paperless environment through well design database.

To Proponents

This study will help the proponents to enhance the ability on how to create an understandable computerized system in an easy way. This will serve to the proponents as a challenge to do a better system. To the other Researcher

This study gives knowledge to the researcher on how to create a Computerized System in understandable way. This will serve as a fresh ground for the researcher whose study will be related in the field of Information Technology.

Scope and Limitation

Scope
This study is designed to develop a Computerized Payroll System for Capiz Electric Cooperative. It covers the process of preparing the Pay slip of each employee, the regular and job order employee, keeping of records safety and computing the exact wages of each employee. Including the stored report list of employee such as Monthly Salary, Basic salary, overtime, Gross payment, Net pay, and Deduction such as withholding tax, SSS, and Medicare, SSS loan, Advances, Multi-purpose loan, PAG-IBIG Contribution, CAPELCO loan, Cash Advance, Bond, Energy Sales, Motorcycle, Canteen, under time, Cigna, WELCA, union loan, Lot/housing loan, health Care and AR. The proposed Payroll System for Capiz Electric Cooperative is expected to generate Pay Slip of Employees, Report list of employees, Remittances for respective agencies, Payroll register of regular and job-order employees, and Payroll form for every pay period. Limitation

The proposed Computerized Payroll System for Capiz Electric Cooperative does not support network topology implementation and online program or online transaction.