CPA Practice Advisor - 36

THE 21ST CENTURY ACCOUNTANT

Automation and the

FUTURE OF AUDITING
AUDITING HAS CHANGED significantly over the last 50 years. During the days of paper
general ledgers (the 1980's and before), two auditors would work together to validate the
posting of entries from the general journal to the general ledger using a method called

BRIAN F. TANKERSLEY

CPA.CITP, CGMA (@BFTCPA, CPATechBlog.com
K2 Enterprises
brian.tankersley@cpapracticeadvisor.com

"holler and tick". The person with the general ledger book would call out the accounts
and amounts from each entry, and both auditors would make tick marks next to the
relevant line on the ledger paper in the physical books that held these books of original
entry. Both auditors would then scan the books for any unmatched transactions (or
transactions which were posted twice), and the person with the general ledger would
use a 10-key adding machine to foot each account and validate the balance.
Auditing in the mid-21st century
will use more automation and will
require future entry-level auditors
to perform higher level tasks than
those required just a generation
ago. Enterprise-grade test automation tools like ACL Robotics and
Caseware IDEA have each been
around for at least 30 years, but each
of these legacy tools has typically
required special training to use the
tools effectively - meaning that they
were only used by a few members of
the audit team. Just as the low code/
no code robotic process automation
tools I've written about in previous
columns are changing the way our
clients work by scripting simple
routine tasks, new audit tools will
simplify and automate many routine
audit tasks.

36

AUGUST 2019 ■

Some of the more popular tools available in the marketplace today
include the following applications:

USE/CASE/NEED

POSSIBLE SOLUTION(S)

Wizard-based full data set testing using Microsoft Excel for
non-technical users

TeamMate Analytics, ActiveData for Excel

Enterprise-class audit automation tools

Galvanize ACL Robotics, Caseware IDEA

Data extraction from documents, receipts and statements

Receipt Bank, AutoEntry

Trial balance extraction, data set import, and creation of
InFlo, CCH Audit Accelerator, Validis
basic lead schedule, analytical schedules, and other routine
schedules
Full data set analysis, unusual transaction identification,
and data visualization

Inflo HI, Mindbridge.ai

Bank statement and credit card retrieval from financial
institutions

Hubdoc, File This Fetch, Receipt Bank Fetch

(This table presents a small
number of the capabilities of
selected solutions in the marketplace, and is not designed to present
each capability of every application
in the marketplace today.)
Many new tools are expected
in the next few years, including a
product called "Dynamic Audit Solution" from CPA.com and Caseware, a
cloud-based version of CCH Engagement, Thomson Reuters' Onvio Audit
solution, as well as enhancements to
existing tools such as AuditFIle, CCH
ProSystem fx Engagement, Caseware
Working Papers, and Thomson

www.CPAPracticeAdvisor.com

Reuters AdvanceFlow.
While much remains to be
decided by the marketplace, the
future of auditing will likely involve
real-time transaction analysis,
risk evaluation, and data validation. Although this approach was
endorsed by many academics and
corporate governance experts over
20 years ago, we have seen few adoptions of this approach (outside of the
internal audit/compliance groups at
large enterprises and entities who
need SOC audits). When blockchainbased data repositories are more
broadly used by mid-market com-

panies, third party commercial tools
will be required to help auditors
evaluate the integrity of the data
sets. As firms and their clients adopt
more structured business process
automation solutions (e.g. process
workflow tools), process mining will
further shift the landscape in favor
of real time auditing.
In conclusion, my advice is for
everyone to get ready for change
in the audit space, as it looks like
we're in for some big changes to the
standards, tools, and approaches we
use for our profession's marquee
service over the next ten years. ■


http://www.CPATechBlog.com http://www.Mindbridge.ai http://www.CPA.com http://www.CPAPracticeAdvisor.com

CPA Practice Advisor

Table of Contents for the Digital Edition of CPA Practice Advisor

From the Editor: Technology Will Never Be Slower Than It Is Today
Succession Planning for Small Accounting Firms
How to Improve Financial Systems for Small Business: 6 Best Tips for Managing Small Business Cash Flow
From the Trenches: Do Your Best Practice Management
2019 Innovation Awards Focus on AI and Automation
2019 Product Review: Tax Document Automation
2019 Product Review: Fixed Asset Management Systems
Apps We Love: Cities & Local Government
How to Shine as a Payroll Accontant
9 Types of Flexible Work Arrangements
3 Keys to Serving Governmental Entity Clients
4-Step Marketing Campaign to Win Municipality Clients
Resources for the Municipal Accountant
The 21st Century Accountant: Automation & The Future of Accounting
The ProAdvisor Spotlight: New Features and Enhancements in QuickBooks Online Accountant
The Millennial Advisor: Stepping Out
The Staffing & HR Advisor: Know How to Negotiate Salaries? You'll Need to Today
5 Process Trends Impacting Your Firm
The Leadership Advisor: The Human Skills Tech Can Never Replace
Bridging the Gap: Does Your Technology Meet Client Expectations?
CPA Practice Advisor - 1
CPA Practice Advisor - 2
CPA Practice Advisor - 3
CPA Practice Advisor - From the Editor: Technology Will Never Be Slower Than It Is Today
CPA Practice Advisor - Succession Planning for Small Accounting Firms
CPA Practice Advisor - How to Improve Financial Systems for Small Business: 6 Best Tips for Managing Small Business Cash Flow
CPA Practice Advisor - 7
CPA Practice Advisor - From the Trenches: Do Your Best Practice Management
CPA Practice Advisor - 9
CPA Practice Advisor - 2019 Innovation Awards Focus on AI and Automation
CPA Practice Advisor - 11
CPA Practice Advisor - 12
CPA Practice Advisor - 13
CPA Practice Advisor - 14
CPA Practice Advisor - 15
CPA Practice Advisor - 16
CPA Practice Advisor - 17
CPA Practice Advisor - 18
CPA Practice Advisor - 19
CPA Practice Advisor - 20
CPA Practice Advisor - 21
CPA Practice Advisor - 22
CPA Practice Advisor - 23
CPA Practice Advisor - 2019 Product Review: Tax Document Automation
CPA Practice Advisor - 25
CPA Practice Advisor - 26
CPA Practice Advisor - 27
CPA Practice Advisor - 2019 Product Review: Fixed Asset Management Systems
CPA Practice Advisor - 29
CPA Practice Advisor - 30
CPA Practice Advisor - Apps We Love: Cities & Local Government
CPA Practice Advisor - How to Shine as a Payroll Accontant
CPA Practice Advisor - 9 Types of Flexible Work Arrangements
CPA Practice Advisor - Resources for the Municipal Accountant
CPA Practice Advisor - 35
CPA Practice Advisor - The 21st Century Accountant: Automation & The Future of Accounting
CPA Practice Advisor - The ProAdvisor Spotlight: New Features and Enhancements in QuickBooks Online Accountant
CPA Practice Advisor - The Millennial Advisor: Stepping Out
CPA Practice Advisor - The Staffing & HR Advisor: Know How to Negotiate Salaries? You'll Need to Today
CPA Practice Advisor - 5 Process Trends Impacting Your Firm
CPA Practice Advisor - The Leadership Advisor: The Human Skills Tech Can Never Replace
CPA Practice Advisor - Bridging the Gap: Does Your Technology Meet Client Expectations?
CPA Practice Advisor - 43
CPA Practice Advisor - 44
https://www.nxtbook.com/endeavor/cpapracticeadvisor/december2022
https://www.nxtbook.com/endeavor/cpapracticeadvisor/octobernovember2022
https://www.nxtbook.com/endeavor/cpapracticeadvisor/august2022
https://www.nxtbook.com/endeavor/cpapracticeadvisor/june2022
https://www.nxtbook.com/endeavor/cpapracticeadvisor/april2022
https://www.nxtbook.com/endeavor/cpapracticeadvisor/december2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/november2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/october2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/september2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/august2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/july2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/june2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/may2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/april2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/march2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/february2021
https://www.nxtbook.com/endeavor/cpapracticeadvisor/december2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/CPA_Practice_Advisor_November_2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/october2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/september2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/august2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/CPA_Practice_Advisor_July_2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/CPA_Practice_Advisor_June_2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/may2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/CPA_Practice_Advisor_April_2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/CPA_Practice_Advisor_March_2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/february2020
https://www.nxtbook.com/endeavor/cpapracticeadvisor/december2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/november2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/october2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/september2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/august2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/july2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/june2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/may2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/april2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/march2019
https://www.nxtbook.com/endeavor/cpapracticeadvisor/february2019
https://www.nxtbookmedia.com