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.
A question to supporters: is that important to have in QB all order lines of invoices from WA, or it is enough to merge them all to a single line with total sum?
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.
Bill Tidball commented
All lines would be required. Thanks for looking into this.
Ann Darmstetter commented
Yes, it is important to have all order lines.
I agree with the majority that all lines are needed.
Jeffrey Hill commented
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.
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
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.
Breaking out the HST is also extremely important. The more the better!! So glad this is on your radar.
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.
All lines please.
Jon Carlson commented
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.
Detailed data please and the ability to map where the transactions are coded.
Glenn Fell commented
The more detailed data, the better. So all order lines would be preferred
All order lines, please!
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
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
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.
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.
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.
Tom H commented
Not interested in a workaround.