The formula used to calculate recovery rate is: (Invoices created during the selected interval that were recovered / invoices created during the selected interval) * 100.
To find the total number of invoices created during the selected interval that were recovered, you would download the Invoices - Summary export (Invoice Type: Charge, Invoice Status: All).
You will first look at the total number of invoices that come up and note that.
Once this is done, go to the status column and filter out all statuses except for Paid.
You would go to the recovery_reason column and filter out all invoices that don't have a reason populated. You will be left with a list of invoices that were recovered.
Divide the total number of invoices created during your selected interval by the total number of invoices recovered and then multiply that by 100 to get your recovery rate.
Comments
0 comments