--- title: Daily settlement fees breakdown slug: ops-and-admin/reports/card-payments/daily-settlement-fees-breakdown description: The settlement fees breakdown report maps each network settlement fee drawn from your COS settlement account to the card transactions that make up its total, securely delivered via SFTP to your assigned folder. createdAt: 2026-10-26T13:31:21.396Z --- ## Report description The settlement fees breakdown report helps you reconcile the network settlement fees drawn down from your COS settlement account against the original card transactions. For each fee, the report lists every transaction that contributed to it, and how much each transaction contributed. The report covers all the settlement-related fee types charged through COS. Each row combines two kinds of data: - Fee information from COS (columns A to N): as seen in the [Daily account activity](docId\:jISaStzNJA3nRpW6VFbRw) reports. - Transaction information (columns O to AD): as seen in the [Daily settlement (detailed)](docId\:ID2xJOHUQ_SaDaUgT9Xhv) reports. You receive this report using the Secure File Transfer Protocol (SFTP), which lets you receive and send information securely. To get access, see [Set up SFTP](docId\:vS2CkU9_W5BQQlbjsBq25). This report is generated automatically, and pushed to your assigned subfolder on the secure server, where you access it. :::hint{type="warning"} **IMPORTANT** SFTP must be set up *before* you create a request with Cross River’s support team to configure this settlement fees breakdown report. This allows the reporting team to automate the delivery of Settlement and Reconciliation reports to the appropriate folders. ::: Contact [ptpe.support@crossriver.com](mailto\:ptpe.support@crossriver.com) if you have any issues accessing your reports. ## Report distribution Recipients include Card Payments partners only. ## Delivery schedule | Item | Details | | ------------- | ---------------------------------------------------------- | | Delivered | Tuesday to Saturday | | Not delivered | Sunday, Monday and banking holidays | | Content | Fees posted to your settlement account on the previous day | | Tuesday file | Fees posted on Saturday, Sunday and Monday | Because each file covers the previous day, the fees you see in your account activity for a given date are in the next day's report. For example, fees posted on July 8 are in the report dated July 9. ## Report structure The settlement fees breakdown report filename uses this convention: **PartnerName\_CRB\_Settlement\_FeesBreakdown\_YYYY-MM-DD** The report has one row for each transaction that contributed to a fee. A fee made up of 1,000 transactions takes up 1,000 rows. The fee columns (A to N) repeat on every row of that fee. The sum of `SettlementPortion` (column O) for all the rows of a fee equals that fee's `Amount` (column N). The settlement fees breakdown report structure includes the fields presented here. | Column | Field | Description | | ------ | ----------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------ | | A | Id | Unique ID of the settlement account entry in COS. All the rows that belong to the same fee have the same `Id`. | | B | TransactionId | ID of the COS transaction that posted the entry | | C | TraceNumber | COS trace number of the transaction | | D | Status | Status of the COS transaction. Always `Posted`. | | E | TransactionType | Direction of the entry on your settlement account: `Debit` or `Credit` | | F | ActivityType | Activity type of the COS transaction, for example `External` | | G | Source | Source of the COS entry, for example `Transaction` | | H | MasterAccountNumber | COS master account the entry was posted to | | I | SubAccountNumber | COS subaccount (sub ledger) the entry was posted to | | J | TransactionCode | Transaction code shown in the Code column of your account activity, for example `XPAY Credit` | | K | Description | Fee description, exactly as it appears in your account activity, in the format PARTNER\_NAME \{fee name} YYYY-MM-DD. See Fee types, below. | | L | Rail | Rail that posted the entry: `X Pay` or `Internal` | | M | RailId | ID of the payment on the rail, in the format `payment/{id}`. `0` when `Rail` is `Internal`. | | N | Amount | Total amount of the fee, as shown in your account activity. Always positive; use `TransactionType` for the direction. | | O | SettlementPortion | This transaction's exact portion of the fee in column N | | P | TransactionAmount | Amount of the original card transaction | | Q | TransactionDescription | Network fee category of this row, for example `Visa Interchange Fee`. See Fee types, below. | | R | SettlementDate | Network settlement date of the transaction. If the column shows a number in Excel, format it as a date. | | S | CurrencyCodeTransactionAmount | Currency of `TransactionAmount`, for example `USD` | | T | CardNumberFirst6 | First 6 digits of the card number (BIN) | | U | CardNumberLast4 | Last 4 digits of the card number | | V | CardAcceptorId | Card acceptor (merchant) ID. Can be empty. | | W | CardAcceptorName | Card acceptor name and location | | X | CardAcceptorTerminalId | Card acceptor terminal ID | | Y | ProcessingCode | Transaction processing code: `C` or `D`. Can be empty. | | Z | ResponseCode | Network response code of the transaction, for example `00` (approved) | | AA | RetrievalReferenceCode | Retrieval reference number (RRN) of the transaction | | AB | TransactionIdentifier | PTPE transaction identifier. Use it to find the transaction in PTPE. | | AC | InterchangeCategoryDescriptor | Interchange category of the transaction, for example `US REG`. Can be empty. | | AD | StraceNumber | System trace audit number (STAN) of the transaction | A single card transaction can appear in more than one fee. For example, the same transaction can have rows for its transaction amount, its interchange fee and its reimbursement fee. ## Fee types This table shows the values of the `Description` (column K) and `TransactionDescription` (column Q) fields. In your report, PARTNER\_NAME is replaced with your partner name, and YYYY-MM-DD with the posting date. | Description | TransactionDescription | Network data source | Definition | | ----------------------------------------------- | ----------------------------------- | ------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | | PARTNER\_NAME Visa YYYY-MM-DD | Visa AFT Transaction Amount | Visa | The total amount of Visa AFT (pull) transactions used to fund accounts or wallets | | PARTNER\_NAME Visa CR YYYY-MM-DD | Visa Direct Transaction Amount | Visa | The total amount of settled Visa Direct transactions | | PARTNER\_NAME Visa CR Fee YYYY-MM-DD | Visa Reimbursement Fee | Visa | Reimbursement fees assessed by Visa on Visa Direct transactions | | PARTNER\_NAME Visa Intrchg Fees YYYY-MM-DD | Visa Interchange Fee | Visa | The fee paid to the card-issuing bank on each Visa transaction, set by Visa | | PARTNER\_NAME Visa Charge YYYY-MM-DD | Visa Transaction Integrity Fee | Visa | Transaction integrity fees assessed by Visa | | PARTNER\_NAME Visa Reversal RRN YYYY-MM-DD | Visa Reversal RRN | Visa | The amount of reversed Visa transactions, debited or credited back | | PARTNER\_NAME Visa Reversal Fees RRN YYYY-MM-DD | Visa Reversal Fees RRN | Visa | Fees assessed by Visa for processing transaction reversals | | PARTNER\_NAME Mastercard CR YYYY-MM-DD | Mastercard Transaction Amount | Mastercard | The total amount of settled Mastercard transactions | | PARTNER\_NAME Mastercard CR Fee YYYY-MM-DD | Mastercard Estimated Interchange | Mastercard | The fee paid to the card-issuing bank on each Mastercard transaction, set by Mastercard | | PARTNER\_NAME MC Mastercard YYYY-MM-DD | Mastercard Payment Amount | Mastercard | The net payment amount settled by Mastercard to or from you, after netting transactions and fees | | PARTNER\_NAME MC DISPUTE YYYY-MM-DD | Mastercard Chargebacks | Mastercard | The amount of disputed Mastercard transactions reversed through the chargeback process. This can be a debit or a credit, depending on the dispute outcome. | | PARTNER\_NAME MC DISPUTE FEE YYYY-MM-DD | Mastercard Chargeback Fees | Mastercard | Administrative fees assessed by Mastercard for handling and processing chargeback disputes | | PARTNER\_NAME MC Fee Collection YYYY-MM-DD | Mastercard Additional Fees | Manual IPR-OPS | Miscellaneous Mastercard network fees not captured in other categories, such as assessment or access fees | | PARTNER\_NAME MC Fee Collection WO YYYY-MM-DD | Mastercard Additional Fees | Manual IPR-OPS | Miscellaneous Mastercard network fees not captured in other categories, such as assessment or access fees | | PARTNER\_NAME MC NYCE YYYY-MM-DD | Mastercard NYCE Transaction Amount | Mastercard | The total amount of transactions routed through the NYCE debit network | | PARTNER\_NAME MC Pulse YYYY-MM-DD | Mastercard Pulse Transaction Amount | Mastercard | The total amount of transactions routed through the Pulse debit network | ## Reconciling a fee with its transactions To find the transactions behind a fee drawn from your settlement account: 1. In your COS account activity, find the fee entry, and note its date, description and amount. 2. Open the settlement fees breakdown report dated the next day. For fees posted on a Saturday, Sunday or Monday, open the Tuesday report. 3. Apply a filter to the report, and filter the `Description` field (column K) for the fee description, for example PARTNER\_NAME Visa CR Fee 2026-07-08. 4. Check the `Amount` field (column N). It shows the total amount of the fee, which matches your account activity. 5. Check the `SettlementPortion` field (column O). It shows how much each transaction contributed to the fee. The sum of column O equals column N. 6. Use the `TransactionIdentifier` field (column AB) to find each transaction in PTPE. You can also match transactions by `RetrievalReferenceCode` (column AA) and the card digits (columns T and U). ## Related topics - [Daily settlement (detailed)](docId\:ID2xJOHUQ_SaDaUgT9Xhv) - [Daily settlement (summary)](docId\:gX6X18R6oXhV8ckidsmLM) - [Daily exceptions](docId\:IiJ8_BmT0qfpmP_dJjAHm) - [Daily chargeback report](docId\:GjHgMGK1dOOQdccLsZg-o) - [Daily account activity](docId\:jISaStzNJA3nRpW6VFbRw) - [Set up SFTP](docId\:vS2CkU9_W5BQQlbjsBq25)