Stock Gift Entry

Chandra,

This would be useful for us too.  We actually use a custom screen for tracking this information and can enter as many stock gifts as we wish; however, I manually enter the contribution ref id after the gift has been processed, then run a custom stock utility update which auto-populates the details of the corresponding gift to the custom stock screen.  At present, we are not reporting on any of this information - it is mostly there for reference - but I would say that I think many of us agree that we would love for this to be included with the contribution details.

We also like to track:
Stock Name
Mean of High and Low
Valuation Date
Donor Credit Value
Sale Date
Principal Amount
Fees
Actual Payment
Gain/Loss
Stock-specific notes

Thank you for sharing!

Amber

Hi all,

Thanks for the suggestions!  We at the NextGen team love to hear the feedback about what would make your lives easier.  As you have seen, this sort of feedback is making its way into real functionality starting with Version 11.  So, keep it coming.

One note - Chandra, you mentioned this would be great for Version 11.  We are happy to consider this for the NextGen project in general, but we are actually quickly tying up the final pieces of Version 11 and sending it out for alpha testing in another month or so.  Given that we are on the tail end of the Version 11 development cycle, we are primarily focused on bug fixes and usability feedback from the Sandbox at this point - not brand new functionality.

So, bottom line - thanks for the feedback, we'll keep it in mind for a future version, but not v11 :)

Thank you!

Andrew

Hi Andrew,

Thanks for the quick reply!  Could this be an enhancement in v11??

Sorry we didn't have a chance to chat in Orlando!

Chandra

I also just realized that using the payment screen may not work.  If one stock transaction is spread over multiple gifts it would be impossible to accurately break it down (number of shares).  I think I'm going to explore the custom screen on the patron level, rather than at the contribution level, as that allows multiple entries.

Additional thoughts are welcome!

I also just realized that using the payment screen may not work.  If one stock transaction is spread over multiple gifts it would be impossible to accurately break it down (number of shares).  I think I'm going to explore the custom screen on the patron level, rather than at the contribution level, as that allows multiple entries.

Additional thoughts are welcome!

Chandra,

This image will probably be a little blurry, but I've also uploaded it as a JPG and you can get to it through my profile page.  Under "Contribution Details" I enter in the Ref No of the contribution after it has been processed.  Then I run a custom update utility that fills in the rest of the details from the contributions tab.  I can enter as many of these on a record as I want, and enter the reference number for each entry.  There are multiple ref no lines here in case the gift is applied to multiple funds. 

(some fields are manual entry and others auto-populate after the utility is run)

So... here would be the four basic scenarios:
1. Situation: Donor gives one stock gift to one fund
Solution: I add one custom stock entry for the one gift and fill in the one ref numbers post gift entry and run custom stock gift utility

2. Situation: Donor gives one stock gift to multiple funds
Solution: I add one custom stock entry for the one gift and fill in multiple ref numbers post gift entry and run custom stock gift utility

3. Situation: Donor gives multiple stocks for a gift to one fund
Solution: I add a custom stock entry for each different stock but use the same ref number post gift entry and run custom stock gift utility

4. Situation: Donor gives multiple stocks for a gift to multiple funds
Solution: I add a custome stock entry for each individual and unique stock and then add the ref numbers post gift entry where applicatble and then run the custom stock gift utility

I do occassionally run into the issue where a donor gives 20 or so different stocks for one gift, and those are painful to enter, I'll admit, but worth having the information in the system.  We limited each stock entry to three gift reference numbers because it is a rare situation that I have to use more, and if that is the case, then I just add another entry with the same information and notes that it is the same stock, not a duplicate, with multiple allocations and references to the other entry.

Cons
There have been two main cons to our system - the notes box does not wrap the text and Tessitura does not automatically show that there is a scroll bar if there are multiple entries.  You have to zoom out to see all of the stock entries and then zoom in to the one you wish to view.

Of course there are other cons - like prefering this to be incorporated into gift processing, but I just wanted to limit my "con" focus to potential issues within our control at this time.

If you're interested, I could obtain more information from our IT department on how this was accomplished.

Amber

Thanks Amber! I'll review this.  My custom screen is in the contribution module, but as I mentioned, you can't enter multiple lines.  I think I'm leaning now toward the custom screen on the constituent level.

While on the topic of stock gifts, I wanted to know the amount that other organizations record in Tessitura if the gift of stock or securities is paid toward a pledge.  For example, John Doe makes a $10,000 pledge and at a later date donates stock which is valued at $9,800 (Mean value of the high and low on the gift date).  The broker proceeds are $9,500 from change in price, fees and commissions.  In my experience, organizations have recorded the value of $9,800 toward the pledge, leaving a balance of $200.  Do others do that, or would you record the $9,500 broker proceeds toward the $10,000 pledge, leaving a $5,000 balance?  

I would love to hear how others do this.  If any organizations record the gift value, does that work with your customized stock gift screens?

At other organizations, I would have created 2 payments, one with a payment type of Check and the other with a payment type of Stock Difference.  The stock difference is recorded by Finance not as cash but just as a difference which tends to balance out over the year.

Thanks!

Tony