Dealing with Soft Credits and Cont. Total in Solicitations

Hi!

We are wondering how others handle Soft Credts(Creditees) and Cont. Total in Solicitations.

When we receive a gift, for an Individaul from a Family Foundation, we enter the gift in the Foundation record and make the Individual a creditee.  The Solicitation is in the Individuals record, but since the gift is in the Family Foundation record, the Cont. Total in the Solicitation does not reflect the gift amount. In order to pull reports we would like the Cont. Total to reflect the gift amount.  Does anyone deal with this, in a way other than by putting the Solicitation in the Family Foundation record?

Thanks,  Melissa

LA Philharmonic

  • HI Melissa,

     

    We have the same issue, but have worked around it by leaving the Solicitation in the Individual account, but filling out the Recd (Recorded Amount) field and adding a note in the Notes section that the donor paid through their foundation.  It works for us because we use Solicitations mainly as a portfolio monitoring tool, not so much for financial planning so the lack of Cont. Total amount isn’t a huge deal for us.

     

    Christine Pellerin  Development Coordinator
    Soulpepper Theatre Company

    T 416.203.6264 x.145
    F 416.203.1531
    W soulpepper.ca


    Young Centre for the Performing Arts
    Distillery Historic District

    50 Tank House Lane
    Toronto, ON, M5A 3C4


    Box Office: 416.866.8666

     

    Donate Now to Soulpepper online at http://www.soulpepper.ca/donation.aspx

     

    Follow Us: 
    Description: FacebookDescription: TwitterDescription: YouTube

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Melissa Malone
    Sent: Monday, September 16, 2013 3:01 PM
    To: Christine Pellerin
    Subject: [Tessitura Development Forum] Dealing with Soft Credits and Cont. Total in Solicitations

     

    Hi!

    We are wondering how others handle Soft Credts(Creditees) and Cont. Total in Solicitations.

    When we receive a gift, for an Individaul from a Family Foundation, we enter the gift in the Foundation record and make the Individual a creditee.  The Solicitation is in the Individuals record, but since the gift is in the Family Foundation record, the Cont. Total in the Solicitation does not reflect the gift amount. In order to pull reports we would like the Cont. Total to reflect the gift amount.  Does anyone deal with this, in a way other than by putting the Solicitation in the Family Foundation record?

    Thanks,  Melissa

    LA Philharmonic




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • We had a similar issue. We wanted to include people who were "credited" for gifts as well.

    We had our DBA build custom list criteria and outputset elements to include Soft Credits. I have Contribution w/ SC, Fund w/ SC, Total Giving w/ SC, etc.

    Another option might be to have custom element that pulls the value of the "Recorded Amount" in a list or output set 

    Thanks, 

    Marie Kocher
    Development Assistant
    Kansas City Ballet
    500 W Pershing Rd
    Kansas City, MO 64108
    816-931-2232
    www.kcballet.org

    From: Tessitura Development Forum [forums-development@tessituranetwork.com] on behalf of Melissa Malone [bounce-melissamalone3834@tessituranetwork.com]
    Sent: Monday, September 16, 2013 1:02 PM
    To: Marie Kocher
    Subject: [Tessitura Development Forum] Dealing with Soft Credits and Cont. Total in Solicitations

    Hi!

    We are wondering how others handle Soft Credts(Creditees) and Cont. Total in Solicitations.

    When we receive a gift, for an Individaul from a Family Foundation, we enter the gift in the Foundation record and make the Individual a creditee.  The Solicitation is in the Individuals record, but since the gift is in the Family Foundation record, the Cont. Total in the Solicitation does not reflect the gift amount. In order to pull reports we would like the Cont. Total to reflect the gift amount.  Does anyone deal with this, in a way other than by putting the Solicitation in the Family Foundation record?

    Thanks,  Melissa

    LA Philharmonic




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • Former Member
    Former Member $organization

    I would love to hear if anyone has a solution to this as well. I have generally found the Solicitation "Cont Total" unreliable for that reason, but also because we frequently have major donors we cultivate with an "Undesignated" solicitation who then decide to allocate portions of their annual gift to multiple funds/designations. I don't want to make our major gifts officers create multiple solicitations for a gift we've already received just so that the contribution totals calculate correctly.

    Once Solicitations become Plans in v12, you can manually link a contribution to a constituent's Plan when the contribution is entered. That should resolve my second issue, but I've experimented a little in the v12 Sandbox and as far as I can tell you still can't link a contribution to a Plan on a creditee's account, so the cont total for the creditee still won't reflect the gift.

    I don't know, technically speaking, how that number gets calculated, but if it's just a number in a table somewhere it seems like somebody who's savvy with the Tessi back end ought to be able to develop a script to update it periodically with credited giving. Probably one of those things that's easier said than done, though!

  • Matthew - 

    We are also anxiously awaiting v12 - as we are looking to attached all different sorts of contributions to a single plan.

    I've done some work in the sandbox as well - and found a possible solution for seeing plans and credits in both your individual and foundation accounts (for example).

    We've moved to a process where the solicitation (plan) sits on the account where we expect to get the money (lilke a foundation, for example). In v12, when you add in the individual as part of a step (using the Associate ID) - then the plan will suddenly appear in that individual's account as well. Think of it like a "soft plan" :)

    Example: If you go into the sandbox, you can see that the real plan I created is on account #70359, but it shows in accounts #70328 and #70363. These were Associate IDs added to Steps in the Plan. Merely putting in a Relationship to the foundation, nor putting an Initiator on a gift attached to the Plan does NOT get the plan in their account.

    So, in short, if you can start to track solicitations in the payee account in v11, then in v12 you can add in your creditee via a step, and then see the Plan from the creditee's account. (At least that was my finding in the sandbox...)

    Beth

  • Former Member
    Former Member $organization in reply to Beth Gilliland

    Thanks, Beth--that's a great tip! I will definitely have to play with that some more. Issues with the cont. total aside, being able to associate others to a Plan through steps will definitely come in handy.

  • This is great. 

    Thanks for all the input.

    Melissa

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Matthew Echert
    Sent: Wednesday, September 18, 2013 12:53 PM
    To: Melissa Malone
    Subject: Re: [Tessitura Development Forum] Dealing with Soft Credits and Cont. Total in Solicitations

     

    Thanks, Beth--that's a great tip! I will definitely have to play with that some more. Issues with the cont. total aside, being able to associate others to a Plan through steps will definitely come in handy.

    From: Beth Gilliland <bounce-bethgilliland6030@tessituranetwork.com>
    Sent: 9/18/2013 9:56:03 AM

    Matthew - 

    We are also anxiously awaiting v12 - as we are looking to attached all different sorts of contributions to a single plan.

    I've done some work in the sandbox as well - and found a possible solution for seeing plans and credits in both your individual and foundation accounts (for example).

    We've moved to a process where the solicitation (plan) sits on the account where we expect to get the money (lilke a foundation, for example). In v12, when you add in the individual as part of a step (using the Associate ID) - then the plan will suddenly appear in that individual's account as well. Think of it like a "soft plan" :)

    Example: If you go into the sandbox, you can see that the real plan I created is on account #70359, but it shows in accounts #70328 and #70363. These were Associate IDs added to Steps in the Plan. Merely putting in a Relationship to the foundation, nor putting an Initiator on a gift attached to the Plan does NOT get the plan in their account.

    So, in short, if you can start to track solicitations in the payee account in v11, then in v12 you can add in your creditee via a step, and then see the Plan from the creditee's account. (At least that was my finding in the sandbox...)

    Beth




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This email and any attachments may contain confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately, delete this email, and do not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of the Los Angeles Philharmonic Association. The LA Philharmonic does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract.