Chart of Accounts export to QuickBooks
An additional level of detail beyond “class” or replacing "class" that could associate with the Chart of account codes set up in quickbooks would save time and errors by identifying income categories automatically. I assign a general ledger account code to each invoice/payment to coordinate with the bookkeeper in the notes field that must be read manually. Could a separate field be available that QB would recognize on import.
Re: Wild Apricot payments
When our members renew their memberships, they sometimes subscribe to one of our organization's journals. At present (in PayPal; I am told it is the same in WA Payments), although the itemization shows on the invoice, when it passes through the payments processor (and thus, is downloaded for Quick Books Online), the entire transaction is categorized as "membership dues," and then we need to go back in and do journal entries in QBO to re-categorize anything that is not membership dues (journal subscriptions, donations made with membership renewals, etc.).
Can WA improve functionality of payments processing data so that when the transactions are downloaded into QBO, they are properly categorized to the right line items in our budget? If there is a way to determine how each invoice item is categorized (to set that up in WA), that would be great. It would save a lot of time. Thanks for considering this request.
We do not use QB either but associating a GL code with every price is desperately needed. It is very time intensive when trying to reconcile.
Ruth Roth commented
Not every one uses QuickBooks. It would be very helpful to have a way to attach the GL codes needed at a product level. Meaning anytime that something has a price associationed to it we should be able to attach a GL code. Most systems have a separate area to add the GL codes that are then are available to select from when you are setting up a different product. The same GL code can be used for multiple products. When you pull a financial report you should be able to pull the GL code with purchases.
Doug Johanningsmeier commented
Dmitry I would suggest adding GL code tracking at any point Income is going to be registered in WA. Donations, event registrations, memberships, etc.. If there are monies coming in it needs to be assigned to proper GL codes in QuickBooks. I have multiple divisions of bank accounts under a main to accommodate different types of restrictions imposed on that income. Need to be able to designate which bank account in QB as well as GL codes.
LeBon Abercrombie commented
Chart of Accounts account name should be an entry in each registration type type for events as we keep revenue for each event separately in QuickBooks. Also, sub-accounts for Quickbooks should be supported for the QB Export function.
Dmitry Buterin commented
In WA invoices are generated automatically for each transaction (http://help.wildapricot.com/display/DOC/Invoices )
What would you suggest would be the best place in Wild Apricot to assign account codes ? Each membership level and each event?
I agree with you David. However, we also use classes in QuickBooks and we need the information that this field provides, especially since it is the only place that gives us the details on what event or membership level. I think you can accomplish what you are asking by customizing the QuickBooks export settings. It allows you to associate a Chart of Account income item.
Dmitry Buterin commented
Can you please tell us more about this, give us a detailed example? I am not clear yet how this maps to Wild Apricot. E.g. what part of Wild Apricot functionality you would use for that and what is missing/how it would ideally work.
Student Organizations would LOVE this program if only there was a way to keep track of the multiple accounts that we have to utilize. Most Schools issue at least two accounts to student organizations (one that is annual award account from Student Fees and the other from raised funds, such as membership dues, etc...).
If there was a way to track basic transactions on multiple ledgers this would be the PERFECT Software for my student organization!