Applying Gifts to the Planned Gift Type

Options
Angel Teske
Angel Teske ✭
Tenth Anniversary First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
We are implementing the Planned Gift Type and reviewing our process for Estate Gifts.  Currently, we convert the individual record to an Org record(Estate).  Specifically, with the Planned Gift Type, we found (unlike pledges) we cannot apply a gift to a Planned Gift unless it is in the same constituent record.  How do you manage between an Estate Record and an Individual Record?  Do you use one or both?  What best practices have you found for data cleanliness and integrity with Estate Gifts and the Planned Giving Type? 

 
Tagged:

Comments

  • Jessica Taylor
    Jessica Taylor ✭
    Tenth Anniversary Facilitator 1
    We keep all gifts on the original constituent record, with the reference reading made possible through....

    We change the name of the trustee or executor on the main letter and add them as a relationship.

    If by chance the gift needs to be sent elsewhere, we make a new record, link them through relationships and soft credit the deceased.
  • Tom Klimchak
    Tom Klimchak ✭
    Tenth Anniversary Facilitator 2 Name Dropper Photogenic
    We also use the Planned Gift module and found the limitation of only using a single constituent pretty annoying.  We put the planned gift on the individual record when the person is still alive.



    Once the person passes away and we receive a gift from the estate we create a new Estate record, re-create the planned gift (with the original date) on the Estate record and then process the payment.  We also create a relationship between the Estate record and individual record (we use "Estate" and "Estate Namesake" for the relationship types)...



    Be really, really careful with planned gifts.  We like Raiser's Edge, but we really think Blackbaud messed this one up pretty good.  It's nearly impossible to count Planned Gifts as "pledges" and realized gifts in as "payments" on most standard reports.  This means it's real easy to double-count things when you're looking at a 5 or 10 year period of income.



    Example: Let's say you're looking at "committed" money in (pledges and outright gifts...no payments).  If you just query on the gift types you might get a Planned Gift for $100,000 as well as the outright Cash gift of $100,000.  That adds up to $200k, when you really only have half that.  You have to remember to only grab Cash gifts that are "not linked to a Planned Gift" in this example, though in some tallies screens you really can't factor those out. 



    Good luck!
  • Gina Gerhard
    Gina Gerhard ✭
    Ancient Membership Facilitator 3 Photogenic
    Thomas - I thought the planned gifts went in with a gift type of 'planned gift' so wouldn't those be extractable in your gift reporting?
  • Mary GaetzScholtz
    Mary GaetzScholtz ✭
    Tenth Anniversary Facilitator 1
    Unfortunately, we do not have the planned gift module so "planned gift" as gift type is not available. 



    I thought of entering as gift type of "other" on the individual record and creating a new gift sub type of planned gift or DAF.  When funds actually received they would be entered on DAF record with soft credit to individual.  Thoughts? 
  • Tom Klimchak
    Tom Klimchak ✭
    Tenth Anniversary Facilitator 2 Name Dropper Photogenic
    Planned Gifts do go in as "Planned Gifts" but we also count that as a committment, so they're the same as a pledge.  We will often include Planned Gifts with pledges in our reporting.  When you're counting "committed" money you generally will add up all outright gifts as well as all committments.



    The problem is that payment against Planned Gifts are sees in RE as "Cash" not "Payments".... 
  • James Andrews
    James Andrews ✭
    Ancient Membership Facilitator 2 Photogenic

    Thomas Klimchak:

    We also use the Planned Gift module and found the limitation of only using a single constituent pretty annoying.  We put the planned gift on the individual record when the person is still alive.



    Once the person passes away and we receive a gift from the estate we create a new Estate record, re-create the planned gift (with the original date) on the Estate record and then process the payment.  We also create a relationship between the Estate record and individual record (we use "Estate" and "Estate Namesake" for the relationship types)...



    Be really, really careful with planned gifts.  We like Raiser's Edge, but we really think Blackbaud messed this one up pretty good.  It's nearly impossible to count Planned Gifts as "pledges" and realized gifts in as "payments" on most standard reports.  This means it's real easy to double-count things when you're looking at a 5 or 10 year period of income.



    Example: Let's say you're looking at "committed" money in (pledges and outright gifts...no payments).  If you just query on the gift types you might get a Planned Gift for $100,000 as well as the outright Cash gift of $100,000.  That adds up to $200k, when you really only have half that.  You have to remember to only grab Cash gifts that are "not linked to a Planned Gift" in this example, though in some tallies screens you really can't factor those out. 



    Good luck!



    This is exactly what I was complaining about yesterday.  At this point, I'm so used to reporting by dumping everything out of RE and calculating things myself, that I didn't notice there was a "total realized" field I could export to avoid double counting.
  • Nicole S
    Nicole S ✭
    Ancient Membership Facilitator 3 Name Dropper Photogenic


    Currently, our organization creates a "planned gift" (using the planned giving module) on a constituent record when they indicate that they would like to make a gift. This doesn't mean we will ever get any money. Neither does a letter of intent for that matter.

    It's our policy that an "individual" makes gifts and can alert us to a planned gift, but we create organizational records for the actual estate when the money comes in. We don't want to make estate records until an individual dies - so we don't put the planned gift on the estate record we put it on the individual. Like I said, you never really know if you'll get any money, so why make the records until you need them? But when the money comes in we can't apply it to the individual's planned gift.



    I don't like converting the individual to an organization because I think you lose the history.  We also don't like to create the estate record for the purpose of recording the planned gift, becuase it leads to confusion.  Lots of "Is he dead?!?!" calls.



    It's a problem.

    http://rediscovery.uservoice.com/forums/137015-raiser-s-edge-discovery-topics/suggestions/3013162-need-to-be-able-to-apply-gift-to-a-planned-gift-on



  • Kathi McKelvey
    Kathi McKelvey ✭
    Ninth Anniversary First Reply

    Thomas Klimchak:

    Planned Gifts do go in as "Planned Gifts" but we also count that as a committment, so they're the same as a pledge.  We will often include Planned Gifts with pledges in our reporting.  When you're counting "committed" money you generally will add up all outright gifts as well as all committments.


    The problem is that payment against Planned Gifts are sees in RE as "Cash" not "Payments".... 

    Thomas,

    We are doing the same process here with the Individual constituent having the Planned Gift and once deceased the Estate of constituent record is created with the Realized Bequest cash gift.  Have you ever come across the situation where the Planned Gift was higher (250K) than the actual Realized Bequest(45K)?  How did you make the adjustment?  We added the 45K gift to the "Estate of ..." as a cash gift but back in 2014 we have Expected Bequest with 250K in reports. 


    Thanks,

    Kathi

     

  • Tom Klimchak
    Tom Klimchak ✭
    Tenth Anniversary Facilitator 2 Name Dropper Photogenic
    Sorry for the slow response... Yes, we have had large planned gifts that ended up being a lot smaller when they were actually realized.  We don't have a lot of them, but in the few cases where it's happened we ended up revising the original Planned Gift record downward so match the actual realized amount. 


    The same sort of problem can happen when you are counting Pledges as "committed" money and then someone passes away or says they won't pay off their pledge.  You can write off the balance, but that doesn't change the original pledge (committed) amount...  The original pledge amount is still there as a "committed" number even though you know you're never going to receive the money. 
  • Erika Villegas
    Erika Villegas ✭
    Ninth Anniversary First Reply
    Is anyone 'realizing' the planned gift on the original Planned Gift (on the deceased record), and then soft crediting the Estate record? Thank you!
  • Kathi McKelvey
    Kathi McKelvey ✭
    Ninth Anniversary First Reply

    Thomas,

    Thanks for your response.  We can’t
    change the PG due to our processes.  We need to make an
    adjustment in the current fiscal year showing a decrease in the
    Planned Gift column of our reports.  We decided to change our
    business process with Planned Gifts to create the Estate record
    when a PG is accepted and then once the individual passes and we
    receive the gift, we link the received gift to the PG and we get
    the Total Realized which can be used to calculate the
    adjustment. 

     

    It seems a bit dramatic to have to make this
    business process change but in the long run it seems to give us the
    amounts we need for reporting.

     

    Thanks,

    Kathi

     

    Kathi
    McKelvey

    Voice:
    520-621-1939

    1111 N Cherry Ave, Room 305

    Tucson, AZ 85721-0109

     

  • Kathi McKelvey
    Kathi McKelvey ✭
    Ninth Anniversary First Reply

    Hi Erika,

    No we can’t change the PG on the individual
    because it has been reported in previous year’s Campaign
    report.  Since we put the actual gift received on the Estate
    record we can’t link the received gift to the PG to get Total
    Realized.  Thanks for your response.  We need to make an
    adjustment in the current fiscal year showing a decrease in the
    Planned Gift column of our reports.  We decided to change our
    business process with Planned Gifts to create the Estate record
    when a PG is accepted and then once the individual passes and we
    receive the gift, we link the received gift to the PG and we get
    the Total Realized which can be used to calculate the
    adjustment. 

     

    It seems a bit dramatic to have to make this
    business process change but in the long run it seems to give us the
    amounts we need for reporting.

     

    Thanks,

    Kathi

     

    Kathi
    McKelvey

    Voice:
    520-621-1939

    1111 N Cherry Ave, Room 305

    Tucson, AZ 85721-0109

     

Categories