This could be caused by grouping based on last name?
Actually when You Group them by Lastname then It will check the Oustanding balances for all the names with similar lastname and assume to be one person who has the arrears. I think that why you are having these kind of problems. Do not Group By Lastname;U’d rather group by Pk. Try again and consult further if there is still a problem.