Optimization Protection

Deposit Details report

This report provides details of sale and refund transactions for each merchant order number along with the interchange and assessment fees of each transaction for the selected reporting period.

Deposit details report details
Report type	Supported entity types	Supported file formats
Submission details	PE - Processing Entity TD - Transaction Division BU - Business Unit FTI - Fund Transfer Instruction CO - Company RG - Reporting Group PI - Platform Identifier	Comma Separated Values (CSV) Gzip or GNU Zip (GZ) Portable Document Format (PDF) MS Excel Workbook (.xlsx)

Use cases

Verify what was sent and processed against their own internal transactions report.
Reconciliation or research of deposit and submission activity.

Granularity

Combination of Submission Date, Presentment Currency Code, Settlement Currency Code, Transaction Division External Identifier, Payment Method Code, Merchant Order Number, Account Number, Credit Card Expiration Year Month Number, Merchant Action Code, Action Type Code Text, Authorization Date, Country of Issuance, Transaction Type Code, Transaction Type Text, Merchant Category Code, Digital Token Method Code, Digital Wallet Brand, Merchant Information Description, Surcharge Amount, Bank Sort Code, Card Usage Type

Fields

The following table shows the field details. Fields labeled (O) are optional and can be added to preset reports as needed.

Field details
Field name	Definition
Submission Date	The date on which the submission was fully received at J.P. Morgan in UTC time zone.
Presentment Currency Code	The three-character abbreviation for the currency in which the cardholder transaction occurred.
Settlement Currency Code	The three-character abbreviation for the currency in which the merchant is being funded.
Payment Method Code	The code that identifies the (MOP) method of payment for the transaction.
Merchant Order Number	The order number submitted by the merchant with the original sale.
Account Number	The cardholder's account number.
Credit Card Expiration Year Month Number	The credit card account expiration date (month and year) as submitted by the merchant with this transaction. Note: If the values in this column, do not render correctly, open the report file in Notepad to get the correct values for this field.
Transaction Amount in Presentment Currency	The total of sale or refund amount in presentment currency.
Merchant Action Code	The merchant supplied code that indicates the type of transaction conducted.
Action Type Code Text	The description of the action type code.
Authorization Date	The date in UTC time zone on which the authorization was performed for the transaction.
Country of Issuance	The standard alpha ISO country code that identifies the card's issuing country. May be space-filled for transactions on unsupported methods of payment.
Transaction Type Code	The code that identifier the attributes of the transaction.
Transaction Type Text	The textual description of the transaction type.
Merchant Category Code	The code that is used to classify a merchant's product or service.
Digital Token Method Code	The code that indicates whether the pre-dispute is related to a digital payment token.
Digital Wallet Brand	The name of the token requestor within the card network.
Interchange Qualification Code	The code that identifies the rate at which J.P. Morgan qualified the transaction.
Interchange Unit Fee	The fee per item as assessed by the card associations. For this field, a positive amount indicates a debit unit fee to the merchant. A negative amount indicates a credit unit fee.
Fee Rate	The percentage rate fee applied to the face value of this transaction. For this field, a positive amount indicates a debit % rate to the merchant. A negative amount indicates a credit % rate.
Total Interchange Amount	The total Interchange fee assessed for this data record in settlement currency.
Total Assessment Amount	The total assessment fee assessed for this data record in settlement currency.
Other Debit Passthrough Fees	The total debit pass through fee assessed for this data record in settlement currency.
Merchant Information Description	The customized free form block of merchant specific data (up to 99 bytes) sent in with this submission. The submission must be sent directly to Stratus for this field to populate.
Surcharge Amount	The total surcharge amount submitted by the merchant for this transaction.
Bank Sort Code	The code that identifies both the bank and the branch where the account is held.
Card Usage Type	Identifies whether the transaction is a signature debit transaction (1), PIN debit transaction (2), or credit card transaction (3).
Entity Identifier	The associated CO, BU, TD, or PE identification number.
Entity Type Code	The level at which the reported event occurred. Valid values are: `BU` - Business Unit `CO` - Company `TD` - Transaction Division `PE` - Processing Entity
Platform Identifier	The identifier of the platform used to facilitate the transaction request.
Platform Name	The name of the platform used to facilitate the transaction request.
Entity Name (O)	The name associated with the Commerce platform assigned entity identifier.
Transaction Division External Identifier (O)	The identifier of the external transaction division.
Transaction Processing Entity Identifier (O)	The identifier of the transaction processing entity.
Merchant Presenter Identifier (O)	The merchant's presenter ID number.
Merchant Presenter Short Name (O)	The merchant's presenter ID abbreviated name.
Submission Identifier (O)	The Commerce platform assigned unique identification number for the submission.
Record Number (O)	The record number is the sequential number of a transaction within a submission file.
Receiving Depository Financial Institution Number (O)	The unique identifier of a financial institution (routing number) that receives an Electronic Check Processing (ECP) transaction.
Merchant Service Authorization Response Code (O)	The three digit authorization response indicating Approval, Decline, or Rejection.
Trace Number (O)	The sequential eight-digit identifier assigned by Commerce platform ranging from 1-99999999. This field is used for trace number for US debit transactions only.
Consumer Bank Country Code (O)	The code that indicates the country in which the consumer's bank is located.
Durbin Amendment Regulator Indicator (O)	Indicates whether the issuing bank card range is regulated or not as defined by the Durbin Amendment.
International Bank Account Number (O)	The international bank account number that is comprised of the bank's country code, a checksum, and the Base Bank Account Number (BBAN).
Bank Identification Code (O)	The bank identification code.
Creditor Identifier (O)	The identifier of the creditor associated with the transaction.
Mandate Identifier (O)	The code that identifies the agreement between the consumer and merchant to allow the consumer's direct debit account to be debited in an automated manner over a period of time.
Mandate Type Code (O)	The sequence type of the mandate.
Signature Date (O)	The date on which the consumer signed the mandate.
Authorization Code (O)	The six character code related to a positive response from the endpoint.
Authorization Timestamp (O)	The date and time for authorization activity.
Transaction Timestamp (O)	The hour, minute, seconds, and date (if timestamp) or year, month, and date (if date) when the transaction (monetary or non-monetary) occurred.
Batch Identifier (O)	The identifier of a group of sale and refund transactions processed through the POS terminal or similar device.
Cash Back Amount (O)	The amount of cash returned to the cardholder that was included in the total transaction value. May be space-filled. This field is valid for retail debit transactions and to display Discover or Mastercard Cash Over Amount.
Digital Token Method Code Text (O)	The code that indicates whether the pre-dispute is related to a Digital Payment Token.
Terminal Identifier (O)	The identifier of the Point Of Sale (POS) terminal or similar device through which the transaction was processed.
Voucher Number (O)	The number used for EBT debit transactions only.

