If you use ACL (the standard data analytics tool for auditors), you might be wondering if what you do in ACL can be done in python. ACL helps auditors to do typical auditor tasks easily. 

For example, (i) Testing for duplicates; (ii) Ageing analysis to see overdue payments or open purchase orders; (iii) Showing the total value per user/ vendor/ customer to know the most important 3rd parties; (iv) Filtering journal entries on those that are manual and that have accounts that are rarely used or users that rarely post; (v) Sorting the list of sales order prices in increasing order to see unusually low prices; (vi) Using statistics and stratification to find outliers in a large data set. In this webclass we will take those commands and see how we can create our own repository of Python equivalents. We will share the repository and some dummy data with the group and see if anyone wants to contribute to that repository following the class.