Reports
Monthly Reports
The monthly set of financial reports consists of three types of reports:
SAPPHIRE contains a Guide to Reading the University of Nebraska Monthly Reports. This guide contains detailed information on how to read each of the above reports, which will not be covered in the following information.
The month-end reporting process starts at approximately 7:00 P.M. on the last working day of the month. Revenues are reported with their natural sign as a negative, which indicates a credit. Expenses are reported with their natural sign as a positive, which indicates a debit.
SAP Cost Center Revenue and Expense Summary reports
These reports summarize budgeted and actual revenues, expenses and transfers by cost element for a given time period. The budget or plan is displayed in the initial column followed by actual results for the month and year. Commitments for the fiscal year are then listed. The variance (difference between the plan and the cumulative activity plus commitments) is calculated as a dollar amount and as a percentage. Users can drill down to the Actual, Plan and Commitment Line Item reports. The three different variations of Revenue and Expense Summary Report include:
Cost Center Revenue/Expense Summary Report without Benefits
This report excludes benefits and should only be run for state-aided, non-revolving cost centers. Please note that this report should NOT be used to review the balances on cost centers that are funded by Tobacco, Research Incentive Funds (RIF), Nebraska Research Incentive (NRI) or Programs of Excellence (POE) dollars. These specific state-aided, non-revolving accounts are responsible for benefit expenses.
Refer to the Reference Guide for this report on SAPPHIRE for additionalinformation.
Cost Center Revenue/Expense Summary Report with Prior Year Balance Forward
This report provides a summary of the current and prior year activity on individual cost centers and includes both the prior fiscal year balance forward and the current fund balance. The prior year balance forward is only applicable on the state-aided revolving or auxiliary cost centers. Fund balance information will only be presented on the cost center that is equivalent to the fund.
Refer to the Reference Guide for this report on SAPPHIRE for additional information.
WBS Revenue and Expense Summary Report
This report provides a summary of the current and prior year activity on individual WBS elements, such as grants, contracts and other externally sponsored activities. If more than one WBS element is included in a Project, this report will summarize the information for the project, as well as, offer the individual Revenue and Expense Summary reports on each WBS element.
Refer to the Reference Guide for this report on SAPPHIRE for additional information.
SAP LINE ITEM REPORTS
Click here for a table of Document Types that may appear on your line item reports.
Each of the following reports is available for both cost centers and WBS elements:
Detail/Actual Line Item Report:
This report lists the individual documents that were posted during the specified time period. It is critically important that departments verify all posted financial transactions to ensure that the correct cost object and cost element were charged. If errors are discovered in the posting of operating revenue or expenses, SAP on-line users should create a journal entry to transfer the income/expenditure to the correct cost object.
Commitment Line Item Report
This report lists all open commitments for the current fiscal year. Commitments include open purchase orders, purchase requisitions, projected salary expenses and manual fund commitments. It is important to review your open purchase orders closely, especially at fiscal year end, as they will be used to carry forward budget on state-aided activities.
Plan Line Item Report
This report provides detailed information regarding the original budget and any adjustments, by cost element. Budget changes are first submitted and recorded on the PSL (Personal Services Ledger), and then uploaded into SAP. If several changes are entered into the PSL at one time, only the net affect will be reflected on the Plan Line Item Report. For the detail of these combination entries, refer to the PSL Budget Reconciliation Report, in Mynulook, within the University/Budget section.
SAP Funds Management Summary Report
This report provides a high level budget/actual summary of major revenue and expense categories for all state-aided revolving (22) and auxiliary (23) cost centers and year-to-date trust (27) WBS elements sharing the same Fund Center (department) and Fund (source of funding). It gives a complete picture of each revolving or self-supporting activity, including the balance carried forward from prior years.
