Payroll & Workforce (MoM)

Sage 300 People, Dashboard

The Payroll & Workforce (MoM) dashboard for Sage 300 People calculates monthly payroll performance, workforce cost, headcount change, and earnings volatility. It includes salary expense, net pay, cost per employee, overtime, and month over month (MoM) payroll fluctuations.

How to use the payroll and workforce dashboard

• Follow salary cost and net pay across the months of the selected year.
• Compare the average salary cost of each job grade and the average cost per employee.
• Check the overtime percentage to see how much of the payroll cost comes from overtime.
• Count the active employees included in payroll for the selected period.
• Spot abnormal payroll fluctuations and large earning variances from one month to the next.

Filters

Use the filtering panel at the top of the Workforce Demographics dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.

The filters from Branch to TWK Costing work as a hierarchy: a selection in one limits the values listed in the filters that come after it.

Different filters

The list below may not match what you see in your own filters. Sage lets each company name and order these hierarchy filters on its own, so Branch through TWK Costing is only one possible example.

Year: one value

Month: one value

Large Change Threshold: one value

Company: multiple values

Branch 1: multiple values

Department 2: multiple values

Province 3: multiple values

Cost Centre 4: multiple values

Project 5: multiple values

Farm Department 6: multiple values

Division 7: multiple values

Contractors 8: multiple values

Status 9: multiple values

TWK Costing 10: multiple values

Key performance indicators (KPIs)

The key performance indicators (KPIs) at the top of the dashboard show six payroll and workforce measures for the selected month and year, and update based on the filters you apply.

KPI	What it measures
Salary Cost	Total gross salary expense for the selected month and year, which rises as payroll costs more.
Net Pay	Total net pay after statutory and voluntary deductions, where a higher value means more cash is paid out to employees.
Avg. Cost per Employee	Average payroll cost per active employee, which is higher when pay is higher or the workforce is more senior.
Overtime %	Overtime cost as a proportion of total payroll, where a higher value means a larger share goes to overtime and may point to a capacity strain.
Headcount (Active)	Number of active employees included in payroll for the selected period, which grows as the workforce expands.
Company Contributions %	Employer contribution percentage for statutory or benefit related payroll components, where a higher value means the employer pays more in contributions.

Visual components

View name	Type of view	What it shows
Avg. Salary Cost by Job Grade	Horizontal Bullet	Compares the average salary cost of each job grade, with one bar for each grade and a red reference line on each bar.
Total Payroll Cost by Component	Combination	Follows earnings and company contributions for each month of the year, with the running total of salary cost year to date as a line.
MoM Earnings Variance	Combination	Compares the payroll of each month with the payroll of the previous month, with the MoM variance % as a line.
Employees with MoM Earning Variances	Worksheet	Lists employees with their MoM variance %, their total earnings this year month to date (TYMTD), and their total earnings last month to date (LMTD), with a flag next to the variance.