Sample report configurations

The following samples help you get an idea of how to configure deposit details reports.

CO/BU/TD/PE

The following request code block shows how to configure a deposit details report for entityType = CO/BU/TD/PE.

Json

{
    "entityType": "CO",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionTitle": "Deposit Details",
             "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "sectionSelectedFields": [
                {
                    "reportAttributeName": "Entity Identifier"
                },
                {
                    "reportAttributeName": "Entity Type Code"
                },
				{
                    "reportAttributeName": "Submission Date"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                },
                {
                    "reportAttributeName": "Payment Method Code"
                },
                {
                    "reportAttributeName": "Merchant Order Number"
                },
                {
                    "reportAttributeName": "Account Number"
                },
                {
                    "reportAttributeName": "Credit Card Expiration Year Month Number"
                },
                {
                    "alias": "Transaction Amount in Presentment Currency",
                    "reportAttributeName": "Presentment Amount",
                    "aggregateOperationText": "sum",
                    "conditionalAggregateIndicator": true,
                    "conditionalAggregateFilterList": [
                        {
                            "aggregateConditionAttributeName": "Charge Category Code",
                            "aggregateConditionText": "IN(\"SALE\",\"REF\")"
                        }
                    ]
                },
                {
                    "reportAttributeName": "Merchant Action Code"
                },
                {
                    "reportAttributeName": "Action Type Code Text"
                },
                {
                    "reportAttributeName": "Authorization Date"
                },
                {
                    "reportAttributeName": "Country of Issuance"
                },
                {
                    "reportAttributeName": "Transaction Type Code"
                },
                {
                    "reportAttributeName": "Transaction Type Text"
                },
                {
                    "reportAttributeName": "Merchant Category Code"
                },
                {
                    "reportAttributeName": "Digital Token Method Code"
                },
                {
                    "reportAttributeName": "Digital Wallet Brand"
                },
                {
                    "alias": "Interchange Qualification Code",
                    "reportAttributeName": "Interchange Qualification Code",
                    "aggregateOperationText": "max",
                    "conditionalAggregateIndicator": true,
                    "conditionalAggregateFilterList": [
                        {
                            "aggregateConditionAttributeName": "Fee Text",
                            "aggregateConditionText": "IN(\"Interchange\")"
                        }
                    ]
                },
                    {
                        "alias": "Interchange Unit Fee",
                        "reportAttributeName": "Unit Fee Amount",
                        "aggregateOperationText": "sum",
                        "conditionalAggregateIndicator": true,
                        "conditionalAggregateFilterList": [
                            {
                                "aggregateConditionAttributeName": "Fee Text",
                                "aggregateConditionText": "IN(\"Interchange\")"
                            }
                        ]
                    },
                    {
                        "alias": "Interchange Face Value % Fee",
                        "reportAttributeName": "Fee Rate",
                        "aggregateOperationText": "sum",
                        "conditionalAggregateIndicator": true,
                        "conditionalAggregateFilterList": [
                            {
                                "aggregateConditionAttributeName": "Fee Text",
                                "aggregateConditionText": "IN(\"Interchange\")"
                            }
                        ]
                    },
                    {
                        "alias": "Total Interchange Amount",
                        "reportAttributeName": "Raw Settled Total Fee Amount",
                        "aggregateOperationText": "sum",
                        "conditionalAggregateIndicator": true,
                        "conditionalAggregateFilterList": [
                            {
                                "aggregateConditionAttributeName": "Charge Category Code",
                                "aggregateConditionText": "IN(\"IA\")"
                            },
                            {
                                "aggregateConditionAttributeName": "Charge Subcategory Text",
                                "aggregateConditionText": "IN(\"Interchange Fees\")"
                            }
                        ]
                    },
                    {
                        "alias": "Total Assessment Amount",
                        "reportAttributeName": "Raw Settled Total Fee Amount",
                        "aggregateOperationText": "sum",
                        "conditionalAggregateIndicator": true,
                        "conditionalAggregateFilterList": [
                            {
                                "aggregateConditionAttributeName": "Charge Category Code",
                                "aggregateConditionText": "IN(\"IA\")"
                            },
                            {
                                "aggregateConditionAttributeName": "Charge Subcategory Text",
                                "aggregateConditionText": "IN (\"Assessment Fees\")"
                            }
                        ]
                    },
                    {
                        "alias": "Other Debit Passthrough Fees",
                        "reportAttributeName": "Raw Settled Total Fee Amount",
                        "aggregateOperationText": "sum",
                        "conditionalAggregateIndicator": true,
                        "conditionalAggregateFilterList": [
                            {
                                "aggregateConditionAttributeName": "Charge Category Code",
                                "aggregateConditionText": "IN(\"PFEE\")"
                            },
                            {
                                "aggregateConditionAttributeName": "Charge Subcategory Text",
                                "aggregateConditionText": "IN(\"Debit Pass Thru Fees\")"
                            }
                        ]
                    },
                   {
                        "reportAttributeName": "Merchant Information Description"
                    },
                    {
                        "reportAttributeName": "Surcharge Amount"
                    },
                    {
                        "reportAttributeName": "Bank Sort Code"
                    },
                    {
                        "reportAttributeName": "Card Usage Type"
                    }
                ],
                "sectionSortOrderList": [
                    {
                        "reportAttributeName": "Submission Date",
                        "sortOrderCode": "asc"
                    },
                    {
                        "reportAttributeName": "Entity Identifier",
                        "sortOrderCode": "asc"
                    },
                    {
                        "reportAttributeName": "Payment Method Code",
                        "sortOrderCode": "desc"
                    }
                ],
                "sectionFilterAttributeList": [
                    {
                        "reportAttributeName": "Online Submission Indicator",
                        "filterAttributeCode": "=\"N\""
                    },
                    {
                        "reportAttributeName": "Merchant Action Text",
                        "filterAttributeCode": "=\"DEPOSITS\""
                    },
                    {
                        "reportAttributeName": "Transaction Type Text",
                        "filterAttributeCode": "!=\"Rejects\""
                    },
                    {
                        "reportAttributeName": "Transaction Deposit Indicator",
                        "filterAttributeCode": "=\"Y\""
                    },
                    {
                        "reportAttributeName": "Merchant Order Number",
                        "filterAttributeCode": "!=\"NULL\""
                    }
                ]
            }
        ],
    "fileDelimiter": ",",
    "reportConfigurationName": "Deposit Detail Report",
    "reportFileName": "Deposit Detail Report.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
    "reportHeader": "EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
    "fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "reportName": "Deposit Detail Report",
    "csvColumnNameDisplayIndicator": true,
    "reportConfigStatus": "active",
    "frequencyConfig": {
        "scheduleFrequency": "adhoc",
    	"reportingPeriodStartTimestamp": "2026-03-24 02:00:00",
    	"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
    }
}

PI

The following request code block shows how to configure a deposit details report for entityType = PI.