FundSvcs Community

 View Only
  • 1.  Hierarchy of corporate records in conversion to Affinaquest

    Posted 10-18-2023 01:29 PM

    Our institution is in the process of changing systems, we are in Ellucian Advance and will be going to Affinaquest. We are currently evaluating how to establish a corporate hierarchy as we move into Affinaquest. Our current business process is to establish a new organization/foundation/etc. entity in Advance when we receive a donation for an organization with an address different than the one listed for the organization already in the system. Is this best practice?

    For those institutions that have created a corporate/business hierarchy, how have you gone about that process?

    • How did you decide which record to use as the "parent" organization / top of the hierarchy (corporate headquarters, branch working with your development staff)?
    • How do you handle capturing company giving associated with 3rd Party Vendors (i.e., Benevity, YourCause, Cybergrants, etc.)?
      • Do you handle matching funds differently than the employee payroll donations, when received through a 3rd Party Vendor?


    ------------------------------
    Lora Miller
    James Madison University
    mille7la@jmu.edu
    ------------------------------


  • 2.  RE: Hierarchy of corporate records in conversion to Affinaquest

    Posted 10-18-2023 01:43 PM
    Lora, regardless of the CRM, the hierarchy is typically standard:
    • The corporate HQ for the business is the "parent," even if the parent never makes a donation to you. You determine the HQ by looking up the corporate record using Google ['Ford Corporate Headquarters'] or D&B Hoovers.
    • Individual branches and offices that make donations on their own are subsidiaries of that parent.
    • Once in a while, a corporation is so large that it has regional HQs. Those are set up as subsidiaries of the parent company. Any branches under those subsidiaries are set up as subsidiaries of the regional office. Whether you also want to link that branch to the parent is up to you. However, you may want all sub-organizations to be set up to give automatic soft credit to the parent to see the entire financial relationship.
    • Any affiliated foundation is also created as a subsidiary of the parent. That foundation rarely has any subsidiaries.
    • Third-party gifts are recorded for hard credit on the third-party record (i.e., America Online Giving Foundation). These are NOT subsidiaries of the company. You then assign soft credit according to your policy, typically giving the employee 100% soft credit for their gift and the company match, and the company gets soft credit for just their match.
    There are variations on this strategy. However, this is the structure I find most common.

    John

    John H. Taylor
    Principal
    John H. Taylor Consulting, LLC
    2604 Sevier St.
    Durham, NC   27705
    919.816.5903 (cell/text)

    Serving the Advancement Community Since 1987






  • 3.  RE: Hierarchy of corporate records in conversion to Affinaquest

    Posted 10-19-2023 06:54 AM

    Hi Lora,

    We would set up separate entities for different addresses with the exception of home office addresses. In Affinaquest we would use Relationships and relate a parent and subsidiary with Account roles of "Organization" and "Subsidiary" the idea being that "Organization" is inherently the parent in the relationship when the other is "Subsidiary." Then in hierarchies that have more than two levels, one Account might have a role as "Organization" to "Subsidiary" with one account but be just the opposite in their relationship with another Account.

     

    Regarding the 3rd party companies that facilitate matching gifts but technically operate as donor advised funds; we are recording them as donor advised funds. Even if you don't use "Matching Gift" as a method, you can still link it to a matched donation so you could go that route and drive reporting based on records that have a matched gift reference ID if are looking for ways to group these together.

     

    Regarding the comparison to employee payroll deductions that come through those same companies. Since we are managing both scenarios as donor advised funds, and thus not using the matching gift method, we would handle them in the same batch.  We would HC the DAF and soft credit the donor/advisor on the gift transaction and then for the "match" we would hard credit the DAF and soft credit the donor/advisor and the matching company. I'm sure there are multiple ways to handle these situations, with none being perfect, but that is how we are doing it.

     

    Hope that helps,

     

    John Smilde

    Director of Gifts and Records Administration

    Advancement and Alumni Relations

    George Mason University

    4400 University Drive, MSN 1A3

    Fairfax, VA 22030

    703.993.8680

    jsmilde@gmu.edu

     

    This electronic message contains confidential information which is, in whole or in part,

    subject to exclusion from disclosure under the Freedom of Information Act pursuant to

    §2.2-3705.4.7. of the Code of Virginia.