Sponsored Reports


Project Team Reference

The Project Team Reference Dashboard provides a report of team members, their roles, and their committed effort for Sponsored projects. It can be filtered by Award, Project, Role, and Team Member Name for current projects with the option to include past and future projects.
Please Note: The committed effort listed in this report reflects the effort level specified in the original proposal to the agency or otherwise explicitly negotiated with the agency prior to the award.

Award Analysis Dashboard

This dashboard includes sub-reports that break out data by school and department and show variances against prior periods. It provides Monthly/Annual Expenditures Reports, Award data, and a Five-Year Trend.

Budget to Actual Reporting - Sponsored Projects

Similar to the Budget to Actual Reporting dashboard in the FMS - Operational folder, this dashboard contains a summary and detail budget to actuals report and a financial trend report for life to date activity on Sponsored Projects.

Effort Analysis Report

Provides the percentage of committed effort, the percentage of charged effort, the percentage of certified effort and a variance of the certified vs. committed effort. The report can be run by Operating Unit, Department, Award, Project, Individual employee, or Assigned Pre-Reviewer. All effort pages that contain employee payroll have the same security as the labor report.
Therefore, only authorized charged or managed employee detail will appear based upon your security configuration.

Effort Salary Cap Report

Provides salary distribution for employees paid from sponsored projects. This report provides an indication that a salary cap exists for an award, as well as the amount of the salary cap, when applicable. In addition, this report provides a calculation of the maximum amount of salary the employee could charge per effort reporting period in order to avoid exceeding the sponsor-imposed salary cap.

Effort Status Report

Provides the ability to view the status (pending, pre-reviewed, certified) of effort certifications by Operating Unit, Department, Award, Project, or Assigned Pre-Reviewer. All effort pages that contain employee payroll have the same security as the labor report. Therefore, only authorized charged or managed employee detail will appear based upon your security configuration.

Proposal Analysis Dashboard

This Dashboard provides a monthly proposal statistics summarization of the number of proposals received by the university, as well as funding information for those proposals.

Sponsored Research Accounts Receivable Aging Report

Provides a report of payments to Emory on sponsored projects and their aging status if late. The report allows users to analyze late payments on Sponsored Projects and provides details regarding the agency information, contract information, PI, and invoice due dates. For late payments, aging is broken into periods of 1-30 days, 31-60 days, 61-90 days, 91-120 days, and greater than 120.

Sponsored Research Financial Summary

Previously available in FORS, the Sponsored Research Financial Summary provides a snapshot of the Cash and Budget position for a particular award.

The Report is multi-layered as follows:

  1. Shows the Asset and Liability position as well as Available Balance at an award level.
  2. Drill down on an Award resulting in a list of Projects associated with the selected award that shows the Asset and Liability position as well as Available Balance at a project level for that award.

In addition the report enables reporting for the 11330- Research Participant Payment Fund. The report can be run by Operating Unit, Department, PI, Award, Contract type, etc.