The ageing reports are primarily designed to show ageing debtor/creditor invoices, they just happen to show any payment on account balance too, but only for those cases where there are aged invoice balances.
So what you’d need to do is in the Client Management screen go to Advanced Search and select the check box to show credits. You can then order the credit column by size and see all your clients with account credits, largest to smallest.