LAB $15-1($LO $15-12)$ Using Alteryx to Audit Accounting Data

Skip to question

$[$The following information applies to the questions displayed below.$]$

Lab Insight: In this lab you will use Alteryx to aggregate and analyze accounting data, which you can then write to an Excel spreadsheet. Before working on this assignment, you should review the concepts on accounting treatment of cash and accounts receivable. For information on how to download Alteryx see the Alteryx$\_$Installation$\_$and$\_$Intro file.

Required:

Write a report based on what you did in each part of this exercise. You need to comment on the findings as you were the auditor. Submit the files of Alteryx workflow and the output in Excel that you will use to assist the readers to follow your logic while reading your report.

Ask the Question: How can we use Alteryx to aggregate and analyze accounts receivable data, which we can then export the findings to an Excel spreadsheet for further analyses? The following examples demonstrate a common accounting task, creating an aging analysis of accounts receivable.

Master the Data:

Download and save the data file AR$\_$Data.xlsx$.$

Follow the lab instructions provided in the Word file: Lab$\_15\mathrm{.}1\_$Alteryx.

Lab $15-1$ Using Alteryx Part $1$: Create a one$-$dimension aging analysis

Part $1$ Analysis

Write a report based on what you did in Part $1$ of this exercise. You need to comment on the findings as you were the auditor. Submit the files of Alteryx workflow and the output in Excel that you will use to assist the readers to follow your logic while reading your report. Submit your files through your course LMS or as directed by your instructor.

Note: The Zip file is not compatible with Connect upload at this time.