Data Analytics Roundtable:  Payroll Data Analytics in Action

Members only event

The ACUA Data Analytics subcommittee is hosting a payroll data analytics roundtable, providing members with a collaborative forum to share experiences and insights. The session will feature brief demonstrations of a few key payroll data analytics using readily available tools. This will be followed by breakout into rooms based on ERP systems for small group discussions to share our challenges, successes, and best practices. This will also allow participants the opportunity to network and connect with other members interested in data analytics.

Tools Demonstrated:

• Excel with Copilot
• Tableau
• Power BI

Payroll Analytics:

• Identifying Potential Ghost Employees
• Identifying Employees Paid After Termination
• Comparing Employee vs Vendor Databases

Breakout Rooms – ERP System:

• Banner
• Workday
• Oracle
• PeopleSoft
• Other

The presentation is suitable for anyone interested in payroll data analytics. The demonstrations will be designed for those less experienced in data analytics, but auditors at all experience levels are encouraged to attend, share insights/expertise, and collaborate.

Will Aurich

Senior Auditor, Office of Audit, Risk and Compliance, Oregon State University

Kate Scarabelli

Audit Services Director, Audit & Compliance Services, Wake Forest University

John Snedeker

Associate Director, Internal Audit Department, The Ohio State University

Tiffany Yordan

Principal Auditor, Audit and Advisory Services, Rutgers University, and current director of the subcommittee