Today, I assisted my senior with the CAATs job for a company. Unfortunately, we lacked the general ledgers for the JV test and sales-related documentation for the sales three-way match test. I attempted to contact the client for these missing documents, but the person in charge was unavailable due to a meeting.
Since I couldn't proceed with those tests, I focused on the payroll test instead. However, I was surprised to find that the company had a large number of staff, which meant I needed to be extra careful to avoid errors. When I received the salary listing, I noticed that it wasn't sorted by employee ID but rather by the department and the number of staff in each department. I realized that I couldn't perform the test unless the data was grouped by employee ID, so I reached out to the human resources person in charge.
Initially, she was reluctant to provide me with the necessary data and asked why we needed it this year when we didn't request it in the previous year. I explained to her that the test was not conducted last year, so we didn't require the same data. I also reassured her that the salary figure was optional for our test and that we didn't need that information. After some explanation, she agreed to resend me the salary listing grouped by employee ID.
Main things that have learnt:
To learn how to communicate with the person in charge of requesting confidential payroll-related documents.
Comment/idea/opinion
N/A
Comments