Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Merging two foundation records

Last post 03-31-2009 1:52 PM by Laurel Quaintance. 8 replies.
Page 1 of 1 (9 items)
Sort Posts: Previous Next
  • 03-31-2009 11:30 AM

    • Vickie Birch
    • Not Ranked
    • Posts 4
    • Organization: Eastern Virginia Medical School

    Merging two foundation records

    Question:  If two foundations (that are constituents) are merging with a new name, what is the best way to merge their records?  Should I merge both records, using new name and placing old names as alias?  When gifts are merged, will I be able to see the history of who gave through which original foundation?  Or, should I keep the original records and create a new one for the merged foundation, linking them as relationships?  Thanks for any help you can give.

     Vickie Birch

     

    Filed under:
  • 03-31-2009 11:35 AM In reply to

    • Melissa Graves
    • Top 10 Contributor
    • User Since: 2002
    • Posts 1,153
    • Organization: Village for Families and Children
    • Products:  The Raiser's Edge

    Re: Merging two foundation records

    If it is important to you to see which original foundaton gave which gift then I would not merge them because you will lose that history.  I would create the new foundation, inacivate the old foundations, link the old foundations to the new foundation via relationships.  It would be up to you to decide if you want to go back through old gifts and soft credit the new foundation so all combined giving history shows (in soft credit form) on the new foundation.

    Melissa S. Graves
    Annual Fund Database Manager
    Pathfinder International
  • 03-31-2009 11:37 AM In reply to

    • Melissa Graves
    • Top 10 Contributor
    • User Since: 2002
    • Posts 1,153
    • Organization: Village for Families and Children
    • Products:  The Raiser's Edge

    Re: Merging two foundation records

    oh and still put the names of the old foundations in the alias on the new foundation in case someone searches by the old name.

    Melissa S. Graves
    Annual Fund Database Manager
    Pathfinder International
  • 03-31-2009 1:01 PM In reply to

    • Vickie Birch
    • Not Ranked
    • Posts 4
    • Organization: Eastern Virginia Medical School

    Re: Merging two foundation records

     That and the gift history as some people gave through each foundation.  I am not sure if that information is still captured if a merge the two records.

  • 03-31-2009 1:02 PM In reply to

    • Vickie Birch
    • Not Ranked
    • Posts 4
    • Organization: Eastern Virginia Medical School

    Re: Merging two foundation records

     Thanks Melissa,  that is alot of help.  As I have been thinking this through, my thought pattern was the same.

  • 03-31-2009 1:31 PM In reply to

    • Julie Stogsdill
    • Not Ranked
    • User Since: 2001
    • Posts 2
    • Organization: Hospice of the Calumet Area
    • Products:  The Raiser's Edge

    Re: Merging two foundation records

    Vickie:

     I believe that the merge feature would work well in this case, especially if you want to make sure the most current name and contact information is used on future correspondence. You can retain the data, and I would definitely use the alias for the old names, but you can merge as many fields as you want or all of them. That way, you have an accurate picture of the new entity as well as its history.

    Julie Stogsdill

  • 03-31-2009 1:35 PM In reply to

    Re: Merging two foundation records

    Make sure you included soft credits in the merge if you have soft credited individuals that pay through the foundations

    Laurel Quaintance
    Manager, Fund Development Services
    Friends of Bassett, Inc.
    607/547-3081

    Donate Now! https://www.friendsofbassett.org/fob.php

    Bassett Healthcare: Right Where You Need Us

    Bassett Healthcare, A network of 5 Hospitals and over 25 Health Centers, offers the finest medical care to residents of rural Central New York
  • 03-31-2009 1:42 PM In reply to

    • Melissa Graves
    • Top 10 Contributor
    • User Since: 2002
    • Posts 1,153
    • Organization: Village for Families and Children
    • Products:  The Raiser's Edge

    Re: Merging two foundation records

    I do not beleive that the merge function retains which original foundation the original gift was on.  All you know is the aliases of the two foundations before the merge but not which gifts belong to which.  I would not call that retaining the data - I would call that a loss of data.

    You could go through the trouble of adding an attribute or note to all of the gifts before you merge so you can retain this information.  I would not merge however because of the potential loss of history even if I noted all of the gifts.  Who looks that deep on a gift to attributes/notes?

    I might use merge to copy and bring over the biographical info and relationships if contacts are the same but would not merge gift history, actions, appeals, proposals, etc.

    Melissa S. Graves
    Annual Fund Database Manager
    Pathfinder International
  • 03-31-2009 1:52 PM In reply to

    Re: Merging two foundation records

    sorry - my reply didn't make it clear - I was trying to answer this specifically - If you merge records: 'That and the gift history as some people gave through each foundation.  I am not sure if that information is still captured if a merge the two records'.

    I agree with Melissa  I would keep the two old organizations separate - create a new record for the new merged org - put aliases of the old organizations on the new org. Copy over any relevent info to the new record and I would annotate the old records to make sure that  data entry personnel do not accidnetally continue putting gifts on the old record - and to let view only folks know that a new org has been created.

    Laurel Quaintance
    Manager, Fund Development Services
    Friends of Bassett, Inc.
    607/547-3081

    Donate Now! https://www.friendsofbassett.org/fob.php

    Bassett Healthcare: Right Where You Need Us

    Bassett Healthcare, A network of 5 Hospitals and over 25 Health Centers, offers the finest medical care to residents of rural Central New York
Page 1 of 1 (9 items)