Financials Reporting

Financial reports for users are available in two locations Monthly Financial report distribution website and the PeopleSoft Financials reporting system. Access to individual reports is determined from the Online Security Form Reference Guide.

Monthly Financial Reports

Monthly reports that are run by central operations and housed on the web for department administrators or other designees to access. Users have access to reports department-wide. Users who do not have full access to all reports in their department cannot use this system and must run their reports individually in Peoplesoft.

Monthly Financial Reports Website

Peoplesoft Reporting Database

Any available Peoplesoft report or query can be run from this system. While the reporting database looks similar to the financials database, it is a separate link that requires a separate login. PeopleSoft Reporting Database.

Quick Guide on how to Run Reports

Available Reports

The reports that have sample reports names are available in the Monthly Financial Report system.  Reports that don't have a sample name are only available in the PeopleSoft Reporting Database.

Income – Expense Report

The expense statement contains both a summary and a detail section. The summary section lists total expenses for the given time period as well as year-to-date expenses and the current year budget. The detail section lists all journal activity for the given period. Encumbrance section lists requisitions and purchase orders that are pending.

SpeedTypes Used: OPR and INS.

Sample Income – Expense Report

Sample Monthly Financial Reports system Report Name:  2019_01_31_incexp_opr_123456.pdf

Income – Expense Endowment Report

The income/expense statement consists of a summary section and a detail section. The summary section lists total expenses for the given period as well as year-to-date expenses. The detail section lists all journal activity for the given period. The income listed represents the monthly amount distributed to the endowment fund or the actual income received for FHBOs. Encumbrance section lists requisitions and purchase orders that are pending.

SpeedTypes Used: END and FHB

Sample Income – Expense Endowment Report

Sample Monthly Financial Reports system Report Name:  2019_01_31_incexp_end_123456.pdf

Income/Expense – Funded Projects

The income/expense statement consists of a summary section and a detail section. The summary section lists total expenses for the given period, year-to-date expenses, total-to-date expenses, budget amounts and cost share amounts. The detail section lists all journal activity for the given period. Income for the given period is also listed. Encumbrance section lists requisitions and purchase orders that are pending.

SpeedTypes Used: RES, TRN, SPC and OSA

Sample Income Expense – Funded Projects

Sample Monthly Financial Reports system Report Name:  2019_01_31_incexp_prj_123456.pdf

CIP Expense Statements

The income/expense statement consists of a summary section and a detail section. The summary section lists total expenses for the given period, year-to-date and total-to-date expenses, income and total budget and funding amounts . The detail section lists all journal activity for the given period. Encumbrance section lists requisitions and purchase orders that are pending.

SpeedTypes Used: CIP

Sample CIP Expense Statements

Sample Monthly Financial Reports system Report Name:  2019_01_31_incexp_prj_123456.pdf

Budget Performance Report

Used by the budget office, management centers and departments for budget forecasting, this report lists the major account classifications and breaks down current and year-to-date expenses for each class in the various funded and unfunded categories.

Sample Budget Performance Report

Sample Monthly Financial Reports system Report Name:  2019_01_31_bpr_123456.pdf

Revenue Budget Performance Report

Used by the budget office, management centers and departments for budget forecasting, this report lists the major account classifications and breaks down current and year-to-date income for each class in the various funded and unfunded categories.

Sample Revenue Budget Performance Report

Sample Monthly Financial Reports system Report Name:  2019_01_31_bpr_rev_123456.pdf

General Ledger Report

This report lists activity on asset and liability related funds for a given period. The report is sorted by fund, project and account ID. 

Sample General Ledger Report

Income Ledger Report

Lists income detail for endowment, FHBO (Funds Held By Others), income and expense funds. The report is cumulative, showing all detail for the the fiscal year. The report is sorted by department, fund, project and account.

Sample Income Ledger Report

Sample Monthly Financial Reports system Report Name:  2019_01_31_incledg_123456.pdf

Unused Endowment Income

Lists endowment and FHBO (Funds Held By Others) projects, their income balance at the beginning of the fiscal year, year-to-date income by category, year-to-date expense and final, unused income balance.

Sample Unused Endowment Income

Valid SpeedType Listing

This report lists all currently valid (non-archived) speedtypes available for use in the in Financials and HCM.

Sample Valid SpeedType Listing

Statement of Expense: BGT Speedtype Report (BGT Rpt)

The expense statement contains both a summary and a detail section. The summary section lists total expenses for the given time period as well as total-to-date expenses vs. budget. The detail section lists all journal activity for the given period.

Speedtypes used: BGT, VSN

Sample Statement of Expense: BGT Speedtype Report

Sample Monthly Financial Reports system Report Name:  2019_01_31_incexp_vsn_123456.pdf

Case Income & Expense Report

The expense statement contains both a summary and a detail section. The summary section lists total expenses for the given time period as well as total-to-date expenses vs. budget. The detail section lists all journal activity for the given period.

Speedtypes used: CASE, SERV

Sample Statement of Expense: BGT Speedtype Report

Sample Monthly Financial Reports system Report Name:  2019_01_31_incexp_cwr_123456.pdf