How to find information you need in the Gift Accumulation Dashboard
-
Find the funds in your unit that have no restrictions beyond purpose
-
Find the funds that have balances < $1,000 and have not been used for 5+ years
Find the funds in your unit that have no restrictions beyond purpose
Select your unit on the Initial Inputs tab. On either report, uncheck all of the boxes in the Restricted Beyond Purpose section except No restrictions/preferences.
Find your unit's most accumulated purpose
Select your unit on the Initial Inputs tab and go to the summary report, Fund Accumulation and Purpose. The Funds by Purpose . . . chart shows the purpose in descending order starting from the left. The first box is the purpose with the most accumulated funds.
Determine which L4 is holding the most accumulation
Select your division on the Initial Inputs tab and go to the summary report, Fund Accumulation and Purpose. The Fund Accumulation and Balance chart shows the accumulation for each department in the division.
Find the faculty with the most fund accumulation
Select your unit on the Initial Inputs tab and go to the Gift Fund Detail report.
-
In the Required Inputs section, adjust the beginning and ending periods as needed.
-
In the Required Inputs section, select Faculty-PI Name (CF2) as one of the report columns.
-
In the Optional Filters section, uncheck No under Faculty Allocated (CF2).
Generate a report showing a summary of balances by fund variety (current vs. endowment) and accumulation level
Select your unit on the Initial Inputs tab and go to the Gift Fund Detail report. In the Required Inputs section, select these report columns:
-
Fund Variety
-
Fund Accumulation Group
Find the funds that have balances < $1,000 and have not been used for 5+ years
Select your unit on the Initial Inputs tab and go to the Gift Fund Detail report. In the Optional Filters section, make these selections:
-
Fund Used in Past 5 Years: No
-
Current Balance < $1K: Yes
Find the funds whose purpose is graduate support that have no restrictions beyond purpose. Of those, determine how much was spent in the last fiscal year (FY22)
-
On the Initial Inputs tab, select your organization. In the Optional filters section on this tab, select Graduate Student Support from the Fund Primary Purpose drop-down list.
-
Go to the Gift Fund Detail report and select the beginning and ending period for the current year.
-
In the Optional Filters section, uncheck all of the boxes in the Restricted Beyond Purpose section except No restrictions/preferences.
-
Select the desired report columns.
Find restricted funds that may be difficult to use
Select your unit on the Initial Inputs tab and go to the Gift Fund Detail report.
-
In the Required Inputs section, include Fund Accumulation Group
-
In the Optional Filters section, select No for Faculty Allocated (CF2)
-
In the Optional Filters section, select Restriction(s) and Restriction(s) & preference(s) in the Restricted Beyond Purpose section