DAF/IRA reports

Jolynn Uyehara

My colleague is asking me for a report of donors who gave through their DAF or IRA accounts. I don't see how this is possible to run but wanted to reach out to you all to see if you have a suggestion. Thank you!

Joe Moretti

@Jolynn Uyehara I have done this, but the first step is to make sure all Donor Advisor Funds are coded as such either as an attribute or Industry of the record. Once that is done, you can do a constituent query:

Soft Credit Recipient Name not Blank

AND Industry equals Donor Advisor Fund

You can include a gift range if you want, BUT the key is that the Donor Advisor Funds need to be coded as such.

JoAnn Strommen

Hi @Jolynn Uyehara It all depends on how and what data you have entered.

Do you code DAF as such? Do you note in reference, gift attribute or somewhere that the payment was from an IRA?

If you have a specific letter that you use to acknowledge/receipt those gifts you may be able to filter on that.

Jolynn Uyehara

@JoAnn Strommen Hi JoAnn! I do not code those types of gifts or use attributes. I'm wondering if going forward, I should start to?

Jolynn Uyehara

@Joe Moretti Thank you. I do not code those gifts but going forward, I think I need to since this is a new report they want me to run.

Alex Wong

@Jolynn Uyehara
You cannot run a report where your data recording does not support it.

So first question really is: how does your org record gifts coming from DAF or IRA, different from individual giving directly to you.

I know many uses “soft credit”, where the donation is direct credit (directly recorded under) the DAF org record, and then soft credit to the individual who recommended the gift from their DAF to your org.

So first job is to find out how gifts are coded for this situation, while I understand this is a new report they are asking for, I doubt it is a new method of getting gift that your org has never gotten DAF gift before. If there was no process previously defined, then you will need to define that first before report can be generated

Joe Moretti

@Jolynn Uyehara The gifts do not need coded, but the DAVF record needs the code either in the industry field or as a constituent attribute.

Austen Brown

@Jolynn Uyehara - Agree with Alex, take a look at your existing records to see if any coding was used in the past. Personally, I like to use the Gift Subtype field to record DAF/IRA information on gift records.

If you're giving HC to the DAF record, you can ‘tag’ those with Joe's recommendations, in addition I've also seen this recorded in a Constituent Code. If you're giving HC to the recommending donor, make sure you're tracking the DAF's name somewhere, most often with this method, I've seen that recorded in a gift attribute.

Debora Farnham

@Jolynn Uyehara we treat DAF as a separate constituent record (org record). It is set up with a constituency code of Donor advised fund). The rational is because the donor(s) gave a gift to Fidelity, Schwab Charitable or another DAF management entity to set up their often-named DAF. That donor received their charitable gift receipt at that time. In most cases, the funder has the ability to make a recommendation of a gift from their donor advised fund. We recognize the donor via soft credit, and send an acknowledgement thanking them for recommending the gift. Additionally, we add a gift attribute to identify that the gift is a DAF.