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.
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.
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. |
Settled deposit summary
Fields
The following table shows the 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. |
Fees and adjustments summary
Fields
The following table shows the 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. |
Deposit transfer summary
Fields
The following table shows the 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. |
Sample report configuration
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.<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": "2024-07-24 02:00:00",
"reportingPeriodEndTimestamp": "2024-07-25 01:59:59"
}
}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.<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": "2024-07-24 02:00:00",
"reportingPeriodEndTimestamp": "2024-07-25 01:59:59"
}
}