Stock Gift Entry (Multiple stocks to multiple funds)

Brian Davies

Hi All,


I am totally hung up on how to enter this gift. Here are the details:

Donor pledges

$30,000 to Capital Fund

$70,000 to Endowment

$10,000 to FY20 Annual Fund

$10,000 to FY21 Annual Fund

$10,000 to FY22 Annual Fund

Total $130,000


Stock received

233 Shares sold at $93,300

160 Shares sold at $12,400

70 Shares sold at $14,200

43 Shares sold at $1,900

218 Shares sold at $8,200

Total $130,000


Don't worry about receipts for the donor I got that worked out. I am unsure how to enter the stock gifts so that they pay the pledges at the designated value and the pay-stock matches the proper fund. We currently do not use split gifts and I don't really want to start now. How do I enter these?

Austen Brown

Brian Davies‍ - No matter how you do this, it will be messy.  Because your org has a policy not to split gifts, as I see it, you will have to enter all but one stock gift twice in order to complete each pledge.  For instance you could do this: 

233 Shares sold at $93,300 -

• Gift Entry 1: Apply $70,000 of gift to Endowment Pledge;
• Gift Entry 2: Apply Reminder $23,300 to Capital Fund Pledge

160 Shares sold at $12,400 -

• Gift Entry 1: Apply $10,000 of gift to FY20 Annual Fund Pledge; 
• Gift Entry 2: Apply Reminder $2,400 to Capital Fund Pledge

70 Shares sold at $14,200 -

• Gift Entry 1: Apply $10,000 of gift to FY21 Annual Fund Pledge;
• Gift Entry 2: Apply Reminder $4,200 to Capital Fund Pledge

43 Shares sold at $1,900 -

• Gift Entry 1: Apply $100 of gift to Capital Fund Pledge;
• Gift Entry 2: Apply Reminder $1,800 to FY22 Annual Fund Pledge

218 Shares sold at $8,200 -

• Gift Entry: Apply entire gift to FY22 Annual Fund Pledge

 

John Heizer

Austen Brown‍ has given good advice on how to enter the pledge payments.  My concern is that you say they "sold for" a certain amount.  That's not the value you should use when crediting the donor for their gift. Stocks get valued at the average (mean) value of the stock the day you took ownership (daily high added to daily low and divided by 2).

Brian Davies

John Heizer:
Austen Brown‍ has given good advice on how to enter the pledge payments.  My concern is that you say they "sold for" a certain amount.  That's not the value you should use when crediting the donor for their gift. Stocks get valued at the average (mean) value of the stock the day you took ownership (daily high added to daily low and divided by 2).

Yup, got crediting the donor covered. Just trying to get the stocks to pay the appropriate pledges. Austen's suggestion is what I came up with too, but I wanted to see if anyone had another way.