Skip to main content

Payroll & Workforce (MoM)

The Payroll & Workforce (MoM) dashboard provides executive visibility into monthly payroll performance, workforce cost dynamics, headcount change, and earnings volatility. It helps finance and HR leaders monitor salary expense, net pay, cost per employee, overtime exposure, and month-over-month payroll fluctuations for cost governance and workforce planning.

Benefits of this dashboard​

  • Govern payroll‑cost efficiency: Continuously monitors salary and net‑pay trends to maintain strict control over workforce‑related expenditures.
  • Analyze workforce‑cost efficiency: Evaluates average cost per employee to align compensation strategy with productivity and budget constraints.
  • Manage overtime risk: Provides visibility into overtime dependency to mitigate labor‑cost overruns and workforce‑fatigue risks.
  • Plan headcount and capacity: Supports workforce‑sizing decisions through real‑time visibility into active employee volumes.
  • Monitor month‑over‑month volatility: Identifies abnormal payroll fluctuations and large earning variances for rapid financial investigation and control.

Key performance indicators (KPIs)​

KPIDescription
Salary CostTotal gross salary expense for the selected month and year. Higher values indicate increased payroll burden, while lower values indicate reduced salary expense or workforce contraction.
Net PayTotal net pay after statutory and voluntary deductions. Higher values indicate higher compensation cash outflows, while lower values indicate reduced payouts.
Avg. Cost per EmployeeAverage payroll cost per active employee. Higher values indicate higher remuneration intensity or a more senior workforce mix, while lower values indicate a leaner cost structure.
Overtime %Overtime cost as a proportion of total payroll. Higher values indicate greater reliance on overtime and potential capacity strain, while lower values indicate more stable staffing levels.
Headcount (Active)Number of active employees included in payroll for the selected period. Higher values indicate expansion, while lower values indicate downsizing or attrition.
Company Contributions %Employer contribution percentage for statutory or benefit-related payroll components. Higher values indicate higher employer burden, while lower values indicate reduced contribution exposure.

Filters​

You can filter the dashboard using the user-defined hierarchy dimensions in Sage 300 People:

  • Year
  • Month
  • Large Change Threshold
  • Company
  • Branch (Hierarchy code 1)
  • Department (Hierarchy code 2)
  • Province (Hierarchy code 3)
  • Cost Centre (Hierarchy code 4)
  • Project (Hierarchy code 5)
  • Farm Department (Hierarchy code 6)
  • Division (Hierarchy code 7)
  • Contractors (Hierarchy code 8)
  • Status (Hierarchy code 9)
  • TWK Costing (Hierarchy code 10)