Revenue/Expense Dashboard Overview

This article contains an overview of the Revenue/Expense dashboard including: available reports and report defaults.

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

Available Reports

The following reports are currently available for the Revenue/Expense Report dashboard:

  • Revenue/Expense Summary: 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.

 

  • All University Benefits Pool: The All University Benefits Pool report is a summary of your university-funded benefits; 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.

 

  • Budget Detail: The Budget Detail is a detail report of all of your budget 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.

 

  • Actuals Detail (Between Accounting Periods): The Actuals Detail (Between Accounting Periods) report gives you the actual revenue and expenditure transactions for a single month or a specific range of months. It includes: Document Source, Document ID, Document Date, Journal ID, Journal Date, Line Number, Line Description, Invoice ID, Vendor/Customer ID, Vendor/Customer Description, Reference, Reference 1, Reference 2, Fiscal Year, Period, and Actuals.

 

  • Encumbrance Detail: The Encumbrance Detail report shows all year-to-date encumbrances (purchase orders) and the vouchers (payments) associated with the encumbrances. The totals show the total funds that are still encumbered and have not yet become actual expenditures. It includes: Document Source, PO ID, PO Line Number, PO Line Description, Voucher ID, Document Date, Beginning Encumbrance, Current Encumbrance, and Ending Encumbrance.

 

  • Pre-Encumbrance Detail: The Pre-Encumbrance Detail report shows all year-to-date pre-encumbrances (approved purchase requisitions) and the encumbrances (purchase orders) associated with the pre-encumbrances. The totals show you the total funds that are still pre-encumbered and have not yet become encumbrances. It includes: Document Source, Requisition ID, Requisition Date, Requisition Line Number, Requisition Line Description, PO ID, Vendor, Vendor Description, Beginning Pre-Encumbrance, Current Period Pre-Encumbrance, and Ending Pre-Encumbrance.

Report Defaults

Each report on the Revenue/Expense Report has default settings that are applied if you do not set up your own personal preferences for the page using Page Options (see the user guide on Saving Your Customizations & Filters for more on this).

  • Revenue/Expense Summary report: By default the report will show you the current month under “Current Period Actuals” and year-to-date data through the current month under “Current Year Actuals.” You will see information for all chartfields to which you have access.

 

  • All University Benefits Pool: By default the report will show you the current month under “Current Period Actuals” and year-to-date data through the current month under “Current Year Actuals.” You will see information for all chartfields to which you have access.

 

  • Budget Detail: By default the report will show you all of your budget-related transactions for the current year through the current month for all of the chartfields to which you have access.

 

  • Actuals Detail (Between Accounting Periods): By default the report will show you the current month’s actuals for all of the chartfields to which you have access.

 

  • Encumbrance Detail: By default the report will show you all of your encumbrances for the current fiscal year through the current month. You will see information for all chartfields to which you have access.

 

  • Pre-Encumbrance Detail: By default the report will show you all of your pre-encumbrances for the current fiscal year through the current month. You will see information for all chartfields to which you have access.

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.