UBS Payroll 9.5

UBS PAYROLL 9.5 Advance  Cash advanced to employees in the month of February, 2010 were: Employee No. 001 002 003 004 Advance -- RM 1,500.00 RM 1,000.00 RM1, 200.00 Go to Payments  2nd Half Payroll  Advance  Add/Modify  Advance To Individual, key in amount as required. 48

UBS PAYROLL 9.5 4.7 Commission  Process the Commission paid to employees for this month Employee No. 001 002 003 004 Commission RM 1,000.00 - RM800.00 RM1,800 Go to Payments  Commission  Add/Modify  Add/Modify Commission-Amount, key in the amount as required: 49

UBS PAYROLL 9.5 2nd Half Payrolls  Process 2nd Half Payroll according to the following information: Employee No. 001 002 003 004 Working Days 24 days 24 days 24 days 11 days DW 19 days 21 days 23 days 9 days PH 1 day 1 day 1 day 1 day AL 4 days 2 days MC - - No Pay NPL - - - 1 day - - - - OT – ND - 11 hours 14 hours OT – RD - 2.5 hours 5.5 hours 8 hours OT – PH - 5 hours 3 hours - WORK – RD - 2.5 days - WORK – PH - 1 day - INCENTIVE - 1 day 1 day SHIFT 1 5 days RM 380.00 RM 340.00 1 day SHIFT 2 5 days 7 days RM 410.00 SHIFT 3 9 days 7 days 4 days Amount 6403.40 7 days 6 days 4 days 2237.46 13 days 5 days 6880.93 - 885.94 Go to Payments  2nd Half Payroll  Add/Modify  Add/Update  Normal Pay (Basic Pay & Overtime + Allowance + Other) for each personnel. Process Pay And View Pay Slips  To process 2nd Half Payroll, go to Payments  2nd Half Payroll  Process Pay, click on OK, then OK again.  To view pay slip, go to Payments  2nd Half Payroll  View Pay Slip Backup  Backup your data into diskette and also into hard disk drive. 4.8 How To Print Pay Slip Payments  2.nd Half Payroll  5.Print Pay Slip  Pay Slip 50

UBS PAYROLL 9.5 LESSON 5: TRIAL TEST UCCI Practical Test – UBS Computerized Payroll PART A (Company Details) A-1 Data Directory : Create a new data directory named TESTPAY A-2 Company Name : <exam ID + full name> A-3 Registered Address : K-212, Block K, Jalan K2/5, KK Business Centre, 88033 K.K. Tel:088-245213 A-4 This Month / Year : January 2010 A-5 Number of Payment : Once a month, unless specified otherwise. Per Month A-6 Maximum Pay Allowed : RM 3,000.00 A-7 Deduction Method for : Basic Rate / 26 NPL A-8 1st Half Payroll : EPF, SOCSO, PCB to be deducted directly in this pay. A-9 Using Basic Rate Instead : When calculate OT and Bonus PCB. of Basic Pay A-10 Bonus / Commission : Contribute to EPF & PCB and to be deducted directly. Bonus is to paid annually and commission monthly (if any). A-11 Working Hour : 8 hours / day ; 2288 hours / year A-12 EPF Contribution : 11% by employee ; 12% by employer. A-13 Allowance : All allowance is subject to tax only. -- Car Maintenance (Fixed Allowance) -- Traveling (Variable Allowance) -- Lunch (Daily Allowance) -- Shift Allowance Shift 1 (0700-1500)  RM 3.00 per day Shift 2 (1500-2300)  RM 4.00 per day Shift 3 (2300-0700)  RM 5.00 per day 51

UBS PAYROLL 9.5 A-14 Deduction : Hostel & Meal Not subject to EPF, SOCSO & PCB. A-15 O.T. : Subject to SOCSO and PCB. A-16 This Month Calendar OT Type Rate OT on normal working day 1.5 x HRP OT on Rest Day 2.0 x HRP OT on Public Holiday 3.0 x HRP Work on Rest Day 1.0 x ORP Work on Public Holiday 2.0 x ORP : A-17 The Company’s Rest Public Holiday Day Fall on Every : Sunday : Use those table printed on UBS Payroll Self Study Guide. A-18 EPF / SOCSO / PCB Table UCCI Practical Test – UBS Computerized Payroll PART B (Transactions) B-1 Enter the following Employees’ Details Name Alan Wong Li Chan Fui Operation Exec Acc Supervisor Job Title Ast Sales Manager RM 2100.00 / month RM 1800.00 / month * Shift Allowance Basic Salary RM 4000.00 / month * Lunch Allowance RM * Lunch Allowance RM 3.00 for each day 2.50 for each day Other * Car Maintenance RM worked. worked. Benefit 200.00 per month. Hostel & Meal RM Hostel & Meal RM150.00 * Lunch Allowance RM 5.00 150.00 1st July, 2004 for each day worked. 11 January, 2008 Male Deduction -- Female Malaysian Malaysian UBS Certificate Date 1st October, 2000 Diploma (Mec.Eng) Married; Wife is Commence working. Sex Male Single Nationality Malaysian Education Degree (B.Admin) Marital Married with 3 kids; Wife is Status working. 52

UBS PAYROLL 9.5 B-2 Monthly personnel records (January, 2010) Name Alan Wong Li Chan Fui Jan 27, 28 Jan 27, 28 Annual Leave Taken Jan 2, 18 Non-Pay Leave Taken Medical Leave Taken Jan 28 Name Alan Wong Li Chan Fui Traveling Allowance RM 333.00 OT on Normal Working Day 20 hours 5 hours OT on Rest Day 2 hours 6 hours 2 hours OT on Public Holiday 1 day 1 day Work on Rest Day 2 days Work on Public Holiday RM 7000.00 RM 3500.00 Days Worked on Shift Shift 1 = 6 days Shift 2 = 6 days Bonus Shift 3 = 11 days RM 500.00 B-3 Process the pay of all 3 employees in the month of January 2010. B-4 Backup After you have completed all necessary steps, perform backup into two diskettes (one after one). This means, each diskette must contains a file named backup-pay (Before pass up the diskettes, make sure the label and the backup file is readable.) UCCI Practical Test – UBS Computerized Payroll PART C (Fill In The Blanks & Calculation) C-1 View and Write Fill in the blanks by referring to your works. All answer can be obtained from various reports in your data directory of UBS Computerized Payroll system. Description (January’s Pay Alan Wong Li Chan Fui Slip only, not including Bonus) Lunch Allowance Total Allowance Total OT PCB EPF Contributed by employee EPF Contributed by employer / company 53

UBS PAYROLL 9.5 C-2 Calculation 1 Show your calculation of the following for employee Wong Li: (a) Basic Pay (b) Total OT _________________________________________________________________ _________________________________________________________________ _________________________________________________________________ _________________________________________________________________ C-3 Calculation 2 Show your calculation of Bonus Pay for employee Alan. 54