Skip to main content
Top

2024 | Book

Audit Analytics

Data Science for the Accounting Profession

insite
SEARCH

About this book

This book, using R and RStudio, demonstrates how to render an audit opinion that is legally and statistically defensible; analyze, extract, and manipulate accounting data; build a risk assessment matrix to inform the conduct of a cost-effective audit program; and more.

Today, information technology plays a pivotal role in financial control and audit: most financial data is now digitally recorded and dispersed among servers, clouds and networks over which the audited firm has no control. Additionally, a firm’s data—particularly in the case of finance, software, insurance and biotech firms—comprises most of the audited value of the firm. Financial audits are critical mechanisms for ensuring the integrity of information systems and the reporting of organizational finances. They help avoid the abuses that led to passage of legislation such as the Foreign Corrupt Practices Act (1977), and the Sarbanes-Oxley Act (2002).

Audit effectiveness has declined over the past two decades, as auditor skillsets have failed to keep up with advances in information technology. Information and communication technology lie at the core of commerce today and are integrated in business processes around the world. This book is designed to meet the increasing need of audit professionals to understand information technology and the controls required to manage it. This 2nd edition includes updated code and test. Machine learning, AI, and SEC’s EDGAR data are also, improved and updated.

The material included focuses on the requirements for annual Securities and Exchange Commission audits (10-K) for listed corporations. These represent the benchmark auditing procedures for specialized audits, such as internal, governmental, and attestation audits. Many examples reflect the focus of the 2024 CPA exam, and the data analytics-machine learning approach will be central to the AICPA’s programs, in the near future.

Table of Contents

Frontmatter
Chapter 1. Fundamentals of Auditing Financial Reports
Abstract
Audits are independent examinations of the records of an organization to ascertain how far the financial statements present a true picture of the firm and that accounting systems are well controlled, legal, and accurate. Auditing has become such a ubiquitous phenomenon in the world that academics have chronicled the transition to “Audit Societies.” The early twentieth century saw the standardization of auditors’ tests and reporting. Statistical sampling and computer tools to conduct statistical samples and opinions based on them are an integral part of modern auditing. This chapter surveys the state of the profession and what the twenty-first century auditor needs to know.
J. Christopher Westland
Chapter 2. Foundations of Audit Analytics
Abstract
Broad application of statistical and data analytic tools is essential for the cost-effective completion of audits. Fortunately, R has become the go-to language for analytics, and offers many features that reduce the cost of data acquisition, preparation, exploration, and summarization. It provides a scientific basis for audit decisions underlying the auditor’s opinion. Effective legal defense of audit methods is predicated on data analytics and statistical methods. This chapter summarizes the subset of R capabilities that are germane to an audit.
J. Christopher Westland
Chapter 3. Analysis of Accounting Transactions
Abstract
Accounting transactions are the “raw data” of accounting system, but the idiosyncratic vernacular of accounting, and spotty empirical study of distributions and characteristics of accounting transactions mean that statistical methods that are applied in other disciplines are likely to prove suboptimal, and even counterproductive in auditing. This chapter delineates the idiosyncrasies of accounting transactions and summaries, and describes tools to cost-effectively prepare and render decisions from client accounting data.
J. Christopher Westland
Chapter 4. Risk Assessment and Planning
Abstract
Risk assessment, planning, and budgeting of audits are essential precursors to the successful audit. The determination of risk of a particular subset of accounting operations related to the rendering of the audit opinion-i.e., on whether the accounts have material error when GAAP has been consistently applied. This chapter delineates construction of the risk assessment matrix-a collaborative “learning” worksheet to support a scientific foundation for audit scope, planning, and budgeting prior to initiation of audit field tests.
J. Christopher Westland
Chapter 5. Analytical Review: Technical Analysis
Abstract
Analytical procedures are evaluations of financial information made by a study of plausible relationships between both financial and non-financial data. They are used in all stages of the audit including planning, substantive testing, and final review stage. This chapter surveys a range of R packages that ease technical analysis and data collection tasks in analytical review.
J. Christopher Westland
Chapter 6. Analytical Review: Intelligence Scanning
Abstract
Analytical procedures involve the study of plausible relationships between both financial and non-financial data. Before the mid-2000s, sources of such information were spotty, unreliable, and scarce, and that, indeed, was considered a prime reason for markets needing annual, audited financial statements. Today, there are numerous social networks, news, and discussion boards that offer both raw and curated, streaming sources of useful business intelligence. The auditor who does not scan for such client and industry intelligence both increases the cost of auditing, and can be considered negligent in not investigating all available information about the financial health of their client.
J. Christopher Westland
Chapter 7. Design of Audit Programs
Abstract
Audit programs—from a scientific perspective, natural experiments—are empirical studies in which the activities of firms, individuals, or groups are exposed to the experimental and control conditions that are determined by nature or by other factors outside the control of the auditors. This chapter details the cost-effective planning for an audit, based on a deep understanding of natural experiments and the proper analytical tools needed to draw conclusions from them.
J. Christopher Westland
Chapter 8. Interim Compliance Tests
Abstract
Compliance tests determine whether the firm’s transaction processing follows generally accepted accounting principles (GAAP). They have grown increasingly important and are the basis for much of the reporting in the SAS No. 115 letter to management, and support management’s response in the Sarbanes-Oxley letter. This chapter delineates the statistical tools used to insure cost-effective compliance testing in the audit.
J. Christopher Westland
Chapter 9. Substantive Tests
Abstract
Substantive testing directly supports the auditor’s opinion that economic events in the real world are or are not accurately summarized in the financial statements of a firm. This chapter delineates the statistical tools used to insure cost-effective substantive testing in the audit.
J. Christopher Westland
Chapter 10. Sarbanes–OxleyEngagements
Abstract
Academic research on reporting from Sarbanes-Oxley Act of 2002 (SOX) has to date focused on internal consistency, compliance, and accrual accounting assessments. Some research has been performed on the related external risks such as fraud and security breaches. This chapter surveys what we know about compliance cost and information content of SOX filings, and provides machine learning tools to assess the information contained in SOX reports.
J. Christopher Westland
Chapter 11. Blockchains, Large Language Models, Cybercrime, and Forensics
Abstract
Auditors are often asked to opine on technical security and encryption technologies, as well as providing admissible evidence in legal cases. This chapter reviews the most encountered security and encryption technologies, with guides to how auditors should assess and manage them. Substantial new capabilities are now available through machine learning and large language models, which are reviewed in this chapter.
J. Christopher Westland
Chapter 12. Special Engagements: Forecasts and Valuation
Abstract
Auditors have an intimate understanding of their client’s finances. Because of that, they are likely to be called upon to assess the value of a new or existing investment. This chapter reviews the factors that go into performing a successful assurance and valuation assessment for a client.
J. Christopher Westland
Chapter 13. Simulated Transactions for Auditing Service Organizations
Abstract
Testing the shared, proprietary third-party platforms of service organizations and cloud computing presents auditors with a significant challenge. Auditors in these reviews can test automated controls by reading a “deck” of known transactions and comparing these with the accounting reports generated by a client’s automated system. This chapter delineates procedures for constructing and using these methods.
J. Christopher Westland
Backmatter
Metadata
Title
Audit Analytics
Author
J. Christopher Westland
Copyright Year
2024
Electronic ISBN
978-3-031-47464-4
Print ISBN
978-3-031-47463-7
DOI
https://doi.org/10.1007/978-3-031-47464-4