Coordinator Shortcuts

This page contains descriptions and links to reports and websites that are of use to University Relations Coordinators. Each link provides specific information about which login to use to access the report or web page.

Note that all links open a new tab in your browser.

Information for and about Donors

Pledge Audit Tool - The pledge audit tool presents (by default) all overdue, currently due, and future pledges for the UMCPF foundation. Parameters on this report allow you to expand the tool to include the other foundations, other pledge statuses, or to filter the report accordingly. Login with your UR account.

Pledge Reminders Tool - The pledge reminders tool presents an interface for reviewing and generating current and 60-days past due pledge reminders for the UMCPF foundation. Login with your UR account.

Individual Pledge Summary - If you know the pledge number, you can produce a one-page overview of the pledge with all the information we know about it. This is used daily by Principal Gifts for their strategy sessions. We can also use it to see pledge summaries for Trustees. Login with your UR account.

Donor Strategy Report - Principal Gifts uses this report to run strategy meetings for Presidential donors. It includes summary information about the donor, as well as the current strategy (which is now stored in Advance). Login with your UR account.

Donor Strategy Spreadsheet - This report provides a summary of strategies for a group of prospects in spreadsheet form. It includes summary information about the donor, as well as the current strategy (which is stored in Advance as strategic notes on the prospect). Login with your UR account.

Donor Acknowledgment Report - This report is used to help with donor acknowledgment. You can pull a list of donations to a school or college over a period of time. Each gift is recorded as a single row, with detailed information about joint and additional donors (e.g. In Honor Of), as well as premium information. Login with your UR account.

Financial Information

UR Dashboard - Executive dashboard that you can also see on your phone. Note that the text may seem large in a web browser. Login with your UR account.

Gift Processing System - (Chrome or Firefox recommended) This is the new system for submitting gifts to the Gift Acceptance office. Gift Acceptance also uses this system to review, process and load gifts into Advance in a paperless environment. If you do not have access, please contact Business Applications. Login with your University (Timesheets) account. DO NOT prefix with AD.

Blackbaud Financial Reporting for Account Administrators - This is the online tool that account administrators across campus can use to see day-old reporting of all projects managed by UMCPF. It presents endowment values, spendable income, and current transaction summaries with drill-through on everything. This information resides in Blackbaud. Permission Restricted. Please contact the University Foundation Office to request access.

Blackbaud Transaction Details (Audit) Dump - When auditors ask for detailed transaction dumps, this is the tool to use. It has all GL transactions for a given date range, with zero-sum balance data, as it contains both sides of every GL transaction. If you try to run more than one month, there may be too much data, but you can merge it in a single spreadsheet using copy-past. This information resides in Blackbaud. Permission Restricted. Please contact the University Foundation Office to request access.

Main Campaign Report-by Type and Source - The main report that is produced monthly showing YTD activity and campaign-to-date activity. This is the report that Carolyn sends out. Login with your UR account.

Unit Progress Campaign Reports - This is the other monthly report that most Deans use to track their progress against goal. It presents YTD and Campaign to date totals by C/S/U. It also shows their FY goal and their campaign goal, and progress towards that goal. Login with your UR account.

Gift Table - This is the report we use to count million dollar gifts. It combines gifts and pledges from the same primary donor which are made on the same day (think Smith or Iribe) into a single "big" gift. It builds a gift table by gift size, and includes goals, prospect, and pipeline information as well. Note that the numbers on this report do not always agree with the campaign report because it counts future gifts (that may not be a part of the campaign). Login with your UR account. 


Gift Summary - Provides a detailed transaction listing of all donations made within a chosen date range and for a chosen amount range. Defaults by yesterday's date, minimum donation of $1,000.00. Login with your UR account.                                          

DO Metrics, Portfolio Analysis, Contact Reports

Major DO Metrics and Portfolio Report - The report monitors key metrics such as visits, gifts from proposals, and "over the transom" gifts from donors within a DO's portfolio. It is also an easy way to look at a DO's portfolio and how that portfolio is distributed across donor stages. Login with your UR account.

Annual Giving DO Metrics Report - The report monitors key metrics such as visits, gifts from proposals, and "over the transom" gifts from donors within a DO's portfolio. It is also an easy way to look at a DO's portfolio and how that portfolio is distributed across donor stages. Login with your UR account.

Proposal Pipeline Report - This report can be used to see all proposals for a development office or individual DO. Login with your UR account.

Contact Reports and Visits - This report provides information about contact reports filed by development officers. It can be filtered to specific contact report types (e.g. visit or communication), outcomes, office, and date. Login with your UR account.

Historical Regional Analysis - This report provides summary information about a geocode or state. Geocodes include counties in MD, VA, PA, and DE and also major metropolitan areas around the US. You can also filter by school and major. Login with your UR account.