Right now, the power to solve new global challenges across industries, is at your fingertips, no matter where you're working from. Create a new topic or reply to an existing thread to share your perspective.

Industry Discussions

Share resources, connect with others, and discuss industry-specific challenges.
SOLVED

Internal Audit

shawnbearsphelan
6 - Meteoroid

Hello,

 

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. 

28 REPLIES 28
alex
11 - Bolide

Hello Shawn,

 

I've used it in a variety of ways to help clients with reviewing financials for the month end close and annual audits based on account rules (must be debit balance, variance over prior year, variance to budget, should not be zero, etc.).  I've also used it to review transaction level details, payroll data and to create data tables for a Excel based financials that are fed from pivot tables.  The sky is the limit.  Feel free to reach out if you have any specific questions or needs.

 

Alex

alyon
10 - Fireball

Hi @JenP ! 

 

I would like to connect with you but your private message setting is off so I couldn't send you a message. Whenever

you can, contact me at alyon@dcpmidstream.com. 

 

Best, 

 

Alejandra Lyon

aristiguieta
8 - Asteroid

Hi @JenP, sorry for the late reply...

 

Anyway, ... for the risk rank it is a simple 1 to 3 scale based on what we know is a stronger indicator (like paid more than 30 days after being terminated or before being hired) vs a complement indicator (not much on its own, but important when other things are at play, like being paid by physical checks that can be endorsed).

the score for the risk ranking each test may change (adjusted by hand) by what we learn during the review/follow-up. for example, based on the number of actual problems found by a test vs false positives; and in principle the scale can go as high as needed for tests that become actual smoking guns with fingerprints! 😉

 

On the predictive test the idea was that the system would choose the factors of importance on its own (every time it ran), but from the early results we found that things like the higher the complexity of the expense report the higher chances of approval (likely rubber stamp). when I say complexity I mean things like: time separation between the first and last expense included, number of locations (one city vs several countries), number of line items, etc. 

 

Other factors that were interesting were the seniority of the submitter and the number of direct reports to the reviewer/aprover.

 

rsomani005
8 - Asteroid

Hi JenP,

 

The example of Benfords law was quite intriguing. A follow up question on this is, lets say I test my data against Benfords Law and my results are significantly off (Say 1 is occurring 50% of the time as opposed to prediction under Benford law of 30%) what conclusions does one draw next?

JenP
6 - Meteoroid

@rsomani005 

 

Greetings.  If '1' is occurring at 50% level, the next steps would be:

1) Look at the vendors that make up the 50%: can you isolate which ones are driving the outliers?

2) If you can isolate these vendors, ask yourself does it make sense the vendors are outliers...

            a) maybe the vendor sequences all their invoice # to begin with '1'

            b) maybe the invoice number isn't a 'real' invoice number (like an telecom vendor that begins the invoice # with 1(800)...

3) If it doesn't make sense for a vendor to have a high number of invoice #'s beginning with '1'....take a look at some of the invoices, talk to AP, Google the vendor for more info.  Dig deeper by asking around.

4) You can also fine tune your workflow to do the analysis around only higher risk vendors ...say vendors without a PO number,etc

 

Hope this helps,

Jen

jacob_kahn
12 - Quasar

@shawnbearsphelan 

 

I am a tax accountant at Grant Thornton LLP

 

Please let me know if there is anyway I/we can assist our organization in any way in adopting Alteryx and in use-case build out.

 

Feel free to DM me or connect via LinkedIn, Instagram or one of the many other social platforms around.

 

Sincerely,

 

 

jacob_kahn
12 - Quasar

@JeremyN 

 

I'm a tax accountant and Advanced Alteryx Certified User! Let me know if I can help in any way 🙂

 

Feel free to DM me or reach out on LinkedIn or my social media accounts on my account profile!

 

Sincerely,

esoden
8 - Asteroid

March 4, 2021: We just posted this webinar specific to Internal Audit: https://capitalizeconsulting.com/webinar/streamlining-internal-audit-with-alteryx-analytic-process-a...

SahilArora3139
8 - Asteroid

@aristiguieta Hi can you share some sample workflows for risk i am curious to work on these parameters as i am also working with a firm who is working on risk automation.

and i have currently built my workflow on t&e