Account Status by Area Org

Provides financial status summary. This report does not display accounts with Fund #'s 1603, 1783, 1612, 1619, 1620, 1622, 1624, 1626, 1638, 1655, 1657, 1774, 1682, 1697, 1699, 1701, 1703, 1705, 1717, 1734, 1736, 1761. Funding associated with these agencies

Yes

Daily Account Status will be replaced by

Budget vs. Actual – Program Account Report

Also available in :

Sponsored Award Summary

Sponsored Award Overview

Aged Pre-Award Accounts by Area

Displays accounts in pre-award status and specifies the number of days from the start date. Expenses in pre-award accounts will be moved to the departmental non-sponsored account if proposal is not awarded.

GAP

No delivered report.  This report has a low priority, It will not be created.  Query would need to be developed

Aged Pre-Award Accounts by Area Class

Displays accounts in pre-award status and specifies the number of days from the start date. Expenses in pre-award accounts will be moved to the departmental non-sponsored account if proposal is not awarded.

GAP

No delivered report.  This report has a low priority, It will not be created.  Query would need to be developed

Agency Specific Expenses Categories Summary by Budget Period

Provides budget period expenses by selected agency category; Includes ability to drill down to transaction level detail. Expense categories for reserves (objects 7900 & 9500) are excluded.

GAP

No delivered report.   This report is complex it can not be developed in reporting instance. 

Budget Period Expense Summary

Provides budget period information for a specific sponsored project by expense category (object); Includes ability to drill down to other levels of detail.

GAP

No delivered report. Query would need to be developed in reporting instance. 

Daily Expense Summary

View current(to date) expense and balance information by the type of expense for one account

Yes

Transaction Listing and Activity by Account Report

Budget vs. Actual – Program by Account

Actual Rev/Exp by Period (Query and Report)

Data will be available on one of several reports depending on whether data needs to include open period information or not

Daily Project Status

View current (to date) account balance and total costs since the project began. May drill down to Daily Expense Summary (above).

Yes

Transaction Listing and Activity by Account Report

Budget vs. Actual – Program by Account;

Actual Rev/Exp by Period (Query and Report)

 Data will be available on one of several reports depending on whether data needs to include open period information or not

Daily Transaction Register

View the transactions that have hit your account in the current month (format similar to personal checkbook...lists transactions in date order).

Yes

Transaction Listing and Activity by Account Report

General Ledger Activity Report

Journal Entry Detail Report and Journal Inquiry Page

Fixed Price Account Balances by Area

Provides balances at project end date on fixed price accounts for a specific CUFS Area. Accounts with zero balance are not displayed.

GAP

No delivered report.  This report has a low priority, It will not be created.  Query would need to be developed

Fixed Price Account Balances by Area  Class

Provides balances at project end date on fixed price accounts for a specific CUFS Area Class. Accounts with zero balance are not displayed.

GAP

No delivered report.  This report has a low priority, It will not be created.  Query would need to be developed

Flexible Period Expense Summary

Displays expenses for a specified period of time (one month minimum).

GAP

No delivered report. Query would need to be developed in reporting instance. Units will need to be able to write a PS query.

Indirect Cost Recovery by Area

Provides summary data on how much Indirect Cost Recovery (ICR) has been generated (not allocated) and the negotiated and effective Indirect Cost (IDC) rates for a specific grant in the current fiscal year.  *Current IDC rate may not be applied to all direct costs

GAP

No delivered report. Query would need to be developed in reporting instance. Units will need to be able to write a PS query.

Indirect Cost Recovery Summary by Area Class

Provides summary data on how much Indirect Cost Recovery (ICR) has been generated by a CUFS Area for the current fiscal year. (object code 8500 by area)

GAP

No delivered report. Query would need to be developed in reporting instance. Units will need to be able to write a PS query.

Main/Multiple Project Summary

Displays main project account and all associated accounts for a sponsored project. The report provides information for inception-to-date only.

Yes

Account Activity Summary Report (GPC)

Payroll Encumbrance and Expense Summary

Provides salary, fringe, and stipend (object 7802 only) expense and encumbrance information summarized by person for a selected calendar month. The report returns data for the current fiscal year plus 5 preceding fiscal years. Additional payroll reports are available on the UM Reports website (www.umreports.umn.edu).

GAP

No delivered report Query would need to be developed in reporting instance.  Units will need to be able to write a Data Warehouse query.

PI Active Projects

View a project summary snapshot of all the active accounts for which you are the Principal or Co-Investigator

Yes

Account Activity Summary Report (GPC)

Program Income by Area

Provides inception-to-date reportable and non-reportable program income totals for all areas within the specified Area

Yes

Program income is a GL entry.  Transaction should be in system.  Query could be run in reporting instance. Units will need to be able to write a PS query.

Program Income by Area Class

Provides inception-to-date reportable and non-reportable program income totals for all areas within the specified Area Class

Yes

Program income is a GL entry.  Transaction should be in system.  Query could be run in reporting instance. Units will need to be able to write a PS query.

