Course Description:
This module trains students in managing hotel payroll operations using a digital Payroll Management System. Students will learn employee setup, time and attendance tracking, payroll computation, government remittances, and payroll reporting in a Philippine hotel context.
Week 1: Employee Setup & Payroll Configuration
Objective: Set up employee profiles and configure payroll parameters.
Workflow Focus: System Setup & Employee Masterlist
Hands-on Exercise 1:
Create employee profiles for 5 hotel staff members across different departments (Front Desk, Housekeeping, F&B, Security, Maintenance).
Input key details: Employee ID, Department, Designation, Date Hired, Employment Status (Regular/Probationary), Basic Monthly Salary.
Configure payroll settings: Pay Frequency (Semi-monthly), Working Days per month, and Official Work Hours.
Set up mandatory government deduction rates: SSS, PhilHealth, Pag-IBIG.
Week 2: Time & Attendance Tracking
Objective: Record and manage employee attendance, leaves, and overtime.
Workflow Focus: Attendance & Time Management
Hands-on Exercise 2:
Log the daily time records (DTR) for all 5 employees for a simulated 2-week payroll period.
Record 2 cases of absences (without pay) and 1 case of a half-day.
Record 8 hours of overtime (OT) for the Security employee who worked beyond regular hours.
Approve a Sick Leave request and a Vacation Leave request. Verify leave balances updated correctly.
Week 3: Basic Pay Computation
Objective: Compute gross pay based on attendance records.
Workflow Focus: Gross Pay Computation
Hands-on Exercise 3:
Compute the semi-monthly basic pay for all 5 employees based on their DTR (from Week 2).
Compute deductions for absences: (Monthly Rate ÷ 22 working days) × number of absent days.
Compute Overtime Pay: (Hourly Rate × 1.25) × OT Hours (for regular day OT).
Compute Night Differential pay (10% additional) for the Security staff's night shift hours.
Week 4: Government Deductions & Contributions
Objective: Apply mandatory government deductions correctly per Philippine labor law.
Workflow Focus: SSS, PhilHealth & Pag-IBIG
Hands-on Exercise 4:
Compute SSS contributions for all 5 employees using the current SSS contribution table.
Compute PhilHealth contributions (Employee Share: 2.5% of basic salary).
Compute Pag-IBIG contributions (Employee Share: 2%, max ₱100/month).
Compute Withholding Tax for applicable employees using the BIR tax table.
Week 5: Allowances, Benefits & Other Earnings
Objective: Add non-taxable and taxable allowances, benefits, and other earnings to payroll.
Workflow Focus: Allowances & Benefits Setup
Hands-on Exercise 5:
Add a daily Meal Allowance of ₱50 (non-taxable) for all employees.
Add a Transportation Allowance of ₱1,500/month for the F&B and Front Desk staff.
Process a special Incentive bonus for the top-performing employee of the month.
Verify that non-taxable allowances are correctly excluded from the taxable income computation.
Week 6: Loan Deductions & Employee Advances
Objective: Manage salary loans and cash advance deductions in the payroll system.
Workflow Focus: Loans & Cash Advances
Hands-on Exercise 6:
Record an SSS Salary Loan for the Housekeeping employee (₱15,000, paid in 24 installments). Compute the monthly deduction.
Record a Company Cash Advance of ₱3,000 for the Maintenance employee. Deduct from current payroll.
Record a Pag-IBIG MP2 voluntary contribution for 1 employee.
Verify all loan deductions are correctly reflected in the payslip computation.
Week 7: Payroll Processing & Payslip Generation
Objective: Run the full payroll cycle and generate official payslips.
Workflow Focus: Payroll Run & Payslip
Hands-on Exercise 7:
Run the full payroll computation for the 2nd semi-monthly period for all 5 employees.
Review and approve the Payroll Register. Verify gross pay, deductions, and net pay for each employee.
Generate and print individual payslips for all 5 employees.
Generate the Payroll Summary Report showing total payroll cost for the period.