WIXLIB

DESIGN AND IMPLEMENTATION OFPAYROLL INFORMATION SYSTEM INPT. KARYA TAMA RIMBA CEMERLANG12,3Agustinus Noertjahyana , Felix Montana Arlinah Imam RahardjoInformatics Department, Faculty of Industrial Technology, Petra Christian University, Surabaya123agust@petra.ac.id , 26405043@petra.ac.id ,arlinah@petra.ac.idAbstractPT. Karya Tama Rimba Cemerlang has a traditional accounting system, thus the payroll also done manually by HRD.The payroll system is calculated based on the attendance list which is obtained from the manual machine. Everyday theworkers have to register their attendance and leave so that it can be traced by the company in order to determine themonthly salary. Then the data will be processed by using Microsoft Excel. However, this system has severaldisadvantages such as the high processing time and the possibilty of incorrect input. Thus, in this research, acomputerized system is very crucial for the development of the company.In creating the new payroll system, first we do an observation in the company internal system. From the internal data,then the company willl be able to design the new payroll system that can be customized based on the needs of thecompany through a more structurized DFD, ERD, and tabels. However, the new system is the integration of payroll andadministration modul. Parts of the payroll system are basic salary, munch money, bonuses, taxation, Jamsostek, THRand cash bon. The administration process comprises the workers’personal datas, absenteeism, permission and leave,violation of rules and firing.Based on the payroll application, the satisfaction level of PT. Karya Tama Rimba Cemerlang as the user is 76%, thusas a conclusion, the application process of the new payroll system has fulfill the target and has the suitable system. Infact, this system able to support the company with a faster payroll report yet accurate.Keywords: Basic Salary, Payroll system, Taxation.1INTRODUCTIONOne function of HRD (Human ResourceDepartment) on a company is calculating salary foreach employee to the company. There are various wayscalculation process employee payroll, depending on thepolicies implemented by the company.PT. Tama Rimba Karya Cemerlang is acompany which is engaged in wood drying. Everydivision in the company has a payroll system that is notthe same with each other. This is because of differencesin company tenure, job type and the needs of thecompany (to save on expenses).The process of calculating employeessalaries are still done manually by Human ResourcesManager. The Process is calculated by counting thenumber of the days of each company's employeepresence for a certain period. The data has beenobtained is then processed and entered manually intoMicrosoft Excel program one by one. Then the inputdata is processed in a table that had contained thevariables in the form of salary deductions, allowances,basic salary, and others. The result is total salary ofemployees in a certain period.Manual accounting system is certainly hassome shortcomings that led to HRD experiencingdifficulties, such as requiring a long time in getting dataon the company's employees. Currently the number ofemployees at the company is approximately 55. For thetime being to process the data takes about two hours. Inaddition, the possible risk of error (human error) thatsuch a high frequency of errors in input data by HRPDF Creator - PDF4Free v3.0employees. HRD is often difficult to classify the data ofemployees of different divisions.Therefore, with the advances in informationtechnology that existed at the moment, is expected to becreated an information processing system using acomputer system to help overcome the weaknesses ofthe manual system faced by PT. Karya Tama RimbaCemerlang.This can be realized by designing anapplication that can perform calculation of employeesalaries of PT. Tama Rimba Karya Cemerlangautomatically so that counting can be produced morequickly and accurately.2PAYROLL SYSTEMPayroll system is a set of business activitiesand implementation of data processing relatedcontinuously. Payroll information system is able toperform automatic payroll calculation process in whichsalary components such as basic salary, allowances,commissions, bonuses, overtime, leave, calculation ofincome tax, jamsostek and others are included tofacilitate the calculation of wages [6].2.1 PAYROLL SYSTEM ACTIVITIESThere are several important activities in thehuman resources department, began recruiting andhiring, training, assignments, compensation (payroll),employee performance and termination of therelationship between companies and employees. Forcompensation subsystem, there are seven events,namely: [7]http://www.pdf4free.com

