THE CASE  

Company Background 

You were recently promoted to audit senior at your firm, Aoife & Josephine LLP, and one of your primary clients is Souper Bowl Inc. Souper Bowl (“the company”) is a privately-held business headquartered in Maine with a fiscal year end of December 31. The company has been in business for ten years and prides itself on offering creative soups made with locally sourced ingredients at a reasonable price. The most popular soups include sweet potato corn chowder, curried root vegetable and lentil, and maple-roasted butternut squash. Souper Bowl typically experiences increased sales during winter months since soup hits the spot on a cold and snowy day. To further encourage sales on days when customers often avoid venturing outside, the company provides a delivery service and guarantees that soup can be delivered to anyone no matter the weather. The company found this strategy to be particularly successful in 2015 when New England (including Maine) experienced record snowfall during February and March. 

Souper Bowl sells soup out of several restaurant locations throughout Maine. The company employs three managers that direct the day-to-day operations for a set of stores that are organized by approximate geographic region: northern Maine (store type 1), mid-Maine (store type 2), and coastal Maine (store type 3). Appendix A provides a map of these store locations. Each manager knows their local market well and has the flexibility to advertise and offer promotions with the overall goal of increasing sales year over year. Because of warmer weather and less snowfall in 2016, the company developed a new incentive plan for 2017 to boost sales. The manager whose set of locations (i.e., “store type”) has the highest year-over-year growth (%) will earn a monetary bonus from the company.  

An audit of the company is required to comply with the debt covenants related to a large bank loan that the company entered into when it began operations. Specifically, Souper Bowl must provide audited annual financial statements to the bank within 90 days of the fiscal year end. The company must also provide unaudited quarterly financial statements to the bank within 45 days of each quarter end. The debt contract includes a financial covenant requiring that pre-tax income in each quarter is greater than zero. If not met, the bank has multiple remedies at its disposal including calling the loan such that the entire balance is due immediately, seizing the company’s assets that are posted as collateral, or providing a waiver for the violation. Souper Bowl’s net income for the year ended December 31, 2017 is $668,654, while net income for the prior year ended December 31, 2016 was $468,810. 

Auditing Revenues 

As part of your new role as audit senior, you will be performing a large portion of the planning and testing of sales for the 2017 audit of Souper Bowl. AU-C Section 240.26 states that “when identifying and assessing the risks of material misstatement due to fraud, the auditor should, based on a presumption that risks of fraud exist in revenue recognition, evaluate which types of revenue, revenue transactions, or assertions give rise to such risks.” During planning for the audit, the partner and manager determined that the following three management assertions represent significant risks for revenues:  

1) recorded sales occurred; 

2) sales are accurately recorded; and,  

3) sales are recorded in the proper period.  

In prior years, the audit approach relied on random sampling to test revenues. However, the partner wanted to develop more focused procedures in the current year to hone in on potentially riskier sales transactions. As a result, the plan is to perform disaggregated sales analytics to identify unusual trends in the daily sales data with the goal of identifying sales on specific days at specific store locations that should be subjected to substantive testing due to heightened risks. The remainder of the population would then be sampled using a random sampling approach.   

Based on your experience from prior audits, you know that Souper Bowl’s daily sales fluctuate with temperature and snow accumulation. To perform your revenue analytics, you request a file from the client that includes daily sales by store location for both 2017 (current year) and 2016 (prior year). You also retrieve daily weather data from the National Oceanic and Atmospheric Administration’s (NOAA) website for the weather centers closest to Souper Bowl’s store locations.  Total revenue for the current year ended December 31, 2017 is $18.2 million, while total revenue for the prior year ended December 31, 2016 was $17.4 million. The audit team’s workpapers include the following lead sheet for revenue testing, and the total balances for each year agree to the trial balance and the company’s draft financial statements for 2017. 

Your manager stated that Tableau is a popular data visualization tool that your firm recently adopted and she instructed that you learn how to use it to perform these sales analytics. Since she is very busy overseeing the planning and testing of other audit areas, she wants you to take the first pass and then document your results in a memo for her review. The manager wants to see thoughtful analyses and a thorough exploration of the possible relationships in the data. You are eager to impress her with your work, especially following your recent promotion to senior. 

Requirements 

1. Read the articles assigned by your instructor to gain an understanding about how big data, data analytics, and new technologies are transforming external audits (available on Canvas).   

• Cao, M., R. Chychyla, and T. Stewart. 2015. Big data analytics in financial statement audits. Accounting Horizons 29 (2): 423-429. 

• Tysiac, K. 2020. How firms are delivering value with audit data analytics. Journal of Accountancy (January 21, 2020). 

After reading these articles, provide a response to the following two questions: 

a. Discuss at least three specific ways in which big data, data analytics, and new technologies can enhance external audits. How does each item discussed improve the effectiveness and/or efficiency of the audit? 

b. On the other hand, what challenges do auditors face when using big data, data analytics, and new technologies during the audit? 

2. As noted in the case, auditing standards specifically require auditors to identify revenue recognition as a fraud risk in most audits. Based the case information provided above and your understanding of the company, what factors may increase the risk of fraudulent financial reporting in Souper Bowl’s 2017 revenues? 

3. Use the daily sales by location from the client (2017 and 2016) and the weather data from NOAA to perform disaggregated sales analytics in Tableau. Your goal is to develop visualizations that identify potential outliers in the 2017 daily sales data related to the significant risks identified by the partner and manager. Using the memo template in Appendix B, document your analyses and conclusions as to the specific daily sales from certain locations that you recommend selecting for focused substantive testing.  

Note: Your conclusion needs to be precise enough to pull specific transactions—for example, you would not list the ‘month of March’ in store 1010 because this would result in too many observations to feasibly test. Also, you should not recommend testing observations from 2016. Your engagement team completed that audit in the prior year— instead, you are using 2016 data as a component of your baseline prediction for 2017. 

REFERENCES 

Christensen, B., R. Elder, and S. Glover. 2015. Behind the numbers: Insights into large audit firm sampling policies. Accounting Horizons 29 (1): 61-81. 

Cunningham, L. M. and S. E. Stein. 2018. Using visualization software in the audit of revenue transactions to identify anomalies. Issues in Accounting Education 33 (4): 33-46.

APPENDIX A 

MAP OF STORE LOCATIONS FOR SOUPER BOWL, INC.

data-file2016-2017

cao-et-al-2015-big-data-analytics-in-financial-statement-audits

how-firms-are-delivering-value-with-audit-data-analytics-journal-of-accountancy