Today, we returned to our Kuala Lumpur office to work on the paperwork for the three companies we conducted fieldwork on. One particular company caught my attention as I needed to conduct a CAATs test. To my surprise, the company has 16 subsidiaries, which means I need to perform data cleaning for all of them.
I requested the documentation from the auditor in charge but encountered an issue when I found out that the file provided was corrupted and could not be opened. To resolve this issue, my senior instructed me to ask the auditor to upload the documents onto the APT platform so that my senior can access and download the files for me.
Main things that have learnt
To learn how to perform data cleaning for company that has large number of subsidiaries
To learn how to solve the problem when the documents received are corrupted
Comment/idea/opinion
As the companies have 16 subsidiaries, and I need to perform CAATs test for all of them, so I need to be very careful during my data cleaning process if it is not done carefully, then I might need to take extra time to redo it and it will be time-consuming.
Comments