1.2.3.4.5.6.7.Update master payroll fileUpdate tax rate and deductionsValidate time and attendance dataPrepare payrollDisburse payrollCalculate employer-paid benefits and taxesDisburse payroll taxes and other deductions2.2 Pph 21PPh 21 is the income tax imposed on incomein the form of salary, honorarium, wages, allowances,pensions, and compensation activities with respect toemployment, services or activities performed by anindividual taxpayer in the country. Pph 21 is reportedand paid correctly by the taxpayer on income receivedor accrued in connection with the employment of oneemployer (Peraturan Direktur Jenderal Pajak, 2010).2.3 JAMSOSTEKJamsostek is a public program that providesprotection for workers to overcome the risk of certainsocioeconomic and operate using the mechanism ofsocial insurance. As public programs, Social Securityprovides the rights and obligations for certain overload(compulsory) for employers and workers under the ActNo.3 of 1992 which set the type of Program JaminanKecelakaan Kerja (JKK), Jaminan Hari Tua (JHT),Jaminan Kematian (JKM ) and Jaminan PemeliharaanKesehatan (JPK), while the obligations of theparticipants is the orderly administration and pay dues(PT JAMSOSTEK, 2010, par. 1-2)2.4 TUNJANGAN HARI RAYA (THR)In addition to benefits of existing payrolltaxes, businesses will be charged in return othersubstantial remuneration. THR is one type of benefitthat is often used by some companies in Indonesia.According to Permen 04/1994, which meant THR is theincome of workers must be paid by employers toworkers or their families before the religious holiday inthe form of money or other forms. THR is probably dueto additional income, people call it "Gaji ke-13".According to Permen 04/1994, any personwho employs another person referred to employers andpayers to pay THR. Legislation does not questionwhether an employer is an individual, a limited liabilitycompany, foundation, or association. In essence, everyperson who employs another person obliged to paywages in return for THR. Employers must pay workerswho had worked successively for 3 months or more.This regulation does not distinguish the status ofworkers, whether permanent employees, contractemployees, or part-time employees. Originally a workerhas worked for 3 consecutive months, he is entitled toTHR.employers and workers so that the goal, ideally, theharmonious relationship between employers andworkers can be achieved [5].3ANALYSIS AND DESIGN SYSTEMIn any information system applicationdevelopment is always going through the stages ofanalysis and design. [1].3.1 Problem AnalysisThe process of manually calculating salarycauses some problems in the company of PT. TamaRimba Karya Cemerlang. Problems faced by companiestoday are: A large number of company employees whoconstantly growing raises wage calculation processbecomes longer and not effective. The possibility of human error in the calculation ofsalaries To search for data takes a long time because data isnot stored properly.3.2 Requirement AnalysisBased on the existing problems, companiesneed a computerized system, especially in calculatingthe employee's salary that can support the developmentof the company, such as: Computerized system for employee absences thatcan be integrated with existing systems (fingerprintattendance machine) with an employee salarycalculation software. Computerized system to process employee payrollcalculation, so that the counting process can beconducted faster, precise, and accurate. Computerized system for data storage in order tominimize the risk of data loss. Computerized system that can perform a searchemployee data quickly and easily.3.3 DATA FLOW DIAGRAMThe design stage begins with the design DataFlow Diagrams (DFD). Data flow diagram of thesystem to be developed can be seen in Figure 1.2.5 SERIKAT PEKERJA SELURUH INDONESIA(SPSI)One of tools to realize the industrial relationswas the establishment of trade unions. Theestablishment of the union is expected to absorb theaspirations of workers and bridge the interests ofPDF Creator - PDF4Free v3.0http://www.pdf4free.com

position the employee's basic salary in advance. Formbase salary and position contained in the master menu.Display the program can be viewed as in Figure 3.Figure 3. Form Master4.3 Form Insert DataForm Insert data is used to input data andtheir employee base salary and information about theposition. Form insert data can be seen in figure 4.Figure 1. Data Flow Diagram3.4 ENTITY RELATIONSHIP DIAGRAMEntity relationship diagrams are used todescribe the relationship of each table exists on thesystem. ERD consists of two pieces: the conceptual andphysical.4RESULTS AND DISCUSSIONSThe results of the analysis and design thathas been done before is as follows:4.1 Form LoginForm login is used to differentiate accessrights of each user. Form Login can be seen in Figure 2.Figure 4. Form Insert Data4.4 Form Setting UMRForm setting UMR is used to incorporate thelarge amount of current minimum wage. The benefits ofthis form is to note any changes that occur UMR. Formsetting UMR can be seen in figure 5.Figure 2. Form Login4.2 Form MasterAll menus and facilities that exist in the mainmenu page can be accessed by company directors.Before the input data of employees, directors areencouraged to check and input data as well as thePDF Creator - PDF4Free v3.0Figure 5. Form Setting UMRhttp://www.pdf4free.com

4.5 Form Master EmployeeForm Master Employee is used to enterinformation related to employee data that existed at thecompany. Form master employee can be seen in figure6.4.8 Form JamsostekForm Jamsostek is used to determine theamount of the percentage of jamsostek paid by theemployee and the company. Form Jamsostek can beseen in figure 9.Figure 6. Form Master EmployeeFigure 9. Form Jamsostek4.6 Form Setting TaxForm Setting tax used to enter data relatingto taxation. Form Setting tax can be seen in figure 7.4.9 Form BonusesForm bonuses are used to determine theamount of bonus for each employee. Form bonuses canbe seen in figure 10.Figure 7. Form Setting tax4.7 Form setting THRForm setting THR, is used to determine theamount of THR for the current period. This helpscompanies to keep records of payments THRemployees automatically. Form setting THR can beseen in figure 8.Figure 8. Form Setting THRPDF Creator - PDF4Free v3.0Figure 10. Form Bonuses4.10 Form Setting Hari liburForm Setting Hari Libur is used to defineholidays that apply to the company. The Benefit of theform is that it can help the calculation of employeeabsences automatically. Form Setting hari libur can beseen in figure 11.Figure 11. Form Setting hari liburhttp://www.pdf4free.com