Using Data Analytics and Visualization in Accounting and Auditing at Toby Biotech Inc.

by Tiffany Rasmussen


In this auditing and data visualization case on Toby Biotech Inc. (Toby), use of the data analytics tool Tableau and a certain amount of role-playing needs to occur to identify the accounting anomalies and to be able to ask questions for an in-class simulated audit client team meeting - which is a key learning objective. The class is usually broken up into teams of three to four students. Each student team is then assigned to role-play the audit team from Toby’s firm of independent auditors - TRG LLP - with the key roles being the partner (Jordan), the manager (Aaron) and the senior (Cameron). For this assignment, each student team prepares in advance for the simulated audit client meeting with Toby’s senior financial team, which will include the chief financial officer (Sage), the controller (Duncan) and the chief revenue officer (Taylor) - played by the instructor and teaching assistant—to go over the initial audit findings on accounts receivable (AR), the allowance for credit losses (ACL), the reserve for returns and allowances (RRA), and revenue recognition. Based upon the students’ analysis of Toby’s financial statements and the AR data prior to class, each student team will then present their assessment of Toby’s financial statement risks, share their data visualizations, ask the client questions, and suggest next audit steps in a class session in which the case is discussed.

Learning Objectives


This case study on Toby Biotech Inc. (Toby), a fictitious publicly-held company with offices worldwide, allows accounting students the opportunity to apply a data analytics and visualization software tool to an audit of financial statements. In this situation, students are asked to focus on certain financial statement accounts for Toby - account receivables (AR), the contra accounts allowance for credit losses (ACL), and reserve for returns and allowances (RRA) - and on revenue recognition, while using the Tableau software to identify anomalies, to pinpoint risks of material misstatement, to ask client’s questions, and to develop responsive audit procedures.


Details

Pub Date: July 1, 2021

Discipline: Auditing

Subjects: Accounting, Accounting Standards, Accounts Receivable, Allowance for Credit Losses, Revenue Recognition, Reserve for Returns and Allowances, Data Analytics, Data Visualization, Auditing

Product #: B5979-PDF-ENG

Industry: Auditing Services

Geography: California

Length: 6 page(s)


Berkeley Haas Case Series
Berkeley Haas Case Series The Berkeley Haas Case Series is a collection of business case studies written by faculty members at the Haas School of Business. Cases are conceived, developed, written, and published throughout the year, on subjects ranging from entrepreneurship and strategy to finance and marketing. Each case includes a teaching note for use in the classroom.

Recommended

Berkeley Haas Case Series

A new collection of business case studies from Berkeley Haas

The aim of the Berkeley Haas Case Series is to incite business innovation by clarifying disruptive trends and questioning the status quo.

Learn more
Follow Us