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 TitanInsights. View the TitanInsights Basics & Overview guides for more information.

Please use Google Chrome to open the Revenue/Expense Dashboard for optimal performance.

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.

Accessing the Report

1. Access TitanInsights from the campus portal.

If you do not see the TitanInsights icon in your Titan Online widget in the portal, you may not have submitted an Access Request Form to request this access. View instructions on the Access Request Form process.

2. Click on Shared Folders, then select Finance.

TitanInsights shared folders
  1. Click Shared Folders.
  2. Select Finance.

3. Select the Rev/Exp (CFS) folder.

Finance shared folders

4. Click Rev/Exp (CFS) to open the Revenue/Expense dashboard.

Rev/Exp (CFS) dashboard icon

5. Click the Revenue/Expense Summary tab.

Revenue/Expense Summary tab

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 initially. If you select any filters, those settings will populate again when you open the report or move to another tab.

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.

By default, the report shows you all available values with transactions associated with them between accounting period 1 and the current accounting period (e.g., if you do not select any particular accounts, your report will show all account codes that have a transaction associated with them between accounting period 1 and that particular accounting period).

Revenue Expense Summary Filters
Filter Descriptions Table
Filter Description
Fiscal Year The beginning calendar year of the Fiscal Year for which you wish to view data (i.e., FY 2024-2025 = 2024).
Accounting Period For this year-to-date report, this is the ending month for the year-to-date data (e.g., choosing 6 will mean you see data from July 1st to December).
Fund The specific fund code(s) for which you wish to view data along with the name associated with the fund code(s). Funds delineate the money source of the transaction.
Account The specific account code(s) for which you wish to view data along with the name associated with the account code(s). Accounts record the nature of the transaction (e.g. 616003 = IT Software, 601300 = Support Staff Salaries.)
Program

The specific program code(s) for which you wish to view data along with the name associated with the program code(s). Programs are used by departments to track specific expenditures and revenues, including billable transactions which are 7xxx programs.

Class

The specific class code(s) for which you wish to view data along with the name associated with the class code(s). Classes provide for any special cost reporting needs that a division, department, or other organizational unit may have that are not met by the campuswide reporting values in other chartfields (e.g. 20364 = Consolidated Course Fee, 20483 = Office Supply Program.)

Project The specific project code(s) for which you wish to view data along with the name associated with the project code(s). Projects are used to track capital expenditures or one-time repairs/maintenance. 
Division The specific campus division(s) for which you wish to view data.
Sub-Division/College The specific campus sub-division(s) or college(s) for which you wish to view data.
Master Department A Master Department groups several departments together. Use this to select a specific master department for which you wish to view data.
Department The specific department ID(s) for which you wish to view data along with the name associated with the department ID(s).

Report View

Below the filters is the View menu. This menu allows you to select additional layouts.

View menu with options

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

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

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 (Year-to-Date Period) will match the Accounting Period in the report filters.

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

Available Column Headers Table

The following column headers are available for the report results table.

Use the drop-down menus to select the columns you want to see on your report results table. Please note that you can only use seven headers at a time.

When you make a selection from one of the drop-down menus, the report will automatically re-run.

Column Description
Dept ID The five-digit Department ID associated with the transaction (e.g. 10356.)
Dept Descr The name associated with the Department ID for the transaction (e.g. IT Training.)
Dept Fdescr Both the Department ID and the name associated with the Department ID appear (e.g.10356 - IT Training.)
Fund The five-character Fund code associated with the transaction (e.g. THEFD.)
Fund Descr The name associated with the Fund code for the transaction (e.g. CSU Operating Fund.)
Fund Fdescr Both the Fund code and the name associated with the Fund code appear (e.g. THEFD - CSU Operating Fund.)
Account The six-digit Account code associated with the transaction (e.g. 660825.)
Acct Descr The name associated with the Account code for the transaction (e.g. General Supplies.)
Acct Fdescr Both the Account code and the name associated with the Account code appear (e.g. 660825 - General Supplies.)
Program The four-digit Program code associated with the transaction (e.g. 7806.)
Program Descr The name associated with the Program code for the transaction (e.g. Philanthropic Foundation.)
Program Fdesc Both the Program code and the name associated with the Program code appear (e.g. 7806 - Philanthropic Foundation.)
Class The five-digit Class code associated with the transaction (e.g. 20364.)
Class Descr The name associated with the Class code for the transaction (e.g. Consolidated Course Fee.)
Class Fdescr Both the Class code and the name associated with the Class code appear (e.g. 20364 - Consolidated Course Fee.)
Project The eight-digit Project code associated with the transaction.
Project Descr The name associated with the Project code for the transaction.
Project Fdescr Both the Project code and the name associated with the Project code appear.
Level 2 Fdescr This is equivalent to the Division designation.
Level 3 Fdescr This is equivalent to the Sub-Division/College designation.
Level 4 Fdescr This is equivalent to the Master Department designation.

