Body
What is this?
As we receive gifts throughout the year some of them need adjusting. This results in gifts received just before the end of the fiscal/calendar year being adjusted in the next year. Each year there is a two-day window where a year’s gifts are considered final and reports can be run to pull the final year numbers. This window is usually a couple weeks after the close of the respective year, fiscal or calendar.
Gifts can still change
The FYE/CYE window provides the opportunity to pull official final numbers. After the official FYE/CYE window, gifts may still be adjusted, and any reports pulling these gifts may be different from the official FYE/CYE numbers.
2025 CYE Window
January 19th and 20th
The Data Warehouse (Business Objects) will not refresh on the night of the 19th, giving users an extra day to pull CYE reports. Reports needing official CYE numbers should be pulled before 8pm on January 20th.
Additional information on the 2025 CYE Schedule for Gifts
2025 FYE Window
July 14th and 15th
The Data Warehouse (Business Objects) will not refresh on the night of the 14th, giving users an extra day to pull FYE reports. Reports needing official FYE numbers should be pulled before 8pm on July 15th.
Additional information on the 2025 FYE Schedule for Gifts
Resources
Provides a list of all gift transactions (Payments, Pledges, and Planned Gifts) added to DART during the specified time period.
You may want to capture gifts processed between in July/January and credited for June/December. Gifts such as these will have a RevenueDate Added in the new year, but a Revenue Date in the previous year.
Find additional information on the Gift Acknowledgement Report in this Knowledge Base article.
Provides overall production values by fiscal year (accounting for gift adjustments and corrections, without including subsequent pledge or planned gift payments).
Find additional information on the DART FY Production Report in this Knowledge Base article.
Provides overall production values by calendar year (accounting for gift adjustments and corrections, without including subsequent pledge or planned gift payments).
Provides revenue information for pledges based on Designation, Site, SCU Rollup, Campus, or VP Area and FY provided. There’s also a tab for written-off pledges.
Provides all giving to the selected SCU campaign in the production counting method: Gifts (with no other payments), commitments in their full amounts and expectancies in their full face value.
This folder contains shortcuts to the most commonly used FYE reports.
Tableau
Several reports are manually refreshed to support FYE reporting. The IDS team will complete these manual refreshes by 1 p.m. on the first day of FYE reporting. The reports include:
- The Look to Michigan Campaign Snapshot
- The Look to Michigan Campaign Report
- The DART Production Report