University of Missouri System

Office of the Controller

Web Applications

 

PeopleSoft Financial Reports

• Budget Variance – Summary of budgeted revenues and expenditures compared to actuals.
• Income Statement – Detail and summary reports of actual revenues and expenditures.
• Balance Sheet – Report on assets and liabilities

 

Budget Variance Reports

A budget variance report would be used when you want to look at budgeted revenues and expenditures.

Summary budget variance reports are available based on the given information:

• Rpt1 – Fund and DeptId
• Rpt2 – Fund, DeptId, and Program
• Rpt3 – Fund, DeptId, and Project
• Rpt4 – Fund, DeptId, and Class
• Rpt5 – Fund and DeptId, grouped by Class within Account
• Rpt6 – Fund and DeptId, grouped by Account within Class
• Rpt7 – Fund and DeptId, grouped by Account within Program
• Rpt8 – Projects, grouped by Account within Fund
• Rpt9 – Projects, grouped by Fund within Account
• Summary Budget Report – Budget Level, Fund Level and DeptNode

 

Select the report you want to run and then click Go

 

Report 1 – Fund and DeptId

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual DeptIds. It also provides for the selection of a Fund(s) when the DeptId is associated with multiple Funds. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

1. Enter the following information in the criteria boxes:
   • DeptId – Enter the DeptId or search using the search button ( ).
     • Hit Tab key to populate Business Unit and Budget Level.
   • Business Unit – Populates based on DeptId selected, or may be selected using the drop-down list.
   • Budget Period – Defaults to the current budget period, but may be changed.
   • Fiscal Year – Defaults to the current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Populates based on the selected DeptId.
     • Budget Level 1 – For DeptIds budgeted at Level 1
     • Budget Level 2 – For DeptIds budgeted at Level 2
     • Budget Level G – For Grant and Contract DeptIds
     • Budget Hospital – For Hospital DeptIds
   • Funds (optional) – Enter Fund number(s) or search using search button. Leave blank to return all Funds.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.

2. Click Run Report.

 

 

Report 2 – Fund, DeptId, and Program

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual DeptIds. It also provides for the selection of a Funds or Programs when the DeptId is associated with multiple Funds or Programs. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

 

1. Enter the following in the criteria boxes:
   • DeptId – Enter the DeptId(s) or search using the search button ( ).
     • Hit Tab key to populate Business Unit and Budget Level.
   • Business Unit – Populates based on the selected DeptId, or may be selected using the drop-down list.
   • Budget Period – Defaults to current budget period, but may be changed.
   • Fiscal Year – Defaults to current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Populates based on the selected DeptId.
     • Budget Level 1 – For DeptIds budgeted at Level 1
     • Budget Level 2 – For DeptIds budgeted at Level 2
     • Budget Level G – For Grant and Contract DeptIds
     • Budget Hospital – For Hospital DeptIds
   • Funds (optional) – Enter the Fund number(s) or search using the search button. Leave blank to return all Funds.
   • Programs – Enter the Program number(s) or search using the search button.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
2. Click Run Report.
   

 

Report 3 – Fund, DeptId, and Project

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual DeptIds. It also provides for the selection of a Funds or Projects when the DeptId is associated with multiple Funds or Projects. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

1. Enter the following information in the criteria boxes:
   • DeptId – Enter the DeptId(s) or search using the search button ( ).
     • Hit Tab key to populate Business Unit and Budget Level.
   • Business Unit – Populates based on the selected DeptId, or may be selected using the drop-down list.
   • Budget Period – Defaults to 0, but may be changed depending on Project.
   • Fiscal Year – Defaults to current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Funds (optional) – Enter the Fund number(s) or search using the search button. Leave blank to return all Funds.
   • Projects – Enter the Project number(s) or search using the search button.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
2. Click Run Report.

 

 

Report 4 – Fund, DeptId, and Class

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual DeptIds. It also provides for the selection of a Fund, Class, or Program when the DeptId is associated with multiple Funds, Classes, or Programs. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

