What This Report Shows


  • This report will provide the following information for the selected fiscal year through the selected fiscal quarter:
    • Estimated Revenue
    • Year-to-Date Revenue
    • Quarter-to-Date Estimated Revenue
    • Quarter-to-Date Revenue
    • Unrealized Balance
    • Percentage Realized


Best Practice


  • Posted Figures Only – Although distributed and undistributed amounts can be included, normal selection is to include posted figures only.


Notes About Report


  • Due to the sort levels (sorting by dimension), the account descriptions pull from the Chart of Accounts.
  • However, when the Dump Code Details box is selected, the account description pulls from the Account Masters.


Revenue Summary Quarterly Report


  1. Finance → Financial Management → Reports → Summary → Revenue → Quarterly
  2. Range accordingly through each tab.
  3. Once all necessary fields are populated, click Run Report (Process wheel).


Select and Sort

FIELDSOpt.Rec.Req.Description
Fiscal Year——♦The fiscal year associated with data
Quarter——♦The fiscal quarter associated with data
Show Zero Accounts♦——When true, includes account codes with zero amounts
Dump Code Details♦——Displays the full account code along with its amount
Select Posted♦——Pulls summary totals from the account year masters posted field
Select Distributed♦——Pulls summary totals from the account year masters distributed field
Select Undistributed♦——Pulls summary totals from the account year masters undistributed field
Optional Sort Level——♦Allows for sorting through dimensions


Range

FIELDSOpt.Rec.Req.Description
Fund♦——The fund number associated with the expenditure accounts
Account Dimensions♦——The dimensions that are available to range on will depend on your account structure
Account Code♦——The individual account code you need information for


Define Components

FIELDSOpt.Rec.Req.Description
Dimensions♦——
  • This allows for sorting and totaling for a portion of an account dimension (a roll-up):
    • For example: if Source is a six-character dimension (such as 180303) and you wish to roll up to the first three characters (180000), the defined component would be SOURCE thru 3
Opt. = Optional  Rec. = Recommended  Req. = Required