Type in your suggestion - new feature or improvement idea

Financial Reporting: Break out extra charges

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).

67 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kyle Mitchell shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    34 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • PAmela Graham commented  ·   ·  Flag as inappropriate

        Yes please to be able to report 'extra charges' separately! But also need to identify the different types of extra charges on one membership invoice eg Extra Charges: Mooring cruiser LOA
        Extra Charges: Sailing Dinghy < 11'

      • PAmela Graham commented  ·   ·  Flag as inappropriate

        Agree. As a sailing club we have our membership levels (lots!) and 'extra charge' fields for members 'with boats' (different chargeing levels by class of boat). On export to QB we really need to be able to separate out our 'Membership Income' and our 'Boat Charges income'. Income: Membership just does not do the job for us.

      • Scott commented  ·   ·  Flag as inappropriate

        This is a VERY important upgrade for us. As in Mark's comment we belong to a larger body and have smaller sub groups under us. We are using the other charges to separate the funds we need to remit to each. We apparently misunderstood our sales rep and thought this was an existing feature. Without it the functionality and value of this otherwise GREAT product is greatly diminished. Please float this up to the top of your 'to do' lists. We and I am sure many other organizations are in the same boat. We eagerly await the addition of this feature.

      • CVMG_webadmin commented  ·   ·  Flag as inappropriate

        Release 5.1.2 implemented the wishlist item 'Custom Reports/Full Transaction Data Extract' for financial reports. However, not all financial fields were made downloadable. We still need to export invoice line items (so, line item description and the amount and whether it's taxable), rather than just the total amounts for an invoice.

      • Robert Routledge commented  ·   ·  Flag as inappropriate

        Option 1 is the only one that meets our needs, and I would assume the need of any non-profit that has to reconcile their books? We have to be able to see the "extras" a member purchases as part of their membership in detail in order to do this. Option 2 doesn't show enough detail, option 3 appears to be "change nothing".

      • Jon Carlson commented  ·   ·  Flag as inappropriate

        Yes, I really need this too - break out the items people signed up for. I'm similar to Pamela Graham in that I need to import the "Extra Items" amounts separately from the base membership fee to break out different budget items. I am currently trying to import the Quickbooks export into Quickbooks Online (with mixed success), and I've had to write my own script software to massage the exported .IIF data.

      • Anonymous commented  ·   ·  Flag as inappropriate

        For budgeting and reporting purposes we need to break out Extra Costs. As a swimming pool, we charge for Guest Passes, Voluteer Fee, Initiation, Bond, etc. Right now it's all lumped into "Membership".

      • PAmela Graham commented  ·   ·  Flag as inappropriate

        As a sailing club Members pay fees and boat charges according to type of boat and variables as to whether cruisers are on a mooring or not. We have set up boat charges as 'extra charges' for invoicing, but we will need to be able to export the detail of charges by boat type etc for financial accounting (boat fee income by various category). We are currently piloting WA to see if the financial reporting and link with Quickbooks makes it a long term option for us. We really like some aspects of WA, but hopefully your current work on financials will be addressing some of our concerns (these are similar to those expressed on this and other threads). Thank you.

      • AdminTeam Payments (Payments and Finances features, Wild Apricot) commented  ·   ·  Flag as inappropriate

        During analysis of related thread on improving financial exports (https://forums.wildapricot.com/forums/308932/suggestions/8826166), we have also investigated some of the options to report on extra charges. We explored several solution options and want to verify them with you before making any further moves.

        We see at least 3 options to break out extra charges:

        Option 1: further improve invoice export and add dedicated column for each extra charge. E.g. one column for shipping, another - for certificate option, etc. See example: https://docs.google.com/spreadsheets/d/1ekz1xSkvhTs8pE_ZS7ctmVY9QOreLcs3BmSsXh3TFdM/pubhtml?gid=1372848087&single=true

        Cons:
        - might be too many columns to export, especially when invoices for events and membership mixed
        - hard to implement at the moment, requires deep architectural changes

        Option 2: make an invoice line-item export, where each row represents single invoice item. Common invoice fields, like number, date, etc are duplicated in each row. See example:
        https://docs.google.com/spreadsheets/d/1ekz1xSkvhTs8pE_ZS7ctmVY9QOreLcs3BmSsXh3TFdM/pubhtml?gid=656302130&single=true

        Pros:
        - no architectural problems for implementing
        - format is digestable by QuickBooks (probably with some extra plug-ins/adaptors)

        Option 3 is not to bother with individual extra charge export and report consolidated numbers. I've added some more details in this thread: https://forums.wildapricot.com/forums/308932/suggestions/10198449

        Any comments on which option is better are appreciated. Or suggest your own one :)

        Oleg, Product designer @ Payments team

      • AdminTeam Payments (Payments and Finances features, Wild Apricot) commented  ·   ·  Flag as inappropriate

        During analysis of related thread on improving financial exports (https://forums.wildapricot.com/forums/308932/suggestions/8826166), we have also investigated some of the options to report on extra charges and generally what kind of reports is needed. Here's a draft idea: https://drive.google.com/file/d/0BziC5-u6DgiaRVczYlQ5clJFNXM/view?usp=sharing

        Any comments/ideas?

        Oleg, Product designer @ Payments team

      • Jon Carlson commented  ·   ·  Flag as inappropriate

        I have figured out the QB export. However, when I have a new member sign up (or a renewal), I have a basic membership fee, and the user can optionally check another box or two for additional things to pay for.

        When I manually view the invoice, the items selected are individually broken out.

        But the IIF file that is prepared to import into Quicken has the invoice item amounts broken out into the SPL records, but every item has the same QB "Account" tagged, i.e. Income:Membership. I need the base membership fee to have one Account (Income:Membership) and the additional items to have a different Account (Income:MyItem1, Income:MyItem2, etc).

        The items paid for are reflected in the memo field. I just can't get it to be reflected in the QB Account field for categorization. Yes, I could go into QB and fix it manually, but the point of computers is to do that sort of thing for us and eliminate errors along the way. Thanks.

      • Shelbi Hoffman commented  ·   ·  Flag as inappropriate

        I vote for the feature! I have a client that charges a membership fee, but gives the options for membership materials to be shipped for $20. We would like to easily break out this fee instead of having to track it manually. I would also vote for the ability to add donation fields within the membership application/renewal process.

      • Mark Millsap commented  ·   ·  Flag as inappropriate

        We run a "Makerspace" (shared tools, knowledge and inspiration for benefit of members and public) that includes monthly membership dues and "other" charges throughout the month, such as time on laser cutter, shop consumables, and goodies (tee shirts, electronic parts and pieces, etc.). Would love to be able to add these other charges to member account and send comprehensive invoice once a month. We could also add charges via API to member accounts. That would be nice.

      • Rob commented  ·   ·  Flag as inappropriate

        This would make it much easier for our treasurer to reconcile income that flows in through WA vs. income that is gathered at club meetings, etc.

      • Dmitry Buterin commented  ·   ·  Flag as inappropriate

        Thank you for a detailed write-up - the need on extras reporting is clear. We have missed this in our original analysis and design so unfortunately there is no quick fix, now we need to figure what exactly is needed, then design and implement solution.

        I would appreciate more details from you - how would you ideally see reporting on this?

        And I hope to see input from other clients so we can prioritize this higher.

        In the meantime the only workaround to report on extras I could think of is using QuickBooks export function in WA. (And you do not need QuickBooks to use it). You can either use a preview of the export - or produce the actual export file, rename it from IIF to XLS and open in Excel.

      • sanddollar commented  ·   ·  Flag as inappropriate

        Hi,

        Has this issue been resolved? Can you now map item for the QuickBooks download? If yes, can you point me to documentation of how to do this mapping? Thanks, Sanddollar

      ← Previous 1

      Feedback and Knowledge Base