• Replies 6 replies
  • Subscribers 414 subscribers
  • Views 80 views
  • Users 0 members are here
Related

Fixing Membership Levels

Brian O'Neill
$organization

I should be able to pull a quick report to find our current donors based on level, but the results are not accurate. I believe they are pulling from funds that it shouldn't (such as elevated events and donated tickets). I'm looking for advice on how best to set up our membership levels so that when I'm asked how many members we have at a certain level I can easily report on that.

Parents
  • $organization
    Alternatively, you would need to examine your membership setup and which funds are tying to a campaign that triggers a membership. This gets complicated, but the gist as I understand it is:

    - Money is put on a certain fund
    - Each fund is tied to a certain campaign for each fiscal year (different funds can be tied to different campaigns, but each fund can go to only one campaign)
    - Each campaign is set to either create memberships or not create memberships

    So when a gift is given, the system goes through the following logic:
    Which fund is it on? --> Which campaign is it on? --> Does that campaign say that you should create memberships from it? --> 1) If not, no membership is created. 2) If the campaign does say to create memberships, then it looks at your membership organization to see what dollar level the gift is at, which determines which level of membership gets created.

    Keep in mind that you can have different funds go to the same GL number. I have a bunch of different funds that all go to the same GL, just so I can do more detailed break-outs in my reports but Accounting still gets all the money in the right place. In theory, it sounds like what you need is some funds for some of those "extra" things, like events and donated tickets, which do NOT tie to a membership-creating campaign. Then your numbers should line up.

    Beth

    *   *   *   *   *
    How do astronauts get to space? How do they eat, sleep, and do research in a weightless environment? And how do they go to the bathroom? Find out during an unforgettable day of space exploration at the world premiere Space exhibition. It's now open at the Science Museum of Minnesota, along with the brand new Omnitheater film, Journey to Space. Visit www.smm.org/space to plan your visit today!

    From: "Megan Hall" <bounce-meganhall6920@tessituranetwork.com>
    To: evarro@smm.org
    Sent: Tuesday, August 25, 2015 12:00:20 PM
    Subject: Re: [Tessitura Development Forum] Fixing Membership Levels

    Hi Brian,

    If your membership set-up isn't serving this data need, you will probably need to build a custom report. We hired Klearsky to write one for us that has functioned great. We look at gifts made to specific funds by fiscal year, rather than rolling 12-month period, so it was inexpensive to set up the logic.

    Megan
    Seattle Symphony

    From: Brian O'Neill <bounce-brianoneill8854@tessituranetwork.com>
    Sent: 8/24/2015 11:18:58 AM

    I should be able to pull a quick report to find our current donors based on level, but the results are not accurate. I believe they are pulling from funds that it shouldn't (such as elevated events and donated tickets). I'm looking for advice on how best to set up our membership levels so that when I'm asked how many members we have at a certain level I can easily report on that.




    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!
Reply
  • $organization
    Alternatively, you would need to examine your membership setup and which funds are tying to a campaign that triggers a membership. This gets complicated, but the gist as I understand it is:

    - Money is put on a certain fund
    - Each fund is tied to a certain campaign for each fiscal year (different funds can be tied to different campaigns, but each fund can go to only one campaign)
    - Each campaign is set to either create memberships or not create memberships

    So when a gift is given, the system goes through the following logic:
    Which fund is it on? --> Which campaign is it on? --> Does that campaign say that you should create memberships from it? --> 1) If not, no membership is created. 2) If the campaign does say to create memberships, then it looks at your membership organization to see what dollar level the gift is at, which determines which level of membership gets created.

    Keep in mind that you can have different funds go to the same GL number. I have a bunch of different funds that all go to the same GL, just so I can do more detailed break-outs in my reports but Accounting still gets all the money in the right place. In theory, it sounds like what you need is some funds for some of those "extra" things, like events and donated tickets, which do NOT tie to a membership-creating campaign. Then your numbers should line up.

    Beth

    *   *   *   *   *
    How do astronauts get to space? How do they eat, sleep, and do research in a weightless environment? And how do they go to the bathroom? Find out during an unforgettable day of space exploration at the world premiere Space exhibition. It's now open at the Science Museum of Minnesota, along with the brand new Omnitheater film, Journey to Space. Visit www.smm.org/space to plan your visit today!

    From: "Megan Hall" <bounce-meganhall6920@tessituranetwork.com>
    To: evarro@smm.org
    Sent: Tuesday, August 25, 2015 12:00:20 PM
    Subject: Re: [Tessitura Development Forum] Fixing Membership Levels

    Hi Brian,

    If your membership set-up isn't serving this data need, you will probably need to build a custom report. We hired Klearsky to write one for us that has functioned great. We look at gifts made to specific funds by fiscal year, rather than rolling 12-month period, so it was inexpensive to set up the logic.

    Megan
    Seattle Symphony

    From: Brian O'Neill <bounce-brianoneill8854@tessituranetwork.com>
    Sent: 8/24/2015 11:18:58 AM

    I should be able to pull a quick report to find our current donors based on level, but the results are not accurate. I believe they are pulling from funds that it shouldn't (such as elevated events and donated tickets). I'm looking for advice on how best to set up our membership levels so that when I'm asked how many members we have at a certain level I can easily report on that.




    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!
Children
No Data