1. Enter the following information in the criteria boxes:
   • DeptId – Enter the DeptId(s) or search using the search button ( ).
     • Hit Tab key to populate Business Unit and Budget Level.
   • Business Unit – Populates based on the selected DeptId, or may be selected using the drop-down list.
   • Budget Period – Defaults to current budget period, but may be changed.
   • Fiscal Year – Defaults to current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Populates based on the selected DeptId.
     • Budget Level 1 – For DeptIds budgeted at Level 1
     • Budget Level 2 – For DeptIds budgeted at Level 2
     • Budget Level G – For Grant and Contract DeptIds
     • Budget Hospital – For Hospital DeptIds
   • Funds (optional) – Enter the Fund number(s) or search using the search button. Leave blank to return all funds.
   • Class (optional) – Enter the Class number(s) or search using the search button. Leave blank to return all Classes.
   • Programs (optional) – Enter the Program number(s) or search using the search button. Leave blank to return all Programs.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
2. Click Run Report.
   

 

Report 5 – Fund and DeptId, grouped by Class within Account

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual DeptIds. It also provides for the selection of a Fund(s) when the DeptId is associated with multiple Funds. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY, grouped by Class within Account. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

1. Enter the following information in the criteria boxes:
   • DeptId – Enter the DeptId(s) or search using the search button ( ).
     • Hit Tab key to populate Business Unit and Budget Level.
   • Business Unit – Populates based on the selected DeptId, or may be selected using the drop-down list.
   • Budget Period – Defaults to current budget period, but may be changed.
   • Fiscal Year – Defaults to current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Populates based on the selected DeptId.
     • Budget Level 1 – For DeptIds budgeted at Level 1
     • Budget Level 2 – For DeptIds budgeted at Level 2
     • Budget Level G – For Grant and Contract DeptIds
     • Budget Hospital – For Hospital DeptIds
   • Funds (optional) – Enter the Fund number(s) or search using the search button. Leave blank to return all Funds.
   • Programs (optional) – Enter the Program number(s) or search using the search button. Leave blank to return all Programs.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
2. Click Run Report.

 

 

Report 6 – Fund and DeptId, grouped by Account within Class

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual DeptIds. It also provides for the selection of a Fund(s) when the DeptId is associated with multiple Funds. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY, grouped by Account within Class. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

1. Enter the following information in the criteria boxes:
   • DeptId – Enter the DeptId(s) or search using the search button ( ).
     • Hit Tab key to populate Business Unit and Budget Level.
   • Business Unit – Populates based on the selected DeptId, or may be selected using the drop-down list.
   • Budget Period – Defaults to current budget period, but may be changed.
   • Fiscal Year – Defaults to current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Populates based on the selected DeptId.
     • Budget Level 1 – For DeptIds budgeted at Level 1
     • Budget Level 2 – For DeptIds budgeted at Level 2
     • Budget Level G – For Grant and Contract DeptIds
     • Budget Hospital – For Hospital DeptIds
   • Funds (optional) – Enter the Fund number(s) or search using the search button. Leave blank to return all Funds.
   • Programs (optional) – Enter the Program number(s) or search using the search button. Leave blank to return all Programs.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
2. Click Run Report.
   

 

Report 7 – Fund and DeptId, grouped by Program within Account

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual DeptIds. It also provides for the selection of a Fund(s) when the DeptId is associated with multiple Funds. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY, grouped by Program within Account. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

1. Enter the following information in the criteria boxes:
   • DeptId – Enter the DeptId(s) or search using the search button ( ).
     • Hit Tab key to populate Business Unit and Budget Level.
   • Business Unit – Populates based on the selected DeptId, or may be selected using the drop-down list.
   • Budget Period – Defaults to current budget period, but may be changed.
   • Fiscal Year – Defaults to current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Populates based on the selected DeptId.
     • Budget Level 1 – For DeptIds budgeted at Level 1
     • Budget Level 2 – For DeptIds budgeted at Level 2
     • Budget Level G – For Grant and Contract DeptIds
     • Budget Hospital – For Hospital DeptIds
   • Funds (optional) – Enter the Fund number(s) or search using the search button. Leave blank to return all funds.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
