# JPMC-PDP Documentation from https://developer.payments.jpmorgan.com # 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 Seperated 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. **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. | | Transaction Division External Identifier | The identifier of the external transaction division. | | Transaction Processing Entity Identifier | The transaction processing entity identifier. | | 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 | The name associated with the Commerce platform assigned entity identifier. | | Merchant Presenter Identifier | The merchant's presenter ID number. | | Merchant Presenter Short Name | The merchant's presenter ID abbreviated name. | | Submission Identifier | The Commerce platform assigned unique identification number for the submission. | | Record Number | The record number is the sequential number of a transaction within a submission file. | | Receiving Depository Financial Institution Number | The unique identifier of a financial institution (routing number) that receives an Electronic Check Processing (ECP) transaction. | | Merchant Service Authorization Response Code | The three digit authorization response indicating Approval, Decline, or Rejection. | | Trace Number | 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 | The code that indicates the country in which the consumer's bank is located. | | Durbin Regulated | Durbin regulated. | | International Bank Account Number | 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 | The bank identification code. | | Creditor Identifier | The identifier of the creditor associated with the transaction. | | Mandate Identifier | 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 | The sequence type of the mandate. | | Signature Date | The date on which the consumer signed the mandate. | | AUTHORIZATION CODE | The six character code related to a positive response from the endpoint. | | AUTHORIZATION TIMESTAMP | The date and time for authorization activity. | | Transaction Timestamp | The hour, minute, seconds and date (if timestamp) or year, month, and date (if date) when the transaction (monetary or non-monetary) occurred. | ## 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....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,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. ```json { "entityType": "PI", "entityIds": [ "6019581085" ], "reportSections": [ { "sectionTitle": "Deposit Details", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "reportAttributeName": "Submission Date" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Transaction Processing Entity Identifier" }, { "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": "Platform Identifier" }, { "reportAttributeName": "Platform Name" }, { "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": "Transaction Processing 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....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Deposit Detail Report", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2024-05-06 11:30:00", "reportingPeriodEndTimestamp": "2024-05-07 02:00:00" } } ``` ## Download sample report Download the sample [Deposit details report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Deposit%20Details%20Preset%20Report.csv). ## Related [Scheduled and adhoc report configurations](/docs/commerce/optimization-protection/capabilities/reporting/report-configurations/scheduled-adhoc)