stock gift entry - import, update description and entry order
1- Ability to import securities - helpful as some donors contribute 20+ stocks at a time
2 -Auto complete the description of the security (but field should be able to be edited if needed). The database pulls the high / low information so it should also be able to pull the name of the security
3 - Keep the securities listed in the order they are entered. For some reason csuite re-orders (in no particular order) the securities after saving the entry making it difficult to review the stock gift entry
Wendy Ponting
shared this idea
9/4/2024: Donations: Enhanced the Public Securities workflow. Added the ability to import of stock on the donation record and sell of stock. Updated the securities table to use commas and six decimals places for Quantity and Unit Cost. Description will auto populate using the stock name and quantity of stock on look up of stock during creation, but not on edit of a security. Users have the option from the left hand menu to Upload file. This will allow for a .csv file with symbol, qty, description, unit_cost. Symbol and quantity are required fields on the import. User can use the csv template on the left hand menu to download the template for importing.
Public Securities: Added the ability import the sale of securities. Users will enter the sale date and account information. The fund field will auto-populate using the fund from the donation record and accounts. Users will enter the quantity, sale amount, and fee amount. Transactions have will now Ref public_security id.
Profile Payment: Added Public Securities as a payment method in Payments. This will allow users to add multi-fund donations. From Payments, users will enter date, fund, and public security. Users will be prompted to the Add Securities table, import is available from left hand menu. After Securities are added the users can then apply amounts through donation, invoice, or tickets.
Custom Report: Added a Public Securities Sales custom report. This will allow users to populate a report with cost basis, gain loss, net deposit amount, post date pssh id, pub sec id, ref, ref id, sale amount, sale date, sale days, sale fees, sale qty, sale unit price, ticker symbol, security description, trans id, and unit cost. This report also includes all profile, account, admin fee, distribution and fund fields.
-
Anna Wagner
commented
Since being released, we're very disappointed as it isn't helping the need. The description field is not populating with the stock name. The new population is just repeating what was already there (symbol and quantity) and provides no value. We still have to take out what is populated and replace it with the security name. Can you have it pull the security name to populate the description field?
-
Anna Wagner
commented
The description field is not populating with the stock name. The new population is just repeating what was already there (symbol and quantity) and provides no value. Can you have it pull the stock name to populate the description field?
-
Tiffany Peterson
commented
Would also like same securities fields in donor tax receipts to be fields in Year End donor letters. We do these manually when the data is now built into fields for donation tax receipts.
-
Sally Gillespie
commented
I would also like the ability to run a single report that shows security donations with gift value and net proceeds of security sales with the donor names. When stock gifts are paying a pledge and the donation value is less but the proceeds are more, it would helpful to have a consolidated report to be able to easily see who truly has a balance owed on their pledge and who's balance should be cancelled.