Project Summary-Expenses

View project summary budgeting, encumbering, and expense information by type of expense. Information is presented for both the current month as well as project-to-date. May also drill down to specific transactions. Equals expenses on UG213 report.

Yes

Budget vs. Actual – Program by Account

 Report and Account Activity summary Report

Project Summary-Revenues

Provides project inception-to-date as well as current month revenues by revenue source; Includes ability to drill down to other levels of detail. Does not provide revenues by a budget period. Equals revenue on UG213 report.

Yes

Budget vs. Actual -Program by Account Report

Proposal and Award Activity Report (By Area or Area Class)

Displays proposal and award activity for time period (based on submit date) and area or area class selected. Information can be shown in detail or summarized format. Detail report output will require landscape legal size paper. Questions regarding report data should be directed to the EGMSi Business Help Line at 612-624-1033.

Yes- In the future

This is on the list of reports to be developed by EFS reporting team.  It has a low priority score. Historical data should be available in Data Warehouse.

 PreA_GPC_078 (future report #) 

Salary Transfers by Area Class/College

Lists salary transfers for a selected Area Class/College and fiscal year (does not include transfers for object 7802).

GAP

No delivered report.  Query would need to be developed in reporting instance.  Units will need to be able to write a Data Warehouse query.

Salary Transfers by Area/Department

Lists salary transfers for a selected Area/Department and fiscal year (does not include transfers for object 7802).

GAP

No delivered report.  Query would need to be developed in reporting instance.  Units will need to be able to write a Data Warehouse query.

Salary Transfers by PI/Account

Lists salary transfers for a selected fiscal year and PI (does not include transfers for object 7802).

GAP

No delivered report.  Query would need to be developed in reporting instance.  Units will need to be able to write a Data Warehouse query

Spending Rate of Sponsored Accounts by Area

Displays percentage of balance and time remaining for all sponsored accounts for a specific CUFS Area. Report is sorted by PI Name.

Yes

The name of the report may be different. GPC_014_1 -Sponsored Award Summary

Spending Rate of Sponsored Accounts by PI

View how fast funds are being spent (burn rate) for a specific account. View percentage of project time remaining and percentage of available funds remaining, by budget period.

Yes

The name of the report may be different. GPC_014_1 -Sponsored Award Summary

Sponsored Accounts in Deficit by Area

Lists sponsored accounts for selected Area that are in overdraft for the PERIOD OF TIME SHOWN IN THE BUDGET PERIOD COLUMN.

GAP

No delivered report.  This report has a low priority, It will not be created.  Query would need to be developed

Sponsored Accounts in Deficit by Area Class

Lists sponsored accounts for selected Area Class that are in overdraft for the PERIOD OF TIME SHOWN IN THE BUDGET PERIOD COLUMN.

GAP

No delivered report.  This report has a low priority, It will not be created.  Query would need to be developed

Sponsored Accounts Receivable and Aging by Area

Provides open A/R aging by Area/Org. Conversion of existing awards will occur through May, 2004.

Yes

Sponsored Award Overview Report

Sponsored Accounts Receivable and Aging by Area Org

Provides project inception-to-date billed/received and open A/R aging. This report does not display accounts with Fund #'s 1603, 1783, 1612, 1619, 1620, 1622, 1624, 1626, 1638, 1655, 1657, 1774, 1682, 1697, 1699, 1701, 1703, 1705, 1717, 1734, 1736, 1761

Yes

Sponsored Award Overview Report

Sponsored Accounts Receivable and Aging by College – Org Detail

Provides open A/R by Area/Org. Conversion of existing awards will occur through May, 2004..

Yes

Sponsored Award Overview Report

Sponsored Accounts Receivable by College – Area Detail

Provides open A/R aging by Area. Conversion of existing awards will occur through May, 2004.

Yes

Sponsored Award Overview Report

Sponsored Financial Reporting Budget Period Adjustments

Provides budget period adjustments detail information at the Area/Org/Obj/Sub-object level

No

This will be accomplished differently in PS. 

Sponsored Suspect Income

An SFR oversight report to ensure compliance with a sponsor's requirements regarding program income. The report displays summary by account and detail transactions processed by departments to revenue source codes on sponsored accounts for a selected account

GAP

This is a report that SFR would need to provide. 

Transaction Detail by Area/Org/Fiscal Year

Yes

Transaction listing and Activity by Account Report

General ledger activity Report

Entry Detail Report Journal Inquiry Page

Transaction Detail –Expenses 

Lists individual expense transactions during a monthly period, similar to the UA611/UG201 CUFS reports; To be used for reconciling both sponsored and non-sponsored accounts

Yes

Transaction Listing and Activity by Account Report

General Ledger Activity Report

Journal Entry Detail Report and Journal Inquiry Page

Transaction Detail Revenues

Lists individual revenue transactions during a monthly period, similar to the UA611/UG201 CUFS reports; To be used for reconciling both sponsored and non-sponsored accounts

Yes

Transaction Listing and Activity by Account Report