Report Results Table

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

Revenue Expense Summary results
Column Descriptions Table
Column Description
Budgeted Baseline The total amount of the baseline budget for the selected Fiscal Year as of the selected Accounting Period.
Budget Revised The total amount of all budget-related transactions (i.e. baseline budget, budget adjustments, budget transfers, carry forward, etc.) for the selected Fiscal Year as of the selected Accounting Period.
Current Period Actuals

The total amount of all revenues/expenditures that were posted during the Accounting Period in the report filters for the selected Fiscal Year.

Current Year Actuals The total amount of all year-to-date revenues/expenditures as of the Accounting Period in the report filters for the selected Fiscal Year.
Encumbrance The total amount of encumbrances (purchase orders) still active as of the Accounting Period in the report filters for the selected Fiscal Year.
Pre-Encumbrance The total amount of pre-encumbrances (approved purchase requisitions) still active as of the Accounting Period in the report filters for the selected Fiscal Year.
Budget Balance Available This total is calculated based on your revised budget minus your current year actuals, encumbrances, and pre-encumbrances.

If you select an alternative report view, you may see additional columns (e.g. Project to Date Actuals, Dept Level 6 Description, etc.)

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
drill report selection

Baseline Budget and Revised Budget

These columns appear when you click on the Baseline Budget drill report or the Revised Budget drill report.

Budget detail
Budget Column Descriptions Table
Column Description
Scenario The type of budget transaction.
Journal ID The identification number assigned to the budget transaction.
Jrnl Ln Descr The line description associated with the budget transaction.
Doc Ln Descr The header description associated with the budget transaction.
Jrnl Ln Ref The line reference for the budget transaction if entered.
Journal Date The date of the budget transaction.
Fiscal Year The first calendar year of the fiscal year during which the budget transaction occurred. (i.e. FY 2024-2025 = 2024.)
Period The Accounting Period when the budget transaction was posted.
Baseline Budget The amount of the transaction that was applied to the baseline budget.
Revised Budget The amount of the transaction that was applied to the revised budget.

Current Year Actuals

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

Actuals Detail

Encumbrance

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

Encumbrance detail
Encumbrance Column Descriptions Table
Column Description
Doc Src

The type of transaction. Values include:

  • ENC = Encumbrance Activity from a PO
  • VCH = AP Voucher Accounting
  • PYB = Prior Year Balance or Beginning Balance
PO ID The identification number associated with the purchase order.
PO Ln The line number on the purchase order.
PO Ln Descr The line description on the purchase order.
Voucher ID The identification number associated with the voucher.
Document Date The date of the transaction.
Beginning Encumbrance The total existing encumbrance amount at the beginning of the Accounting Period set in the report filters.
Current Encumbrance Any changes to the encumbrance amount that occurred during the Accounting Period set in the report filters.
Ending Encumbrance The total amount still left encumbered at the end of the Accounting Period set in the report filters.

Pre-Encumbrance

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

Pre-Encumbrance detail
Pre-Encumbrance Column Descriptions Table
Column Description
Doc Src

The type of transaction. Values include:

  • ENC = Encumbrance Activity from a PO
  • REQ = Pre Encumbrance from a Requisition
Req ID The identification number associated with the requisition.
Req Date The date of the requisition.
Req Ln The line number on the requisition.
Req Ln Descr The line description on the requisition.
PO ID The identification number associated with the purchase order.
Supplier The supplier/vendor identification number.
Supplier Descr The supplier/vendor name.
Beginning Pre-Encumbrance The total amount of funds pre-encumbered at the beginning of the Accounting Period set in the report filters.
Current Period Pre-Encumbrance Any changes to the pre-encumbrance amount that occurred during the Accounting Period set in the report filters.
Ending Pre-Encumbrance The total amount of funds still pre-encumbered at the end of the Accounting Period set in the report filters.

Need More Help?

For technical assistance with TitanInsights, please contact the IT Help Desk at [email protected] or 657-278-7777.

For questions about getting access to TitanInsights or how to use the reports, please contact IT Training at [email protected] or 657-278-5647.