How to Choose an Audit Analytics Tool

Donny C. Shimamoto

With clients continuing to put downward fee pressures on auditors, firms need to look for additional ways to gain efficiency on their audits. One of the easier ways to do this is to look at data analytic tools that are designed to help automate the auditor’s work or audit analytics tools.

What are audit analytics tools? Audit analytics tools are designed to help automate some of the procedures originally performed manually by an auditor. These tools can be used when an auditor can get the underlying data for a report and also potentially access to the transactions that the report needs to be tied to. For example, getting beginning and ending trial balances and all of the underlying journal entries in between, or an AR aging reporting and the underlying outstanding invoices.

The basic functionality that you’ll see in audit analytics tools is the ability to import the data, and then perform tests on the data. Additionally, audit analytics tools can help with sampling (e.g., random or monetary unit sampling) and other data-related tasks. Some tools also provide you with the ability to clean up or segment data as part of the import. An example of segmenting data is taking an account number and splitting it between natural classification and department—taking 6100-10 and splitting that into 6100 (Advertising expenses) and 10 (Department A) in two separate fields so that you can do further analysis.

Examples of audit analytics tools Some of the common audit analytics tools used by firms today, as well as some of their common features or differentiators are shown to the right (in alphabetical order).

There are two additional audit analytics tools that are also available, ACL (acl.com) and IDEA (audimation.com/products/caseware-idea-data-analysis-software/). These are not included to the right, as they are more complex to use and require extensive training and some programming knowledge to use effectively. They also are generally more costly than the tools listed, so they are usually provided to “specialists” within an audit department, rather than to every auditor. (The rest of the tools mentioned to the right would usually be provided to every auditor.)

ActiveData www.informationactive.com (Use Donny’s link to save 15% off: Informationactive.com/intraprise) • Excel Add-In, familiar feel and minimal learning curve • Provides both data preparation functions and preprogrammed tests • Low cost enables you to put this in the hands of every auditor

Inflo www.inflosoftware.com • Web-based application, requires Internet connection • Variety of pre-programmed tests available • Test results can be exported to

Excel or PDF formats • Native integration with

Thomson Reuters

AdvanceFlow for workpapers • Includes benchmarking capabilities

MindBridge AI www.mindbridge.ai/solutions/ai-auditingaccounting-firms-cpas/ • Web-based application, requires Internet connection • Enables auditors to focus on higher-risk transactions by automatically running many common audit tests and using the results of these to provide risk scoring • Beneficial for fraud detection and audit planning

TeamMate Analytics www.teammatesolutions.com/analytics/ summary-of-tools.aspx • Excel Add-In, familiar feel and minimal learning curve • Pre-programmed tests or create your own custom tests • Tests result in selfdocumenting Excel workpapers that document what was done

How to evaluate audit analytics tools I’ve found that there is no right or wrong tool for a given firm, and just because you’re using a particular vendor doesn’t mean that you should by default select their audit analytics tool. Before you begin to consider these tools, look at your audit engagements and determine which types of tests are performed most often. Then look at which tools perform those tests and whether those tests would be easy for your staff to learn. Then you can consider which types of tests you could begin doing if you were using a tool. For example, while many firms use sampling when looking at a dataset, could you instead switch to use risk scoring to have greater insights on the entire data population and focus your testing on higher risk transactions? Sometimes this means running more tests, which while technically less efficient, could also reduce your detection risk and thereby make your audit more effective.

Find out whether your staff have experience with any of the tools. This is a good approach if you have experienced hires. If several of your staff already know how to use a particular tool, it may make sense for you to more heavily consider using that tool. Having “power users” for a new tool can help the rest of your staff get up to speed more quickly.

Request a trial from the vendors The next step is to talk to the vendors and request a trial of their software. Set aside time to run real client data through the software. Consider re-performing selected audit procedures that you have already completed so that you can see the difference between how you did the audit manually and how you used the tool.

Be sure to try the tools out on a variety of clients: simple and complex, different industries, and different accounting systems. It’s important to figure out which types of clients you can or can’t use the tool on, and which types of tests or procedures you can perform with the tool. Both of these will help you to determine what the benefits of the tool may be across your portfolio of clients, and you can use that to determine how much benefit you may see from the tool versus the cost of the tool.

Audit analytics tools are ready for your firm Audit analytics tools are a mature set of software that automate existing audit procedures—they are ready for your firm to adopt today. Take the summer to check out some of the tools and figure out which tool is right for your firm. You’ll want to have it figured out before you go into engagement planning in the fall so that you can incorporate the use of the tools into your engagement budgets and updated workplans.

As a WSCPA member, you are part of a community. One of the WSCPA's most important functions as an organization is to provide you with opportunities to collaborate, socialize, and celebrate with your fellow members. The Connect platform is your interactive member directory. Find and chat with members from across the state. You can join groups organized around your interests and participate in discussions on a variety of topics that are important to you.

Connect is your gateway to join resource groups and committees. Find groups you are already a part of and find others to join. Then, let the collaboration begin!

Check it out: wscpa.org/connect

Nano Learning CPE Comes to Washington State

Nick Rial

Are you confused about nano learning? Wondering if it means you have new CPE requirements to follow? Read on, and I’ll walk you through what nano learning is (and isn’t), and what it means for your continuing professional education (CPE) moving forward.

The Washington State Board of Accountancy (WBOA) approved changes to a number of CPE rules that went into effect January 1. One of the changes was to recognize nano learning as an option for qualifying CPE.

As now defined in WAC 4-30-010, there are four main qualities that make a CPE program a nano learning course:

The course is a minimum of 10 minutes and less than 50 minutes long (and is worth at least 0.2 and less than 1 full CPE credit). The course is electronic self-study. The course has at least one stated learning objective. The course has two questions to test the course-taker’s understanding at the conclusion of the course.

So what would not count as a nano course that qualifies as CPE in Washington State?

1. 2. 3. 4. Any live course or CPE qualifying activity Any written (paper) self-study course Any course without learning objective(s) Any course without the two final questions

During the course of your CPE reporting period, you may earn up to 12 credits total (which translates to 60 ten-minute nano courses).

You may be wondering whether short webinars—such as our one-hour Prix Fixe series or Member Exclusive webinars—are nano events. These webinars are not nano courses, as they are live, at least 50 minutes long, and do not include a twoquestion quiz at the end.

Some CPAs have been confused by the requirement for nano courses to conclude with two questions. While many long form self-study courses require participants to answer five questions per CPE hour, or about one question for every 10 minutes, nano courses require double this amount.

And that’s everything you need to know about nano learning. Curious about what a nano course is like? Want to give it a try? The WSCPA has partnered with ACPEN to produce some nano courses.

“We’re excited to offer this new on-demand CPE format,” said Hayden Williams, CFO of the WSCPA. “Our nano learning programs, taught by some of WSCPA’s very best and brightest tax experts and trainers, are each designed to teach you a very focused concept in 10 minutes.”