Financial activity summary report
This report provides a summary of conveyed and settled transactions, financially impacting chargebacks or disputes, interchange and assessment fees, processing fees, and other adjustments related to effective or pending fund transfers. Funding occurs at Funds Transfer Instruction (FTI) level, and once the funding is in effective or pending funds transfer status, you can view all the associated payments activity part of that funds transfer.
Use Cases
- Analyze total fees and disputes daily to identify any spikes that may need further investigation.
- View overall processing volume and funds transfers.
Observations
- Funding occurs at a Funds Transfer Instruction (FTI) level. When setting up the preset report:
- If you select CO level it will combine all FTI transfer activity and may not match your individual bank statements.
- If you have multiple FTI’s with different payments activity and bank accounts, we recommend you set the Financial Activity Summary Report at an FTI level using the entity picker.
- If you are setting up this report at a daily, weekly, or monthly level, we recommend giving this report a unique name with the FTI for better tracking in your Reports Download section in Commerce Center.
- For Gross Funded merchants, Fees and associated Fund transfer amounts will appear monthly on Last Calendar Day/Last Fiscal Calendar Day or on a particular day of the month based on the FTI setup.
Granularity
Presentment Currency Code, Settlement Currency Code, and Reporting Date.
Fields
The following table shows the field details.
Field name |
Definition |
|---|---|
Presentment Currency Code |
The three-character abbreviation for the currency in which the cardholder transaction occurred. |
Settlement Currency Code |
The three-character abbreviation for the currency in which the merchant is being funded. |
Reporting Date |
Date the transactions/events took place. |
Net Conveyed Deposits |
Sales less refunds for conveyed MOPS (Amex, for example). Conveyed transactions are those that we process but do not take on any risk with regard to chargebacks or fraud – we simply process the payments. This amount is provided in Presentment Currency. |
Net Settled Deposits |
Sales, less refunds, for standard/settled MOPs(Visa, Mastercard, etc). This amount is provided in Presentment Currency. |
Foreign Exchange Rate |
The foreign exchange rate at which J.P. Morgan qualified the transaction for cross currency transactions. |
Net Settled Deposits in Settlement Currency |
Total Amount of Sales less refunds for Settled MOPs for the activity date in the Reporting Date Column. |
Chargeback/ECP Return/Debit Adjustments |
Net amount of PDE activity (chargebacks, representments, returns, redeposits, etc.) received for the activity date in the Date Column. |
Interchange and Assessment Fees |
Fees charged by the card brands and issuers on the transactions. |
Processing Fees |
Acquiring or Processor fees charged by J.P. Morgan. |
Other Adjustments |
Sum of any other adjustments. |
Backup With Holding Adjustments |
Any amount less than or greater than the amount owed to the IRS by the merchant. |
Reserve Adjustments |
If we are holding a reserve in place to cover any chargebacks. You will have been notified on account setup if this applies to you. |
Net Financial Activity |
Total net financial activity for the record (Sale/Refund- all charges & adjustments). |
Rejected Transfers |
Total amount of rejected transfers on the activity date. |
Pending Transfers |
Total amount of funds transfer that is in a “to be sent” status as the effective transfer date has not been yet reached. |
Effective Transfer |
Total amount that will be sent to the client’s bank account on the activity date. |
Daily Ending Balance |
The total sum of financial events that are included in the merchant’s running balance that have not been included in a pending funds transfer at the end of the day based on the Activity Date. |
Reserve Balance |
Specifies the monetary value of the cash portion of a reserve for a merchant acquiring account at the Company level. The total collateral held on a client is the sum of the Cash Reserve Amounts and the Collateral Reserve Amounts. The reserve amount is held to mitigate risk due to the Firm's liability of potential losses related to the merchant acquiring account. |
Sample report configuration
The following request code block shows how to configure a financial activity summary report for entityType = CO/BU/TD.
Json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Settlement Summary",
"sectionReportTypeId": "3005",
"sectionSelectedFields": [
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Activity EDT Date",
"alias": "Reporting Date"
},
{
"reportAttributeName": "Category Amount",
"alias": "Net Conveyed Deposits",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "IN(\"SALE\",\"REF\")"
},
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"C\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Category Amount",
"alias": "Net Settled Deposits",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "IN(\"SALE\",\"REF\")"
},
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"alias": "Foreign Exchange Rate",
"reportAttributeName": "Foreign Exchange Rate",
"aggregateOperationText": "max",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Net Settled Deposits in Settlement Currency",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "IN(\"SALE\",\"REF\")"
},
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Chargeback/ECPReturns/Debit Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "IN(\"CB\",\"ERET\",\"DBADJ\")"
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Interchange & Assessment Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"IA\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Processing Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"PFEE\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Other Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"OTH\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Backup With Holding Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"BUW\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Reserve Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"RES\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Net Financial Activity",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Rejected Transfers",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Funds Transfer Category Code",
"aggregateConditionText": "= \"REJFT\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Pending Transfers",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Funds Transfer Category Code",
"aggregateConditionText": "= \"PENDFT\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Effective Transfers",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Funds Transfer Category Code",
"aggregateConditionText": "= \"EFEFT\""
}
]
},
{
"reportAttributeName": "Daily Ending Balance"
},
{
"reportAttributeName": "Reserve Balance"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Activity EDT Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Category Code",
"filterAttributeCode": "NOT IN (\"OTHER\")"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Financial Activity Summary Report",
"reportFileName": "Financial 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": "Financial Activity Summary Report",
"csvColumnNameDisplayIndicator": true,
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2023-02-03 04:00:00",
"reportingPeriodEndTimestamp": "2023-02-05 03:59:59"
}
}The following request code block shows how to configure a financial activity summary report for entityType = PE.
Json
{
"entityType": "PE",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Settlement Summary",
"sectionReportTypeId": "3005",
"sectionSelectedFields": [
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Activity EDT Date",
"alias": "Reporting Date"
},
{
"reportAttributeName": "Category Amount",
"alias": "Net Conveyed Deposits",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "IN(\"SALE\",\"REF\")"
},
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"C\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Category Amount",
"alias": "Net Settled Deposits",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "IN(\"SALE\",\"REF\")"
},
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"alias": "Foreign Exchange Rate",
"reportAttributeName": "Foreign Exchange Rate",
"aggregateOperationText": "max",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Net Settled Deposits in Settlement Currency",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "IN(\"SALE\",\"REF\")"
},
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Chargeback/ECPReturns/Debit Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "IN(\"CB\",\"ERET\",\"DBADJ\")"
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Interchange & Assessment Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"IA\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Processing Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"PFEE\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Other Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"OTH\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Backup With Holding Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"BUW\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Reserve Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Category Code",
"aggregateConditionText": "=\"RES\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Net Financial Activity",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Current Merchant Activity Indicator",
"aggregateConditionText": "=\"TRUE\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Rejected Transfers",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Funds Transfer Category Code",
"aggregateConditionText": "= \"REJFT\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Pending Transfers",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Funds Transfer Category Code",
"aggregateConditionText": "= \"PENDFT\""
}
]
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"alias": "Effective Transfers",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "=\"S\""
},
{
"aggregateConditionAttributeName": "Funds Transfer Category Code",
"aggregateConditionText": "= \"EFEFT\""
}
]
},
{
"reportAttributeName": "Daily Ending Balance"
},
{
"reportAttributeName": "Reserve Balance"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Activity EDT Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Category Code",
"filterAttributeCode": "NOT IN (\"OTHER\")"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Financial Activity Summary Report",
"reportFileName": "Financial 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": "Financial Activity Summary Report",
"csvColumnNameDisplayIndicator": true,
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2023-02-03 04:00:00",
"reportingPeriodEndTimestamp": "2023-02-05 03:59:59"
}
}