Optimization Protection

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.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
    "reportHeader": "EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
    "fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "reportName": "Deposit 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.