Accounts recieviable ageing - Dynamic date

I can try, but don't know if I am allowed to post the data all considering

The requirment is two fold

1) Create a table that will show accounts recievable ageing on a spesific date. So that the company can go back and see how much money that where overdue at a certain date (They want to see if there is any effect from changes in invoice routines)

2) Create graphs that show the historical development of the same data, so that they graphically over time can see if there are any effect.

The data is in 2 tables in general:

1) Invoice data, including due date, amount, invoice number, customer name, customer number etc

2) Payment data, including amount, invoice number and payment date

The result will be a table overview like this:

Customer name - 1-30 days - 31-60 days - 61-90 days - 90+ days - Total

           A                  5000                                                       2500          7500

           B                                        4500                                                   4500

           C                  1000                                                                         1000

Total                        6000              4500                                 2500         13000

Then if I change date the data should be as it was that date

Then Graphs based on the totals, going for x months