Type in your suggestion - new feature or improvement idea

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.

25 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

    David Cooper shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    13 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Administrator One commented  ·   ·  Flag as inappropriate

        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

      • Administrator One commented  ·   ·  Flag as inappropriate

        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.

      • kelly commented  ·   ·  Flag as inappropriate

        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!

      • kelly commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        I also agree. It would be nice if I could run the report for a particular date range.

      • CEFPIbook commented  ·   ·  Flag as inappropriate

        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

      Feedback and Knowledge Base