System Government Costing - Expenditures and Transfers: Running the Webi Report
Guide to running the Webi report for expenditures.
To complete the Expenditures and Expenditures Detail tabs in the Service Activity Rate Calculation Template, you need to run the Expenditures and Transfers Webi Report first.
- Go to the Service Activities Resource Page.
- Click Expenditures and Transfers under the Job Aids and Training Materials section to expand the drop-down menu.
- Click Expenditures and Transfers Report Template (Webi).
- Select the Open option in the dialog box to open the report.
- 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).
- Click the Web Intelligence menu on the top left.
- Select Login As.
- Log in with your ID and password.
- Click the Login button.
- Click the Expenditures and Transfers.wid report.
- 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.
- Click the Refresh button at the top.
- Click Enter Fiscal Year under Prompts Summary.
- Type the fiscal year in the Type a value field.
- Click Enter COA under Prompts Summary.
- Type the Chart of Account in the Type a value field.
- Click Enter Fund Code under Prompts Summary.
- Type the Fund Code in the Type a value field.
- Click the OK button.
NOTE: The report may not refresh immediately based on the amount of information and server connections.
- To export the data to Excel, click the down arrow next to the Save button.
- Select Save As.
- Locate a place to save on your computer.
- Name your report in the File Name field. For example, you can add the fund number and fiscal year to the file name.
- Select Excel for Files of Type.
- 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 “Expenditures for Rate” and “Detail Expenditures for Rate” report. You may save the others if necessary.
- Click the Save button.
- 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.
- Refer to the Expenditures and Transfers Populating the Service Activity Rate Template job aid to populate the template with the expenditure and transfer information.