Finance Trend

Quarterly - for the current quarter compared to the same quarter in prior years

Annually - for the current year plus four years prior

Audience:

Dean, Executive Officer, Department Group Administrator, Department Manager, Project Director, and Single Administrative Point of Contact (SAPOC)

Description:

This report displays revenue and expense data to monitor trends over time and compare to prior quarters or years.

Instructions:

Review this report quarterly to compare the current quarter to the same quarter in previous years to identify abnormal patterns, ensure expected transactions have posted, and monitor financial activity. Use the Accounting Period filter to select the months you wish to view.

Review this report annually for the current year plus four years prior to observe trends and assist with future planning efforts.

Finance Trend Tab:

The 'Group by' filter allows users to toggle between a Source/Use or Account Group view of the data.

Use the 'Account Group' or 'Account' filters to view trends for certain types of transactions. Use the 'Journal Type' filter to drill down to specific types of activity such as AP, JE's or SUB.

Click the year you are interested in viewing in the color key in the bottom left corner to highlight it in the graph. Click 'Revenue' or 'Expense' under Account Group Detail to show a breakdown of activity by Account Group. Hover over any dollar amount in the Detail section to display the trend for that specific category.

Finance Variance Tab:

View a list of the Top 5 Expenses and Revenues by Account Group at the top of the report.

The 'Finance Variance - by Account Group' section shows the dollar amount and percent variance for each Account Group that had activity during the time period selected. The report will default to highlight variances >20% in orange. You can customize the orange variance flag using the Variance % or Variance $ threshold filter in the bottom left corner. If values are entered in each, they will both apply.

The report defaults to compare each fiscal year to the previous, as shown on the X-axis. The X-axis scale can be adjusted using the +/- buttons to compare to the previous quarter or month.

Click on any bar to see transaction details below.

Next Steps: