# JPMC-PDP Documentation from https://developer.payments.jpmorgan.com # Deposit activity summary report This report provides the summary of sales and refunds (settled and conveyed), fees and adjustments, and funds transfer activity for the selected reporting period. **Deposit activity summary report details** | Report type | Supported entity types | Supported file formats | | --- | --- | --- | | Submission details and settlement summary | - 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 - Summarize the deposit activity that J.P. Morgan received during a specified date range and reconcile with the user’s systems. - Summarize any fees and adjustments that financially impacts the user. - Reconcile transaction activity with funds transfer for given reporting period. ## Granularity - Conveyed deposit summary: Combination of Presentment Currency Code, Settlement Currency Code, and Payment Method Code - Settled deposit summary: Combination of Presentment Currency Code, Settlement Currency Code, and Payment Method Code. - Fees and adjustments summary: Combination of Presentment Currency Code, Settlement Currency Code, and Foreign Exchange Rate. - Deposit transfer summary: Combination of Activity Date, Presentment Currency Code, Settlement Currency Code, Funds Transfer Category Description, Fund Transfer Instruction Number, Fund Transfer Identifier, Merchant Activity Date Range, and Fund Transfer Effective Date ## Conveyed deposit summary ### Fields The following table shows the conveyed deposit summary field details. **Conveyed deposit summary field details** | Field name | Definition | | --- | --- | | Record Type | Deposit summary type. | | 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. | | Payment Method Code | Code that identifies the (MOP) method of payment for the transaction. | | Conveyed Sales Count | Total number of conveyed sales. | | Conveyed Sales Amount | Total conveyed sales amount in presentment currency. | | Conveyed Refund Count | Total number of conveyed refunds. | | Conveyed Refund Amount | Total conveyed refund amount in presentment currency. | | Entity Identifier | Associated CO, BU, or TD identification number. | | Entity Type Code | Level at which the reported event occurred. - BU: Business Unit - CO: Company - TD: Transaction Division | ## Settled deposit summary ### Fields The following table shows the settled deposit summary field details. **Settled deposit summary field details** | Field name | Definition | | --- | --- | | Record Type | Deposit summary type | | 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. | | Payment Method Code | Code that identifies the (MOP) method of payment for the transaction. | | Settled Sales Count | Total number of settled sales. | | Settled Sales Amount in Presentment Currency | Total settled sales amount in presentment currency. | | Settled Sales Amount in Settlement Currency | Total settled sales amount in settlement currency. | | Settled Refund Count | Total number of settled refund included in this data record. | | Settled Refund Amount in Presentment Currency | Total settled refund amount in presentment currency. | | Settled Refund Amount in Settlement Currency | Total settled refund amount in settlement currency. | | Entity Identifier | Associated CO, BU, or TD identification number. | | Entity Type Code | Level at which the reported event occurred. - BU: Business Unit - CO: Company - TD: Transaction Division | ## Fees and adjustments summary ### Fields The following table shows the fee and adjustment summary field details. **Fee and adjustment summary field details** | Field name | Definition | | --- | --- | | Record Type | Deposit summary type. | | 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. | | Net Settled Deposits Amount | Net total of settled sales and settled refunds in settlement currency. | | Interchange & Assessment Fees | Total interchange and assessment fees in settlement currency. | | Processing Fees | Total processing fees in settlement currency. | | Chargeback Adjustments | Total chargeback adjustments in settlement currency. | | Other Fees & Adjustments | Total of other fees and adjustments in settlement currency. This excludes interchange and assessment fees, processing fees, chargeback adjustments. | | Net Financial Activity | Total net financial activity in settlement currency i.e. the difference between the net settled deposits and sum of all the fees. | | Foreign Exchange Rate | The foreign exchange rate multiplier applied to the currency pair in this data record for cross currency transactions. | | Entity Identifier | Associated CO, BU, or TD identification number. | | Entity Type Code | Level at which reported event occurred. - BU: Business Unit - CO: Company - TD: Transaction Division | ## Deposit transfer summary ### Fields The following table shows the deposit transfer summary field details. **Deposit transfer summary field details** | Field name | Definition | | --- | --- | | Record Type | Deposit summary type. | | Activity Date | Activity date of the transaction in UTC time zone. | | 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. | | Funds Transfer Category Description | Describes the textual description associated with funds transfer category code. | | Fund Transfer Instruction Number | Funds transfer instruction number associated with the reported activity. | | Fund Transfer Identifier | Unique identifier assigned by Chase for each fund transfer activity. | | Merchant Activity Date Range | J.P. Morgan activity date range for this data record. | | Fund Transfer Effective Date | Indicates the date on which the funds transfer is scheduled to be credited to the merchant's bank account. | | Funds Transfer Amount | Total of funds transfer amount for settled deposits in settlement currency. | | Entity Identifier | Associated CO, BU, or TD identification number. | | Entity Type Code | Level at which reported event occurred. - BU: Business Unit - CO: Company - TD: Transaction Division | ## Sample report configurations The following samples help you get an idea of how to configure deposit activity summary report. ### CO/BU/TD The following request code block shows how to configure a deposit activity summary report for `entityType` = CO/BU/TD. ```json { "entityType": "CO", "entityIds": [ "1234567" ], "reportSections": [ { "sectionTitle": "Conveyed Deposit Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Conveyed Deposit Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Payment Method Code" }, { "alias": "Conveyed Sales Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Sales\")" } ] }, { "alias": "Conveyed Sales Amount", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Sales\")" } ] }, { "alias": "Conveyed Refund Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Refunds\")" } ] }, { "alias": "Conveyed Refund Amount", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Refunds\")" } ] } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Payment Method Code", "sortOrderCode": "desc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Settled Deposit Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Settled Deposit Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Payment Method Code" }, { "alias": "Settled Sales Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Settled Sales\")" } ] }, { "alias": "Settled Sales Amount in Presentment Currency", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"SALE\")" } ] }, { "alias": "Settled Sales Amount in Settlement Currency", "reportAttributeName": "Settlement Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"SALE\")" } ] }, { "alias": "Settled Refund Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] }, { "alias": "Settled Refund Amount in Presentment Currency", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] }, { "alias": "Settled Refund Amount in Settlement Currency", "reportAttributeName": "Settlement Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Payment Method Code", "sortOrderCode": "desc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Fees & Adjustments Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Fees & Adjustments Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Settlement Amount", "alias": "Net Settled Deposits Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN (\"SALE\",\"REF\")" }, { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN (\"S\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Interchange & Assessment Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Interchange & Assessment Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Processing Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Chargeback Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Chargeback Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Other Fees & Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Interchange & Assessment Fees\",\"Chargeback Adjustments\",\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Net Financial Activity", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ] }, { "reportAttributeName": "Foreign Exchange Rate" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "Not IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Deposit Transfer Summary", "sectionReportTypeName": "Settlement Summary", "sectionReportTypeId": "3005", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Deposit Transfer Summary" }, { "reportAttributeName": "Activity Date" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Funds Transfer Category Description" }, { "reportAttributeName": "Fund Transfer Instruction Number" }, { "reportAttributeName": "Fund Transfer Identifier" }, { "reportAttributeName": "Merchant Activity Date Range" }, { "reportAttributeName": "Fund Transfer Effective Date" }, { "alias": "Funds Transfer Amount", "reportAttributeName": "Funds Transfer Category Amount", "aggregateOperationText": "sum" } ], "sectionSortOrderList": [ { "reportAttributeName": "Activity Date", "sortOrderCode": "asc" }, { "reportAttributeName": "Funds Transfer Category Description", "sortOrderCode": "asc" }, { "reportAttributeName": "Fund Transfer Effective Date", "sortOrderCode": "asc" }, { "reportAttributeName": "Fund Transfer Identifier", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Category Code", "filterAttributeCode": "NOT IN (\"OTHER\")" }, { "reportAttributeName": "Funds Transfer Category Amount", "filterAttributeCode": "!=0.0" }, { "reportAttributeName": "Settled Conveyed Code", "filterAttributeCode": "IN (\"S\")" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Deposit Activity Summary Report", "reportFileName": "Deposit ACtivity Summary Report....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "reportName": "Deposit Activity Summary Report", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2024-07-24 02:00:00", "reportingPeriodEndTimestamp": "2024-07-25 01:59:59" } } ``` ### PE The following request code block shows how to configure a deposit activity summary report for `entityType` = PE. ```json { "entityType": "PE", "entityIds": [ "1234567" ], "reportSections": [ { "sectionTitle": "Conveyed Deposit Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Conveyed Deposit Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Payment Method Code" }, { "alias": "Conveyed Sales Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Sales\")" } ] }, { "alias": "Conveyed Sales Amount", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Sales\")" } ] }, { "alias": "Conveyed Refund Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Refunds\")" } ] }, { "alias": "Conveyed Refund Amount", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Refunds\")" } ] } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Payment Method Code", "sortOrderCode": "desc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Settled Deposit Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Settled Deposit Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Payment Method Code" }, { "alias": "Settled Sales Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Settled Sales\")" } ] }, { "alias": "Settled Sales Amount in Presentment Currency", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"SALE\")" } ] }, { "alias": "Settled Sales Amount in Settlement Currency", "reportAttributeName": "Settlement Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"SALE\")" } ] }, { "alias": "Settled Refund Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] }, { "alias": "Settled Refund Amount in Presentment Currency", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] }, { "alias": "Settled Refund Amount in Settlement Currency", "reportAttributeName": "Settlement Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Payment Method Code", "sortOrderCode": "desc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Fees & Adjustments Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Fees & Adjustments Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Settlement Amount", "alias": "Net Settled Deposits Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN (\"SALE\",\"REF\")" }, { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN (\"S\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Interchange & Assessment Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Interchange & Assessment Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Processing Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Chargeback Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Chargeback Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Other Fees & Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Interchange & Assessment Fees\",\"Chargeback Adjustments\",\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Net Financial Activity", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ] }, { "reportAttributeName": "Foreign Exchange Rate" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "Not IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Deposit Transfer Summary", "sectionReportTypeName": "Settlement Summary", "sectionReportTypeId": "3005", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Deposit Transfer Summary" }, { "reportAttributeName": "Activity Date" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Funds Transfer Category Description" }, { "reportAttributeName": "Fund Transfer Instruction Number" }, { "reportAttributeName": "Fund Transfer Identifier" }, { "reportAttributeName": "Merchant Activity Date Range" }, { "reportAttributeName": "Fund Transfer Effective Date" }, { "alias": "Fund Transfer Amount", "reportAttributeName": "Funds Transfer Category Amount", "aggregateOperationText": "sum" } ], "sectionSortOrderList": [ { "reportAttributeName": "Activity Date", "sortOrderCode": "asc" }, { "reportAttributeName": "Funds Transfer Category Description", "sortOrderCode": "asc" }, { "reportAttributeName": "Fund Transfer Effective Date", "sortOrderCode": "asc" }, { "reportAttributeName": "Fund Transfer Identifier", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Category Code", "filterAttributeCode": "NOT IN (\"OTHER\")" }, { "reportAttributeName": "Funds Transfer Category Amount", "filterAttributeCode": "!=0.0" }, { "reportAttributeName": "Settled Conveyed Code", "filterAttributeCode": "IN (\"S\")" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Deposit Activity Summary Report", "reportFileName": "Deposit ACtivity Summary Report....", "reportHeader": EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "reportName": "Deposit Activity Summary Report", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2024-07-24 02:00:00", "reportingPeriodEndTimestamp": "2024-07-25 01:59:59" } } ``` ### PI The following request code block shows how to configure a deposit activity summary report for `entityType` = PI. ```json { "entityType": "PI", "entityIds": [ "6019581085" ], "reportSections": [ { "sectionTitle": "Conveyed Deposit Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Conveyed Deposit Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Platform Identifier" }, { "reportAttributeName": "Platform Name" }, { "reportAttributeName": "Payment Method Code" }, { "alias": "Conveyed Sales Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Sales\")" } ] }, { "alias": "Conveyed Sales Amount", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Sales\")" } ] }, { "alias": "Conveyed Refund Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Refunds\")" } ] }, { "alias": "Conveyed Refund Amount", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Conveyed Refunds\")" } ] } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Payment Method Code", "sortOrderCode": "desc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Settled Deposit Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Settled Deposit Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Payment Method Code" }, { "alias": "Settled Sales Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN(\"Settled Sales\")" } ] }, { "alias": "Settled Sales Amount in Presentment Currency", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"SALE\")" } ] }, { "alias": "Settled Sales Amount in Settlement Currency", "reportAttributeName": "Settlement Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"SALE\")" } ] }, { "alias": "Settled Refund Count", "reportAttributeName": "Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] }, { "alias": "Settled Refund Amount in Presentment Currency", "reportAttributeName": "Presentment Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] }, { "alias": "Settled Refund Amount in Settlement Currency", "reportAttributeName": "Settlement Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN(\"S\")" }, { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN(\"REF\")" } ] } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Payment Method Code", "sortOrderCode": "desc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Fees & Adjustments Summary", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Fees & Adjustments Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Settlement Amount", "alias": "Net Settled Deposits Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Code", "aggregateConditionText": "IN (\"SALE\",\"REF\")" }, { "aggregateConditionAttributeName": "Settled Conveyed Code", "aggregateConditionText": "IN (\"S\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Interchange & Assessment Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Interchange & Assessment Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Processing Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Chargeback Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Chargeback Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Other Fees & Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Interchange & Assessment Fees\",\"Chargeback Adjustments\",\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Net Financial Activity", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ] }, { "reportAttributeName": "Foreign Exchange Rate" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Charge Category Text", "filterAttributeCode": "Not IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Deposit Transfer Summary", "sectionReportTypeName": "Settlement Summary", "sectionReportTypeId": "3005", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Deposit Transfer Summary" }, { "reportAttributeName": "Activity Date" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Funds Transfer Category Description" }, { "reportAttributeName": "Fund Transfer Instruction Number" }, { "reportAttributeName": "Fund Transfer Identifier" }, { "reportAttributeName": "Merchant Activity Date Range" }, { "reportAttributeName": "Fund Transfer Effective Date" }, { "alias": "Fund Transfer Amount", "reportAttributeName": "Funds Transfer Category Amount", "aggregateOperationText": "sum" } ], "sectionSortOrderList": [ { "reportAttributeName": "Activity Date", "sortOrderCode": "asc" }, { "reportAttributeName": "Funds Transfer Category Description", "sortOrderCode": "asc" }, { "reportAttributeName": "Fund Transfer Effective Date", "sortOrderCode": "asc" }, { "reportAttributeName": "Fund Transfer Identifier", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Category Code", "filterAttributeCode": "NOT IN (\"OTHER\")" }, { "reportAttributeName": "Funds Transfer Category Amount", "filterAttributeCode": "!=0.0" }, { "reportAttributeName": "Settled Conveyed Code", "filterAttributeCode": "IN (\"S\")" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Deposit Activity Summary Report", "reportFileName": "Deposit ACtivity Summary Report....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "reportName": "Deposit Activity Summary Report", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2025-09-17 02:00:00", "reportingPeriodEndTimestamp": "2025-09-23 01:59:59" } } ``` ## Download sample report Download the sample [Deposit activity summary report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Deposit%20Activity%20Summary%20Preset%20Report.csv). ## Related [Scheduled and adhoc report configurations](/docs/commerce/optimization-protection/capabilities/reporting/report-configurations/scheduled-adhoc)