The days of accountants relying on sprawling legal notepads, bulky calculators, and illegible chicken scratch are long gone. Accounting in 2021, like many industries, has been revolutionized by an onslaught of new technologiesvlogƵranging from complex Microsoft Excel spreadsheets and formulas to ever-sophisticated software.
Pace Accounting Professor Freddy Huang is well aware of these changes, and is helping to usher in a new era in accounting. Through the Multi-Dimensional Audit Data Selection (MADS) frameworkvlogƵwhich Huang and his colleagues helped develop in conjunction with the American Institute of Certified Public Accountants (AICPA), the Chartered Professional Accountants (CPA) Canada, and audit experts from the Big Four accounting firmsvlogƵHuang is helping auditors to, quite literally, crunch the numbers more effectively.
A large component of accounting is auditing; which refers to independent examination of financial information of a company, often conducted by external accounting firm. For large companies, auditing theoretically involves looking at potentially millions of business transactions in a given year.
vlogƵTraditionally, auditing is quite labor intensive,vlogƵ said Huang.
Because of this reality, auditors have long engaged in a process known as samplingvlogƵwhich involves taking a smaller portion of transactions and analyzing that portion to make determinations about the full quantity of transactions.
vlogƵIn relation to audit data analytics, itvlogƵs important for students to develop a mindset."
vlogƵThey donvlogƵt take look at all of a businessvlogƵ transactions. TheyvlogƵll just select, letvlogƵs say, 100 records as a representative sample of the population,vlogƵ said Huang. vlogƵThen, with those records, theyvlogƵll apply some audit procedures, and draw conclusions on the entire population.vlogƵ
However, as Huang notes, this method has historically come with a risk, which is commonly known asvlogƵyou guessed itvlogƵsampling risk.
vlogƵIf you only audit 100 records, your conclusion may be different from if you hypothetically audit the full population (thousands or possibly millions of records).vlogƵ
Enter, data analytics. With the advantage of todayvlogƵs data analytic tools, it has become increasingly easier and cost-effective to examine large quantities of transactions with a relatively low-cost, which theoretically solves the problems of sampling risk. Yet, a new problem has emerged. Namely, if auditors have several weeks to audit a company, what is the most effective way to break down this deluge of information? Is even attempting to sift through mountains of data in an auditorvlogƵs best interest?
vlogƵOne reason why accounting firms are hesitant to apply full population tests are the large number of outliers,vlogƵ notes Huang.
Outliers, are in essence, the red flagsvlogƵtransactions in an audit that based on the audit criteria, raise possible suspicion and merit a further look. Because a full-scale audit can produce thousands of outliers, analyzing all of the outliers in a large audit is often impractical, and possibly conducive the human error.
The key is then, as Huang explains, to apply frameworks to further reduce the number of outliers down a number that is manageable for an auditor, while also ensuring those outliers are the most important transactions for the auditor to look at. This is exactly the problem that HuangvlogƵs Multi-Dimensional Audit Data Selection (MADS) Framework is dedicated to solving, and does so by breaking down outliers into three different outputs. In other words, it uses algorithms and equations to even further reduce the number of outliers in an audit to the ones that raise the greatest suspicion.
vlogƵWe first start with the full population analysis,vlogƵ explains Huang. vlogƵBased on whatever test or filters you need to apply, youvlogƵll first get a large set of outliers. ThatvlogƵs the Stage One output, but not the final output of the analysis. We then apply additional tests for our Stage Two output, which could be an advanced machine learning algorithm, or based on the output of Stage One, auditors may develop additional filters or test using their own judgement.vlogƵ
Finally, in the Stage Three output, Huang and his colleagues created a vlogƵsuspicion score,vlogƵ which evolves an equation that weights transactions based on the feature and/or number of violations a given transaction has along with the dollar amount of a transaction. If two transactions have the same amount and type of violations but one transaction is significantly larger in dollar amount, for example, that transaction would most likely be greater cause for concern.
Ultimately, through the MADS frameworkvlogƵas well as through looking at how to best incorporate Robotic Process Automation (RPA) into auditing (which aims to free up accountants from doing repetitive and low-judgement tasks in order to focus on tasks that require greater professional judgment)vlogƵHuang understands that the future of accounting is heavily trending toward having a strong command of data analytics. When it comes to training the next generation of accountants at Pace, Huang believes that ensuring students approach complex tasks with a strong command of todayvlogƵs technological tools is paramount for success.
vlogƵIn relation to audit data analytics, itvlogƵs important for students to develop a mindset. In the future, when they start to work for different accounting firms and with different clients, they will certainly be dealing with different types of data sets. But with this mindset, they'll always know where to start and what to follow."
Through a grant totaling nearly $500,000 Dyson professors Matthew Aiello-Lammens and Erika Crispo are helping elevate Pace to new heights through incorporating data science into the biology and environmental science fields.
Dyson Environmental Studies and Science Professors Monica Palta and Anne Toomey have been conducting research in Coney Island Creek, documenting the existing environmental and social ecosystem. Their work aims to reshape the conversation surrounding urban waterfront development.
Dyson Biology Professor Melissa Grigione, PhD, has spent her career traveling all around the world to better understand a wide range of animal populations. She's now passing on what she's learned to the next generation.