How do other organizations handle coding donor advised funds for the organization and the donor and where and how do you notate it for querying purposes?

Options

How do other organizations handle coding donor advised funds for the organization and the donor and where and how do you notate it for querying purposes?

Tagged:

Comments

  • @Linda Schwambach
    I've seen it done a couple of ways. Either you can put the DAF in as their own Constit record and give them a Constit Code of Donor Advised Fund and when $$ comes in soft credit the individuals.

    Or you can record the $$ on the individual record and sc the DAF. And in that case I would suggest a Gift Attribute with the DAF name for each of those gifts.

    Either ways allows for pulling queries and reports. Which way to record them is an topic that's been around since dirt.

  • @Linda Schwambach

    However you credit the gift, it is helpful to have a relationship record linking the DAF holder and the donor with a relationship type indicating it is a DAF. You can note the name of the donor's fund with the DAF holder on that relationship record for reference.

    For gift credit, I prefer the Bill Connors method of hard crediting the donor with a “Name on Check” gift attribute/custom field. The receipt amount should be zero, which can be helpful for queries and letters. You can use other coding options, like a gift attribute/custom field, to indicate it is a DAF. Soft crediting the holder of the DAF may not be necessary depending on your reporting needs.

    There isn't a right/wrong way to do this. Important considerations:

    • Determine the best way for your reporting and acknowledgement needs.
      • Work backward from the regular queries, reports, and letters you need to run to ensure the way you plan to code the records will work for you.
    • Document how you are going to record everything
    • Be consistent in following your documented processes
  • @Linda Schwambach
    Thank you for your time in explaining your methods. We settled on gift attributes/descriptions to notate the DAFs. The donor is credited and the DAF is soft credited in our system now. Your point of documenting and following the documented process is well taken, Mr. Watson along with working backwards from the necessary documents and products needed.

Categories