Optimization Protection

Debit Authorization Aging report

This report helps identify authorized debit transactions that were not completed as sales within three or more days.

Debit authorization aging report details
Report type	Supported entitiy types	Supported file formats
Debit authorization aging details	PE - Processing Entity TD - Transaction Division BU - Business Unit CO – Company RG – Reporting Group	Comma Separated Values (CSV) Gzip or GNU Zip (GZ) Portable Document Format (PDF) MS Excel Workbook (.xlsx)

Note

You must be a legacy reporting client to access this report.

Use Case

Monitor and identify authorized debit transactions that have not been completed as sales within three or more days.

Granularity

Summary section: Days, Count, Net Amount

Details section: Merchant Company Name, Company External Identifier, Entity Identifier, Account Number, Authorization Amount, Number of Days Outstanding, Trace Number and Merchant Order Number

Fields

Summary

The following table shows the summary section field details.

Summary field details
Field name	Description
Days	The day range.
Count	The number of transactions
Net Amount	The sum of the transaction amount.

Details

The following table shows the details section field details.

Details field's details
Field name	Description
Number of Days Outstanding	The precise number of days the item has been in the system. Number of days since the submission was received.
Merchant Company Name	The name associated with the Merchant Services assigned CO number.
Company External Identifier	The external company identifier.
Entity Type Code	The hierarchy level of the transaction.
Entity Identifier	The unique entity identifier.
Authorization Code	The six-character code related to a positive response from the endpoint.
Authorization Date	The date in UTC time zone on which the authorization was performed for the transaction.
Merchant Action Code	The merchant supplied code that indicates the type of transaction conducted.
Authorization Amount	The authorization amount.
Payment Method Code	Code that identifies the method of payment (MOP) for the transaction.
Account Number	The cardholder's account number.
Merchant Order Number	The order number submitted by the merchant with the original sale.
Debit Tracing Number	A unique identifier assigned to a debit entry that enables end-to-end tracing of the debit transaction.
Transaction Type Code	The code that identifies the attributes of a transaction.
Presentment Currency Code	The three-character abbreviation for currency in which the cardholder transaction occurred.
Settlement Currency Code	The three-character abbreviation for currency in which the merchant is being funded.

Sample report configuration

CO/BU/TD/PE

The following request code block shows how to configure an authorization report for entityType = CO/BU/TD/PE.

Json

{
  "entityType": "CO",
  "entityIds": [
    "1234567"
  ],
  "reportSections": [
    {
      "sectionReportTypeName": "Debit Authorization Aging Details",
      "sectionTitle": "Debit Authorization Aging Summary",
      "sectionReportTypeId": "3010",
      "sectionSelectedFields": [
        {
          "reportAttributeName": "Days"
        },
        {
          "reportAttributeName": "Count",
          "aggregateOperationText": "count"
        },
        {
          "reportAttributeName": "Net Amount",
          "aggregateOperationText": "sum"
        }
      ]
    },
    {
      "sectionReportTypeName": "Debit Authorization Aging Details",
      "sectionTitle": "Debit Authorization Aging Detail",
      "sectionReportTypeId": "3010",
      "sectionSelectedFields": [
        {
          "reportAttributeName": "Number of Days Outstanding"
        },
        {
          "reportAttributeName": "Merchant Company Name"
        },
        {
          "reportAttributeName": "Company External Identifier"
        },
        {
          "reportAttributeName": "Entity Type Code"
        },
        {
          "reportAttributeName": "Entity Identifier"
        },
        {
          "reportAttributeName": "Authorization Code"
        },
        {
          "reportAttributeName": "Authorization Date"
        },
        {
          "reportAttributeName": "Merchant Action Code"
        },
        {
          "reportAttributeName": "Authorization Amount"
        },
        {
          "reportAttributeName": "Payment Method Code"
        },
        {
          "reportAttributeName": "Account Number"
        },
        {
          "reportAttributeName": "Merchant Order Number"
        },
        {
          "reportAttributeName": "Debit Trace Number"
        },
        {
          "reportAttributeName": "Transaction Type Code"
        },
        {
          "reportAttributeName": "Presentment Currency Code"
        },
        {
          "reportAttributeName": "Settlement Currency Code"
        }
      ],
      "sectionSortOrderList": [],
      "sectionFilterAttributeList": [],
      "filterExpression": "",
      "distinctSelectIndicator": false
    }
  ],
  "fileDelimiter": ",",
  "reportConfigurationName": "Debit Authorization Aging Report",
  "reportFileName": "Debit Authorization Aging Report,<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
  "reportHeader": "<Processing Entity ID>,<Report Type>,<frequency>,<From Date YYYY-MM-DD>,<To Date YYYY-MM-DD>,<Generation Date YYYY-MM-DD>,<Generation Time HH:MM:SS>",
  "fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
  "fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
  "reportConfigStatus": "active",
  "reportName": "Debit Authorization Aging Report",
  "csvColumnNameDisplayIndicator": true,
  "frequencyConfig": {
    "scheduleFrequency": "adhoc",
    "reportingPeriodStartTimestamp": "2026-07-10 00:00:00",
    "reportingPeriodEndTimestamp": "2026-07-11 23:00:00"
  }
}

Download sample report

Scheduled and ad hoc report configurations