Do you have donor directed funds, if so how do you track/manage designations from DDF to other funds?
We have a few instances where a donor has given us a lump sum which we have put in a "John Smith Donor Directed Fund" (DDF). As projects/needs arise, the donor will tell us to transfer $XXX from their DDF to a specific fund.
We are struggling with how to track these funds without a lot of manual records and to prevent double counting. We want $ to show in report for the specific fund once it has been designated.
We considered gift adjustments but some are stock gifts and cannot be adjusted or split after entry. We were wondering if gift subtype could be used. Any suggestions or ideas?
(This is not DAF $ from an outside org, it's essentially an inhouse DAF. We created fund and agreement is $ is for use by our org at donor's direction.)
Answers
-
Situation you are talking about is handled with TBD (to be determined) fund in RE (and project in FE).
donation amount with TBD fund will not be "used"
once donor decides what to do with the fund, an adjustment is made from TBD fund to the specific program/project fund.
I understand the limitation on adjustment relating to stock gifts, mainly speaking, it's the "sales" info of stock gift. The way this is handled is that "sales" info is marked as "do not post" (while the actual "sales" info is journal entried into FE). Anytime an adjustment has to be made to stock gift, the "sales" is deleted (generally will be "stored" as a screenshot first), adjustment made, then sales is recreated (using screenshot) back to the RE gift record.
1 -
I think this is a strictly finance/business office decision @JoAnn Strommen. I don't know if I agree with @Alex Wong that a special TBD fund should be used. The donor created these funds for a purpose that is seemingly working as designed. I'm not a big fan of changing these gifts on the fly, as it doesn't tell the true story of the gift. We should be working to retain as much gift integrity as possible, and sometimes that means that we don't have the ability to report in the same way.
You've entered the gift to the DDF in RE, and for all intents and purposes, the gift left the donor's account and went to that account at your institution. What happens after that is an internal process but doesn't change the initial spirit of the gift that was made. In these cases, I think manual reporting is necessary to account for those funds. Especially since it sounds like this DDF will consistently be getting changes/adjustments every time a new need/project is identified.
That said, the ideal way would be as a soft credit, but that can only happen if the gift can be adjusted/amended. This is a great example of why gift notation is so important.
1 -
Maybe I'm not understanding the "Donor Directed Fund" well from JoAnn and you Dariel.
When you say "we have put in a "John Smith Donor Directed Fund". My understanding is this is a Fund that the gift is coded to. Not a separate constituent record call "John Smith Donor Directed Fund", which Dariel seems to indicate when he mention "soft credit".
Soft credit is soft crediting a gift to another constituent record, it does not require adjustment. You can make change to soft credit tab/grid even if the gift is posted.
0 -
@Alex Wong You're right there, I misspoke. When I mention soft credits, I'm thinking of a manual process, and not an actual soft credit. So not creating a constituent, but more along the lines of having some gift notes that basically break down everytime the initial gift is distributed to another internal fund. Something that everyone can see and follow.
The issue is that for reporting purposes, you should only be counting the initial gift. However, I feel that the best way to report on this would be some manual process, which I stated earlier.
0 -
Thanks for the replies. We really want to get away from the manual process. Making sure that one person has the info and the time from DDF to designation can be years.
Really looking for a way to track within RE.
0 -
my org did not care about if a donor initially gave to a "DDF" and make later decision on what project/program to support, they care about what project and program they supported, and how that is correctly reflect in CRM and financially system for proper reporting of fund spending, but if origianlly is DDF is important, this is what I would do, maybe helpful maybe not for you JoAnn:
- Fund record specific for DDF (which I would only have ONE fund, instead of having one per donor DDF, but if you must have multiple, one for each donor DDF, use some grouping like Fund type or category or custom field for easy reporting)
- the gift(s) record from donor who gave to DDF would get a gift "tag" (depending on your existing field usage already, it can be a marketing source code, gift code, or gift custom field). I would use a gift custom field, of type currency to indiate "Donor Directed Fund Amount".
- as donor indicate what project/program they want to support from the DDF, adjust the gift from DDF fund to the actual fund, so you will always know how much a certain fund has raised, and easily able to report on who supported what fund/project/program.
- since original amount given into a DDF never changes, the attribute/custom field simply stays and never change and is very much reportable.
just my 2cents.
0 -
Thanks Alex.
We definitely want a separate fund for each donor's DDF. I will visit with CFO about a special fund type/category.
Adjustments are the direction I wanted to go but not posible to adjust or split stock gift after inital entry. Can only split when entering and number of the gifts are stock.
We are wrapping up multi-year campaign and different funds are applied to different 'pillars.' Manual is just such as risk for error.
0 -
I definitely hear you about the adjustment on stock gift b/c of the "sales" posted situation, I am hoping one day Blackbaud will realize this issue and fix it (maybe the newest feature Anthony Gello is working on (bringing adjustment to webview) will open that up.
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 213 bbcon®
- 1.4K Blackbaud Altru®
- 403 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 656 Blackbaud Grantmaking™
- 576 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 939 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.6K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 119 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 241 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 34 PowerUp Challenges
- 3 (Open) 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
- 793 Community News
- 2.9K Jobs Board
- 54 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

