Aged Accounts Receivable Report

Windy Kidd
Windy Kidd
Fifth Anniversary
in Blackbaud Higher Education Solutions™ General Discussions

Curious if anyone has run into the issue we have. We migrated from the old EE Student billing to the new billing mgt in January. Our year end is 7/31. Mid August, after everything was closed for /the year we ran an aged receivables report out of BM as of 7/31 so we could reconcile to the GL. We were having issues reconciling so a week later I ran the report again as of 7/31 and got a totally different number. Figured out that if you post a payment or credit to an account after 7/31 but it is applied to a transaction prior to 7/31 then it change the 7/31 aging number making it impossible to reconcile to the GL. This is not the way it worked in the old system. It only changed the aged receivable number if the credit/payment was POSTED on or before 7/31. Opened a helpdesk ticket and they pretty much said sorry about your luck. It's running the way we intended it to. Anyone else having issues with this and what is your work around?

Tagged:

Comments

  • Dawn Alonso
    Dawn Alonso
    Sixth Anniversary Kudos 3 Name Dropper Participant

    Hi Windy,

    Yes, that is a very frustrating thing that I had noticed as well. Unfortunately, there really is no work around other than printing/exporting to excel any reports that you want to reference. Because the reports and transaction lists don't work of of the status as of a particular date, it is hard to go back and recapture a snapshot of a particular date and time, unless you save the reports and work off of them.

  • Bruce Kariya
    Bruce Kariya
    Fourth Anniversary Facilitator 1

    Ugh! We just transitioned to Billing Management and I was running into different problems with the A/R aging different from what you are describing, Windy. I couldn't even get the aging to come out with the same balance as what had just been imported from Student Billing.

    The auditor in me tells me that we should be able to run the aging report as of a particular date at any point in time and get the same results. Student Billing could do it. FE can do it. I don't understand why BM can't do it. More than that, I don't understand why BM was apparently consciously designed NOT to do it….

    Bruce

Categories