Analytics & Business Intelligence

Payroll Reports (AST)

Highlights

The M-Reports Payroll Landing Page has links and descriptions for payroll reports in the Management tab.

Payroll Management reports feature:

  • Quick trend analysis via graphs, variances, and more
  • Drill-down options to go from high-level totals to transaction details

Criteria bar options let you control how much data to view.

Report Overview

The reports in the Payroll folder of the Management reports tab provide links and descriptions for:

  • Monthly reports
  • Quarterly reports
  • Annual reports
  • Other useful reports

The Payroll Yearly Trend report, for example, shows high level for each compensation type for the current and past 12 months. The report is organized into types of pay (e.g, staff, faculty, overtime, temp).

Data Sources

M-Reports dataset containing data from the M-Pathways Human Resource Management System (HCMPROD).

Access Details

Who gets access?

If you have access to Internal-Controls-Employment (ICE) reports, you are automatically be granted access to reports in the Payroll folder of the M-Reports Mgmt Reports tab. Access is based on your Departmental Security Settings (DSS) and the roles you are assigned. Your default DSS is the department group of your Primary Appointing Department (PAD) but can be narrowed or expanded, if necessary, during the access request process. Your PAD is the department that grants the appointment for your primary job.

Refresh Schedule

  • The Payroll Funding Dept/Appointing Dept Mismatch and Pay Estimates Compared to Actual Pay reports follow the U-M Data Warehouse refresh schedule:
    • Main Payroll tables: After each off-cycle, biweekly, and monthly payroll is complete; the time for this refresh is not fixed. For regular Thursday off-cycles the refresh usually begins between 5 – 5:30 p.m. See U-M Payroll Office for a schedule of the University pay dates.
    • Pay_Estmt table: Monday–Friday, 9 - 10 p.m.
  • The data for the Payroll Yearly Trend and Payroll Five Year Trend reports is refreshed nightly.