I was curios if anyone uses the fund relationship in the Relationships tab of RE7?  If your company does use it, how do you use it?  I noticed when I read the user guide it indicates it is to affiliate a fund that the person has established and was wondering if anyone uses it to record just funds that the donor gives to regularly?

 Thanks for any assistance you can provide.

Hi Heather.

We use the Fund relationships on the relationship tab. We use it to see who are advisors, committee members, or fund statement recipients.

Karen

khartt@mainecf.org

We use Fund Relationship for Family members of those named in our Endowed Scholarships ie.  The John Jones Scholarship for painting has its own fund 6999.  Then Mr. Jones and his family would have a Fund relationship(s). we have all our scholarship students send thank yous to any family members attached to the scholarship and this makes it easier

Like Karen, we also use it for fund statement purposes.

I must say, however, that the ability to query on the fund relationship is currently VERY limited.  If you're doing a fund query, you can do much more but if you're doing a constituent query and trying to get the fund relationship information, that's an issue.

I would definitely recommend looking at what you can query before putting a lot of work into building these. 

I think, however, that they are in the process of improving this and we have a Community Foundation web meeting later this month where this will be discussed. So hopefully this will be improved soon!

Gina

gg@nhcf.org

Hi,

We use the fund tab relationship tab as follows:

For every endowment fund we create relationship to the constituent who established that fund. We also create relationship for those donors who contribute to the fund and would like to get a yearly report on the fund status. In addition, to keep everything in the same place, we create relationships to custodians - administrators of the fund. At this time we are exploring the options of creating relationships between funds and students, for scholarships reason.

 We use the fund relationship to notate scholarship reciepeints and scholarship donors.  Works quite slick actually.

We are looking at doing the same thing.  What relationship types did you create?  I've been thinking of 'financial report to' and 'fund sponsor.'  Do you store any fund balances, distributions and earnings on the fund record?  I'm not seeing great ways to do that and wonder how you report back in the yearly fund report.

Thank you,

Dwight

Hi Dwight,

We do use a fund relationship code, for our donor advised funds (they have Fund advisor), outside committees for funds (scholarship and FOI, they have Committee Member), and for NPO's that have endowments (they have a Fund Statement).

Karen

We use the fund relationship for named scholarships - for the scholarship contact, the scholarship honoree, and the scholarship recipient.  We use fund attributes to track things like last awarded  YYYY semester; special requests, such as a mass on the birthday of the honoree; awarded at a particular ceremony, first gift for endowed; etc.  Although most of this information is in the scholarship agreement/contract, by using attributes, it it easily reportable.

We use it to list the constituent's relationship to the fund; donor, fund successor, solicitor, etc.

We haven't used it in the past so am reading this string with interest.  I can see using it for named scholarships/funds, DAF, memorials etc. 

Janices, do you actually add each donor's name, every solicitor?  Do others do this?  To me this seems redundant and unnecessary.  As under fund, I have solicitors and can easily query on donors.  This almost seems to overlap with constituent code on gift record.

Other thoughts?