Better Business Through Data Analysis & Monitoring My Account

Innovation Starts with IDEA

Wrap Up - Part 1

More than 125 IDEA users, partners and CaseWare representatives gathered in Houston on November 1-2 to learn new strategies for implementing and growing their use of data analytics. It was also an opportunity to celebrate the 25th anniversary of Audimation Services, Inc., which has helped countless audit, accounting and financial professionals use data analytics to achieve higher levels of efficiency and effectiveness.

From the hands-on training sessions to sessions led by IDEA experts, and inspiring keynote presentations, the Conference covered a lot of ground. For those who couldn’t join us, we wanted to share a few key takeaways. Plus, don’t miss out on the next IDEA User Conference, which will be held September 18-21, 2018 in Denver, CO. The call for presenters is now open through December 22, 2017. Click here for more information.

Adopting Analytics

Data analytics can be integrated into the entire audit lifecycle, but to truly be successful, you’ll need to build it into the structure of audit plan and use it to help focus on specific areas.  IDEA should be used as part of the risk assessment process to look at materiality for original scope and help scope out areas that require more in-depth testing. There are many features within IDEA that can be used to sift through the data and focus on anomalies that rise to the top including Field Statistics, Fuzzy Matching, Discover and Benford’s Law. While not every red flag will lead to a multi-million-dollar infraction, they can help engage management in discussions about processes that need to be addressed. Additionally, the new visualization features within IDEA turn findings into images, which can be included in the audit report.

One of the biggest challenges is keeping pace with both the business and potential risks. It’s no longer enough to develop a test and check the box. As new fraud schemes emerge every day, your tests should evolve with those changes. Building a standardized and sustainable data analytics program takes tools, time, budget and support from management – all worthwhile investments for preventing fraud and reducing risks.

Collaboration

Gathering data from different sources and using it to deliver information they didn’t have before can be…well…a bit intimidating. It’s a delicate dance between remaining independent and helping business units take part in the analysis process, but it can be done! Engaging IT, business unit managers and data gatekeepers in the process gives everyone an opportunity to exchange ideas and work together to prevent revenue losses, prevent fraud and strengthen controls. Support from the audit committee goes a long way in helping prevent roadblocks along the way. Internal networking with everyone from junior-level staff that may have hidden talents to the business unit managers, who have everything to gain from the use of data analytics to gain meaningful insights, can help raise internal audit’s value within the organization.

Automated Risk Identification

LyondellBasell is one of the largest plastics, chemical and refining companies in world with annual revenues of $29+ billion and offices spanning 18 countries. With a stellar safety record and companywide commitment to mitigating risk, it’s no surprise the data analytics team is expanding their use of IDEA into new areas. They began using IDEA on an ad-hoc basis and have used it to prevent global anti-corruption and fraud. They have standardized their audit process by using scripts and custom functions to cover more ground and rank transactions based on risk levels. While designing a test to catch everything is difficult, they are using sophisticated visualization and BI tools in addition to IDEA to help them fine tune their audits. So, what’s the key to their success? They spend about 90% of their time identifying where the data exists and preparing it for analysis. The more accurate the data, the better the output.

A Picture Can Be Worth a Million Rows

Visualization is certainly having its moment in the audit spotlight these days. Images and graphs have been used to quickly communicate complex information for years. When staring at rows and columns of data, not much “jumps out” at the viewer, but with the new data visualization tools built into IDEA, the end user (and key stakeholders) get a clear story to draw conclusions from that they wouldn’t have seen otherwise. Chevron’s Data Resource Manager is using data visualization to evaluate risks, plan and scope audits, conduct field work and communicate findings. Pie charts with product value data help her see materiality across multiple locations to help prioritize, plan and scope audit engagements. When you have a finite amount of time and resources, the patterns, spikes and trends can help guide you in the right direction.

All Aboard: Growing Your Data Analytics Program

The University of Texas System is as big as Texas with three types of institutions, each with their audit plan, budget, Chief Audit Executive, audit committee and ERP system. When upper management wanted to provide a centralized data analytics service among a decentralized structure of groups, the obstacle course was set. Priority number one was helping those who needed help. Priority number two was creating tools and resources across the various systems to help them “own” their own audits. After a few starts and stops, the plan shifted to include a mix of consulting, SharePoint resources, training, tools and cross-system sharing. A key driver in the success of the program was support from management. From adequate budget to support travel and tools, to patience, support and even some cheerleading, the top-down backing of using data analytics made a difference in how the use of IDEA was rolled out across the organization. Some auditors are starting to share their best practices with others via virtual lunch-and-learns, and the UT System has even shared their approach with other higher education institutions to help them launch their own data analytics service groups.

Navigating Changes While Protecting Culture

Change is an inevitable part of business. Suzie Jones with Training Resources & Consulting, LLC has experienced many changes during her 40-year career in the financial industry. While change should not cause disruption, it can quickly turn into a crisis if not handled properly. Her keynote address provided some advice for inspiring your team through times of transition, disruption and crisis. Suzie invited everyone to think about their company culture – Is it exciting, supporting, fun, engaging, innovative? How do unexpected changes such as mergers and acquisitions, outsourcing, budget cuts, layoffs or office closures affect the morale? How do you keep the team motivated and inspired when everyone is worried about their own jobs? While we can’t prevent changes or disruption, we have four levers of control we can “pull on” during a crisis to stave off disruption:

Lever 1:

Management’s Behavior –Management’s attitude directly impacts the team’s reaction. Leaders should grow and mentor their teams, which builds loyalty and trust. Have an open-door policy. Walk the halls without an agenda…and talk about something other than work. Celebrate success now. Thank each other publicly.

Lever 2:

