Alternative Methods for Clearing Old Customer Balances from the Customer Account Status Report

Hi,

Our customer is using the report Customer Account Status report in order to get an overview of customer account balances. However, there are old customer balances from November 2023 and January 2024 that are still showing. These balances persist because manual refunds were booked manually directly in GL.

Does anyone know of an alternative method to remove these balances, other than performing a mock refund and marking it as paid? We would prefer to avoid this approach if possible. Is there any other way to clear these balances from the report?

Thanks in advance!

Kind Regards,
Caroline