Today, I spent half of my day converting the PDF general ledgers into Excel files, and the other half focused on data cleaning. My senior emphasized the importance of being careful during the data cleaning process, as any mistakes could require me to redo the entire process, which would be time-consuming given the large size of the general ledgers.
During the data cleaning process, I focused on extracting the most important fields for the JV test, such as the account codes, account names, debit and credit amounts, dates, and document numbers. I bought my senior's guidance on how to extract these fields and ensure their accuracy. I was able to cross-check the data I obtained by comparing the total debit and credit amounts to the grand total amount stated in the general ledgers.
It took me around four to five hours to merge all the cleaned data and proceed with the JV test. Meanwhile, another senior has asked me to join her for fieldwork tomorrow.
Main things that have learnt:
To learn how to perform JV CAATs test for a company that has a large size of general ledger documents.
Comment/idea/opinion
N/A
Comments