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 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.
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 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