Day 14 (4 Nov 2022)

Today, I will be helping another colleague, Kar Enn to do CAATs for a company namely Envictus group, it has six subsidiaries under the group and one of them is Texas Chicken Malaysia. Kar Enn emailed me all the Excel files and each of them is grouped properly according to the company and type of test. The first thing I did is to roughly go through all the Excel data to see whether the files are complete or not. I noticed that some company, they are without some necessary documents that are required for the CAATs test, I jotted down the document that the particular company is lacking and asked Kar Enn’s opinion on it, Kar Enn then emailed the client to request them to provide us the missing documents, the table below list out the documents that are missing from the particular company.

Besides missing document, another problem I found is some excel file cannot be opened and is corrupted as the picture below shows.

Kar Enn also mentioned this problem in the email and ask a client to resend us the document. In return, the client did resend us the requested document however for the sales order archive as we listed in the email, the client replied that they are not able to provide us as they also didn't have the document due to the reason that the sales are handled in POS. One more problem that I found is for the company Texas Chicken Malaysia, does not have the outstanding invoice and account receivable summary, client then mentioned they are unable to provide us as they can not be exported by Navision itself as the data exceeded the limitation of 2GB. Kar Enn then mentioned me to proceed the test without the missing document.

I started the aging test as the first test. For the aging test, I noticed that the companies have different outstanding days, for example, some are until 150 days, while some are only until 120 days, it then means that I can't append all six companies into one but I need to do the test individually. As normal, I cleaned the raw data, then used the cleaned outstanding invoice list, put it to the prepared template, and then use the pivotal function to get the summary of each debtor and their respective owing amount according to the duration, it is then being used to compare with client’s prepared debtor summary, the variances are then being shown.

---

Main things that have learned

• Check the completeness of the document

• Deal with corrupted excel file

• Deal with missing document

• Conduct aging test

---

Comment/idea/opinion

Communication with clients is important like how I encountered today, when we found anything wrong with the document, we need to contact with the client as soon as possible so that we can deal and settle the problem fastly.