Actuals Detail (Between Accounting Periods) Report
This article covers how to run and interpret the Actuals Detail (Between Accounting Periods) report on the Revenue/Expense dashboard.
This user guide assumes basic knowledge of TitanInsights. View the TitanInsights Basics & Overview guides for more information.
What does this report show?
The Actuals Detail (Between Accounting Periods) report gives you the actual revenue and expenditure transactions. Actuals data can be retrieved from different fiscal years, for a single accounting period, or for a specified range of accounting periods as selected by the user. It includes: Chartfields, Document Source, Document ID, Document Date, Journal ID, Journal Date, Line Number, Line Description, Invoice ID (if applicable), Vendor/Customer ID (if applicable), Vendor/Customer Description (if applicable), Reference (if applicable), Reference 1 (if applicable), Reference 2 (if applicable), Fiscal Year, Period, and Actuals (amount).
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.
- Click Shared Folders.
- Select Finance.
3. Select the Rev/Exp (CFS) folder.
4. Click Rev/Exp (CFS) to open the Revenue/Expense dashboard.
5. Click the Actuals Detail tab.
Report Overview
The Actuals Detail (between Accounting Periods) report can be run for a specific accounting period or range of accounting periods for a selected 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.
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).
| 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 | The specific accounting period or range of accounting periods for which you wish to view data. |
| Account Type | The type of transactions you wish to view: All, Revenue, or Expenditures. |
| Account Category | The category or categories of transactions that you wish to view. |
| Fund | The specific fund code(s) for which you wish to view data along with the name associated with the fund code(s). |
| 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. |
| 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 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 Parameters
Business Unit will always be FLCMP (Fullerton Campus).
Fiscal Year will match the Fiscal Year in the report filters.
Period will match the selected Accounting Period(s) in the report filters.
Therefore, the report will be showing transactions for the selected Accounting Period or range of Accounting Periods for the selected Fiscal Year.
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.
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.
Column Descriptions
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.