You are currently employed by the company Transport Titania. You have been charged with preparing documentation for the auditor. Specifically, you have been asked to gather information related to the two quarters between January 1, 2017 and June 30, 2017, including the trial balance, summary of automated journal entries, and list of manual journal entries. You have downloaded these three items from the various information systems, but are concerned about whether the information is complete and accurate. Prior to handing the information to the auditors, you want to verify activity in the manual and automated journal entry files matches activity as recorded in the trial balance.

Prior to beginning this project, please familiarize yourself with the four files available:

• Chart of Accounts
• Summary of Automated JEs
• Manual JEs
• Trial Balance

Note 1: the chart of accounts is a summary of all accounts in the GL. Titania uses a code (COMBO_ACCT) that is unique to each account. In the JE lists, this account may be sub-divided into two columns.

Note 2: the automated JE list uses batch processing. As a result, activity is summarized by account. This is not the case for the manual JE listing.

Your job is to verify the JE listings are complete and accurate (i.e. the total activity matches the trial balance). Please create a new project in IDEA, and complete this task. Create a document titled Procedure detailing the exact steps you went through to verify the JE listings were complete and accurate. The procedure should be detailed enough that a manager could review it and understand your process.

If there are any accounts where the activity from the manual and automated journal entries does not equal the net activity on the trial balance, please list these accounts and the amount of the variance at the bottom of your document.

Final deliverable is a word document uploaded through Canvas, which should contain:

• List of any accounts where activity from the JEs does not match TB activity (10 points).
  • The amount of the variance between the two balances.
• A procedure outlining the steps you performed to reach your conclusion (40 points).