This report is developed by System Government Costing to assist service activities with populating the data in the Rate Calculation Financial Template with the Banner financial information in the Rate Calculation Financial Report in EDDIE. This report is meant to be used in conjunction with the Rate Calculation Template available on the BusFin Service and Storeroom Center website.

Run the Report

1. Login to EDDIE using NetID credentials.
   1. BusFin website drop-down menu “Login to Applications”
2. Navigate to the folder location:
   1. Folders > Public Folders > OBFS System Government Costing Reports
3. Open the UR_SA_Rate Calculation Financial Report with Depreciation in EDDIE.

NOTE: There are three different reports, which pull the financial information with or without the equipment depreciation, and a separate report for only equipment depreciation.

• UR_SA_Rate Calculation Financial Report
• UR_SA_Rate Calculation Financial Report with Depreciation
• UR_SA_Equipment Depreciation Report

Answer the Report Prompts in the EDDIE text field “Enter a value manually.”

4. Enter COA – Type the single-digit Chart of Account into the text field.
5. Enter Fund Code – Type the 6-digit Fund Code for the service activity into the text field.
6. Enter Fiscal Year – Type the 4-digit fiscal year into the text field.
7. Enter 3-Digit Org Code with % wildcard – Type the first 3 digits of the Organization code that the service activity fund belongs to, followed by a “%” symbol.
   1. Using the % wildcard will allow the report to pull all the equipment within all related Org codes within the Organization.
8. Enter Fiscal Year for Equip Depr (Last Completed FY) – Type the 4-digit fiscal year for the most recently completed fiscal year.
   1. Since depreciation is only recorded in Banner during the year-end closing process, the fiscal year used in this field must have been closed. Otherwise, the report will return no information on the equipment depreciation tabs.
9. Run - Click the “Run” button in the lower right corner.
   1. Once this report has run, you will need to download and save it in a place most convenient for you

Export the Report to Excel

10. Click the Export button in the upper left corner of the EDDIE ribbon menu, or type Ctrl+E.
    1. This button resembles an arrow pointing downward.
11. Select the “All Reports” checkbox.
12. Click the “Export” button in the lower right corner.
    1. The file will save to the default folder location for downloads.

Please refer to the job aid “Service Activities – How to Populate the Rate Calculation Template” for instructions on how to populate the Rate Calculation Template with the information generated from this report.

Please refer to the Job Aids “Service Activities – How to Perform a Rate Calculation Using the Template” for instructions on how to perform a rate calculation using the Rate Calculation Template.

System Government Costing offers extensive training for performing the full rate calculation process. Visit the Service Activity Basics and Service Activity Advanced training pages.

Please contact System Government Costing with questions about this report.