Skip to content
← CommunitySuite Idea Lab

How can we improve CommunitySuite? Search or submit ideas below.

CommunitySuite Idea Lab: Donations/Pledges/Promises/Public Securities

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Public Securities Donations To Multiple Funds

Would like the ability to split or allocate a public security donation to more than one fund.

30 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

David Weisz shared this idea  ·   ·  Report…  ·  Admin →
Implemented  ·  AdminSkye Weber (Admin, Foundant Technologies) responded  · 

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 desc



ription, trans id, and unit cost. This report also includes all profile, account, admin fee, distribution and fund fields.

Show previous admin responses (10)
Comments are closed An error occurred while saving the comment
  • Brandie Fand commented  ·   ·  Report

    We need to be able to add public securities donations to multiple funds.

  • Lee O'Neil commented  ·   ·  Report

    Consider allowing public securities as a profile payment type. I have a donor who gives gifts of stock each year to be split between 5 funds. With a normal check payment, I'd start in the payments window and split the donation from there. But there is no public securities option, meaning I need to add it all into one fund and create Interfund Transfers.

  • Sally Gillespie commented  ·   ·  Report

    Desperately need this in order to establish a link between donors and all the funds they support. It is a common occurrence for our donors to make a lump sum gift by securities and allocate it across multiple funds.