System Government Costing - Fund Balance: Running the Webi Report

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.

1. Go to the Service Activities Resource Page.
2. Click Expenditures and Transfers under the Job Aids and Training Materials section to expand the drop-down menu.
3. Click Fund Balance Report Template (Webi).
4. Select the Open option in the dialog box to open the report.
5. Once the report opens, click the small X at the top right corner to close the report (leave Webi open, do not click on the large X at the very top in the red box).
6. Click the Web Intelligence menu on the top left.
7. Select Login as.
8. Log in with your ID and password.
9. Click the Login button.
10. Click the Fund Balance report.
11. Click Design button at the top right (not the drop-down arrow). This adds tabs at the top of the screen and will allow for filtering in future steps, but the overall look of your screen will not change.
12. Click the Refresh button at the top.
13. Click on the Responsible 3-Digit Org Code with % wildcard under Prompts Summary.
14. Type the 3-Digit Org code with the % sign behind in the Selected Value(s) field.
15. Click on the Enter COA Code under Prompts Summary.
16. Type the Chart of Account in the Selected Value field.
17. Click on Fiscal Year under Prompts Summary.
18. Type in the four digit (example: 2015) fiscal year in the Selected Value field.
19. Click the OK button.
    NOTE: Items displayed will be all 3E Funds that match the criteria. The report may not refresh immediately based on the amount of information and server connections.
20. To filter for one specific fund, click in the Financial Fund Code field in the report, then click the Analysis tab at the top of the screen.
21. Click the down arrow next to the Filter button.
22. Click Add Filter.
23. Click on the specific fund under Financial Fund Code.
24. Click the right arrow button under Selected Value(s).
25. Click the OK button.
26. To export the data to Excel, click the down arrow next to the Save button.
27. Click the Save As button.
28. Locate a place to save on your computer.
29. Name your report in the File Name field. For example, you can add the fund number to the file name.
30. Select Excel for Files of Type.
31. On the right side of the Save As window, you will see a window to Select Reports. Here you can select the tabs that you want to be in your saved Excel file. For this file, you will save the “EOY Fund Balance” report.
32. Click the Save button.
33. Click the small X at the top right corner to close the report. You can click No in the dialog box that pops up asking to save changes to the Webi report.
34. Refer to the Fund Balance: Populating the Service Activity Rate Template job aid to populate the template with the fund balance information.