We provide the solution to this challenge using:
Need a program? Click here.
This challenge works in connection with Challenge 52|ALTERYX – Balance Sheet Boost. As a first-year associate who recently graduated from school, you have joined a small local accounting firm in the area. Your first assignment is to audit the Financial Statement Controls of a local chain of car repair shops. The senior member of the engagement team informed you that they had strengthened the controls around the income statement in the previous year. However, they remain concerned about some of the controls around certain balance sheet accounts that do not meet the firm’s standards.
You decide to use your skills in Alteryx to identify balance sheet accounts that require the most attention during the audit. After meeting with others on the engagement team, you determine that accounts that have 1,000 transactions or more during the month and have an ending debit or credit balance of 50,000 or more will require the most attention. You notify the other members of the audit engagement that you will find which accounts meet these criteria.
Using Alteryx, create a workflow to identify which accounts meet the aforementioned criteria. Remember, accounts must have 1,000 transactions or more and have an ending debit or credit balance of 50,000 or more. Sort by the number of transactions in descending order and be sure to sort out the data that has a null account number. In the end, your output should have the following columns: Acct, GLAcctDesc, EndingDebitBalances, NumOfTransactions.
Suggestions and Hints
When trying to find the accounts that follow the criteria of having an ending debit or credit balance of $50,000 or more, remember that we are given the ending debit balance. Using absolute value can help you get around this problem.