2. Click Run Report.

 

 

Report 8 – Projects, grouped by Account within Fund

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual Projects. It also provides for the selection of a Fund, Class, Program, or DeptId when the Project is associated with multiple Funds, Classes, Programs, and DeptIds. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY, grouped by Account within Fund. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

1. Enter the following information in the criteria boxes:
   • Projects – Enter the Project number(s) or search using the search button ( ).
     • Hit Tab key to populate Business Unit.
   • Business Unit – Populates based on the selected Project, or may be selected using the drop-down list.
   • Budget Period – Defaults to 0, but may be changed depending on Project.
   • Fiscal Year – Defaults to current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Defaults to Budget Level G (Grants and Contracts)
   • Funds (optional) – Enter the Fund number(s) or search using the search button. Leave blank to return all funds.
   • Class (optional) – Enter the Class number(s) or search using the search button. Leave blank to return all Classes.
   • Program (optional) – Enter the Program number(s) or search using the search button. Leave blank to return all Programs.
   • DeptId (optional) – Enter the DeptId(s) or search using the search button. Leave blank to return all DeptIds.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
   • Show Revenues – Check box to show revenues for specified Projects.
2. Click Run Report.
   

 

Report 9 – Projects, grouped by Fund within Account

This report is used primarily to compare budgeted revenue and expenditures with actual revenue and expenditures on a FY-to-date basis for individual Projects. It also provides for the selection of a Fund, Class, Program, or DeptId when the Project is associated with multiple Funds, Classes, Programs, and DeptIds. The report displays current budget, actual year-to-date revenues and expenditures, pre-encumbrances, encumbrances, and the variance between budgeted amounts and actuals for the FY, grouped by Fund within Account. It also displays actual transactions for the month as well as monthly activity in pre-encumbrances and encumbrances.

 

 

1. Enter the following information in the criteria boxes:
   • Projects – Enter the Project number(s) or search using the search button ( ).
     • Hit Tab key to populate Business Unit.
   • Business Unit – Populates based on the selected Project, or may be selected using the drop-down list.
   • Budget Period – Defaults to 0, but may be changed depending on Project.
   • Fiscal Year – Defaults to current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Defaults to Budget Level G (Grants and Contracts)
   • Funds (optional) – Enter the Fund number(s) or search using the search button. Leave blank to return all funds.
   • Class (optional) – Enter the Class number(s) or search using the search button. Leave blank to return all Classes.
   • Program (optional) – Enter the Program number(s) or search using the search button. Leave blank to return all Programs.
   • DeptId (optional) – Enter the DeptId(s) or search using the search button. Leave blank to return all DeptIds.
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
   • Show Revenues – Check box to show revenues for specified Projects.
2. Click Run Report.
   

 

Summary Budget Report – Fund Level and Dept Node

This report provides a summary of revenues and expenditures by Fund Level and DeptId Node. It allows for multiple DeptIds in a combined statement. The selection of multiple DeptIds allows for a greater level of budget information for the department.

 

 

1. Enter the following information in the criteria boxes:
   • Dept Node – Enter the appropriate Dept Node or search using the search button ( ).
   • Business Unit – Select the appropriate Business Unit by using the drop-down list.
   • Budget Period – Defaults to the current budget period, but may be changed.
   • Fiscal Year – Defaults to the current fiscal year, but may be changed.
   • Month – Defaults to Current month, but may be changed.
   • Budget Level – Determines what account values will be reflected in the report. Populates based on the selected DeptId.
     • Budget Level 1 – For DeptIds budgeted at Level 1
     • Budget Level 2 – For DeptIds budgeted at Level 2
     • Budget Level G – For Grant and Contract DeptIds
     • Budget Hospital – For Hospital DeptIds
   • Fund Level – Enter appropriate Fund Level (1-4).
   • Stat – DO NOT USE.
   • Report – Defaults to report chosen from the selection page. This may be changed if you want to view a different report.
2. Click Run Report.