绿巨人视频

Faculty and Staff

Crunching the Numbers

By
Lance Pauker
Posted
November 16, 2021
piggy bank atop a bed of $100 bills

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 technologies鈥攔anging from complex Microsoft Excel spreadsheets and formulas to ever-sophisticated software.

绿巨人视频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) framework鈥攚hich 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 firms鈥擧uang 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.

鈥淭raditionally, auditing is quite labor intensive,鈥 said Huang.

Because of this reality, auditors have long engaged in a process known as sampling鈥攚hich involves taking a smaller portion of transactions and analyzing that portion to make determinations about the full quantity of transactions.

鈥淚n relation to audit data analytics, it鈥檚 important for students to develop a mindset."

鈥淭hey don鈥檛 take look at all of a business鈥 transactions. They鈥檒l just select, let鈥檚 say, 100 records as a representative sample of the population,鈥 said Huang. 鈥淭hen, with those records, they鈥檒l apply some audit procedures, and draw conclusions on the entire population.鈥

However, as Huang notes, this method has historically come with a risk, which is commonly known as鈥攜ou guessed it鈥攕ampling risk.

鈥淚f you only audit 100 records, your conclusion may be different from if you hypothetically audit the full population (thousands or possibly millions of records).鈥

Enter, data analytics. With the advantage of today鈥檚 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 auditor鈥檚 best interest?

鈥淥ne reason why accounting firms are hesitant to apply full population tests are the large number of outliers,鈥 notes Huang.

Outliers, are in essence, the red flags鈥攖ransactions 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 Huang鈥檚 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.

鈥淲e first start with the full population analysis,鈥 explains Huang. 鈥淏ased on whatever test or filters you need to apply, you鈥檒l first get a large set of outliers. That鈥檚 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.鈥

Finally, in the Stage Three output, Huang and his colleagues created a 鈥渟uspicion score,鈥 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 framework鈥攁s 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)鈥擧uang 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 today鈥檚 technological tools is paramount for success.

鈥淚n relation to audit data analytics, it鈥檚 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."

More Research At Pace:

绿巨人视频Magazine

Through a grant totaling nearly $500,000 Dyson professors Matthew Aiello-Lammens and Erika Crispo are helping elevate 绿巨人视频to new heights through incorporating data science into the biology and environmental science fields.

Faculty and Staff

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.

绿巨人视频Magazine

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.