Adjusting a Stock gift that has been sold and posted already

Jesse Calagna 2 · May 2019

I was wondering I have a stock gift that we put into anonymous record until we knew who it was supposed to be credited to. We found out and now I have to adjust it to $0 and add it to the constituent record, then split it between pledge pay (originally just a cash gift in anonymous record) and extra cash overage. How would I go about doing this?

support sent me this (which i've already seen) and it doesn't seem to cover what I'm looking for....any insight would be wonderful!

Austen Brown · May 2019

Hi Jesse - You will need to adjust the original gift entered into the Anonymous record to $0.00. Next re-enter a gift under the correct constituent, however you do this normally - either by Gift Batch or directly on the constituent record. When entering the gift a pop-up will appear asking if you want to apply the gift to their pledge - click Yes. The system will ask you how you want to handle the over-payment and mark that you want it to be entered as a donation, and click okay. Do not be alarmed that you cannot see a division in batch between the pledge payment and regular stock donation, it will be committed correctly to RE. Fill in the remainder of the gift record fields according to your gift entry procedure and validate/commit the batch to RE. When you review the gift tab under the constituent's record you will see two gifts - one for the pay-stock/property pledge payment and one for stock/property of the overage amount.

Throughout all of this communicate with your Finance department, as they will need to know that the stock donation needs to be reduced by the amount applied to the system as pledge receivable. Once they have this information, they will make corresponding edits within their own system to ensure that both systems match.

Jesse Calagna 2 · May 2019

I cannot adjust the gift to $0 because it is a stock that has been sold - i can only adjust the sale of the stock to $0

Austen Brown · May 2019

Hi Jesse - I found this article in knowledge base (No. 51166). It looks like you need to delete the record of sold stock/property information from the original gift record, then create an adjustment. If the gift is posted and you cannot delete this portion of the gift while it is posted, you will need to run the "UnPost Gifts" Plug-In, so you will be able edit the gift record.

To run the "UnPost Gifts" Plug-In create a gift query with the gift you need to un-post. Make sure no other users are logged into the system, and go to Plug-Ins on the left navigation column and scroll right until you find "UnPost Gifts". First, find the gift query you previously created; note, if you click "Begin" with no query linked, the Plug-In will un-post every gift record in RE. After your query is linked and appears in the query field, click begin. After this has run, you will be able to make the necessary edits to the original gift record.

Let me know if you have any other questions.

Christine Adams · May 2019

1. I take a screen shot of the original stock gift including the sale information and create a word document.

2. Delete the gift

3. Enter the new and also supply screen shots of the new gift.

I send all this to Finance. Our gift feeds feed over the stock gain/loss and because it’s already been fed to our Banner system, I can’t feed over any adjustment (the gift was deleted) and I don’t want it doubled.

It’s a pain!

Jesse Calagna 2 · May 2019

Those both sounds like good ideas. My biggest issue is the stock is sold and therefore not adjustable (only sale of stock is adjustable), as well as it going from a cash gift to a pledge payment which complicates things. I also have one that is going from a cash gift to a pledge pay with some overage.

Adjusting a Stock gift that has been sold and posted already

Comments

Categories