The 21st Minute


Blog Image

University Automates Analysis of AP, P-Card and Employee Data

Client Success Story


The internal audit department of a university with 9,500+ students purchased CaseWare IDEA® to conduct ad hoc reviews of various data sets.


University auditors wanted to quickly implement IDEA to analyze Accounts Payable, Purchasing Card (p-card) and employee data for duplicates and potential matches to identify potential fraud. The internal auditors were uncertain about which tests to run, and wanted to automate analysis for low-risk areas to increase their efficiency.


The Solutions Development team proposed a variety of analytics tests to increase visibility within key financial areas. P-card control tests included issuance, activity for employees on leave, administration, program performance, spending patterns and transaction policy violations, such as cash advance purchases.


The client was able to quickly test and detect matches and potential violations within AP, p-card and employee data. The Solutions Development team created custom IDEAScripts to automate repeatable processes for future audits. Testing these key risk areas helped the university strengthen internal controls, increase their efficiency and properly monitor transactions. By testing these key areas, the auditors were able to make more informed decisions and focus on the results rather than the process.


Automate Procedures , Success Story

Posted By

By Sarah Palombo
Sarah Palombo founded Avery Public Relations in 2007 and took on Audimation Services as her first client. She has more than 20 years of experience developing communications programs and creating content.

Related Posts
Task Automation Using IDEA
Apr 16 Audit scenarios rarely require an entirely unique process. Having a preferred set of tests ready to go is a great time-saver, but that can be further improved i...
Gain Productivity with RPA
Apr 16 Leaders of professional associations are urging auditors to embrace emerging technologies to advance the industry, create audit efficiencies and manage organiza...
Turn Your Data into a Competitive Advantage
Nov 05 We are in the midst of a data explosion where every action is collected, from a credit card swipe to the vibration of a factory machine. You have been collectin...

This website has been designed for modern browsers. Please update. Update my browser now