Account Receivable Aging automatic calculation by outstanding receivable amount

[F4fahi]

Hi,
I searched on many platforms for my question but didn't get the write result as per my query.

I have two sets of data sheets
Sheet1: data of all sales of customer with sale date, customer name and sales value
Sheet 2: data of received amount from customer
Date, customer name and received amounts

Now I want to calculate customer aging on the basis of these two sheets
Let suppose pick one customer from these sheet
And today date is 9 oct.

Sales data sheet 1
22aug A , $30
30sep, A, $40
2oct, A. $20


Sheet 2
Received amount sheet

25aug A , $30
31sep, A, $ 20

If we calcule the balance it should be
Total sale- total receive =$40

Now I want another sheet will pick automatically the following data by sum all invoices subtract the total receive and mention those sales who left behind which is equal to his balance

Like this

22aug A , 0
30sep, A, $20. 9 days (No of days passed by calculate with current date)
2oct, A. $20. 7 days


Thanks if any one can sort out my level of difficulty