Incorporating Data Analytics in a Technical Tax Setting: A Case Using Excel and Tableau to Examine a Firm's Schedule M-3 and Tax Risk
- 22 January 2021
- journal article
- research article
- Published by American Accounting Association in Issues in Accounting Education
- Vol. 36 (2) , 129-139
Abstract
New tax accountants are expected to possess strong technical tax and data analytic skills. This case provides an opportunity to improve students' corporate tax and accounting for income taxes knowledge and experience with professional tax workpapers. It also provides exposure to two powerful data analytic platforms, Tableau and Excel. Students must complete a set of tax workpapers, including a Schedule M-3 reconciliation. Students begin to view tax through an analytical mindset, gaining familiarity with descriptive data for tax analyses. This case helps students calculate GAAP and cash effective tax rates, taxable income, temporary and permanent book-tax differences, and formulate a professional written communication. Students also complete tax workpapers; benchmark tax data across time and industry peers; clean, format, and combine data using Excel and Tableau; analyze and visualize data using Tableau; and access and use the IRS's SOI database. JEL Classification: H29; D89; A22; A23.Keywords
This publication has 20 references indexed in Scilit:
- The role of data visualization and analytics in performance management: Guiding entrepreneurial growth decisionsJournal of Accounting Education, 2017
- Taxes and Organizational Form: An Activity in Partnership and Corporate EntitiesIssues in Accounting Education, 2016
- Vistabeans coffee shop data analytics teaching caseJournal of Accounting Education, 2016
- Accounting education literature review (2015)Journal of Accounting Education, 2016
- Analyzing Data for Decision Making: Integrating Spreadsheet Modeling and Database QueryingIssues in Accounting Education, 2016
- The importance of the internal information environment for tax avoidanceJournal of Accounting and Economics, 2015
- Big Data in Accounting: An OverviewAccounting Horizons, 2015
- Shoe Zoo, Inc.: A Practice in Electronic Work Papers, Tick Mark Preparation, and Client Communication through the Audit of Property, Plant, and EquipmentIssues in Accounting Education, 2012
- Utopia Home Health, Inc.: A Case Study on C Corporation Taxation from Cradle to GraveIssues in Accounting Education, 2010
- Integrating AIS and Accounting for Income Taxes: From Calculation to DisclosureIssues in Accounting Education, 2010