I'm working on a financial report for my organization, and I'm trying to find the line-item detail for all financial transactions conducted through our site (so I can slice and dice the data to illustrate various aspects). Without this, it's not possible to resolve discrepancies in the data and close out our organization's finances.

I was able to download a report from "Payments and Refunds", however this only shows totals for each invoice and does not show what line items each person is paying for, so I can't break the data down fully. I also found the "Income" report under "Reports", however this seems to have even less detail.

The WA support folks suggested going into each invoice separately to see a breakdown of each line item, and said that there is currently no other way to view line-item details. However, this would be very manual and time-consuming as we have hundreds of invoices with multiple line items each.

So, I wanted to find out if it would be possible to add a feature to give downloadable line-item visibility for all financial transactions? Presumably this raw data is already being collected by logs on WA's back-end, so it might just be a matter of exposing the relevant data to admins as an excel file if requested for download.

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