To run downloads, log into Edgar Web Apps, select the Finance tab, navigate to the Downloads menu.  The selection of downloads available to you will vary based on your Banner security profile.  These are available downloads:

• Financial Transactions
• Budget Status
• Purchase Order Detail
• Fixed Assets
• Fund Codes
• Org Codes
• Account Codes
• Fund Text
• Rice Books Budget Detail
• Open Encumbrance Detail
• General Ledger Activity
• Fin Trans (Payroll)
• Wire Transfer Tracking Report
• Payments to Foreign Vendors
• Payments to Check Vendors
• Scheduled Jobs Output

Here is some detail on the most useful download types:

Financial Transaction download

To run, select the item and click submit to get the parameter screen.  Enter your query parameters.  See separate blog posts for discussion of dates, document reference numbers, and rule codes.  The output you see is governed by your Banner security agreement.

The resulting download includes a staggering amount of detail: fund code, fund title, org code, org title, account code, account type, account title, program code, activity code, location code, transaction date, invoice date, fiscal year, fiscal period, rule code, document number, document reference, document reference transaction date, encumbrance number, vendor invoice number, commodity description, check number, check date, description, transaction type, transaction amount, budget period, budget division, budget division and budget set codes, and certain text fields if selected.

Budget Status download

To run, select the item and click submit to get the parameter screen.  Select the desired fiscal year and period from the drop down lists. Enter your query parameters. The output you see is governed by your Banner security agreement.

The resulting download includes a FOAPAL-level summary that includes: original budget, budget adjustments, current period activity total, fiscal year-to-date activity total, open encumbrance balance, available balance, budget division, budget set, and account title.

Fund Code download

To run, select the item to get the parameter entry screen.  You may select a range of fund codes and/or range of default org codes, and/or range of default program codes.  You may specify one PI or one financial manager.  The output you see is all codes, regardless of your Banner security agreement.

Org code and account code downloads are similar.

Fund Text download

Extensive text is entered on R funds and donor restrictions are entered on E and G funds.  Text is optional for other fund types.

To run, select the item and click submit to get the parameter screen.  Enter desired funds and/or orgs and/or program codes.