# 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 Separated 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 impact 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 ## Fields ### Conveyed deposit summary The following table shows the conveyed deposit summary field details. Fields labeled **(O) **are optional and can be added to the preset report as needed. **Conveyed deposit summary field details** | Field name | Definition | | --- | --- | | Record Type | The section of the report. For this summary section, record type value is Conveyed Deposit Summary. | | 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 | The code that identifies the (MOP) method of payment for the transaction. | | Conveyed Sales Count | The total number of conveyed sales. | | Conveyed Sales Amount | The total conveyed sales amount in presentment currency. | | Conveyed Refund Count | The total number of conveyed refunds. | | Conveyed Refund Amount | The total conveyed refund amount in presentment currency. | | 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 | | 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. | | Foreign Exchange Rate (O) | The foreign exchange rate for the currency pair to be applied for cross-currency transactions. | | 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. | | Company External Identifier (O) | The identifier of the external company. | | Company Name (O) | The name associated with the Commerce platform assigned CO number. | | Batch Date (O) | The date when the Point Of Sale (POS) device is closed and the transactions are sent for processing. | | Batch Identifier (O) | The identifier of a group of sale and refund transactions processed through the Point Of Sale (POS) terminal or similar device | | Terminal Identifier (O) | The number identifying the Point Of Sale (POS) terminal or similar device through which the transaction was processed. | ### Settled deposit summary The following table shows the settled deposit summary field details. Fields labeled **(O) **are optional and can be added to the preset report as needed. **Settled deposit summary field details** | Field name | Definition | | --- | --- | | Record Type | The section of the report. For this summary section, record type value is Settled Deposit Summary. | | 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 | The code that identifies the (MOP) method of payment for the transaction. | | Settled Sales Count | The total number of settled sales. | | Settled Sales Amount in Presentment Currency | The total settled sales amount in presentment currency. | | Settled Sales Amount in Settlement Currency | The total settled sales amount in settlement currency. | | Settled Refund Count | The total number of settled refund included in this data record. | | Settled Refund Amount in Presentment Currency | The total settled refund amount in presentment currency. | | Settled Refund Amount in Settlement Currency | The total settled refund amount in settlement currency. | | 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 | | 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. | | Foreign Exchange Rate (O) | The foreign exchange rate for the currency pair to be applied for cross-currency transactions. | | 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. | | Company External Identifier (O) | The identifier of the external company. | | Company Name (O) | The name associated with the Commerce platform assigned CO number. | | Batch Date (O) | The date when the Point Of Sale (POS) device is closed and the transactions are sent for processing. | | Batch Identifier (O) | The identifier of a group of sale and refund transactions processed through the Point Of Sale (POS) terminal or similar device | | Terminal Identifier (O) | The identifier of the Point Of Sale (POS) terminal or similar device through which the transaction was processed. | ### Fees and adjustments summary The following table shows the fee and adjustment summary field details. Fields labeled **(O) **are optional and can be added to the preset report as needed. **Fee and adjustment summary field details** | Field name | Definition | | --- | --- | | Record Type | The section of the report. For this summary section, record type value is Fee & Adjustment Summary. | | 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 | The net total of settled sales and settled refunds in settlement currency. | | Interchange & Assessment Fees | The total interchange and assessment fees in settlement currency. | | Processing Fees | The total processing fees in settlement currency. | | Chargeback Adjustments | The 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 | The 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 | The associated CO, BU, TD, or PE identification number. | | Entity Type Code | The level at which reported event occurred. Valid values are: - BU - Business Unit - CO - Company - TD - Transaction Division - PE - Processing Entity | | 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. | | 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. | | Company External Identifier (O) | The identifier of the external company. | | Company Name (O) | The name associated with the Commerce platform assigned CO number. | | ECP Return Adjustments (O) | The sum of adjustments affecting the merchant’s running balance related to ECP Return activity. | ### Deposit transfer summary The following table shows the deposit transfer summary field details. **Deposit transfer summary field details** | Field name | Definition | | --- | --- | | Record Type | The section of the report. For this summary section, record type value is Deposit Transfer Summary. | | Activity Date | The 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 | The textual description associated with funds transfer category code. | | Fund Transfer Instruction Number | The funds transfer instruction number associated with the reported activity. | | Fund Transfer Identifier | The unique identifier assigned by Chase for each fund transfer activity. | | Merchant Activity Date Range | The J.P. Morgan activity date range for this data record. | | Fund Transfer Effective Date | The date on which the funds transfer is scheduled to be credited to the merchant's bank account. | | Funds Transfer Amount | The total of funds transfer amount for settled deposits in settlement currency. | | Entity Identifier | The associated CO, BU, TD, or PE identification number. | | Entity Type Code | The level at which reported event occurred. Valid values are: - BU - Business Unit - CO - Company - TD - Transaction Division - PE - Processing Entity | | Entity Name | The name associated with the Commerce platform assigned entity identifier. | | Transaction Division External Identifier | The identifier of the external transaction division. | | Transaction Processing Entity Identifier | The identifier of the transaction processing entity. | | Secure Bank Account Number | The Commerce platform-assigned secure bank account number. | | Business Unit Identifier | The identifier of the business unit associated with the record. | | Business Unit Name | The name associated with the Commerce platform assigned business unit number. | | Company External Identifier | The identifier of the external company. | | Company Name | The name associated with the Commerce platform assigned CO number. | ## Sample report configurations The following samples help you get an idea of how to configure deposit activity summary report. ### CO/BU/TD/PE The following request code block shows how to configure a deposit activity summary report for `entityType` = CO/BU/TD/PE. ```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": "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 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 - [English sample report](/system/downloads/commerce/reporting/Deposit_Activity_Summary_Preset_Report.csv?type=stream) - [French sample report](/system/downloads/commerce/reporting/Resume_des_activites_de_depot.csv?type=stream) ## Related [Scheduled and ad hoc report configurations](/docs/commerce/optimization-protection/capabilities/reporting/report-configurations/scheduled-adhoc)