Show real balances in the Aged AR Balance Report

The aged AR balance report does not reflect the real account balances when there're not applied payments. For examples, an account has a payment of $100 not applied, the account balance is a credit of $100 under biller profile activity. But in the AR report, the balance shows as zero. The system seems to default credit balances to display as zero for reports. This happened to statements as well. It creates problems when reconciling Billing Management with General Ledger as balances don't match even after everything is posted and imported to GL.

  • Jing Jin
  • Sep 23 2022
  • Shipped
Blackbaud Billing Management / Reporting
  • Attach files
  • Admin
    Kelsey Huijgen commented
    October 12, 2022 16:13

    Hello! The fact that the Aged Accounts Receivable report wasn't including unapplied payments was actually a bug that has just been fixed, so these payments should now be correctly reflected in your report balances.

    Attachments Open full size
  • Tony Block commented
    September 28, 2022 18:35

    Also, columns in AR report do not include current transactions, ones that are not past due.


    Attachments Open full size
  • Tony Block commented
    September 28, 2022 18:23

    There are also issues tying the AR report to the general ledger if you are using payment plans. The AR balance is based on payment plans, regardless of the date of the transactions going in to the payment plan. This would not be an issue if the application of payments against payment plan transactions were handled differently.

    Attachments Open full size

Related ideas