Linking Planned Gifts to a DAF Gift
Hi everyone,
We’re running into a situation in Raiser’s Edge and I’m curious how other shops handle it.
We received a $50,000 gift from Bank of America Charitable Gift Fund (DAF), so the hard credit is on the DAF, not the individual donor. However, the gift fulfills two $25,000 planned gifts associated with the individual donor.
Because the DAF holds the hard credit, I can’t find a clean way to link the realized amount to each planned gift record.
In the past we’ve sometimes $0 out planned gifts once the funds are received, but these records attributes, so I want to make sure we’re handling it correctly.
How are others managing this?
- Do you link the planned gift to the DAF gift somehow?
- Mark the planned gift as realized and adjust the amount?
- Handle it another way?
Would love to hear how other institutions track this.
Thanks!
Answers
-
Hi @Philip Mitchell - I'm tagging in a few All-Stars who might be able to help! @JoAnn Strommen @Dan Snyder @Austen Brown @Carlene Johnson.
1 -
@Philip Mitchell We do not use the specific planned gift module for our planned gifts (mostly because we had a system in place before we had access) so what we do at my org may not be helpful.
For DAF payments that pay off a pledge (bequest or other multi-year commitment) we do also hard credit the DAF and we include a gift code of Pledge Payment so our reporting places it in the correct area. On the pledge record, that is on the individual's record, we write off the corresponding amount received from the DAF. This sounds similar to the manually marking a PG as realized and adjusting the amount, but again I do not have that direct experience.
I am not saying this is best practice, more just an option. Hopefully you get some other thoughts from the other All-Stars Crystal tagged or other community members.1 -
We have the same question that @Philip Mitchell raised. We have had RE for less than a year and we are trying to figure out what our practices are. My question to @Dan Snyder is, if you write off the pledge, doesn't that reduce the individual's lifetime giving total? I realize that this money is arriving after the person's lifetime, but still, the lifetime giving total often matters to their survivors. Since you don't use the specific planned gift module, if you simply call the pledge a pledge, you could give soft credit to the deceased donor so that they could be recognized posthumously. Why is that not your practice? Thanks for sharing your ideas and experience.
cc: @Nelle Stough
0 -
@Peggy Dolter A write off would not reduce the lifetime giving, just reduce the pledge balance. Even if we did an adjustment to reduce the pledge amount, we are giving the donor (alive or dead) soft credit for the payment from their donor advised fund so it is still included in their lifetime giving.
I realize I left the specific part of soft crediting the donor in our DAF process above and again, I follow this approach because it fits within a longstanding way of tracking planned gifts and it did not make sense to go back and convert everything to the planned giving module.
0 -
@Dan Snyder written of pledges works differently in "summary of gift" for lifetime giving depending on how you run it.
- Gift Querying and summing it in excel or other visualization tool
- this depends on how do you the summing, so won't comment
- Constituent Query (export from Query)
- write off amount included in sum of giving amount
- Consituent Export (export from Export module)
- write off amount is NOT included in sum of giving amount
@Peggy Dolter I'm not particularly familiar with how our finance team does planned giving, but from "data reporting" pov, I think they do not record a "Planned Gift" gift record. They only record when it is received. Opportunity record is used to track what "may" come in.
0 - Gift Querying and summing it in excel or other visualization tool
-
Thanks @Alex Wong for that distinction in exported data.
0
Categories
- All Categories
- 1 Blackbaud Agents for Good™
- Raiser's Edge NXT test
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 403 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.2K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 16 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 661 Blackbaud Grantmaking™
- 583 Blackbaud Education Management Solutions for Higher Education
- 3.3K Blackbaud Education Management Solutions for K-12 Schools
- 947 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.8K Blackbaud Raiser's Edge NXT®
- 3.8K SKY Developer
- 251 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 243 Member Lounge (Just for Fun)
- 37 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Closed) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 804 Community News
- 3K Jobs Board
- 57 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)



