CashBox Portal User Guide
CashBox for Salesforce
Decline Recovery Report
This report enables you to examine the effectiveness of your retry strategies. Using a cohort based on initial billing attempts that occur between the Start and End dates of a report, and which all have the same Initial Response Code, the Decline Recovery report tracks Retry results to-date as of the Report Run Date. The report automatically extends to the number of configured Retry attempts that have occurred to-date. Bear in mind that a cohort consists of invoices with initial billing attempts between the Start and End dates of the report that also share the same Initial Response Code and Currency. Performance is tracked, through multiple retries, all the way through the retry period (if run after a complete Retry cycle has finished), providing a complete picture of the end results of your retry strategy.
You can schedule this report (CSV format) and be notified when they are completed, or run the report on-demand (CSV format).
Create Decline Recovery Report Schedule
To run the report, go to Reports > Run Reports and select the report name. Enter a Day of Report date and, if you want to be notified when the report is ready, enter an email address. Click Submit.
To schedule a report, go to Reports > Create Scheduled Report and select the report name. Select weekly/monthly and enter a Begin the first report period date. Enter an email address if you want to be notified when the report is ready, and click Submit.
The following sample report shows a cohort of all billing attempts with an initial billing/attempt date of 7/4/17 and tracks Recovery through all retry attempts to-date.
Enter the desired parameters and click Submit to generate the report.
The following table describes the display fields of the Decline Recovery report.
|Report Run Date||Date the report is run.|
|Report Start Date||Start date of the report period. This is the earliest date for an initial billing attempt date to be included in the report.|
|Report End Date||End date of the report period. This is the latest date for an initial billing attempt date to be included in the report|
|Currency||Currency of the transaction.|
|Initial Response Code||Response code for initial billing attempt.|
|Initial Billing Amount||Amount of initial billing attempt, in the specified currency. (May not always be present.)|
|Starting Count||The number of individual transaction items for which this billing was declined.|
|Overall Recovery Rate||The percentage recovered of the total cost of all items in this billing attempt.|
|Overall Recovery Amount||The amount of money recovered.|
|Retry(n) Success||The success, measured in the number of individual items for which payment was received on this retry. For example, if Starting Count is 2 and Retry(1) Success is 1, this means one of two items was successfully billed. Retry(1) Failure will be 1, and Retry Recovery Rate will be 50%.|
|Retry(n) Failure||The number of individual items this billing attempt failed to recover. For example, if Starting Count is 3 and Retry(1) Failure is 1, this means one of three items was successfully billed. Retry(1) Success will be 1 and Retry(1) Recovery Rate will be 33%.|
|Retry(n) Recovery Rate||The percentage of transactions recovered in this retry.|