Arranging data presentation even an idea on excel

Brass Contributor
may I ask for assist regarding the attached sheet.
If I have a list of units (B) that have dues in different dates (E) and different amounts (D) also I have the payments as described from column (I) To column (AU). Every payment including (clear date - amount - Receipt Number), then the calculated fieled (AY) and i need to organize these data to be easier for tracking 
I need also to make an aging for total Remaining (AY) per unit, per month and year

Thanks in advance
1 Reply
You have posted on the Microsoft Learn community board which is all about exams, certification and training.
You might get a better response on the Excel community board