Today, there are two tasks I am working on, the first is to help Kar Enn to go CAATs journal voucher test for two companies namely Tarumas Padu Sdn Bhd and Adient Automotive Holding Bhd. The second task I am working on is to update the information request list for YX Precious Metal Bhd.
For the first task, I received an email from Kar Enn and inside there is a link for me to access to the general ledgers and trial balance of the firms, it has the zip files and extracted files. The first step I did is to download the general ledgers and trial balance files, then I see what are fields it has, as I then need to proceed to clean them. The fields contained in the trial balance are GL Account, GL Description, Sub-Account, Cost Center Account, Opening Balance BC, Period Debut BC, Period Debit BC, Period Credit BC, BC Balance, Entity Code, TC Balance, Layer Code, Intercompany, Cost Center, Project, Currency, SC Balance, GL Category, GL Type, Daybook Code, Layer Type, Active GL Account, Balance Sheet Account, Sub-Account Analysis, Fixed IC, Base Currency Account, Project Analysis. I noticed that some fields are actually repeated and what I do in my data cleaning job is I take out those fields that are repeated and the ones I think are unnecessary to have, so what is left is only the Company Code, GL Account, GL Description, Opening balance, Ending balance. Next, going to the general ledgers, same as the trial balance, it also has a lot of fields, which are: Entity, GL Account, GL Period, Daybook Code, Type, Voucher, Posting Date, Currency, BC Balance, Layer Code, Description, Third Party, External Invoice Reference, Sub-Account Code, Sub-Account Description, Creator, TC Debit, TC Credit, BC Curr, BC Debit, BC Credit, Cost Center, SC Curr, SC Debit, SC Credit, GL Description, GL Type, Cost Center Description, Project, Daybook Type, Daybook Description, Posting Description and etc, I then clean it and let it to only have the fields of GL Account, Posting Date, System Date, Description, TC Debit, TC Credit, GL Description, Creator, GL Type, Daybook Type, Voucher, Year, Month.
After cleaning the data, then I jumped to the IDEA, like what I have practiced for other JV tests, and then found out there is no variance being produced. I moved to the second task, which is to help Ili update the information request list. I opened two files, one is the information request list excel file another is the folder of the client’s given evidence, I compare and cross-check each other for those that have provided, and I will remark it as received for those that haven't received, I will remark it as pending, after that I double check everything and send it to Ili, I believe the next move for Ili is to send the file to the client an inform her that those are the files we are still waiting for her to provide us.
Main things that have learned
Help Kar Enn to do GL test for Tarumas Padu Sdn Bhd
Done update IRL for Tomei
Comment/idea/opinion
Data cleaning work might be a burdening task as we need to go through the fields and use our judgment to judge which fields are necessary and which ones are not, if it is picked wrongly, it might affect the next step when we are processing the data onto the IDEA.
Comments