Data Analysis and Data Integrity – part #2

Part #1 looked at why assessing data integrity is an important, value-added activity that supports management decision making.  Part #2 examines things you can do to improve the integrity of the data and your analytic results.  While I will be looking at data integrity primarily from a data analytics perspective, it is important to recognize that many people play a role in the integrity of data.  Ensuring data integrity is…

August 19, 2022
Read More >>

Data Analysis and Data Integrity – part #1

A common refrain that I hear is, “We can’t rely on the data because it does not have integrity.” This raises a couple of questions in my mind and should in yours as well.  First, what is management using to produce its reports and make decisions?  Second, how accurate does your data have to be to allow you to perform analytics and arrive at valid recommendations/conclusions.  The obvious answer to…

August 10, 2022
Read More >>

Duplicates Invoices – Root Cause Analysis

Cost recovery firms make millions of dollars identifying and recovering duplicate payments.  They often have well developed analytics that can identify duplicate payments while reducing the number of false positives.  You will pay 25-50% but you are getting money back, so it feels like a win-win.  However, there are two things to keep in mind: 1) they go after the low hanging fruit and the largest possible duplicates; and 2)…

June 10, 2022
Read More >>

Audit Finding Attribute: Impact

This is the sixth in a series of articles on data analytics and internal audit. This article looks at the audit finding statement: Impact. The focus will be on the use of data analytics to assist you in determining the impact of what was observed (the condition) and to support the recommendation. In simple terms, the impact answers the ‘why should I care.’  What is the impact of controls failing…

March 21, 2022
Read More >>

Audit Finding Attribute: Cause

This is the fifth in a series of articles on data analytics and internal audit. This article looks at the audit finding statement: Cause. The focus will be on the use of data analytics to assist you in determining the cause of what was observed (the condition) and to support the development of the recommendation. In simple terms, the cause answers the ‘why.’  Why are controls failing to prevent and/or…

March 9, 2022
Read More >>

Audit Finding Attribute: Condition

This is the fourth in a series of articles on data analytics and internal audit. This article looks at the audit finding statement: Condition. The focus will be on the use of data analytics and how the condition supports the development of the recommendation. In simple terms, the condition is “what is.” Typically, the analytics are testing for the existence of something, and the results are the condition. For example,…

February 28, 2022
Read More >>

Data Analytics and Internal Audit

This is the next post in a series that discusses the importance of having a proper audit objective, defining the business goals and objectives, and the risks to the achievement of those objectives.  This article will discuss the identification and assessment of risk.  The next series of articles will look at the audit finding statement: Criteria, Condition, Cause, Impact and Recommendation.  The focus will be on the use of data…

February 16, 2022
Read More >>

SOX Cost Reductions through Data Analytics

According to the Protiviti report, ‘SOX Compliance and the Promise of Technology and Automation1’ SOX compliance costs have shown year-over-year increases but are starting to level off.  It also states that organizations are beginning to make greater use of technology and automation to support the compliance process.  However, implementing automation in the SOX compliance process is difficult for many organizations.  Understanding and defining requirements, getting stakeholder buy-in, and the investment…

July 5, 2021
Read More >>

Unicorns and the Case for Analytics

It feels odd to have to continue to justify the need for and use of analytics.  What can I add that has not already been stated many times over the past 20-30 years?  Studies since the early 1990’s have pointed to the need for businesses and auditors to embrace the use of analytics.  More recently, Deloitte’s 2021 Global Risk Management Study1 recognizes the potential for digital risk management technology to…

April 27, 2021
Read More >>

37-Point Check-up for your ERP

COVID hasn’t really changed things for auditors – it has just brought things to the forefront that we should already have been doing.  Things like: focusing on key risks to the organization, and embracing and maximizing the use of analytics.  This article describes how an audit function can check on the robustness of the internal controls, identify and assess risks, prevent fraud, and provide assurance – remotely – by employing…

July 17, 2020
Read More >>