Type in your suggestion - new feature or improvement idea

Access to income report detail/Drill down reports

When I create a monthly income report, I get aggregate figures for events and membership types. I would like to be able to create a monthly report, and then be able to see all the transactions that went into that report. I don't find a way to do that. I CAN get a list of transactions for a certain time period, but that screen is limited to 50 per page. A very annoying limitation. I would like to see them all, and have them in a searchable file, which I could also download.

Mark Rougeux

19 votes
Sign in
Check!
(thinking…)
Reset
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

    Mark RougeuxMark Rougeux shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Ed TEd T shared a merged idea: drill down in financial reports  ·   · 

    11 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Ed TEd T commented  ·   ·  Flag as inappropriate

        I can run a report that shows me for instance how much was collected during a given month by check, credit card etc. But I would like to be able to click on any of those dollar amounts and see the actual transactions

      • Chuck WrayChuck Wray commented  ·   ·  Flag as inappropriate

        I just want to reinforce what SCDF is saying here. I am addressing the last question from:

        Dmitry Buterin, Chief Apricot - "Can you also elaborate why is this needed/how this would be typically used?

        As SCDF said, we need it to reconcile with our accounting records, because Wild Apricot has basically become and extension of our accounting system.

        Just a little more on this-- Essentially, we are all constrained by economics, so we have limited hours to commit to administration. Our organization is a small, non-profit with a very limited, part-time, monthly contract administrator budget. This was a huge reason why we chose Wild Apricot, to save us time on administration. Since Invoices and Payments are done in Wild Apricot, there is no reason to duplicate time and hours to export them to Quickbooks. This would additionally create headaches keeping both systems in sync, etc. There is no need to do this with our limited budget,

        The solution we are all requesting already exists in your program --

        Since you are working with the data to give us the Summary figures for Invoices and Payments, then could you simply giving us a report with the details that make up the subtotals? You really don't need to create a new format. How about using the fields and formats you have defined in the Export to Excel? And while you are at it, could you add the Preview Transactions you already have defined? You are so close!

        Again, you must realize with so many comments, that there is a sincere need for this. It is actually suprising that it does not exist already. I have been buying and implementing software packages and modules for over 30 years. And I feel this is a reasonable expectation. It would satisfy so many needs on many levels. And it would be a HUGE value you have added to Wild Apricot.

        Just a postscript- I have attempted to use the Export to Excel that exists in Finances>Invoices and Finances>Payments & Refunds. These exports need extensive work to prepare them for a report that can be used. This would be needed monthly, so it is a time expense our organization (and I think others) will not be able to afford. Yet it is sincerely needed. You have already defined the summary/subtotaling needed for us in your Finances>Reports. So the report is defined.

        Can we hope for this in the near future?

      • SCDFSCDF commented  ·   ·  Flag as inappropriate

        To reconcile the events with our accounting system. Since WA is essentially handling our Accounts Receivable, it becomes an extension of our accounting system. Therefore, there has to be a reconciliation between WA and our accounting system. And, since your "Invoice" or Payments and Refund" report doesn't provide the details on the Event Name or Membership Level, there is currently no way to confirm who paid for what.

      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        Thank you, I understand what you are asking for. Can you also elaborate why is this needed/how this would be typically used?

      • SCDFSCDF commented  ·   ·  Flag as inappropriate

        Example: Finances: Income Report. Ability to click on each event or membership level to see the transactions that make up the totals. See attached.

        Understand? Desperate for more details for our financial reports.

      • SCDFSCDF commented  ·   ·  Flag as inappropriate

        It would be extremely helpful to have the ability to zoom in to see the transactions that make up the totals on the Income Report. Currently you can zoom in on the AR Report but not the Income Report. This would help tremendously in our accounting.

        Thank you.

      • SCDFSCDF commented  ·   ·  Flag as inappropriate

        I agree. It would be very helpful if the income report was zoomable so we can see the detail behind the totals provided. This would solve a lot of the financial reporting problems I am having.

      • ckcarpenter42ckcarpenter42 commented  ·   ·  Flag as inappropriate

        You are correct that this work around will provide the detail but one then has to sort the Excel file by origin and construct breaks so as to create totals that agree with the excellent summary report provided by WA. I would like to see an "advanced" button that when click would provide a user with the option of seeing the detail.

      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        Since income report is based on invoices, one workaround is to go to Finances/Invoices and apply the same dates filter (assuming you want all invoices included). You can export this list into Excel from this screen.

        Let us know if this helps.

      Feedback and Knowledge Base

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