# MAT Report
source: https://developer.mastercard.com/mastercard-send/documentation/reports/mat/index.md
This page describes the contents and specifications of the Mastercard Send version 7.x Mismatched and Adjustment Transaction (MAT) reports.
For an overview of Mastercard send reporting, see [here](https://developer.mastercard.com/mastercard-send/documentation/reports/index.md).
## Overview {#overview}
The MAT report contains details of transactions that are settled in a different way (and for a different amount) than what was processed and reported by the Mastercard Send APIs.
This report is only generated when exceptions occur and only on local settlement (banking) days determined by the Mastercard Settlement Account Management (SAM) system, which exclude currency holidays and local banking holidays. For example, exceptions occurring over the weekend will appear on the MAT report generated on Monday, or whenever the next local banking day occurs.
The Reconciliation and MAT reports can be used to reconcile settlement positions. The Reconciliation Report contains transaction data as it was processed by the Mastercard Send APIs. When differences appear between what is provided in the Reconciliation Report and what was actually settled, details for those differences are provided in the MAT report.
### General layout {#general-layout}
The [Daily Transaction, Reconciliation](https://developer.mastercard.com/mastercard-send/documentation/reports/dtr-recon/index.md), and MAT reports have the same general layout, which includes:
* [File Header](https://developer.mastercard.com/mastercard-send/documentation/reports/mat/index.md#file-header): 100 record of column names and 101 record of values
* For each OI/TI (Reseller/Sponsor OI reports might contain data for multiple OIs/ TIs):
* [ICA Batch Header](https://developer.mastercard.com/mastercard-send/documentation/reports/mat/index.md#ica-batch-header-and-records-fps-report-only) (FPS report only): 110 record of column names and 111 record of values
* [Batch Header and Records](https://developer.mastercard.com/mastercard-send/documentation/reports/mat/index.md#batch-header-and-records): 200 record of column names and 201 records for each transaction
* [Batch Trailer](https://developer.mastercard.com/mastercard-send/documentation/reports/mat/index.md#batch-trailer): 300 record of column names and 301 record of values
* [File Trailer](https://developer.mastercard.com/mastercard-send/documentation/reports/mat/index.md#file-trailer): 900 record of column names and 901 record of values
All reports are provided in a comma-separated values (CSV) file. Fields are separated by embedded commas and double quotes to allow for special characters. Any decimals provided in transaction amounts are explicitly displayed. The reports are sent in bulk files, which are in variable block format (record maximum length 27994, block size 27998) during file transfer.
Note: The tables in the [Report Specifications](https://developer.mastercard.com/mastercard-send/documentation/reports/mat/index.md#report-specifications) section below identify the report fields that support special characters. However, be aware that other fields might be updated to include special characters.
When opening report CSV files in spreadsheet applications, such as Microsoft Excel, be aware that some applications attempt to convert the imported data and might incorrectly alter or truncate the data. For example, date formats might be altered, and long numbers exceeding 15 digits (such as PANs and numeric Reference IDs) might have subsequent digits converted to zeros: '72715118484282248412' becomes '72715118484282200000'.
### Example {#example}
For report samples, see [here](https://developer.mastercard.com/mastercard-send/documentation/reports/report-samples/index.md).
## Report specifications {#report-specifications}
The following tables describe the contents of the Mastercard Send version 7.x MAT reports. We recommend you also refer to the [Mastercard Send Release Notes](https://developer.mastercard.com/mastercard-send/documentation/send-release-notes/index.md) to see details of any recent changes and proposed future changes.
To support future items, the report has placeholder columns, which are identified by "Reserved for future use" in the tables below. No new columns will be added to the reports until these fields are exhausted. Updates to these fields, such as column name, data type and length, are considered backward compatible and will be added without changing the report version. Applications consuming these resources should be written such that new fields appearing in reporting will not cause errors.
Mastercard Send provides the reports in one of the following versions:
* **Standard reports---apply to most implementations:** Version 7 or 7.1, which contain the same columns but differ in what is shown for the account number: last 4 digits (version 7) or full number (version 7.1).
* **FPS reports---apply to FPS participants and non-card account implementations:** Version 7.4.
The tables identify the columns that are present in a particular report version. For each column, a field will be blank if it is not relevant to that transaction record or to that report, or when the value was not present in the API request or resulting network messages.
### File header {#file-header}
| Column Name | Description | Format |
|---------------------|---------------------------------------------------------------------------------------------------|-------------------------------------------------------------|
| Report Name | The report name: 'Mismatched and Adjustment Report'. | Alphanumeric, max length 40 |
| Parent Partner Name | The name of the participant for which the report has been generated. | Alphanumeric special, length 100 |
| Partner Id | The Partner Reference ID of the participant for which the report has been generated. | Alphanumeric special, max length 40 |
| Generated Date | The date and time the report was generated, in 24-hour time, for example, '04/18/2023 18:17 CDT'. | MM/DD/YYYY HH:MM TTT (TTT denotes the time zone alpha code) |
### ICA batch header and records (FPS report only) {#ica-batch-header-and-records-fps-report-only}
| Column Name | Description | Format |
|-------------------|---------------------------------------------------|--------------------------------------|
| Partner ID | The Partner Reference ID of the partner OI/TI. | Alphanumeric special, max length 40 |
| Partner Name | The name of the partner OI/TI. | Alphanumeric special, max length 100 |
| ICA | The Acquiring ICA associated with the Sponsor OI. | Numeric, max length 11 |
| Sponsor Bank Name | The name of the Sponsor OI. | Alphanumeric special, max length 100 |
### Batch header and records {#batch-header-and-records}
| Column Name | Description | Format |
|----------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------|
| Partner Id | The Partner Reference ID of the OI/TI. | Alphanumeric special, max length 40 |
| Partner Name | The name of the OI/TI. | Alphanumeric special, max length 100 |
| Reference ID | The unique transaction reference ID provided by the OI/TI, which is carried through from the following transaction API request fields: * Disbursement = `disbursement_reference` * Payment Transfer = `transfer_reference` * Funding = `transfer_reference` This ID can be used by partners to link report transactions to their back office. | Alphanumeric special, length 6-40 |
| Transaction Type | The type of transaction. Valid values include: * FUNDING * PAYMENT * FUNDING_REVERSAL * PAYMENT_REVERSAL * FUNDING_REFUND * FUNDING_REPRESENTMENT * PAYMENT_REPRESENTMENT * FUNDING_CHARGEBACK * PAYMENT_CHARGEBACK * FUNDING_CHARGEBACK_REVERSAL * PAYMENT_CHARGEBACK_REVERSAL For descriptions, see [Transaction Type](https://developer.mastercard.com/mastercard-send/documentation/reports/transaction-type-status/index.md#transaction-type). | Alpha special, max length 50 |
| Payment Type | The payment flow associated to the transaction, for example, 'P2P' (General Person-to-Person Transfer). For a list of 3-character codes, see the `payment_type` field description in the API Reference documentation on Mastercard Developers or the *Use Cases and Payment Types* section of the *Mastercard Send Implementation and Operations Guide for API Connections*. Valid payment types are configured for each Partner Reference ID. | Alphanumeric, length 3 |
| Date Time Created | The date and time the transaction was originated in the API, in CST. | MM/DD/YYYY HH:MM:SS |
| Date Time Processed | The date and time the transaction was processed, in CST. | MM/DD/YYYY HH:MM:SS |
| Source | The source of the settlement funds. Valid values include: * Settlement * STAR * NYCE * Pulse * Maestro\* * MoneySend * MoneySend DM * MasterCard\*\* * VISA AFT * VISA * VISA Returns * FPS Outbound\*\*\* * FPS Inbound\*\*\*
\* Maestro is just a label for transactions submitted as return transactions (TC20) using the Mastercard Single Message Network. \*\* Mastercard transactions are submitted as return transactions (TC20) using either the Mastercard Dual Network (Global) or Mastercard Dual Messages related to Faster Payments to Accounts Network (FPS). \*\*\* FPS Outbound and FPS Inbound networks are related to Faster Payments to Accounts. **NOTE:** Source and Destination fields are used in conjunction. When the Source field = Settlement, the flow of funds is a debit to partner (funds pulled from the Settlement Account and sent to the relevant Receive Network). This is the normal flow for Payment Transactions and funding reversals. When the Source field = a network, the flow of funds is a credit to partner (funds are moved from the relevant network to the Settlement Account). This is the normal flow for exception item payment reversals and Funding Transactions. | Alpha, max length 20 |
| Destination | The relevant Receive Network, which is the destination network of settlement funds. If the value is 'Settlement', the transaction funds are a credit to the participant. Valid values include: * Settlement * STAR * NYCE * Pulse * Maestro\* * MoneySend * MoneySend DM * MasterCard\*\* * VISA AFT * VISA * FPS Outbound\*\*\* * FPS Inbound\*\*\*
\* Maestro is just a label for transactions submitted as return transactions (TC20) using the Mastercard Single Message Network. \*\* Mastercard transactions are submitted as return transactions (TC20) using either the Mastercard Dual Network (Global) or Mastercard Dual Messages related to Faster Payments to Accounts Network (FPS). \*\*\* FPS Outbound and FPS Inbound networks are related to Faster Payments to Accounts. **NOTE:** Source and Destination fields are used in conjunction. See the note for the Source field. | Alpha, max length 20 |
| Settled By | The settlement entity for the transaction. Valid values: * Mastercard * Visa * STAR * NYCE * Pulse * FPS | Alpha, max length 20 |
| Transaction Amount | The amount transferred. Decimals are explicit. | Numeric, 3‑999999999999 |
| Transaction Currency | The currency code of the transaction amount. | Alpha, length 3 |
| Error | Whether the transaction succeeded: 0 = Success, 1 = Failure. See [Transaction Status](https://developer.mastercard.com/mastercard-send/documentation/reports/transaction-type-status/index.md#transaction-status). | Numeric, length 1 |
| Response Code | A code indicating the reason for error: 00 = Success, 04 = Failure. **NOTE:** If a transaction is in an UNKNOWN status, the Response Code will indicate 04. However, customers must perform an API lookup (GET request) call to confirm final status. The Error and Response Code fields are simplified to ease coding. | Numeric, length 2 |
| Cutoff Date | The Network cutoff date for settlement. | MM/DD/YYYY |
| Amount Settled | The amount settled by the network. | Numeric, 1‑999999999999 |
| Settlement Currency | The settlement currency code of the transaction for the Acquirer or Sponsor OI. **NOTE:** When a transaction settles in a different currency than expected, the amount settled will be different from what was provided in the Reconciliation Report. This field shows the currency for which the transaction qualified in settlement. For example, a network setup error might bypass a domestic settlement service and default to a regional settlement service in a different currency. | Alpha, length 3 |
| Exception Reason | The exception scenario. Valid values and descriptions: * REVERSAL = The transaction has been reversed. * CHARGEBACK = Chargeback was initiated by the Issuer. (Not applicable for Account-based transfers.) * REPRESENTMENT = A financial transaction originated by an Acquirer to partially or wholly recover funds charged back to the Acquirer by an Issuer. (Not Applicable for Account-based transfers.) * NETWORK ERROR = A relevant Receive Network reconciles a transaction differently than how it was processed in Mastercard Send, see Network Error. * CUTOFF TIMING = A relevant Receive Network did not settle on the expected cutoff date. * AMOUNT MISMATCH = Partial approvals are not supported for payments by the relevant Receive Network; however, if a transaction settles in an unexpected currency, this exception reason will appear. * UNKNOWN = A relevant Receive Network has not responded to Mastercard Send or has reconciled a transaction that is not recognized in Mastercard Send. * RETURN = An outbound transaction being returned. Applicable to FPS transfers only. * Chargeback Reversal = Relates to these transaction types: * PAYMENT_CHARGEBACK_REVERSAL = The Receiving Institution of the original Payment Transaction performed a chargeback to the OI and later the Receiving Institution reversed the chargeback. * FUNDING_CHARGEBACK_REVERSAL = the Funding Issuer did a chargeback to the OI and later the Issuer reversed the chargeback. | Alpha |
| Original API Status | The status of the transaction provided on the API: 'SUCCESSFUL', 'FAILED', 'UNKNOWN'. | Alpha, max length 20 |
| Current Status | The status of the transaction when the exception report is generated: 'SUCCESSFUL' or 'FAILED'. | Alpha, max length 20 |
| Payment Origination Country | The country code where the payment originated, if provided in the API request. Otherwise, this field will be blank. | Alpha, max length 3 |
| Institution Country | The country of the Receiving Institution. | Alpha, max length 3 |
| System Trace Audit Number | The System Trace Audit Number (STAN) provided by the relevant Receive Network that processed the transaction. The STAN is unique for each transaction initiated by a message originator on any single UTC date. When Mastercard Send receives no data from the relevant Receive Network or gateway, this field will be blank. Not applicable for FPS transfers. | Numeric, max length 6 |
| Retrieval Reference | The unique reference number that identifies the transaction in the Receive Network. It refers to the original source document of the transaction and is used to assist in locating that source document or a copy thereof. When Mastercard Send receives no data from the relevant Receive Network or gateway, this field will be blank. Not applicable for FPS transfers. | Numeric, max length 24 |
| Funding Source | The source of funds for payments that is provided in the `funding_source` field of the API request. Valid values: * CREDIT * DEBIT * PREPAID * DEPOSIT_ACCOUNT * MOBILE_MONEY_ACCOUNT * CASH Mobile Money Account and Cash are not enabled as valid funding sources for the Mastercard Send Service. | Alpha special, max length 20 |
| Statement Descriptor | A string that might be displayed on the Recipient's bank or card statement. If not provided in the API request, the system will use the value defined in the onboarding process. While most Financial Institutions display this information consistently, some might display it incorrectly or not at all. | Alphanumeric special, max length 22 |
| Interchange Amount | If the network is collecting interchange on this transaction as part of the Settlement Amount, this field will show the interchange amount charged by the network. Example: "0.050". Not applicable for Account-based transfers. | Numeric, up to 999999999999 |
| Network Advice Code | The direct pass-through exception transaction advice code from the Receive Network. | Alphanumeric, max length 7 |
| Network Advice Description | The description of the exception transaction advice code from the Receive Network. | Alphanumeric, max length 100 |
| Card Acceptor ID | Uniquely identifies a TI. If a Receive Network does not support Card Acceptor ID, this field will be blank. Not applicable for FPS transfers. | Alphanumeric special, max length 15 |
| Merchant Category Code | Identifies the type of business of the Recipient. The merchant category code will either match a valid code set by Mastercard rules or the merchant vertical for approved use cases. Not applicable for FPS transfers. | Numeric, max length 4 |
| Processing Code | The value in Data Element 03 of the transaction network message, which describes the effect of the transaction on the account and type of account affected. Not applicable for FPS transfers. | Numeric, max length 6 |
| Switch Serial Number | A unique transaction identification number generated or assigned by Mastercard. Not applicable for FPS transfers. | Alphanumeric, max length 9 |
| Account Number | For records relating to a Funding Transaction, this is the Sender's account (Funding Account) number. For records relating to a Payment Transaction, this is the Receiving Account number. Depending on the report version, this is the last 4 digits of the account number (version 7) or the full account number (version 7.1/7.4). | Version 7: Numeric, length 4 Version 7.1/7.4: Numeric, length 12-19 |
| | **The columns below are only present in standard reports (version 7 and 7.1):** | |
| Sender Address Line 1 | The first line of the Sender's address. | Alphanumeric special, max length 50 |
| Sender Address City | The Sender's city. | Alphanumeric special, max length 25 |
| Sender Address State | The Sender's state or province. | Alpha, max length 3 |
| Sender Address Postal Code | The Sender's postal code. | Alphanumeric special, max length 10 |
| Receiver Address Line 1 | The first line of the Recipient's address. | Alphanumeric special, max length 50 |
| Receiver Address City | The Recipient's city. | Alphanumeric special, max length 25 |
| Receiver Address State | The Recipient's state or province. | Alpha, max length 3 |
| Receiver Address Postal Code | The Recipient's postal code. | Alphanumeric special, max length 10 |
| Card Product Type | The receiving card BIN product type: Debit, Prepaid, or Credit. | Alpha, max length 7 |
| Acquirer Reference Number | Data supplied by Mastercard Send in an Acquirer-originated message that might be required for an Issuer to return a transaction to the Acquirer in a subsequent message. | Numeric, max length 23 |
| Reserved12 | Reserved for future use. | |
| Reserved13 | Reserved for future use. | |
| | **The columns below are only present in FPS reports (version 7.4):** | |
| ICA | The ICA of the Sponsor OI. | Numeric, max length 11 |
| Sponsor Bank Name | The name of the Sponsor OI. | Alphanumeric special, max length 100 |
| Funding PAN | The PAN associated with the token. This field is applicable only for transactions where a token is passed in the request (for Sender's account number). By default, the last 4 digits will be provided. Participants should request configuration if they require the full account number. | Alphanumeric, max length 19 |
| Network Transaction Reference Id | A unique Transaction Reference which will link the Funding and Payment Transaction. Not applicable for FPS transfers. | Alphanumeric, max length 20 |
| Authorization Code | An Authorization Identification Response Code assigned by the Authorizing Institution. Not applicable for FPS transfers. | Alphanumeric, max length 6 |
| Payment UID | The unique ID that was passed to the Faster Payments Network. Applicable only for transactions routed through Faster Payments. | Alphanumeric, max length 36 |
| Faster Payment ID | A unique ID generated by the Faster Payments Network. Applicable only for transactions routed through Faster Payments. | Alphanumeric, max length 42 |
| Destination Sort Code | The sort code for the Recipient account. Applicable only for transactions routed through Faster Payments. | Alphanumeric, max length 6 |
| Destination Account Name | The Recipient's name on the account. Applicable only for transactions routed through Faster Payments. | Alphanumeric special, max length 40 |
| Source Account Number | The Funding Account number. Applicable only for transactions routed through Faster Payments. | Alphanumeric, max length 8 |
| Source Sort Code | The sort code for the Funding Account. Applicable only for transactions routed through Faster Payments. | Alphanumeric, max length 6 |
| Source Account Name | The name on the Funding Account. Applicable only for transactions routed through Faster Payments. | Alphanumeric special, max length 40 |
| Transfer Priority | The type of Payment instruction. Valid values include: * SIP = Single Immediate Payment * FDP = Future Dated Payment Applicable only for transactions routed through Faster Payments. | Alpha, max length 3 |
| Non Card Token | A system identifier that is generated by Mastercard, which is returned as part of the account-mapping response. Populated when an alias is used. Applicable only for transactions routed through Faster Payments. | Alphanumeric, max length 125 |
| Transaction ID | The unique transaction ID provided by the other networks (such as Visa). For the Mastercard Network, this field will always be blank. | Numeric, max length 15 |
| Settlement Amount | The amount of funds to be transferred between the Acquirer and the Issuer equal to the Transaction Amount in the currency of settlement. Decimals are explicit. | Numeric, max length 12 |
| Settlement Currency | The ISO currency code defining the currency of Settlement Amount. | Alpha, length 3 |
| | **The columns below are present in all versions of the report:** | |
| Reserved14 | Reserved for future use. | |
| Reserved15 | Reserved for future use. | |
### Batch trailer {#batch-trailer}
| Column Name | Description | Format |
|----------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------|
| Batch Count | The total number of records in the batch. | Numeric, 1‑999999999999 |
| Batch Checksum | The total batch transaction amount for confirming complete transmission of the batch data. The value should equal the total of the values in the **Transaction Amount** column for the batch. | Numeric, 0‑999999999999 |
### File trailer {#file-trailer}
| Column Name | Description | Format |
|---------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------|
| File Count | The total number of records in the file. | Numeric, 1‑999999999999 |
| File Checksum | The total file transaction amount for confirming complete transmission of the file data. The value should equal the total of the values in the **Transaction Amount** column for all batches. | Numeric, 0‑999999999999 |
The checksum values will have a currency exponent appropriate to the transaction amounts (no scaling). For example, if the amounts are exponent 2 (such as 123.45), the checksum will have an exponent of 2.