FADs: What is the Budget to Actual by Period - Graph?

Tell Me

What is the Budget to Actuals by Period Graph?

The Budget to Actual by Period Graph visually represents the cumulative budget and activity shown by month.

Who should use this report?

The Budget to Actual Summary by Period Graph report is helpful for users with an annual budget to monitor spending/revenue at a very high level. The visualization can help users identify periods with abnormal activity to prompt further investigation and analysis.

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, funds, and departments selected will show. There is an option to select 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 months on the x-axis and the amounts on the y-axis.

The line represents the budgeted amount. Changes in the line represent the budget adjustments, including the reimbursable fringe expense adjustments.

The orange bars are the months included in the filters selected. The bars in grey are months that were not included in the filters selected.

Drill Downs

Users can right-click on any of the bars in the graph and see a pop-up showing the cumulative activity up to the period selected for the past 5 years.