New Electronic Ledger Reconciliation Report, ZFM_ELR_REPORT

Category: Financial

A new report is now available to assist departments, colleges, and campuses manage the electronic ledger reconciliation process. It can be accessed from the menu at IRIS Reporting > Financial > Funds Management > Detail Activity Reports > ZFM_ELR_REPORT.

The report compares the eligible funds for reconciliation to the electronic ledger reconciliation activity. This will provide a list for users based on their selection criteria of any reconciliation activity or lack thereof.

The selection screen requires a fiscal year and period, and one of the following fields must be selected:

  • Fund
  • Funds Center
  • Principal Investigator
  • Budget Entity Code
  • Dean/Director Code
  • Department Code
  • College Code

The Approver Status field can be used to show the fund’s status in workflow.

Check boxes are available to report only funds that meet the following criteria:

  • Approved > 30 days – what funds did not meet fiscal policy requirements and were either not approved or approved more than 30 days after being submitted to workflow.
  • Submitted > 45 days – what funds did not meet fiscal policy requirements and were not reconciled and submitted to workflow within 45 days after the month closed.
  • Submitted & Approved > 75 days – what funds did not meet fiscal policy requirements and were not reconciled, submitted, and approved in workflow within 75 days.

 

The resulting report will provide any electronic ledger reconciliation activity by fund, fiscal year, and period. Column headings and descriptions:

  • Fiscal Year
  • Period
  • Fund
  • No Activity – X = no financial postings exist on the fund. Blank = financial postings exist on the fund.
  • Funds Center
  • Budget Entity
  • College Code
  • Dean/Director Code
  • Department Code
  • Project type
  • Principal Investigator
  • Responsible Person of the funds center
  • Bookkeeper
  • Created by – User that initially started and saved the reconciliation.
  • Created on – Date the reconciliation was initially started and saved.
  • Changed by – User that last changed the reconciliation.
  • Changed on – Date the reconciliation was last changed.
  • Submitted by – User that submitted the reconciliation to workflow.
  • Date Submitted – Date the reconciliation was submitted to workflow
  • Approval Status –
  • Approver – User that approved the reconciliation work item.
  • Approval Date – Date the approver completed the work item.
  • Approved Days- number of days from date of workflow submission to approval in workflow.
  • Submitted Days – number of days from date of month end close until reconciliation is submitted to workflow.