This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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'm very new to Alteryx and I work in a small audit practice.
I would like to use Alteryx to manage account receivables confirmations. Does anyone have experience of doing this?
I start with a spreadsheet with year end accounts receivables balance, customer names, and a customer email address.
I want to send a unique email to each customer including the customer name and receivables balance within the text. I also want to be able to send an attachment with the email.
I'd like to be able to track whether customers have or have not responded to the email on a simple dashboard. I'd like to be able to send a reminder email to customers which haven't responded and an automatic thank you email to those who do respond.
I manage an Alteryx & Tableau server and one of our key areas of focus is controls around payments / sourcing. We use it to test for proper approvals in SAP / Arabia (Sourcing), split commitments (Sourcing), user access reviews (IS), and a number of other things. Our internal audit team and external audit both prefer to review 'manual' controls that have been automated in Alteryx vs. controls that are manually performed using Excel. The possibilities are pretty much endless, anything that took place in Excel and be done in Alteryx faster with more accuracy and less room for human error.
That is absolutely possible, I have done very similar things using Alteryx + Python. I would recommend starting on the project and then positing smaller direct questions in the designer discussion when you get stuck. Here are some links to get you started.