How Do I Calculate the Recovery Rate Using Exports?

The formula used to calculate your recovery rate is:

(Invoices created and recovered / Total invoices created) x 100

You can find this data using a specific process with the Invoices - Summary export.

Step 1: Get Total Recovered Invoices

1. Download the Invoices - Summary export. Set the "Invoice Type" filter to "Charge" and the "Invoice Status" filter to "All".

2. In the downloaded file, filter the status column to only show invoices with a status of "Paid".

3. Next, go to the recovery_reason column and filter out all invoices that do not have a reason populated.

4. The list that remains represents your total number of invoices that were recovered.

Step 2: Get Total Invoices Created

1. Start with the same Invoices - Summary export you downloaded.

2. The total number of invoices that appeared in your initial list before filtering represents the total number of invoices created during your selected interval.

Once you have these two numbers, you can apply them to the formula to calculate your recovery rate.