Better Business Through Data Analysis & Monitoring My Account

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

Challenge

One of America’s largest private cargo transportation companies has a small audit shop with a team of eight auditors and no data analytics expert on staff. The company invested in programming-intensive data analytics software to help acquire data from organically grown systems and perform testing on financial data including vendor expenses, invoices, and to prepare data for annual external audits.

Auditors struggled with using the software to import and test data. Two of the IT auditors used the tool on a limited basis, and after several years of struggling to accomplish their goals, the software turned to shelfware. Management supported the auditors in searching for a data analytics tool that was more user friendly and could help meet their data acquisition and analysis needs.

Highlights:

  • Auditors worked to test revenue and vendor data, and prepare for annual external audits
  • Spent 5+ years trying to use a data analytics tool, but was unsatisfied with their results
  • Currently using CaseWare IDEA® to import, analyze and automate audits

Solution

Auditors searched for a data analytics tool that could be used by the entire team, especially by those without IT audit experience. They selected CaseWare IDEA for its intuitive, Windows-based user interface, which was immediately familiar and easy to navigate. Using IDEA’s Report Reader feature, auditors were finally able to scan data from PDFs and turn them into IDEA databases.

They were able to retrieve data from various internal systems, including tables with multiple fields, and import it into IDEA with relative ease. With a new importing process underway, the auditors were able to perform tests on expenses from vendors, match invoices and analyze critical financial data. Manual testing that was previously impossible is now completed in a few hours.

Using another tool, our data acquisition and analytical work was limited by the staff’s ability to use the application. With IDEA, we can extract and integrate data from a variety of systems, automate those processes and perform analysis on data that was previously impossible. We have accomplished more in one year using IDEA than more than 5 years using another tool, and it’s helped us achieve new levels of efficiency to get more done in less time.
- IT Audit Supervisor

Results

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. Manual testing has been automated, which allows the auditors to perform more frequent data reviews and controls testing. It has also helped them satisfy requests from external auditors.

Using the Visual Script feature within IDEA, auditors have developed IDEAScripts to fully automate data pulls from different sources including SQL server data, which is used to perform regular revenue testing. The automated processes have reduced audit’s reliance on IT to acquire data and significantly reduced the amount of time needed to prepare sample data for external auditors. With an easy-to-use data analytics tool in place, auditors have saved hours of effort and are working towards their continuous auditing goals.

Print

Number of views (1210)/Comments (0)

Sarah Palombo
Sarah Palombo

Sarah Palombo

Marketing Communications Consultant, Audimation Services

Other posts by Sarah Palombo
Contact author Full biography

Full biography

Sarah Palombo joined Audimation Services in 2007 to develop and implement marketing communications programs. She works with the Audimation marketing team to plan, execute and measure sales and marketing campaigns, including content development. Prior to founding Avery Public Relations and working with Audimation Services as a client, Sarah worked for agencies in both Houston and Austin including Pierpont Communications, PetersGroup and Edelman Worldwide. During her 17-year career, she has worked with clients such as Motorola, Reliant Energy, Sony Ericsson, GE Interlogics, Hoover’s, Philip Morris, Open iT, and others. She is a graduate of Texas State University where she earned degrees in both Mass Communication/Public Relations and English. Sarah spent her childhood living inside Lake Corpus Christi Texas State Park, and still enjoys boating with her family on weekends.

x

Please login or register to post comments.

Name:
Email:
Subject:
Message:
x
Global Chemical Company Automates Risks Identification with CaseWare IDEA
14 September 2018

Global Chemical Company Automates Risks Identification with CaseWare IDEA

Global corporation used IDEA to standardize & develop an automated process to comply with anti-corruption policy.

Read More

Telecommunications Provider Turns Two Days of Work Into 20 Minutes with CaseWare IDEA®
14 September 2018

Telecommunications Provider Turns Two Days of Work Into 20 Minutes with CaseWare IDEA®

Auditors Analyzing Hundreds of Millions of Records to Track Buying and Usage Patterns

One of the world’s largest telecom companies' internal audit team leverages tech to analyze trends, tendencies & patterns within customer & financial data.

Read More

Exploring IDEA's Built-In Power of Python
20 August 2018

Exploring IDEA's Built-In Power of Python

IDEA Tech Tip

With the release of version 10.3, IDEA created a buzz with its implementation of the Python scripting language, thereby taking a huge step towards having a more robust coding environment.

Read More

Sharing IDEA Data Using IDEA's ODBC Driver
18 July 2018

Sharing IDEA Data Using IDEA's ODBC Driver

IDEA Tech Tip

Read More

Oncor Achieves Operational Efficiencies with CaseWare IDEA
25 June 2018

Oncor Achieves Operational Efficiencies with CaseWare IDEA

Oncor's internal audit team needed to acquire years of data from different environments and formats to help improve processes and efficiency levels.

Read More

Analyzing the Past to Predict the Future with Trend Analysis
18 June 2018

Analyzing the Past to Predict the Future with Trend Analysis

In business, predicting the future is never an easy task. But IDEA can help as long as you have the right data, and Trend Analysis can help.

Read More

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

RSS