Faster Quarterly Endowment Board Reports With DonorPerfect and Keap

Endowed scholarship reporting is the most labor-intensive task in scholarship fundraising, and almost none of the work requires real thought. A development associate spends two full days every quarter pulling gift totals by fund, matching them by hand to engagement data from another system, formatting a sheet for each scholarship, and emailing PDFs to committee chairs. Thirteen weeks later, they do it all again.

Your board does not need the work to be hard. They need the numbers to be right. The reason it is hard is simple: one system knows what people gave and to which fund, and another system knows what they read, opened, and attended. Joining those two views by hand every quarter is the entire bottleneck.

What the manual quarter really costs

Two days of skilled staff time, four times a year, is sixteen working days a year spent on copy-and-paste. That is time your development associate is not spending on donor calls, stewardship visits, or relationship work that actually grows the fund.

It is also fragile. Each report is rebuilt by hand, which means each report is a fresh chance to transpose a number, misfile a gift, or paste last quarter’s figure into this quarter’s sheet. Endowed scholarships carry legal restriction language that has to appear correctly on every report. A stewardship report that misrepresents a restriction is not a budget problem, it is a compliance problem, and those end careers.

There is a timing cost too. Endowment committees often meet near the end of a quarter, when the most recent two weeks matter most: a major donor’s gift, a memorial pledge, a board chair’s stewardship visit. A report built from last week’s data simply does not reflect where the fund stands today.

A better way to prepare the report

CRMConnect connects DonorPerfect to Keap so fund information and donor engagement live together, on the same donor record, kept current on their own.

Every gift carries its fund designation, restriction, and purpose across automatically. Each of your endowed scholarships becomes a clean, selectable category rather than a free-text note. Giving history per donor per fund sits right next to the engagement picture Keap already tracks: email opens, clicks, event attendance. Because both halves of the donor story live in one place, the quarterly join you used to do by hand is already done.

How it works for your team

Picture Summit Scholars Fund, an illustrative university-affiliated scholarship fund with 38 endowed scholarships and 5,200 alumni donors. Here is the report in plain terms.

Each scholarship gets its own saved view: every donor to that fund, their lifetime giving to it, their last gift date, their most recent engagement, and their last event attendance, all on one screen. The legal restriction language for that scholarship sits inside the view, so committee chairs see the context without hunting for it.

A separate watchlist tracks the top donors to each fund by how long it has been since they last engaged. Anyone who goes quiet for 90 days triggers a task for the assigned development officer, so a cooling relationship gets caught in weeks rather than at the next quarterly meeting.

When report day comes, the development associate opens each saved view, exports it, and sends it. Prep time drops from sixteen hours to three or four.

What this means for your fundraising

Representative results from comparable scholarship funds after adopting this approach:

• Quarterly report prep drops from about sixteen hours to roughly four, a 75 percent reduction.
• Committee chairs report higher satisfaction, because for the first time each scholarship report includes engagement context, not just dollars.
• Cooling major-donor relationships get caught in weeks instead of quarters, thanks to the 90-day-quiet watchlist.
• Annual compliance review gets faster, because restriction language is stored consistently rather than buried in narrative.
• The per-scholarship stories your development officers write improve, because giving data and engagement data sit side by side in one view instead of in a folder of exports.

The honest caveat: this does not eliminate the development associate’s quarterly review. A human still needs to read the data and write the narrative. What disappears is the spreadsheet plumbing, not the judgment. Funds that expected this to replace a staff role were disappointed; funds that expected it to free that person for more donor calls and less Excel were satisfied.

Stewardship and privacy deserve attention. Scholarship recipients have a different privacy expectation than donors. Recipient stories used in reports should always be opt-in, with the right to withdraw. Many universities have specific policies on what can be shared with donors and committee members, and recipient data should be kept out of committee-facing views by default unless those policies allow it.

What to keep human

The temptation is to push toward a fully automated report. Resist it. Automate the numbers, the engagement summaries, the per-scholarship views, the watchlists. Leave the narrative commentary, the part that explains why one scholarship is over-performing and another is under-funded, to your development associate. A board chair can tell the difference between data with context and data without it within the first thirty seconds of opening the report.

Keep the stewardship recommendation human too. The 90-day-quiet watchlist is a flag, not a decision. The right next step for a quiet major donor depends on things a report cannot see: a recent loss, a known life transition, a previously discussed timing preference. Your development officer makes that call, not the dashboard.

Want to see CRMConnect DonorPerfect to Keap in action?

View the API App page.