Type in your suggestion - new feature or improvement idea

Prorating Membership Level Upgrades

Copied from another discussion -

Discount coupons discussed here are only for new member applications.

What you are talking about is prorating the membership payment when members change their level - applying unused membership fee and/or reducing the new fee if new membership level is not for a full period. We are working on this - it would be great if you could start a new thread on the wishlist forum to explain how you would like to see it work.

How our org would like it to work -

Ex - level a - $35 annual fee and level b - $50 annual fee

If a person joins at level a and somtime during the year decides to move to level b, then the software would figure the difference (50-35=15) and charge a $15 upgrade fee. No change occurs to the renewal date. We would like a user defined comment that pops up prior to the transaction being completed. For example, in our case, prior to the person committing to the upgrade, a comment like

"This upgrade will apply to your current membership period. It is not prorated or refundable. Your next renewal will be at the $50 level b annual rate.

If you are near to your level a renewal date, you may wish to delay your upgrade until after your level a renewal."

16 votes
Sign in
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    gypsegypse shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


    Sign in
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      • JerryJerry commented  ·   ·  Flag as inappropriate

        We have the above need, and also other issues with member levels and renewals.

        The issue we have falls into the category that others mention - free first year dues etc. If the member level had the ability to have a first year dues (which could include initiation fees) and a different renewal fee, the issue would be resolved.

        Also, we have members who wish to renew for multiple years. The only way to do that currently is for them to issue the member renewal multiple times. We've had a few figure this out, but it's not very intuitive and certainly not straight forward. The better way would be for WA to have an option to allow for x number of renewals with the member being able to select how many periods they wish to renew for at the time they renew. The invoice would then be calculated based on the annual renewal fee and the member has complete control without involving our volunteer staff to make the changes via admin privileges.

        The other issue we have which others have expressed concerns about. (Dimity has even commented to me that this is something that needs to be addresses) is the issue of changing member levels. We have some levels that members should not be able to change to and others where they should be able to do so. The issue is the next renewal date is not calculated correctly. It assumes the member level being changed to starts all over. In our case a member could be paid through 1/1/18 and when the level is changed, it reverts to a new renewal date of 1/1/17 rather than keeping the same date it had. As a result having the ability for a member to change levels creates a serious problem. This even happens when an admin changes the level is a constant source of errors and double checking manually to keep things straight. With a large club, this defeats many of the benefits of using WA in the first place for member management.

        We just need WA to offer more flexibility in the primary area that we use the site for in the first place - Member Management.

      • Russell NobleRussell Noble commented  ·   ·  Flag as inappropriate

        Simply apply the calculations for the upgrade as if the member we applying as new. At the moment the same person can apply for an upgrade or an outright new membership at the same level and for the same price receive two different renewal dates.

      • OlegOleg commented  ·   ·  Flag as inappropriate

        When level is changed, new level renewal dates and fees apply. No prorating can be applied currently (see help http://help.wildapricot.com/display/DOC/Renewal+date+calculation#Renewaldatecalculation-Formemberlevelchanges ).

        It means that if your member updates to new level (say, Gold membership) on July 1st, and renewal date for Gold membership is July 15th, he will receive renewal notification for the full price of Gold membership before July 15th (according to renewal reminders setup).

        The same works if renewal date is linked to application date (e.g. renew yearly on application date). This is discussed in these threads:
        * Prorate membership level upgrades http://forums.wildapricot.com/forums/308932-wishlist/suggestions/8825686-prorating-membership-level-upgrades-7030
        * Change membership level during upgrade http://forums.wildapricot.com/forums/308932-wishlist/suggestions/8826244-provide-a-way-to-change-membership-level-during-re

        If this is not your case, please elaborate more

      • J BuckleyJ Buckley commented  ·   ·  Flag as inappropriate

        Has this been addressed?

        We have an issue where a member upgrades their membership level, and pays, just before their renewal yet they still receive a renewal notification stating that they need to pay. The system shows that the member paid, with the correct date yet it still shows that they need to renew. It's happened twice now and it's eroding confidence in our system.

        Please advise.

      • pollockkpollockk commented  ·   ·  Flag as inappropriate

        Thank you Mr. Chief for the quick response.

        I am pleased that you have this issue in your sights. please let me know if you need any help with testing or logic on this problem.

        We all have the same goal - make WA do everything for everyone!

        Kim P.

      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        Thanks for the detailed description. What we have now is that WA does not really deal well with level changes which happen at the same time as renewals - it assumes they should be handled separately. This is definitely something we would tackle - it's on our roadmap.

      • Susan AdamsSusan Adams commented  ·   ·  Flag as inappropriate

        Our need is a bit different:

        We have a three-month membership (Learn to Row, or LTR) that costs $250, after which time some people choose to become regular members (Annual Row/Scull), which costs $450. These three-month memberships start at various times during the summer, coinciding with our LTR training sessions.

        If someone wants to become a regular member, and benefit from a prorated membership fee, it seems we must suspend and delete them, and then ask they to reapply. Right? This is onerous, as our membership application is pretty lengthy.

        It would be tons better if they could just convert AND get their fees prorated, just like a new member.

      • Apricot KernelAdminApricot Kernel (Product Manager, Wild Apricot) commented  ·   ·  Flag as inappropriate

        Merged last comment to existing thread.

        @chapka: what you describe makes complete sense but we have not enough resources now to make the change this year - we are busy with other things right now. Still, this is quite high in our priorities so we are keeping this problem on our radar.

      • chapkachapka commented  ·   ·  Flag as inappropriate

        Here's the problem we've run into.

        Our org has two membership levels, one free and one paid. Membership is always for the calendar year; we run events pretty much every week from March through November.

        Our membership campaign for the new year starts in late summer or early fall. This was the first year running it in Wild Apricot. We set up the "new applications" settings for the membership level so that anyone joining after September 1 or so would get a renewal date of January 1, 2013 ("charge full regular fee AND extend by one period").

        So far, great--that's exactly the functionality we wanted.

        The problem is, if someone was already a member at the "free" membership level, they don't get to take advantage of this logic. Instead, they get their existing membership level bumped up to the paid level...but their membership then expires a few months later, before the 2012 events start.

        It would be very helpful if there was some way to apply this new member logic to upgrading members as well. Maybe a fourth tab in the membership options, called "level changes"?

        Is there any way around this problem? I hate to tell people who want to pay for memberships in September to wait until January.

      • Ben RatcliffeBen Ratcliffe commented  ·   ·  Flag as inappropriate

        Hi James,

        I have exactly the same issue. I've tried a number of different approach with no joy.

        I've logged a support ticket, but I was wondering how did you get round the problem?



      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        Hi Erica, thanks for posting about this. We have been thinking about this for some time.

        I would appreciate comments from everyone, e.g.:

        - if you have different renewals dates for these two levels, how do you deal with that

        - how do you typically round remaining balance (by day, by month etc.)

      • EricaErica commented  ·   ·  Flag as inappropriate

        Allowing members, anytime during the year, to "upgrade" from one membership level to a "higher" level & apply membership fees already paid toward new membership would be really helpful.

      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        I am surprised nobody else commented on this yet - it does sound like a common need.

        Might be the thread title, I have edited it to make it more self-explanatory.

        We currently plan to implement pro-rating of membership fee for new memberships in version 3.4.

        (see http://forums.wildapricot.com/forums/308920-archive/suggestions/8831275-pro-rate-membership-fee-for-partial-periods-507 )

        Once that is done, it should become a good foundation to rationalize the level upgrade pro-ratement calculations.

        In the meantime I would appreciate thoughts and ideas from others on this thread,

      • ccappelccappel commented  ·   ·  Flag as inappropriate

        The situation we have is when a member at Level 2 pays before his due date, AND pays extra to become a member of Level 1.

        The problem:
        * If we change his Membership Level to the Level 1 when we receive his payment he's been cheated out of the remaining months of his Level 2 membership.

        * If we change him to Level 2 when he pays he's getting extra months at the higher level that he didn't pay for.
        * The only fair way to handle it is to add a year to his existing due date when he pays, and then remember to go in and change his member level to Level 1 manually on the day his original Level 2 membership expired. Obviously, this doesn't work when you have many members.

        The proposed solution:

        Add to the system the ability to change a membership level on a set date using 2 input fields (Change Level and Change Date). So in the case above, if the member's Level 2 membership expires on 1/1/10, and he pays extra on 6/1/09 to become a Level 1 member, we would handle this when we received his payment on 6/1/09 as follows:
        * Change his renewal date to 1/1/11
        * Set the Change Level menu to "Level 1"
        * Set the Change Date to 1/1/10.

        So the member gets his full year at Level 1, at which time he's upped to Level 2, and administration only has to adjust his profile once, when his payment is received.

        We're facing this issue a lot, as many of our members are renewing early (and changing levels) in order to send their payments in by the end of the year for tax purposes.


      • James KerichJames Kerich commented  ·   ·  Flag as inappropriate

        I like this idea also. Our need is similiar with a twist. In our case, we charge everyone on the same date each year for there membership dues. What will happen is someone will join during the year. We charge them a full year membership at that point. Then on the annual renewal billing date, we charge them a full year less a prorated amount for the prior year.

        For instance, we charge everyone on 9/1 of each year for their annual dues. If someone starts on 4/1 of a given year, they are charged a full year rate at that time. Then on 9/1, we provide them with a discount on their renewal for the number of months they were not members in the prior year (7 mths in this case). So if their dues was $200 charged on 4/1, we would charge them $83 on 9/1 ($200 - $117 which is $200 x 7/12).

        I think the concept is similar, but ours is retroactive instead of prospective as describe above.

      • gypsegypse commented  ·   ·  Flag as inappropriate

        oops - didn't mean to make it sound like that!!

        Once they pay the upgrade fee, they should be at level b and immediately start getting level b benefits - which for most people in our org means they can apply for jury or inclusion in a specialty index. So yes, when they upgrade I'd like the membership level to change and the date of the change recorded - but they keep the existing renewal date.

        What I was trying to convey was if they upgraded 2 months prior to their renewal date, the price is the same as if they upgrade 10 months prior to their renewal date. So if their level a renewal is in 1 month, they can elect to wait for a month and then upgrade . . .

        Sounds like I'm clear as mud.

      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        It sounds like actual upgrade of level would be deferred until the expiry of the current membership term.

        We have not considred this - good to know. We assumed that user would want to be at level b right now - not from the renewal date.

        Very interested to get feedback from others.

      • pollockkpollockk commented  ·   ·  Flag as inappropriate

        Our 2000 + organization offers 1 year, 2 year and 3 year memberships. Our renewal date for everyone is Jan 1. We send out dues notices starting 60 days before dues are due.

        The issue we are having is that the system does not calculate renewal dates correctly for our members who move from one level to another.

        If an annual member has a renewal date of 2012 and we send out the dues notice in Nov of 2011, the member has the option of changing to a 2 year or 3 year membership. If they do so, the new renewal dates are calculated from the date of the change and NOT from the date of renewal.

        The following table explains my frustration - All changes were made in 2011 at dues renewal time...

        Renewal Current New Level WA Calculation Should Be
        Date Level

        2012 Annual No Change 2013 2013

        2012 Annual 2 Year 2013 2014

        2012 Annual 3 Year 2014 2015

        This causes our administrator to be constantly changing dates for people exercising level changes. Why would the software make the change to renewal dates based on the date of the change and NOT by adding the new level to the existing renewal date?

        Is this a problem for anyone else?

      Feedback and Knowledge Base

      Wild Apricot Inc. 144 Front Street West Suite 725, Toronto, Ontario, Canada M5J 2L7