Annual Giving Cash Report - Revenue Details

This report pulls all gifts of $25k and less by academic unit EXCEPT pledge payments on pledges over $25k, based on revenue (legal) credit, providing specific access to revenue details.

Where is it?

Link to Report: 

http://businessintelligence.dsc.umich.edu/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AfGNKoSYg9RJj3QonoVWXGg

BusinessObjects Folder Path: Public Folders/UM-Maintained/Development/DART Development Reports by Category/Annual Giving/

​​​​​What does it do?

This Report

This report pulls all gifts of $25k and less by academic unit EXCEPT pledge payments on pledges over $25k, based on revenue (legal) credit, providing specific access to revenue details.

Why use this report?

Use this report to monitor and analyze gift activity of $25,000 and less by academic unit using revenue credit. It is especially useful for understanding annual giving performance while excluding pledge payments tied to pledges over $25,000, so results reflect the intended giving level. The year-over-year summary of qualifying gifts (payments) also helps you track trends over time and provide consistent performance updates to stakeholders.

How to use this report?

Scheduling

Please refer to this article for more information on scheduling reports: https//teamdynamix.umich.edu/TDClient/83/Portal/KB/ArticleDet?ID=7265

Running the Report Directly

Click the highlighted icon to bring up the user prompts.

If the report is taking too long to run, schedule the report (see above).

Prompts

You then need to set the prompts. (Prompts act as questions that help you to customize the information in a report to suit your own needs!)

Below are the available prompts (with explanation) —

First FY (Required)

Answer the following prompt to restrict to the current fiscal year or the most recent year of the two you would like to compare

• Select First FY

  • You may select one first FY

  • E.g., FY26

Fiscal Month (Required)

Answer the following prompts to restrict giving to pull only up to the first day of the current month in the prior year

• Select Fiscal Month

  • You may select one fiscal month

  • E.g., 4

Enter Second FY (Required)

Answer the following prompts to restrict giving to the older of the two FYs you are comparing

• Select Second FY

  • You may select one second FY

  • E.g., FY24

Report Tabs

There are 6 report tab:

• AF Academic

  • University-wide giving to all designations with the Annual Fund attribute, by academic unit, with a $25k gift cap. Excludes pledge payments on pledges over $25k

• AF and Flagged Gift Academic

  • University-wide giving to all designations with the Annual Fund or Flagged attribute, by academic unit, with a $25k gift cap. Excludes pledge payments on pledges over $25k

• All Gifts Academic

  • University-wide giving to all designations by academic unit with a $25k gift cap. Excludes pledge payments on pledges over $25k

• AF and Flagged Gifts Non-Ac

  • University-wide giving to all designations with the Annual Fund or Flagged attribute, by non- academic unit, with a $25k gift cap. Excludes pledge payments on pledges over $25k

• All Gifts Non-Ac

  • University-wide giving to all designations by non-academic unit with a $25k gift cap. Excludes pledge payments on pledges over $25k

• 25K

  • Summary of all gifts that are $25k or less. Excludes pledge payments on pledges over $25k.