Kyle
Custom Reports/Full Transaction Data Extract
Sort Posts:
  •  08-24-2010, 9:36 PM 19375

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

    Custom Reports/Full Transaction Data Extract

    What I'd love to see is a simple way to export all of my transaction data.  It should include every transaction recorded for event registrations, memberships, renewals, donations, refunds, etc.  
     
    Then I can create my own custom reports with another program (Excel, Access) and all I would need to do is update my report data source with a new daily or weekly export from WA.
     
    Alternatively, the ability to custom design my own reports within Wild Apricot would be nice too.  For example, using a drag-and-drop interface I could create my own pivot table reports like in Excel.

    Kyle Mitchell | www.spec.bc.ca
    See more:
  •  10-20-2010, 8:57 AM 20210 in reply to 19375

    Re: Custom Reports/Full Transaction Data Extract

    I would appreciate examples of reports you envision you would create in this way.
    Dmitry Buterin, Chief Apricot
  •  01-27-2011, 7:31 AM 21354 in reply to 20210

    Re: Custom Reports/Full Transaction Data Extract

    I've mentioned this on another post:

     but the ability to export a list of events with their financial data would be most helpful.

    it basically would allow us to have a quick look at the revenue across different events (we categorise our events using the tags in WA, but there's no way to get those lists downloaded into an exportable format!).

     

    This makes it easy to see if, for example you had a seminar series, whether it was profitable, well attended etc., over time (years, seasons) and / or against other events.

     

    cheers

     

  •  01-27-2011, 7:45 AM 21355 in reply to 19375

    Re: Custom Reports/Full Transaction Data Extract

    Kyle - now that we have new Finances module you can export all payments and all invoices. Does this achieve what you requested?
    Dmitry Buterin, Chief Apricot
  •  01-27-2011, 7:47 AM 21356 in reply to 21354

    Re: Custom Reports/Full Transaction Data Extract

    This (export of events with financial data) is pretty specific so I would suggest creating a thread dedicated to this to see if it can get support from other users.
    Dmitry Buterin, Chief Apricot
  •  02-07-2011, 4:39 PM 21518 in reply to 21355

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

    Re: Custom Reports/Full Transaction Data Extract

    This request sounds a lot like something I've been trying to get, and no I don't think the export of all payments and invoices does it. 

    We evaluate the profitability of each of our events -- the export from Finances does not carry the specific event name.  I would want to sort by event name. 

    We reconcile the financials for each event separately so that the Treasurer knows how much revenue is in checks and Paypal for that event, and to be sure member accounts are correct.  WA Registration by Type gives us total Revenue for that event, but that doesn't tell us all we need to know.

    Currently I export attendee data for each event separately, delete all but relevant financial info, sort it so the event manager can verify the correct amount they have in paper checks so I can be sure our member account balances are correct.  Our event managers often settle a member credit for payment incorrectly, but actually record a new payment (using a tender type for member credits thinking that does it). There is no easy way to find these errors (which must be corrected since members get credits they are not supposed to have). 

    For event reconciliations, I then add back in any cancelation charges for late cancel fees for that event.  Finally I add in Paypal fees for all the Online transactions for the event (something I would not expect WA reports to do), but need to sort the transactions/event by payment type to allocate the PP fees to that specific event.  Without this information, we don't have complete data for pricing our events for next season.

    It is very cumbersome and I spend a lot of time trying to verify member credits are correct, (and helping event managers over the phone settle credits to try to prevent these errors) since the audit trail is not clear for this, especially when a trip leader makes errors on settling credits which is a common occurrence. 

    We are probably going to dedicate a board member to act as "assistant treasurer" to focus specifically on the new WA billing issues  next year to help with all this additional work.

View as RSS news feed in XML
Membership Software - Wild Apricot