What This Report Shows


  • This report provides year-to-date figures for the following:
    • Appropriations
    • Encumbrances
    • Expenditures
    • Annual Available Balance
    • Percentage Used
  • You will not have the opportunity to print this report. A CSV file of this report is automatically created in your filing cabinet and/or a directory of your choosing. This is explained further in the Filename row in the table below.


Expenditure Summary Year Report Export


  1. Finance → Financial Management → Reports → Summary → Expenditure → Summary Year 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——♦Fiscal Year associated with the data
Filename♦——
  • From the Select and Sort Tab:
    • If no filename is entered, the file name will default to (YYYY-MM-DD.HH.MM.source user.EXPSUMYEAR-CSV) and it will be sent to your E-documents
      • YYYY – Fiscal Year
      • MM – Month
      • DD – Day of the Month
      • HH – Hour in which the report was exported
      • MM – Minute in which the report was exported
      • source user – The source user who exported the report
    • 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
    • If a directory is chosen, the system will put a copy of the report in that directory AND in your E-documents filing cabinet
Show Zero Accounts♦——When true, includes account codes with zero activity
Select Posted——♦The summary report should ALWAYS show posted figures
Select Distributed♦——Flag TRUE if distributed data is to be included in this report
Select Undistributed♦——Flag TRUE if undistributed data is to be included in this 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