"Some tenants on list have been gone for more than 2 years and have 0 balance, still on list."

Then you have Open balances and open payments never applied against each other.

An Open Balance report or AR reports should not show anyone, if their balance is 0. If you see the name, then the math is 0, but the cross-posting transactions are not applied to each other.

If you run a Balance Detail, that is the review of the customer's entire activity, so the point of this report is to see if they are at 0 or not.