Billing Attempt Summary

This report lists billing attempt status for Subscriptions during the selected time period, aggregated by Product, Affiliate, and Currency. It lists total billing attempts, and summarizes successful and failed attempts with the total amount billed. It specifies first, second, and subsequent billing attempts. This report can be used to determine whether retry attempts for soft failures, and using card updater, result in increased payment capture, and are therefore cost effective when compared with the fees associated with retries. To determine success rate without retries (Commerce Engine payment capture): Divide (First Attempt Billing: Successful Attempts) by (First Attempt: Sub Total First Billing). To determine Commerce Engine uplift: Divide (Total successful billings - Total successful first attempts) by (Total first attempts). To generate a one time report:

Enter the relevant date range.
Optional. Enter an Email address where you’d like to receive notifications when the report is available. A single email address can be entered.
Click Submit. View the report in the My Reports page.

To generate a recurring report:

Toggle Recurring toggle to Yes.
Select a date for the first reporting period. Note: Reports display data occurring starting from the defined date. For example, a monthly report starting on March 1st displays data for the month of March up to March 31st.
Select the report’s Frequency. Choose between Weekly, Monthly or Quarterly.
Optional. Enter an Email address where you’d like to receive notifications when the report is available. A single email address can be entered.
Optional. If you want to receive the report uploaded to an SFTP Server, enable this option and provide the required details.
Click Submit. View the report in the My Reports page.

Display Columns

Note: The report’s display columns order is machine-generated and may therefore change without prior notice.

Field	Description
Product ID	Product ID from the customer’s Subscription.
Product Name	Product Description from the customer’s Subscription.
Affiliate ID	The Affiliate listed on the customer’s Subscription.
Currency	Currency of Transaction.
Total Billings	Every billing attempt made.
Total Successful Billings	Attempts that resulted in successful payments.
Total Failed Billings	Attempts that resulted in Hard Fail or Soft Fail reason codes.
Total Billings Attempts	All attempts made during period specified (initial and retries; success and failures).
First Attempt Billings	Initial attempts (success and failures).
Second Attempt Billings	Second attempt (retries for failures from initial attempt).
Subsequent Attempt Billings	All other attempts (retries for failures from second attempt and any additional - if Reseller (Service Provider) has specified additional retries).
Number	Count of attempts.
Amount	Total billed for attempts.
Subtotal	The Total for the listed Product’s results.
Total	The Total for all listed Product’s results.

Parent topic:Subscription Reports

Home

Introduction

For Merchants

For Resellers

Partner Ecosystem Management

Commerce Engine

Storefront Experience

APIs

Display Columns

​Display Columns

Display Columns