Budget Transaction Detail Report

This article covers how to run and interpret the Budget Transaction Detail report on the Budget Management dashboard.

This report is similar to the Budget Detail Report on the Revenue/Expense Report dashboard.

What does this report show?

This report is a detail report of all of your budget transactions (both salary and non-salary transactions) such as initial baseline budget load, benefits load, budget transfers, carry forward, etc. It includes: Scenario, Journal ID, Journal Line Description, Document Line Description, Journal Line Reference, Journal Date, Baseline Budget, and Revised Budget.

Accessing the Report

1. Log in to the campus portal and access TitanInsights.

2. Click Shared folders to access dashboards/reports.

QuickSight home page

3. Click on the Finance folder.

dashboard folders

4. Select the Budget Management folder.

Budget Management folder in list

5. Select the Budget Management dashboard.

Budget Management dashboard link

6. Click on the Budget Transaction Details tab.

Report selector

Report Overview

The Budget Transaction Detail report is a year-to-date report by fiscal year and accounting period/month.

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

Budget Transaction Detail 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.

Available 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 period for the year-to-date data. The fiscal year begins in July and ends June of the following calendar year (e.g., choosing 6 will mean you see data from July 1st  - December).
Scenario The specific types of budget transactions for which you wish to view data.
Fund The specific fund code(s) for which you wish to view data.
Account The specific account code(s) for which you wish to view data, along with the name associated with the account code(s).
Program The specific program code(s) for which you wish to view data, along with the name associated with the program code(s).
Class The specific class code(s) for which you wish to view data, along with the name associated with the class code(s).
Project The specific project code(s) for which you wish to view data, along with the name associated with the project code(s).
Division The specific campus division(s) for which you wish to view data. Selections subject to the user’s department level security access.
Sub-Division/College The specific campus sub-division(s) or college(s) for which you wish to view data. Selections subject to the user’s department level security access.
Master Department A Master Department groups several departments together. Use this to select one or more specific master departments for which you wish to view data. Selections subject to the user’s department level security access.
Department The specific department ID(s) for which you wish to view data, along with the name associated with the department ID(s). Selections subject to the user’s department level security access.

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.

report header

Report Parameters

Business Unit will always be FLCMP (Fullerton Campus).

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

YTD Period will match the Accounting Period you selected 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.

Available Column Headers

Use the drop-down menus to select the columns you want to see on your report results table. The data will automatically update when you make a selection.

Available Column Headers Table

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

Column Description
Dept ID The Department ID associated with the transaction.
Dept Descr
The name associated with the Department ID for the transaction.
Dept Fdescr
Both the Department ID and the name associated with the Department ID appear.
Fund
The Fund code associated with the transaction.
Fund Descr
The name associated with the Fund code for the transaction.
Fund Fdescr
Both the Fund code and the name associated with the Fund code appear.
Account
The Account code associated with the transaction.
Account Descr
The name associated with the Account code for the transaction.
Account Fdescr
Both the Account code and the name associated with the Account code appear.
Program
The Program code associated with the transaction.
Program Descr
The name associated with the Program code for the transaction.
Program Fdescr
Both the Program code and the name associated with the Program code appear.
Class
The Class code associated with the transaction.
Class Descr
The name associated with the Class code for the transaction.
Class Fdescr
Both the Class code and the name associated with the Class code appear.
Project
The Project code associated with the transaction.
Proj Descr
The name associated with the Project code for the transaction.
Proj Fdescr
Both the Project code and the name associated with the Project code appear.
Lvl 2 Fdescr
This is equivalent to the Division designation.
Lvl 3 Fdescr
This is equivalent to the Sub-Division/College designation.
Lvl 4 Fdescr
This is equivalent to the Master Department designation.

Report Results Table

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

Report Results

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

Need More Help?

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

For assistance with the Budget Management reports and data, please email [email protected] or visit the Resource Planning & Budget website to submit an inquiry.