Funds Management Dashboards | Public Sector Manager Dashboard

The Funds Management dashboard lets public sector managers and analysts compare encumbrances and actual expenditures to budgets, and view the status of funds in hierarchies of funds, cost centers, and expense categories.

For each fund, cost center, and expense category, you can see the budget, encumbrances, and actual expenses, as well as available funds.

The Funds Management dashboard is designed for use in:
• State and municipal governments
• Higher education

Image

Image

Image

The following headings and calculations are common throughout the reports on the Funds Management dashboard.

Common accounting and financial terms that appear on reports are not defined.
Controlled: Funds available within the appropriate budgetary boundaries governed by the As Of date.
Note: On the Funds Management dashboard, if the period type is
quarter and the As Of date is in the second month of the quarter, then
the budgets are calculated up to that month. This is different from
the Expense Analysis dashboard, which displays the entire quarter.
• Accounted: Funds available within the appropriate budgetary boundaries based on the standard accounting periods.
• Available: Unexpended, uncommitted funds included in an organization’s or project’s budget. Public sector organizations report periodically on budgets, as well as on realized and midstream expenses (encumbrances).

Available funds are calculated as:
Available = Current Budget – Encumbrances – Actual Expenses.


• % Available: Available funds as a percentage of total budgeted funds.
• Budget: Funds allocated to organizations and projects for future expenditures.
Budgets in the Controlled columns are dictated by budgetary control options, while budgets in the Accounted columns and the budget region are calculated based on period type.
• Others: Encumbrance balances other than commitments or obligations.
• Spending Activities: Equals encumbrances plus actual expenses.

 

The Funds Available Summary displays available amounts, budget
amounts, encumbrances, and actual expenses. Data is based on budgetary control parameters and is grouped by fund, cost center, expense categories, and a user-defined dimension.
The Funds Available Summary provides two subsets of information about
budgeted, encumbered, and available funds:

Budget Summary
The Budget Summary displays current and original budgets grouped by fund, cost
center, expense categories, and a user-defined dimension.

You can use this report to answer business questions such as:
• How has my budget changed from the prior period, quarter or year?
• How does my baseline budget compare to my current budget?
• How is my budget allocated to various projects?
• What are the fund sources on a project, fund, and overall organizational level?

The Funds Management page uses three types of budgets:
• Current
• Baseline (original)
• Prior

Budget Trend by Account Detail
The Budget Trend by Account Detail report displays a monthly, quarterly, or annual trend of current budget amounts grouped by fund, cost center, and account.
This report also includes adjustments to the current budget, as compared to the baseline budget.

You can use this report to answer business questions such as:
• Which fund had the most budget adjustments?
• What is my budget for a specific fund, cost center, and account?

Encumbrance Summary
The Encumbrance Summary displays encumbrances by encumbrance type, grouped by fund, cost center, account hierarchy, and a user-defined dimension.

This report also displays encumbrance trend information within the selected period type.

Use this report to answer business questions such as:
• What is the breakdown of my encumbrances between obligations and commitments?
• What is my encumbrance total for a particular cost center or fund?