Funds Summary

Purpose

This report is used to verify the values displayed in the Funds Management are correct.

On the navigation bar, click the Reports Tab
Under the Funds Reports section, locate the tab called Funds Rollover and click the tab
Once the report is displayed, below the following information should be displayed
- Filter Section: Filter by:
  
  Year Month
  
  Department
  
  GL Account
- Columns Displayed:
  
  Department
  
  Fund Account
  
  GL Number
  
  Forecast Budget
  
  Funds Rollover
  
  Funds Used
  
  Funds Held
  
  Funds Delivered
  
  Ending Balance Available
  
  Funds Other

On the navigation bar, click the Reports Tab
Under the Funds Reports section, locate the tab called Funds Summary and click the tab
Select a date range
Export the Report to Excel using the export button located under the Actions button
Verify the columns on the export match the columns in the system
Verify the Values on the export match the values in the system
Run a formula to verify the Ending Balance for each line item is correct. Formula (Forecast Budget -(Funds Rollover+Funds Used+Funds Held+Funds Delivered)= Ending Balance Available)
Sum all of the Ending Balances for each Department and verify the overall Ending Balance is correct
In a new tab on the system, click the Maintenance tab on the Navigation Bar and select Funds Management from the drop-down menu.
Filter the Funds Management page to the same date range as the report.
Using the Funds Management and the Report, compare the data displayed in the Funds Management is reflected on the Report for at least three (3) Departments and GL Accounts.
Test all filters available and verify the data displayed match the export, funds management and purchase order.

The data displayed on the report is based on the filters selected
Under the Actions button, the user has the ability to export the report to excel
An Item Count is placed at the top of the report