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
  • Attach files
  • Admin
    Kelsey Huijgen commented
    12 Oct, 2022 04:13pm

    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.

  • Tony Block commented
    28 Sep, 2022 06:35pm

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

  • Tony Block commented
    28 Sep, 2022 06:23pm

    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.