Able to have an A/R rec where we can see each balance explanation in aging bucket?

Summary:

We have a requirement to reflect detailed transactions bucketed in the defined aging buckets

Content (please ensure you mask any confidential information):

We are in the process of implementing ARCS and have accounts such as Accounts Receivable set up as Account Analysis (non-transaction matching) where we want to upload the detailed transaction lines as balance explanations and use the aging functionality to report out on how each of the balance explanations fall into each of the predefined aging buckets (i.e., 0-30, 31-60, etc.). I have attached an ugly mockup to illustrate. We originally asked our implementation team for a report to be run that shows the detail (the Transaction Aging Analysis report just shows in total) but then I had heard from