The adjusted fund balance and working capital should be calculated for every service fund. The over-under recovery should be calculated to determine if your fund has a surplus or a deficit. If you are over or under recovered, this impacts what you should charge your customers. To complete the Adjusted Fund Balance tab in the Service Activity Rate Calculation Template, you need to run the Fund Balance Webi Report first.

Note: In order to run Webi reports, users must have the latest version of Web Intelligence Rich Client installed on their computer. Updates and installation guides can be found through the aits.uillnois.edu.  Alternatively, users can access this report via the web browser based EDDIE system that is available through the OBFS website.

1. Go to the Service Activities Resource Page.
2. Click the Business Objects Webi Report Templates section to expand the drop-down menu.
3. Click Fund Balance Report Template (Webi).
4. Select the Open option in your file explorer to open the report .
5. When prompted, Login with your user name and password (Net ID and University Password). You must be on VPN if logging from a device not on the University Network.
6. You should be redirected to a blank tab in the report. If not, select the SA_Fund Balance and History_July 2022 report from Open Documents, or Recent Documents in the SAP Business Objects (Webi) main menu.
7. Once the blank report is open, click the Refresh icon (circular arrow) under Query.
8. Click Enter COA on the left side of the Prompts window.
9. Type the single digit COA in the "Search or enter values(s) manually" box. Confirm you input by clicking the (+) button. Your entry will populate in the Selected Values section of the window.
10. Click Enter Fund Code on the left side of the Prompts window.
11. Type the 6 digit Fund Code in the "Search or enter values(s) manually" box. Confirm you input by clicking the (+) button. Your entry will populate in the Selected Values section of the window.
12. Click Enter Fiscal year on the left side of the Prompts window.
13. Type the 4 digit Fiscal Year in the "Search or enter values(s) manually" box. Confirm you input by clicking the (+) button. Your entry will populate in the Selected Values section of the window.
14. Click the Run button.
    NOTE: The report may not refresh immediately based on the amount of information and connection speed.
15. To export the data to Excel, click the down arrow icon (Export) in the File section of the top ribbon.
16. Use the check boxes to select which pages of the report you want to export as tabs in an Excel workbook (or click "All Reports" to select all).
17. Click Export.
18. Refer to the Fund Balance: Populating the Service Activity Rate Template job aid to populate the template with the fund balance information.