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

136 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    77 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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.

        Thanks

      • 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