Control the Message – Good news travels fast, and bad news travels at the speed of light. That negative ripple effect can send everyone into a tailspin if not handled correctly. Seek out the “natural” leaders within groups of people and communicate with them. Don’t allow misinformation to spread.

Lever 3:

Transparency – It’s better to discuss the inevitable up front than allow employees to make their own assumptions about their fate. There may be times when someone’s role will change, but the news can be presented in an assuring way. It’s also important to help staff exit with dignity if their role is eliminated. The key is upfront, clear communication to prevent the feeling of uncertainty.

Lever 4:

Control the Culture Everyday – People buy into the values of a company. Major culture changes can often lead to the loss of good employees who no longer feel the company reflects their own values. Management needs to ensure every change, and communication that accompanies it, fits within the culture of the company.

If all else fails, Suzie recommends to “just breathe.” Take everything in stride and know that things have a way of working out for the best. She left us with these parting thoughts: Respect is earned. Honesty is appreciated. Trust is gained. Loyalty is returned.

Stay tuned for more highlights and detailed takeaways from the IDEA Innovations Conference, which will appear in an upcoming IDEA Newsletter. We thank our expert IDEA users for sharing their best practices, insights and advice with their peers.

7th IDEA Innovations Conference – Save the Date & Submit to Present!

Join us for the next IDEA Innovations Conference, which will be held September 18-21, 2018 in Denver, CO. The call for presenters is now open through December 22, 2017. We're looking for creative, informative and engaging presentations for all levels of users with helpful takeaways, new techniques and engaging stories. Share your IDEA experience and attend the conference at no cost, including travel and lodging! Click here for more information.

Print

Number of views (1553)/Comments (0)

Brad Newman

Brad Newman

Other posts by Brad Newman
Contact author

Please login or register to post comments.

Name:
Email:
Subject:
Message:
x
2018 IDEA® User of Excellence Award Winner Selected
15 June 2018

2018 IDEA® User of Excellence Award Winner Selected

Jennifer Girard, CIDA with American Red Cross Recognized for Exceptional Use of Data Analytics

Jennifer Girard, Sr Auditor with the American Red Cross is the recipient of the 2018 US IDEA UoE Award. She utilized IDEA to assist Finance Department during a natural disaster.

Read More

The Rules of Nature and Audit
6 June 2018

The Rules of Nature and Audit

What’s missing is often as important as what’s present. The rules of nature apply very well to audit if you consider, “Everyone knows it, but do you test for it?”

Read More

Using IDEA to Import QuickBooks General Ledger Data
4 June 2018

Using IDEA to Import QuickBooks General Ledger Data

The General Ledger is typically the starting point to an expanse of detailed information, see a step-by-step guide on how to get a readable version in idea.

Read More

New Features in IDEA 10.3 Part II
10 May 2018

New Features in IDEA 10.3 Part II

IDEA Tech Tip

In a recent article, we introduced the improvements to Stratified Random Samples and Python integration added in IDEA 10.3. But that’s just a small part...

Read More

Cargo Company Swaps Programming-Intensive Data Analytics Software for CaseWare IDEA
10 May 2018

Cargo Company Swaps Programming-Intensive Data Analytics Software for CaseWare IDEA

Auditors Achieve More Success in First Year with IDEA Than 5+ Years with Other Tool

With the entire audit team up and running using data analytics, they are finding new ways to integrate IDEA into other areas of the business and automate repeatable processes.

Read More

Maximizing Your Environment - Global Variables
8 May 2018

Maximizing Your Environment - Global Variables

Consider scope to be a building in which people work. The tools required to accomplish their tasks will of course be housed in that building, but in scripting it’s important to determine which tools need to be shared among the buildings.

Read More

Tips on Acquiring Data
8 May 2018

Tips on Acquiring Data

An IDEA User Shares Frequent Practices

When working with rows and columns of data to spot suspicious behaviors, fraud and errors can look very similar to one another. While Yeriazarian often uses Excel as an interim format for data, he also understands there are several avenues to navigate before getting the right data.

Read More

Identifying Churn in AR
19 April 2018

Identifying Churn in AR

IDEA Tech Tip

Customer churn (customer attrition, turnover, or defection) is when a customer decides to stop engagement with your company. IDEA can help easily identify “churn” in accounts receivable by following these steps...

Read More

Jeremy Clopton Joins Integration Partnership Program to Help Professionals State & Sustain Their Use of Data Analytics
18 April 2018

Jeremy Clopton Joins Integration Partnership Program to Help Professionals State & Sustain Their Use of Data Analytics

Data analytics & fraud detection expert Jeremy Clopton joins the Audimation Integration Partnership program to help organizations leverage data analytics.

Read More

Think Like a Thief to Catch One
11 April 2018

Think Like a Thief to Catch One

Apply Logic to Detect Peculiar Behavior

When working with rows & columns of data to spot suspicious behaviors, fraud & errors can look very similar to one another. Tips on sniffing out fraud.

Read More

5 Elements of a Successful Data Analytics Program
12 March 2018

5 Elements of a Successful Data Analytics Program

Building a successful, sustainable data analytics program takes effort…and a few other elements.

Read More

The Power of Field Statistics
7 March 2018

The Power of Field Statistics

IDEA Tech Tip

IDEA’s Field Statistics can save you a wealth of time. It should be the first thing you go to after importing a file. Why?

Read More

Using Data Analytics to Prepare for Fieldwork
20 February 2018

Using Data Analytics to Prepare for Fieldwork

Automating High-Risk Transactions with IDEA

See how a global corporation used IDEA to develop an automated process to prepare auditors for on-site work.

Read More

People. Processes. Tools.
5 February 2018

People. Processes. Tools.

Successful Integration of Data Analytics

Expert IDEA users share their experiences and advice for building and sustaining a successful data analytics program.

Read More

RSS