FundSvcs Community

 View Only
  • 1.  Sale of Gift in Kind

    Posted 25 days ago

    Dear Colleagues,

    Last fiscal year, a donor generously gifted our university a house, which we recorded in our database as a gift-in-kind based on the appraiser's valuation. The donor's intent was for the property to be sold, with proceeds supporting an endowed named scholarship. This year, the university sold the house at a price lower than the appraised value, and the funds are being directed into the endowment investment.

    My question is: how should we record this transaction in our database so that it reflects the appropriate book value for future financial reports, while ensuring it does not appear as newly raised funds or cash for the current fiscal year? What is the best practice in such cases?

    Thank you 

    Farida Ahmed

    Director, Gift Administration

    The American University in Cairo



    ------------------------------
    Farida Ahmed
    The American University in Cairo
    farida@aucegypt.edu
    ------------------------------


  • 2.  RE: Sale of Gift in Kind

    Posted 25 days ago
    You do not report and sales of gifts in your fundraising database. You only record the value of all property gifts as of the date of gift. Your Business Office will handle the sales, gains, and losses on the GL.

    Some of my clients have noted a significant value difference in a contact report on the prospect record. But that's not always done.

    John

    John Taylor Principal, John H. Taylor Consulting, LLC 919.816.5903 Big ideas; small keyboard





  • 3.  RE: Sale of Gift in Kind

    Posted 25 days ago
    Farida, sales of property can be recorded in your database - the most common case is stock sales, but you can use the same functionality and approach for land or any other property. The mechanics will vary depending on your database, but, for example, in the Raiser's Edge, the Stock/Property tab in the gift record has fields there for storing the sale amount and gain or loss. 


    Thank you,
    Isaac Shalev
    Data Strategy Expert
    Sage70, Inc.
    (917) 859-0151
    isaac@sage70.com

    Schedule a 30-minute consultation now:







  • 4.  RE: Sale of Gift in Kind

    Posted 25 days ago
    Indeed some CRMs allow you to capture this information.

    However, in response to the original email, official fundraising totals are not affected by those sales. No "additional" gift is entered, nor any change to that original amount including gains or reductions should the asset be sold at a loss.

    John Taylor Principal, John H. Taylor Consulting, LLC 919.816.5903 Big ideas; small keyboard







  • 5.  RE: Sale of Gift in Kind

    Posted 24 days ago

    I agree with you that we should not enter the amount received from the sale of the house as new money. However I wanted to know the best practice on how we should record the book value of the endowed fund created from the sale in our database-should we simply note the book value of the endowment as a comment within the newly established fund entry?



    ------------------------------
    Farida Ahmed
    The American University in Cairo
    farida@aucegypt.edu
    ------------------------------



  • 6.  RE: Sale of Gift in Kind

    Posted 24 days ago
    Where I have worked, updating the book value has been a function of the Business Office as performed on the GL. In the Advancement CRM, we record (as a gift) the legal value of the donation as of the date of the gift, prior to the sale of the gift. This value is also what is recognized by Finance as the "corpus."

    I, Isaac, and others have suggested locations in various CRMs where you might want to note additional values.

    In many cases, Advancement offices do not need to track these "non-gift" values and changes. Often, they use other software, such as Fundriver, accessible to the Advancement team, to review those additions.

    John

    John H. Taylor, Principal
    John H. Taylor Consulting, LLC
    2604 Sevier Street
    Durham, NC     27705

    919.816.5903 (cell/text)

    Serving the Advancement Community Since 1987







  • 7.  RE: Sale of Gift in Kind

    Posted 24 days ago
    Thank you

    Highly appreciate your reply

    Regards
    Farida




    Farida Ahmed

    Director, Gift Administration

    The American University in Cairo

    AUC Avenue. P.O. Box 74. New Cairo 11835, Egypt

    Administration Building, room P072

    T  +20 (02)2615-2481

    C +20 0122 177 8696

    E farida@aucegypt.edu