This is an internally developed program for SSMU, designed to assist auditing process of student-run clubs.
-
First, create a folder called 'Transaction Lists'
- This is where all of your transaction lists should be stored
-
Inside that folder, create a folder called 'Audit Report'
- This is where the reports will be automatically generated from the transaction lists
- You need at least 3 excel files for the program to run:
- list of clubs' unique identification (CLU)
- list of concerning keywords you're interested in detecting
- transaction list(s)
The top 4 variables indicate where your files are located / to be located.
- file_names -> indicates file path to the list of clubs
- keywords -> indicates file path to the list of keywords
- audit_report_file_path -> where the reports are to be populated
- clu_file_path -> the transaction list follows naming convention containing the club's CLU number. Enter file path just up until CLU
-
Better commentation
-
Dynamic formatting; xlsxwriter is a bit hardcoded in terms of spacing, etc.
-
Many more keywords need to be added
- Richie Youm