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.
| Report type | Supported entity types | Supported file formats |
|---|---|---|
| Submission Details |
|
|
Use cases
- Verify what was sent and processed against your own internal transactions report.
- Reconciliation or research of deposit and submission activity.
Granularity
A 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 name |
Definition |
|---|---|
|
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:
|
|
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 method of payment (MOP) 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). |
|
Authorization Code (O) |
The six-character code related to a positive response from the endpoint. |
|
Authorization Timestamp (O) |
The date and time in UTC time zone on which the authorization was performed for the transaction. |
|
Bank Identification Code (O) |
The bank identification code. |
|
Batch Identifier (O) |
The identifier of a group of sale and refund transactions processed through the Point Of Sale (POS) terminal or similar device. |
|
Biometric Description (O) |
The description of the method used to automatically recognize a consumer by means of unique physical characteristics, such as facial recognition, fingerprint, or palm. |
|
Biometric Indicator (O) |
The code for the method used to automatically recognize a consumer by means of unique physical characteristics, such as facial recognition, fingerprint, or palm. |
|
Business Unit Identifier (O) |
The identifier of the business unit associated with the record. |
|
Business Unit Name (O) |
The name associated with the Commerce platform assigned business unit number. |
|
Cash Back Amount (O) |
The amount of cash returned to the cardholder that was included in the total transaction value. May be space-filled. Valid for retail debit transactions and to display the Discover or Mastercard cash over amount. |
|
Company External Identifier (O) |
The identifier of the external company. |
|
Company Name (O) |
The name associated with the Commerce platform assigned CO number. |
|
Consumer Bank Country Code (O) |
The country in which the consumer's bank is located. |
|
Conveyed Settled Code (O) |
Indicates whether the data record activity is settled or conveyed. |
|
Creditor Identifier (O) |
The creditor identifier associated with the transaction. |
|
DCC Accepted (O) |
Indicates that the cardholder accepted the Dynamic Currency Conversion (DCC) offer and chose to complete the transaction in their home/card currency. |
|
Digital Token Method Code Text (O) |
The description of the digital token method code. |
|
Durbin Amendment Regulator Indicator (O) |
Indicates whether the issuing bank card range is regulated or not, as defined by the Durbin Amendment. |
|
Encrypt (O) |
The PAN encryption account status. |
|
Entity Name (O) |
The name associated with the Commerce platform assigned entity identifier. |
|
International Bank Account Number (O) |
The International Bank Account Number (IBAN), comprised of the bank's country code, a checksum, and the Basic Bank Account Number (BBAN) of up to thirty alphanumeric characters containing the domestic bank account details. |
|
Mandate Identifier (O) |
The code that identifies the agreement between the consumer and merchant that allows 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. Valid values are:
Space-filled if Mandate Identifier and Signature Date are space-filled. |
|
Merchant Presenter Identifier (O) |
The identifier of the merchant presenter. |
|
Merchant Presenter Short Name (O) |
The abbreviated name of the merchant presenter. |
|
Merchant Service Authorization Response Code (O) |
The J.P. Morgan response code describing the result of an authorization attempt, either received from an endpoint or merchant-supplied. |
|
POS Entry Mode (O) |
Indicates how the card number was entered on the Point Of Sale (POS) device. |
|
POS Transaction Reference Number (O) |
The transaction reference assigned by the payment network or generated by the Point Of Sale (POS). |
|
Receiving Depository Financial Institution Number (O) |
The Receiving Depository Financial Institution (RDFI) number / routing number. |
|
Record Number (O) |
The sequential number of a transaction within a submission file. |
|
Reject Code (O) |
Indicates that the transaction was rejected and not processed for settlement. |
|
Signature Date (O) |
The date the customer signed the mandate. |
|
Sub Merchant Identifier (O) |
The J.P. Morgan-assigned identifier that uniquely identifies a sub-merchant (sponsored merchant) and its location under a Payment Facilitator (PayFac). |
|
Sub Merchant Reference Identifier (O) |
The merchant-assigned reference for the sub-merchant associated with a Payment Facilitator (PayFac). |
|
Submission Identifier (O) |
The J.P. Morgan-assigned unique identification number for the submission. |
|
Terminal Identifier (O) |
The identifier of the Point Of Sale (POS) terminal or similar device through which the transaction was processed. |
|
Trace Number (O) |
For US debit transactions only, a sequential eight-digit identifier (1-99999999) assigned by J.P. Morgan. The number rolls over, so the same number may appear more than once. Space-filled for transactions other than US debit. |
|
Transaction Division External Identifier (O) |
The identifier of the external transaction division. |
|
Transaction Identifier (O) |
The identifier of the transaction. |
|
Transaction Processing Entity Identifier (O) |
The identifier of the transaction processing entity. |
|
Transaction Timestamp (O) |
The activity date and time of the transaction in UTC time zone. |
|
Voucher Number (O) |
The identifying 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.
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"preBuiltConfigurationId": "preset_Unified_Deposit_Detail_Report",
"reportSections": [
{
"sectionReportTypeId": "3003",
"sectionReportTypeName": "Submission Details",
"sectionSelectedFields": [
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code"
},
{
"reportAttributeName": "Submission Date"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Transaction Division External 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": "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"
}
],
"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\""
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Submission Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
}
]
}
],
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2026-04-08 00:00:00",
"reportingPeriodEndTimestamp": "2026-04-09 23:59:59"
},
"reportConfigurationName": "Deposit Detail",
"reportName": "Deposit Detail",
"reportConfigType": "PreBuilt",
"fileDelimiter": ",",
"csvColumnNameDisplayIndicator": true,
"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>",
"languageCode": "en-us"
}PI
The following request code block shows how to configure a deposit details report for entityType = PI.
{
"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.<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>",
"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"
}
}