FADs: What is the Actuals by Year - Graph?

Tell Me

What is the “Actuals by Year Graph” dashboard?

The Actuals by Year Graph visually represents the budget and activity shown by year for the past five years.

Who should use this report?

The Actuals by Year Graph report is helpful for users with an annual budget to monitor their spending and compare it to the previous five years. The visualization can help users see if their actuals are on pace historically.

Filters:

Fiscal Year – Select one fiscal year. UMBC’s fiscal year runs from July 1^st to June 30^th.

Accounting Period YTD – Select the month for the report to run through. The report will always start from the beginning of the fiscal year for the month & year selected. Adjustment Period is the Year-End period which includes periods 906, 910, 920, 930, 970, & 998/

Fund(s) – Depending on what fund is selected, the KPI’s will either show “Carry Forward Balance” and “Budget vs. Actuals” (1111) or “Beginning Balance” and “Balance (Any other fund). If multiple funds are selected, the KPI’s will not show.

Division(s) – The highest level of the department hierarchy. Every department rolls up to a division. Select one or multiple. And the following three filters will be populated.

College(s)/Units – The next level of the department hierarchy. This is the level you will find the colleges that makeup UMBC and other administrative units.

Department(s) – Most departments will be at the level. There is an option to select one, multiple, or all.

Subdepartment(s) – Some departments have subdepartments reporting to them. There is an option to select one, multiple, or all.

Project Code – All active projects related to the time period, fund, and departments selected will show. There is an option to choose one, multiple, or all.

Reading the Report

KPIs

At the top of the page are the Key Performance Indicators (KPIs):

Beginning Balance or Carry-forward Balance – Depending on what fund is selected.

Budget – The total budget amount with all budget adjustments made up to the selected period.

Actuals – The net of all revenues and expenses incurred up to the period selected

Budget v Actuals or Ending Balance – Depending on what fund is selected.

% of Budget YTD – The percent of Budget depleted up to the period selected.  

Each KPI includes a year-over-year comparison showing the percentage change from last year's period.

Bar Chart

The bar chart below shows the fiscal years on the x-axis and amounts on the y-axis.

The orange bars represent the net actuals by fiscal year. The green bar represents the budget by fiscal year.