This user group is for anyone who works with money in their data. Maybe you're in the finance or accounting department at your organization, or maybe you use Alteryx to analyze tax and audit data. Perhaps you work at a bank or are a consultant in the financial sector. No matter who you work for or what your title is - if there's money in your data, this user group is for you.
Please join us in sharing experiences, best practices and knowledge.
User Group Leaders:
Find tips to make the most of your User Group experience.LEARN MORE
I am Shawn and I work with CommScope a telecommunication company and I am looking to connect with other internal audit share use cases of Alteryx. We have been using Alteryx for a little over 6 months.
I'm an Alteryx partner and am certified in Alteryx. I also happen to be doing analytics within the IA space for over 19 years. If there's anything you need help with, don't hesitate to reach out.
Thanks for reaching out. I have currently used Alteryx for T&E, AP, and General ledger, but I would looking to expand into inventory and sales. I would especially interested in any predictive analytics.
Hello everyone. We just started using Alteryx in our internal audit group. I would love to discuss ideas and use cases as well. I'm using a Benfords Law workflow and a Principal Components workflow for an upcoming audit.
There's a lot of different analytics you can perform for sales / inventory from an audit perspective. An example of a few are as follows:
However from a predictive analytics standpoint, I use it to identify outliers in the data population and/or help identify future spend on TNE and/or future expenses to Vendors on AP.
Hope this helps.
Thanks Parm for the information it is very helpful.
Is it possible to create an internal audit user group to share ideas and possible solutions to workflow problems? I think it could benefit all of us as we continue to grow our analytic capabilities. We could have a periodic call to discuss trends, potential risk factors and problems we are facing.
We use Benfords Law to look at vendor invoice numbers in a payment file. The distribution of the first digit of invoice numbers, by vendor,by invoice, should fall into expected probability buckets based on the BL algorithm. Also we compare:
Attached is the workflow I found on the Community Forum. We added some filters based on vendor attributes (like some Telecom vendors often use the phone number as invoice number, other vendors use the same invoice number repeatedly, etc.)
Some people look at the distribution of the first 2 digits. I haven't seen where that adds value to the results.
If you set something up, make certain you are looking at the invoice level, not the itemized invoice level. The itemized level will give false positives.