Page MenuHomePhabricator

Automatic TY for Stock Gifts
Closed, ResolvedPublic3 Estimated Story Points

Description

One of the most manual offline donation types we process is stock gifts. Because the tax receipt requires us to give the fair market value (Average of the high and low for the specific stock on the date received), we need to manually create PDF TYs and email them to the donor. Could we add a special automatic TY for the Stock Gift financial type or payment type?

I think we could add a new field called Stock Value under the Stock Information section that when entered and the contribution is saved, will produce an automatic thank you email with that field value as the amount if we have an email address. This feature will cut down on the the processing time significantly and allow us to send tax receipts much quicker, especially during high volume periods. Let me know if you have any questions. Thanks!

Event Timeline

Talking about this in civi fortnightly we need the fair market value as a new field in civi. Then we can show both values in the standard TY email.

@DStrine Jessica and I spoke about the stock TY email. To give you an idea on timing, stock donations start to ramp up in November so I think having this task in a sprint this month works well. Let me know if you want to go over any of this request! Thanks

ok. We'll try to look at this next print

DStrine triaged this task as Medium priority.Oct 13 2020, 10:49 PM

Change 636749 had a related patch set uploaded (by Jgleeson; owner: Jgleeson):
[wikimedia/fundraising/crm@master] WIP: Add Stock Value field and show in ty letter

https://gerrit.wikimedia.org/r/636749

jgleeson moved this task from Doing to Backlog on the Fundraising Sprint Vagranty McVagrantface board.
jgleeson added a subscriber: jgleeson.

Change 638759 had a related patch set uploaded (by Jgleeson; owner: Jgleeson):
[wikimedia/fundraising/crm@master] Added drush cmd to update custom fields

https://gerrit.wikimedia.org/r/638759

Change 638759 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Added drush cmd to update custom fields

https://gerrit.wikimedia.org/r/638759

Change 636749 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Add Stock Value field and show in ty letter

https://gerrit.wikimedia.org/r/636749

Change 640269 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Load right thank you default for stock

https://gerrit.wikimedia.org/r/640269

Change 640269 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Load right thank you default for stock

https://gerrit.wikimedia.org/r/640269

Thank you @jgleeson! I just tested and the new field showed successfully in the receipt. Would it be possible to add in the Stock Description field to that first sentence as well? We use that field to indicate X number of shares of X stock were received. Stock thank you letters usually indicate that for tax purposes and including will make it clear to the donor that we received their stock transfer. Something like below would work:

Thank you for your one-time gift of <Stock Information> valued at $<Stock Value>.

Let me know if you have any questions, and thanks again!

Hi @LeanneS, I'll create a ticket for the additional field. It's not a big piece of work but it'll have to go through our usual prioritisation process and hopefully, we'll get to it soon!

Thanks!