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.
No immediate plans so far.
We would like to purchase WA, but the lack of integration with QuickBooks Online is disappointing. Any details from WA on when this integration could happen?
Are there any updates on the integration of Quickbooks online? It is frustrating to not have this integration to the point of researching other options for my membership management as I cannot use WA fully without this integration.
Stephanie Deschenes commented
To the Canadian Association of Science Centres, a connection between WA and Quickbooks Online is critical to improving our efficiency (and sanity!) One of the reasons we chose WA was because it integrated with Quickbooks - I didn't realize that it didn't also include QBO. Thanks for your consideration!
kelly q commented
I'd like to add my support for getting more detail on my transactions into QBO. Invoice details would be a big help, as then I can break down my revenues into categories, such as donations, event fees and member renewals.
Green Tea commented
Our treasurer uses quickbooks on-line. Currently she has to go into paypal and transfer monies received from wild apricot to our bank account. When she uses quickbooks she doesn't have an easy way to know what part of the monies transferred were from membership renewals, events, or donations. There needs to be an easy way to link everything. In addition we run a farmers market. I would like to be able to group all of these vendors and bill them weekly via wild apricot. Please advise. Thank you.
I certainly agree with the comments posted here regarding QB Online integration with WA. As our non-profit grows, having a more seamless merging of financial information would be most beneficial. I hope WA will strongly consider developing this feature for its clients.
Joe Lindahl commented
Our chapters would be interested as well.
Despina M Kreatsoulas commented
The California Resource Recovery Association is also interested in development of this feature. QuickBooks Online is also the best choice for our non-profit organization and we are not in a position to change our QB practices. We have been very happy with WildApricot, but as our organization grows, the inability to efficiently and correctly transfer data between QBO and WA may present a challenge to us.
Thank you for your kind consideration.
Colleen McFarland commented
The Society of Indiana Archivists is really interested in the development of this feature, too. We do not have a physical headquarters or office, so using QuickBooks Online makes sense for us. And it is only because of our investment in WildApricot that we are interested in making the transition to QuickBooks....
Thanks for your consideration.
See http://forums.wildapricot.com/forums/308932-wishlist/suggestions/8827717-roadmap-2015-plans-releases-expected-dates for our current up to date status.
Hey Apricots, any update on this now that your version 5 work is deploying? This is the biggest pain point in our use of Wild Apricot: the constant hassle with QuickBooks. 100% synchronization with QB would be huge for us. I am routinely have to defend our use of WA to our organization because of the lack of really solid synchronization with QB Online.
Keith Fetterman commented
We request an enhancement that integrates Wild Apricot (WA) with QuickBooks Online (QBO). The top priority is providing customer/membership data synchronization between the two systems. If a member is added to WA they would appear in QBO and visa versa. The customer data needs to stay in synch, including keeping their contact (phone, email and mailing addresses) synchronized.
Secondly, we'd like to see the invoices and payments that are generated in WA be transferred to QBO.
Yes, we're aware of the API, thanks. We will definitely be looking this (when we can)
Evgeny, for on premises QuickBooks installations, it would be beneficial to move from the obsolete IFF import to using the improved QuickBooks WebConnector. A solid effort integrating into QuickBooks this way would be a big improvement.
The future is QuickBooks online though. Intuit has a rich API and using this to keep QuickBooks and Wild Apricot fully in sync would be a huge plus for your many mutual customers. See https://developer.intuit.com for all the abilities that Intuit offers...
Lori, I missed that you were speaking initially about QB Online, that explains everything - it does not support IIF files importing. Thanks for sharing your comments.
Lori Malone commented
I was surprised to discover that a (rather expensive) third-party app is required to import the IFF file for Quickbooks Online. It's my own fault for not reading more thoroughly, but I thought the invoices generated by Wild Apricot could be imported into Quickbooks Online (like the stand-alone app) and that the payments would also be appropriately applied with an import to Quickbooks.
I recently setup Wild Apricot to integrate with PayPal to allow my non-profit group to pay their membership fees online. In addition, we hope to provide an option to purchase tickets to events online using WA with PayPal.
The option to import these transactions into QuickBooks would be a great time-saver for our treasurer. I read the information about "Transaction Pro Importer" but frankly 24.99 per month (their fee) is cost prohibitive for the size of our organization (as it stands now, WA is a big chunk of our operating budget). Perhaps your developers create a custom tool to allow for import to Quickbooks online? The requirements are pretty basic: create QB records for invoices created in WA and then records the payments that are applied in WA.
As it stands now, having the invoices sent to members via Wild Apricot is not really going to save our treasurer any time since she is (apparently) going to be required to manually create them using QB Online.
Any suggestions would be appreciated. Thank you.
Lori, what kind of integration you are expecting to have? What are your typical scenarios / tasks that you want to automate? More details here will help us in future with proper analysis of the possible solution.
Lori Malone commented
I just wanted to chime in to say that my organization is very interested in more robust integration between Wild Apricot and Quickbooks Online. I read the help information about importing IFF files into the online version of Quickbooks and I was surprised to see how expensive the 3rd party tools would cost just to accomplish the import.
Very disappointing. My organization does not have the budget for the additional expense.
For Quickbooks Online, check out the Quickbooks API: https://developer.intuit.com/docs/0025_quickbooksapi/0005_introduction_to_quickbooksapi