Securities
Create a securities report that shows the fund, securities donated and the subsequent sales of each security. This would make it quick and easy to see which funds still have securities from original donations that need to be process through the sell process rather than the a statement voucher that just records the gains and losses.
Adam Riding
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.
