8-Week Payroll Management System Module

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:

  1. Create employee profiles for 5 hotel staff members across different departments (Front Desk, Housekeeping, F&B, Security, Maintenance).
  2. Input key details: Employee ID, Department, Designation, Date Hired, Employment Status (Regular/Probationary), Basic Monthly Salary.
  3. Configure payroll settings: Pay Frequency (Semi-monthly), Working Days per month, and Official Work Hours.
  4. 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:

  1. Log the daily time records (DTR) for all 5 employees for a simulated 2-week payroll period.
  2. Record 2 cases of absences (without pay) and 1 case of a half-day.
  3. Record 8 hours of overtime (OT) for the Security employee who worked beyond regular hours.
  4. 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:

  1. Compute the semi-monthly basic pay for all 5 employees based on their DTR (from Week 2).
  2. Compute deductions for absences: (Monthly Rate ÷ 22 working days) × number of absent days.
  3. Compute Overtime Pay: (Hourly Rate × 1.25) × OT Hours (for regular day OT).
  4. 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:

  1. Compute SSS contributions for all 5 employees using the current SSS contribution table.
  2. Compute PhilHealth contributions (Employee Share: 2.5% of basic salary).
  3. Compute Pag-IBIG contributions (Employee Share: 2%, max ₱100/month).
  4. 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:

  1. Add a daily Meal Allowance of ₱50 (non-taxable) for all employees.
  2. Add a Transportation Allowance of ₱1,500/month for the F&B and Front Desk staff.
  3. Process a special Incentive bonus for the top-performing employee of the month.
  4. 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:

  1. Record an SSS Salary Loan for the Housekeeping employee (₱15,000, paid in 24 installments). Compute the monthly deduction.
  2. Record a Company Cash Advance of ₱3,000 for the Maintenance employee. Deduct from current payroll.
  3. Record a Pag-IBIG MP2 voluntary contribution for 1 employee.
  4. 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:

  1. Run the full payroll computation for the 2nd semi-monthly period for all 5 employees.
  2. Review and approve the Payroll Register. Verify gross pay, deductions, and net pay for each employee.
  3. Generate and print individual payslips for all 5 employees.
  4. Generate the Payroll Summary Report showing total payroll cost for the period.

Week 8: Comprehensive Simulation (Final Practical Exam)

Objective: Execute a complete month-end payroll cycle from attendance to disbursement.

Workflow Focus: End-to-End Payroll Operations

Hands-on Exercise 8 (Simulation Scenario):