Aged Receivables reporting for full year for ECL Matrix

Hi Everyone

I need to produce an ECL provision matrix for our doubtful debt provisioning. I am trying to find a way in Reckon Hosted that I can produce a report that shows ALL credit sales for the year, and the timing in which they were paid. The aged receivable summary / detail only shows me what is owing over the specified periods at a certain date. Below is a basic example of what I am trying to achieve through a Reckon report. I might have to do this manually, but hoping not as we have hundreds of receivables that need assessing.