Whether you are looking to reinforce existing IDEA knowledge or seeking to push your analyses into new territory such as advanced statistical methods (Standard Deviation and Trend Analysis for example), in this one-day, in-house workshop, you will learn how to harness the power of IDEA Data Analytics to improve any given functional / business areas of your Payroll Audit.

• Mischaracterised expenses, where an employee requests reimbursement for a personal expense, claiming the expense to be business-related
• Inflated expenses, where an employee overstates the cost of actual expenses and seeks reimbursement
• False expense, where an employee invents a purchase and seeks reimbursement
• Multiple claims, where an employee submits a single expense for reimbursement multiple times.

Pre-course requirements

Delegates should be fully conversant with the CIDA foundation level functionality covered in CI101 Introduction to IDEA Data Analysis.

Training scenarios

IDEA Data Analytics can help you analyse data for forward planning, forecasting and making informed decisions in addition to the specific testing areas of:

• National Insurance
• Time & Attendance
• Pensions
• Pay rises
• Absence & Overtime
• Expenses

Whatever your Payroll focus, the workshop will be based upon your own data and will show you how to use IDEA to:

• Take a best practice approach to an IDEA Payroll Audit
• Prepare your own data
• Perform data quality checks looking for missing or incorrectly formatted information
• Look for fraud, unusual exceptions and trends
• Perform specific pre-agreed tests required for your individual payroll audit, provided you can make the data available.

Who should attend?

The course is aimed at External Auditors, Internal Auditors, Data Analysts and all those charged with inspection and /or analysis of Payroll data.