Accounts Receivable Report for selected period
The AR report only provides the current picture. If I do not remember to run it on the last day of the month it must be contrived by deleting any income and invoices. Enabling this to run for a selected period just like all the other reports would provide for correlation/proofing with our books and allow for historical comparisons that tell us if our collections are improving/lagging/meeting our goals.
-
System Administrator commented
When we ask for an income report it doesn't include invoices paid this month as it categorises the invoice by issue date rather than paid date. This is a HUGE problem as it inaccurately reports income. We are told the only way around this is to export all the information manually. As we are only a one person office we purchased your product to save time not take up extra time. I've never worked with a system that can't report payments at the time of payment. Please fix.
Thank you -
System Administrator commented
When we ask for an income report it doesn't include invoice paid this month as it categorises the invoice by issue date rather than paid date. This is a HUGE problem as it inaccurately reports income. We are told the only way around this is to export all the information manually. As we are only a one person office we purchased your product to save time not take up extra time.
-
Thanks for detailed comments, Kelly!
Oleg, Payments Team
-
Kelly Quinn commented
Hi Oleg, I want to be able to reconcile my cash receipts to my membership logs, and right now I can only do this if I pull an invoice report precisely at the right time (which never happens). We have automatic invoicing for membership renewals, but members often wait a week or so (sometimes longer) before they pay the invoice. This becomes a problem when that lag in payment occurs over the end of a month(s), as in a given month's financial report, an invoice will appeared as paid no matter when it is actually paid. This does not let me reconcile my bank statements. I don't really have need for comparing invoices to payments, as I can view my unpaid invoices report--but others might find this feature helpful. I really would just like to reconcile my cash receipts with my membership activity. Thanks for looking into this!
-
Perfect idea, Kelly!
Do you want to use cash reports for reconciliation only? Or do you want to compare invoices vs payments as well in this report?
It will be great if you elaborate what specific info you would like to see in such report and why.Thanks for sharing,
Oleg, Payments Team -
Kelly Quinn commented
Please allow us to pull financial reports on a cash basis, instead of an accrual basis. Right now if we generate an invoice in May, but the member pays in June, I have a problem reconciling my bank statements to my Wild Apricot reports. My bank statements are cash basis (they only reflect cash payments), but Wild Apricot is an accrual basis (if the payment is ultimately paid in June, I can't go back and find out which invoices were unpaid at May 31). I need to be able to reconcile my cash reports, and can't do this right now.
-
LeBon Abercrombie commented
We would like to see this change, among others. We would like to have Wild Apricot be a sub-ledger of Quickbooks. To do that, it needs to be able to produce the normal range of Accounts Receivable reports and have good accounting controls. This would allows us to post only batch figures to QA, and not have to deal with the QB Export-Import process.
-
Becky Parsons commented
The "Finances" section needs a date range ability in the view section, in the report section, and in the export option. There needs to be more information options in this section.
-
GGordon commented
David put it very well when he explained the problem with the Accounts Receivable report. You must remember to print it on the last day of the month for it to be valid. It makes month end reconciliation more difficult and time consuming. Please put this on the wish list.
-
Adrian commented
I also agree. It would be nice if I could run the report for a particular date range.
-
Dianne Ochoa commented
I agree and would find this beneficial!
-
Dmitry Buterin commented
Thanks David!
I would appreciate hearing from other users who would find this useful.
-
Emil Suryahardja commented
Financial data (e.g. Receivables) need to be able to be backdated e.g. quarterly, half yearly etc. rather than perpertual updated at the date of producing Financial Reports.
This is useful for reporting purposes, especially if you are being audited.
Thanks