ipl-logo

Forensic Journal Entry Analysis

1167 Words5 Pages

TO: Audit Files for Koala Corporation FY2005 FROM: Forensic Journal Entry Analysis Team—Ryan Polk CC: Work Paper File CLIENT: Koala Corporation PERIOD: 1/1/2005 – 12/31/2005 Prepared by: Ryan Polk DATE: July 28, 2015 W/P reference: 15.1 Subject: Procedures completed to determine that the manual journal entries are complete The forensics team was asked by John Smith, the partner on the engagement with Koala Corporation, to assist the engagement team in its analysis of the manual journal entries for the fiscal year ending 12/31/2005. In response to the request, we obtained and analyzed the manual and automatic journal entries and advised the engagement team of our observations. The objective of the assignment was to determine whether the manual journal entries were complete during the fiscal year In order to determine whether the manual journal entries were complete, we needed to reconcile the provided totals from the automatic journal entry database by account and manual journal entries database with the trial balance. If there were no differences when adding the totals in each account from the manual and automatic journal …show more content…

In order to fix that problem, we appended an additional column to the joined database which included the appropriate account number, ignoring any blank values. Additionally, in order to properly set up the reconciliation, the total change by account due to the automatic and manual journal entries needed to be added together. To accomplish this, we appended an additional column to the database and summed the total values for the changes by account from the automatic and manual journal entries. Overall, the two appends produced columns with a complete set of account numbers and the associated changes during the year in each account from the journal

Open Document