Type in your suggestion - new feature or improvement idea

Integration with QuickBooks Online

1) Integration with QuickBooks. Need to be able to download monthly in a way that recognizes existing customers and allows me to code transactions in WA according to my QB Chart of Accounts.

For financial data from Wild Apricot to be useful to Parent Booster USA, I have to be able to download an arbitrary number of transactions, e.g., all transactiuons in a month, for all members, them load those transactions into QuickBooks so that the download adds new transactions to the exisitng customer accounts. Downloads that create new customers each month aren't helpful. Beyond that, I'd like to be able to code financial transactions in Wild Apricot so that they match the accounting codes in QB, e.g., new member, basic level is transaction code 6101.

As it currently operates, the financial subsystem gives PBUSA's members something to complain about and the administrators unneeded manual tasks.

Thanks, John

144 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

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


Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • Glenn Fell commented  ·   ·  Flag as inappropriate

    Is there any update with this. We use a third party payment processor as we are able to download our transactions into QBO. I cannot believe that WA is going to be greedy AF and charge 20% extra if we don't use their processor while they have been sitting on this integration. I can create an integration in 5 minutes through Zapier if WA had an integration to that. This is absurb and almost worth dumping WA. According to the Q4FY18 conference call by Intuit that was in August, appx 55% of their global Quickbooks customers were on QBO. Enough with a substandard store. Allow more integrations rather than try to event the wheel and deliver a wooden wheel that can only go 25mph when we need a rubber wheel that can go 70mph.

  • Dennis commented  ·   ·  Flag as inappropriate

    When you export Wild Apricot data from Wild Apricot, you generate a QuickBooks IIF file, but the IIF file cannot be imported into QuickBooks Online. My request is to add an export format selector, so you can select an export format that can be imported by QBO.

  • Jeffrey Hill commented  ·   ·  Flag as inappropriate

    Yes, it is important to have all order lines. We try to track our income by categories, and a single invoice might include membership, a class, a donation, a late fee, etc. We use QB to do our financial books, month end statements, etc. We need to be able to classify the income for that purpose.

  • Robin commented  ·   ·  Flag as inappropriate

    While I am not going to be using this feature, it is abundantly clear that all data should be passed at a line by line level even any sales tax components.

    It needs to be the actual recipient of the data who does any form of summing or aggregation according to the needs or their specific organization.

    There is absolutely no way what so ever that WA could do any summing or aggregation that would meet the needs of each and every WA user - simply because there are just far too many possibilities of how to handle the data.

  • Keith Fetterman commented  ·   ·  Flag as inappropriate

    Hi Dmitry,

    Thanks for asking. I talked with our bookkeeper. She definitely wants the order lines to be included with the invoices. At times, we may have invoice lines that need to go to separate income accounts. Including the lines in the invoices will make her job easier so she doesn't have to go Wild Apricot for each invoice.


  • Anonymous commented  ·   ·  Flag as inappropriate

    Breaking out the HST is also extremely important. The more the better!! So glad this is on your radar.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Yes I have been asking for this. To import invoices from WA to QB online would be an absolute deal changer for me when informing my other clients about WA.

  • Jon Carlson commented  ·   ·  Flag as inappropriate

    All order lines. We currently get one big order line from Paypal for WA transactions. It is useless. We need the breakout of what people bought in order to categorize the revenue.

  • Peter commented  ·   ·  Flag as inappropriate

    Detailed data please and the ability to map where the transactions are coded.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I too: Would want one sales receipt created for each members order, and different order items may map to various GL accounts. One workaround might be to emulate the PayPal import process, with user editing for new customer and sales and tax details, but i assume you've thought of that

  • Daniel SMITH commented  ·   ·  Flag as inappropriate

    All invoice lines or single total line?

    All invoice lines must be included in an export.
    For example, discounts. We track list price plus discounts in Quickbooks. Both are included in IIF files now and must continue in any solution to import into QBO

    Thanks, D

  • Julie commented  ·   ·  Flag as inappropriate

    I have seriously been looking to leave Wild Apricot and am looking at other options due to WAs inability to sinc with QBO. If you can make this happen great, I’ll stay, if not, I’m already searching for alternatives.

  • juliamariepeace@gmail.com commented  ·   ·  Flag as inappropriate

    I echo others comments - please get it done. Would want one sales receipt created for each members order. Otherwise you’re not solving the problem of our treasurer keying in each sales receipts for members purchases by a lump sum.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I don't see how they can all be merged into a single line because different order items may map to various GL accounts and classes.

← Previous 1 3 4

Feedback and Knowledge Base