Stock Gift Question

Hi Britt,

I have had to manage stock transactions at a few places now.  All have been fairly similar.  The stock value for us is the mean value on the “gift date” – the day the stock was received by our broker.   (In other words, it is not on the donor when we sell the stock.)   We have two payment methods.  The first is “Brokerage Check” where we enter the amount of the proceeds check.  The second is something like “Stock differential” which can be negative or positive to make the value accurate. 

For example, we receive 10 shares of ABC stock on January 31.  The mean value of ABC price on January 31 is 9.50.  The value of the stock would be $95.  The stock sells for $97, minus brokerage fees of $4, so the proceeds check is $93.  The contribution would have the following payments.

Brokerage Check: $93

Stock difference:  $2

------------------------------------

The total payment would be $95 (the value of the stock on the gift date).  The payment would look something like this.  You can also notate details in the payment and/or the contribution note.

As for tracking a stock gift for 2 different purposes, we would enter 2 separate contributions.

I have used Raiser’s Edge, but I don’t remember the details of how the contribution works.  Hope that helps!

Best,

Tony

Tony Exler
Director of Data Standards
Nashville Symphony
Schermerhorn Symphony Center
One Symphony Place
Nashville, TN 37201-2031
T 615.687.6535 F 615.687.6403
texler@nashvillesymphony.org
NashvilleSymphony.org

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Britta-Lena Lasko
Sent: Wednesday, February 01, 2017 11:00 AM
To: Tony Exler
Subject: [Tessitura Development Forum] Stock Gift Question

Hello everyone, Does anyone have any stock gift entry procedures that they could share? I have been told to enter the stock mean value on the day that the gift is made to our organization. Does anyone know if there is a way to then go back and detail somewhere the figures of the final gift value after the stock is sold? Raiser’s Edge has a way to do this and I am not seeing anything similar in Tessitura. Also when you are running monthly reports, do your total figures include the final value of the liquidated/sold stock gift or the mean value that was recorded on the gift date? Does anyone know of a way to enter a gift that is designated to two different areas, i.e. one portion to the Annual Fund and another portion to the Endowment? Or must one simply enter two separate gifts? Thanks so much for any guidance that anyone may provide. Cheers, Britt

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Britt,

We use a payment method of Stock for the donor value and Stock Gain/Loss for the difference of the check value, which helps us to reconcile cash for the day.  When entering the gift, we use a custom field on the contribution to record the #shares, High, Low and Donor value.  We also use a CSI to record more details for the stock information, which is useful if we get mystery stock and want to see what donors have given the same type of stock in the past. 

As for splitting the stock between 2 different campaigns, we figure out the percentage of the each entry.  For instance, if someone had a 10,000 donor value of stock and 6,000 went to one and the rest to another, we would use 60% of the donor value for the first contribution and 40% of the donor value for the other.  And then there are the donors who give us several types of stock, which then we have to figure out donor values for each stock type and add them together.  We usually enter it as one contribution, but each stock type as its own payment, and we record lots of notes.  But you could enter each stock type separately as its own transaction.

Hope that helps.

T.C. Brown

Database Administrator

412.392.4834

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Britta-Lena Lasko
Sent: Wednesday, February 01, 2017 11:58 AM
To: TC Brown <TBrown@pittsburghsymphony.org>
Subject: [Tessitura Development Forum] Stock Gift Question

Hello everyone, Does anyone have any stock gift entry procedures that they could share? I have been told to enter the stock mean value on the day that the gift is made to our organization. Does anyone know if there is a way to then go back and detail somewhere the figures of the final gift value after the stock is sold? Raiser’s Edge has a way to do this and I am not seeing anything similar in Tessitura. Also when you are running monthly reports, do your total figures include the final value of the liquidated/sold stock gift or the mean value that was recorded on the gift date? Does anyone know of a way to enter a gift that is designated to two different areas, i.e. one portion to the Annual Fund and another portion to the Endowment? Or must one simply enter two separate gifts? Thanks so much for any guidance that anyone may provide. Cheers, Britt

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!