What This Report Does


  • This report will show Appropriations, Outstanding Encumbrances, month to date Expenditures, year to date Expenditures, Available Balance and Percentage Used through the fiscal month selected on the Select and Sort Tab.
  • Instead of having the option to print the report to the screen or your printer, it will create a file that can be exported from OpenRDA and emailed.


Requirement


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


Expenditure Summary Export


  1. Finance → Financial Management → Reports → Summary → Expenditure → 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 expenditures-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