Sales Reporting to Show Date Successful

We send our sales reports to our accounting team so they can reconcile each month. What we have run into now that we are in a subscription model is that the sales reports show the date initiated and not successful payment date. This ends up being an issue around the end of the month. So contact was charged on 6/28 but failed and recharge was successful on 7/4 So our report looks like sales in June, but payment was not received until July. The only way to find this information is to go into the contact records transaction details and find the recharge successful date. Each month we have a list of people we have to find payments from because of this. Would love a report that shows date payment actually received so it matches our payment processor information.