Expected renewal MRR

On the 1st day of each month I could download a report to calculate how much MRR is due for renewal that month.


But is it possible to obtain it retroactively? It would be very helpful to be able to filter the subscriptions that were active on a given day. We would then be able to compare the situation at the beginning of the month with the one at the end: retention MRR, churn MRR, expansion MRR, etc.