What This Report Does


  • This report will show Estimated Revenue, Year-To-Date Revenue, Month-To-Date Revenue, Unrealized Balance and Percentage Realized through the fiscal month selected.
  • Instead of having the option to print the report to the screen or your printer, it will create a file that can be exported out of OpenRDA to be directly viewed on your desktop through office software.


Requirement


  • F.A.S.T. Level 2 - You must have F.A.S.T. Level 2 in order to email directly from OpenRDA.


Revenue Summary Export


  1. Finance → Financial Management → Reports → Summary → Revenue → Summary Export
  2. Range accordingly through each tab.
  3. Once all necessary fields are populated, click Run Report (Process wheel).
  4. A DOS COPY WINDOW screen will appear. This indicates the file is ready for exporting. Within the screen, it shows the file name that is needed to query the report in the filing cabinet
  5. Click on the Cancel button to close the screen.
  6. Click this link for instructions on sending the file via email: Emailing from OpenRDA.

Select and Sort Tab

FIELDSOpt.Rec.Req.Description
Selected Fiscal Year——♦The fiscal year selected for viewing
Selected Fiscal Month——♦The fiscal month selected for viewing
Filename♦——
  • From the Select and Sort Tab:
    • If no filename is entered, the file name will default to revenues-FY-FM.tsv and it will be sent to your E-documents (FY=fiscal year, FM=fiscal month)
    • If you use the magnifying glass, you may select a directory and folder for the file. The file name is entered in the file name field
Show Zero Accounts♦——When true, includes account codes with zero activity
Select Posted——♦The summary report should always show posted figures
Select Distributed♦——Flag boolean if distributed data is to be included in report
Select Undistributed♦——Flag boolean if undistributed data is to be included in report
Optional Sort Level——♦Allows for sorting through dimensions


Range Tab

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
Opt. = Optional  Rec. = Recommended  Req. = Required