Using the Audit Report to Find Updated or Deleted Transactions

If you are unable to find the cause of a reconciliation error within the time frame it became out of balance, then it is possible that a historical transaction was edited or deleted from within the account.

To locate an updated or deleted transaction from the Audit report, complete the following steps:

  1. From an Account window, click on the Transaction page.

  2. Click the Audit Report button from the grid-view toolbar.

  3. Double click on the Insert column heading.  Note the following fields:

    1. Insert=transaction was added.

    2. Update=transaction was updated.

    3. Delete=transaction was deleted.

  4. From the Insert column, locate transactions that have been updated and deleted.

    1. Updated transactions will be listed on top.

    2. Deleted transactions will be listed on the bottom.

  5. From the Create Date column, look for the most recent Create date, and verify whether these transactions were legitimate.

  6. Export the transactions out of the Audit Report so that you can easily reference them. 

  7. Exit out of the Audit Report.

  8. Compare the transactions in question within the account against the Custodian transactions. Click here for information on how to compare transactions against the custodian.

Note: Exporting the Audit Report to Excel will allow you to customize the columns within your report and sort by only necessary columns.

 

See Also

Comparing Custodian and Morningstar Transactions