community
cancel
Showing results for 
Search instead for 
Did you mean: 

community Lounge

Get to know your fellow analytics buffs and discuss a wide range of topics!
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now! Learn more.

Using Alteryx in External Audit

Highlighted
Meteoroid

 

Hello Alteryx Community!

 

I’m an Assurance Associate at an audit firm, working in the UK. I’m looking for ideas/examples of how you could use Alteryx in an external audit context to make certain tests quicker and more efficient.

 

A few of my colleagues and I have started implementing it for simple tasks, such as filtering transactional data for certain GL codes to generate listings, and formatting, data cleansing and unioning system-generated reports for consistency. Our Data team also uses Alteryx in Journals testing, using a join on the opening and closing TB to search for new GL codes. It then performs a completeness check by summing all the debits and credits from the transactional data to reconcile them to the closing TB.

 

I’ve seen a couple of great examples in the Alteryx Use Cases section of the site. @IK123  has built a workflow to automate reconciliations by using optical character recognition (OCR) on reports and documents, which can be used for bank recs (see ‘KPMG Netherlands is Digitizing Auditing with Alteryx’ post). There’s a cool workflow from @cgoodman3  which also uses OCR to search over 1,000 documents downloaded from Companies House for a specific search criteria (see ‘Automatically Download PDF Documents from UK Companies House’ post).

 

I’d love to hear from anyone working in external audit who has managed to implement Alteryx in their testing.

 

Thanks!

 

Paul

Meteoroid

Hey @pengland17,

 

Great to hear of your Alteryx journey so far! I also work in a team that supports external audit and would be interested in any suggestions that people have.

 

Happy Alteryxing