Revenue/Expense Summary Report

This article covers how to run and interpret the Revenue/Expense Summary report on the Revenue/Expense dashboard.

This user guide assumes basic knowledge of Data Warehouse. View the Data Warehouse Basics guides for more information.

What does this report show?

The Revenue/Expense Summary report is a high-level summary of your  finances; it includes: Baseline Budget, Revised Budget, Current Period  Actuals, Current Year Actuals, Encumbrance, Pre-encumbrance, and Budget  Balance Available. Users can also view detailed information by clicking  on hyperlinks within the report.

Report Overview

The Revenue/Expense Summary report is a year-to-date report by fiscal year.

When you access the report, your personal settings for the report (page) appear. If you have not set up your personal settings, the system defaults will automatically populate.

Revenue Expense Summary report

Report Filters

The first section of the report contains the available filters. Utilize the filters to narrow down your report results or find specific values.

Leaving a filter blank is equivalent to selecting all available values with transactions associated with them (e.g., if you leave Account blank, your report will show all account codes that have a transaction associated with them).

Revenue Expense Summary Filters

Report Parameters and Available Column Headers

Just under the report filters are the report parameters and the available columns headers for the report results table.

Revenue Expense Summary parameters

Report Parameters

Business Unit will always be FLCMP (Fullerton Campus).

Fiscal Year will match the Fiscal Year in the report filters.

YTD Period will match the Accounting Period in the report filters.

Total Number of Records Retrieved will be the total number of rows in the search results table.

Therefore, the report will be showing year-to-date information for the selected fiscal year from July 1st through the YTD Period.

Report Results Table

The second section of the report contains the report results table.

Revenue Expense Summary results

Additional Detail

You can click on hyperlinks in the Baseline Budget, Revised Budget, Current Year Actuals, Encumbrance, or Pre-Encumbrance totals to view the specific transactions included in the total.

Detail hyperlink in results
Detail link

Baseline Budget and Revised Budget

These columns appear when you click on the Baseline Budget summary total or the Revised Budget summary total on the main summary report.

Budget detail

Current Year Actuals

These columns appear when you click on the Current Year Actuals summary total on the main summary report.

Actuals Detail

Encumbrance

These columns appear when you click on the Encumbrance summary total on the main summary report.

Encumbrance

Pre-Encumbrance

These columns appear when you click on the Pre-Encumbrance summary total on the main summary report.

Pre-Encumbrance

3. To return to the previous screen, click Return at the bottom left of the screen.

If you use your browser's Back button, you may lose the report filter that you were working with.

Return link

Additional Report Layouts

Additional Report Layouts options

At the bottom of the Revenue/Expense Summary report are additional links and layouts.

Revenue/Expense Summary (without All University Benefits Pool) will run the Revenue/Expense Summary report in a new tab without university-funded benefits included.

Revenue/Expense Summary (with Project to Date) will run the Revenue/Expense Summary report in a new window with a Project to Date Actuals column.

Need More Help?

For technical assistance with the Data Warehouse, please contact the IT Help Desk at helpdesk@fullerton.edu or 657-278-7777.

For questions about getting access to the Data Warehouse or how to use the reports, please contact IT Training at ittraining@fullerton.edu or 657-278-5647.