Kyle
Financial Reporting: Break out extra charges [10581]
Sort Posts:
  •  08-24-2010, 9:38 PM 19376

    • Kyle is not online. Last active: 02-08-2012, 8:34 PM Kyle
    • Top 50 Contributor
    • Joined about 2 years ago
    • Vancouver
    • Posts 42

    Financial Reporting: Break out extra charges [10581]

     Anytime Memberships are reported out, maybe not at the high summary level, but at the indivdual membership level I would like to see a breakdown of membership fee vs. extra item fee (e.g. In July I had $500 of membership income, how much was from elite level, how much from regular level, and for each, what percentage is membership fee and what percentage is extra items).

    Kyle Mitchell | www.spec.bc.ca
  •  09-28-2010, 10:47 AM 19918 in reply to 19376

    • Gordon is not online. Last active: 02-08-2012, 11:53 PM Gordon
    • Top 25 Contributor
    • Joined about 4 years ago
    • Posts 182

    Financial Reporting: Break out extra charges

    I was disappointed to see that the financial upgrades in version 4.0 continues to lump income for an individual member into a single bucket with no breakout as to source. 

    Specifically, membership fees and extra charge items purchased during membership signup/renewal are reported as a single lump sum.  In my case I have membership levels at $20 and at $25 but I also have an option for members to have their newsletter delivered by surface mail for and extra $5.  I may have $500 in membership fees at the end of the month but no idea how to divide up the revenue between membership and newsletters.

    Granted, we can export the membership files and do the whole thing manually but we could do that before version 4.0.

     Also, as I understand it, the same is true for Events.  Extra items purchased during event registration are lumped in with registration income and we have to go in at a detail record level and break out these charges manually. 

    The reality is that Excel is still the best reporting tool. 

  •  09-28-2010, 10:56 AM 19919 in reply to 19376

    Re: Financial Reporting: Break out extra charges

    Gordon,

    Sorry, we did not have this on the wishlist so we simply did not  think about it. Now that we have this here, I would appreciate comments from others to help us prioritize this.

    I think a possible solution is to separate the base registration fee/membership level fee from all  other charges in the Income report.


    Dmitry Buterin, Chief Apricot
  •  09-28-2010, 8:30 PM 19934 in reply to 19376

    • skipat is not online. Last active: 02-08-2012, 11:39 PM skipat
    • Top 25 Contributor
    • Joined about 2 years ago
    • Posts 111

    Re: Financial Reporting: Break out extra charges

    I would also like further breakdown as to the source of the revenue --- broken down by the source of the revenue.  It makes it easier for a trip leader if all the money order/checks that they have collected are totaled clearly in one column, keep credits applied separately, and on line revenue (credit card payments) a separate total.

    I think the old payment report separated on line revenue from manual payment revenue, and I don't see that in the new one.  That will be missed.  Now that we can also issue credits to invoices, that should be a separate entry too.

     

  •  10-09-2010, 5:03 PM 20086 in reply to 19376

    • jkwalker is not online. Last active: Sep 04, 2011, 12:42 PM jkwalker
    • Top 500 Contributor
    • Joined about 2 years ago
    • Des Moines, IA - United States
    • Posts 8

    Re: Financial Reporting: Break out extra charges

    I agree. Being able to code costs on the back-end, or see a more detailed breakdown, will be extremely helpful when it comes time to record revenues in an accounting program. Otherwise you are required to manually allocate rec'd revenues to multiple revenue accounts.

    I would go a step further and request the ability to code a single fee to multiple categories. For instance, I work with a client who receives annual member fees that are allocated to three separate accounts: $150 - $75 to member dues, $70 to regional fees (this is paid to the regional offices bi-annually) and $5 for printing fees. 

    The greater the ability to pull detailed financial reports, the greater the ability to streamline and increase efficiencies, the greater my ability to make my clients happy :-)

     Jennifer Walker

  •  07-07-2011, 12:52 PM 23043 in reply to 20086

    • pollcokk is not online. Last active: 01-27-2012, 6:57 AM pollcokk
    • Not Ranked
    • Joined about 7 months ago
    • Posts 3

    Re: Financial Reporting: Break out extra charges

    We certainly agree that the accounting for extra fees is woefully inadequate.  The lump payment is stored and retrievable but non of the details are available either in excel, quickbooks or via reporting.  We need to be able to distinguish these extra fees from dues.

     

    Kim Pollock

  •  07-15-2011, 12:19 PM 23165 in reply to 23043

    Re: Financial Reporting: Break out extra charges

    Thanks for your comments - we will be working on that but I cannot promise the dates, unfortunately. 
    Evgeny
    Product Design Team
View as RSS news feed in XML
Membership Software - Wild Apricot