# Reconciliation Reports
source: https://developer.mastercard.com/mastercard-send/documentation/reports/index.md
Mastercard Send provides Program Participants with consolidated daily reports of their Mastercard Send transaction activity to assist Participants with settlement and reconciliation.
During onboarding, Mastercard configures either [v7](https://developer.mastercard.com/mastercard-send/documentation/reports/index.md#v7-reconciliation-reports) or [v8](https://developer.mastercard.com/mastercard-send/documentation/reports/index.md#v8-reconciliation-reports) reconciliation reports for a Participant, based on their implementation. At that time, the Participant can specify whether their reports:
* Provide the last 4 digits of transaction account numbers or the full account numbers.
* Include up to four [custom fields](https://developer.mastercard.com/mastercard-send/documentation/reports/index.md#custom-fields-for-reconciliation), which are populated with additional values the Participant supplies in the Funding and Payment Transaction API calls.
**NOTE:**
* Participants using v7 reconciliation reports do not need to move to the v8 reports at this time. The v8 reports support the Mastercard Network, domestic and cross-border activity. They do not currently support other networks.
* Participants using the MTF Simulator will not get reports.
For report samples, see [here](https://developer.mastercard.com/mastercard-send/documentation/reports/report-samples/index.md).
## V7 reconciliation reports {#v7-reconciliation-reports}
Mastercard Send generates separate reports for global activity and U.K. Faster Payments Service (FPS) activity, depending on the participant's implementation. Mastercard Send also provides additional [U.S.-specific reports](https://developer.mastercard.com/mastercard-send/documentation/reports/index.md#us-specific-settlement-reconciliation-reports) to help U.S. Acquirers reconcile interchange fees with U.S. Receive Networks.
The following table summarizes the reports and delivery cutoff times for each. The report names in this table link to detailed descriptions and report specifications.
| Report | Summary | Bulk File IDs | Typical Delivery Time\* (in Central Standard Time, CST) |
|-------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| [Daily Transaction Report (DTR)](https://developer.mastercard.com/mastercard-send/documentation/reports/dtr-recon/index.md) | Provides detailed transaction information for all processed financial transactions, aligning to the network's cutoff for the previous day. | Unencrypted: * MTF = TBV6 * Prod = TBN6 Encrypted: * MTF = TCA4 * Prod = TCA2 India unencrypted: * MTF = T55D * Prod = T55C | **Global reports (all regions):** Daily, 4:00 am (if the U.S. report is not available by 1:00 pm CST, a notification is sent) **FPS report:** Daily, 6:30 am |
| [Reconciliation Report](https://developer.mastercard.com/mastercard-send/documentation/reports/dtr-recon/index.md)\*\* *(Also known as the 'Recon Report')* | Provides detailed transaction information that will be settled by the networks for the previous day's cutoff activity. Helps reconcile all debits from and to the account. | Unencrypted: * MTF = TBV8 * Prod = TBN8 Encrypted: * MTF = TCA8 * Prod = TCA6 India unencrypted: * MTF = T55F * Prod = T55E | **U.S. report:** Daily Mon--Sat = 11:00 am, Sun = Midnight (if the U.S. report is not available by 1:00 pm CST, a notification is sent) **Outside U.S.:** Timing depends on region and networks **FPS report:** Daily, 7:30 am |
| [Mismatched and Adjustment Transaction (MAT) Report](https://developer.mastercard.com/mastercard-send/documentation/reports/mat/index.md)\*\* | Captures reconciliation exceptions and reversals. This report helps to balance debits and credits to the customer's settlement account when exceptions occur. | Unencrypted: * MTF = TIL8 * Prod = TIL6 Encrypted: * MTF = TJA4 * Prod = TJA2 India unencrypted: * MTF = T55H * Prod = T55G | Local settlement (banking) days and only when exceptions occur **U.S. report:** 5:00 pm (if the U.S. report is not available by 6:00 pm CST, a notification is sent) **Outside U.S.:** Timing might vary **FPS report:** 10:00 am |
*\* The delivery timeframe for each report will vary by market.*
*\*\* The Reconciliation Report and MAT Report totals, added together, will always be equal to the settlement pulls from the Faster Payments Network or Receive Networks (Mastercard, Visa and other Receive Networks).*
These reports are comma-separated values (CSV) files, variable block record format: record maximum length 27994, block size 27998. The MTF MAT report will be empty.
For the options for receiving Mastercard Send Reconciliation Reports, see [Accessing Reports](https://developer.mastercard.com/mastercard-send/documentation/reports/index.md#accessing-reports).
### U.S.-specific settlement reconciliation reports {#us-specific-settlement-reconciliation-reports}
Mastercard Send collects the following U.S.-specific reports and provides them to U.S. Acquirers to help them reconcile interchange fees with the Receive Networks. Regional network files are not available in the MTF environment.
| Report | Description | Bulk File IDs | Typical Delivery Time (in CST) |
|--------------------------------------------------------------------------|--------------------------------------------------------------------------------------------|-------------------------------|--------------------------------|
| STAR Daily Net Interchange (R-009-300) | Provides current day and month-to-date totals for outgoing, incoming, and net interchange. | Unencrypted: Prod only = T8V8 | Daily, 4:00 am |
| PULSE Daily Institution Fee Settlement Institution Summary (DF0005-RP05) | Provides a summary level for interchange and switch fees. | Unencrypted: Prod only = T8V8 | Daily, 7:00 am |
These reports are fixed record format.
Pulse billing/switch fees are settled daily along with interchange transactions.
## V8 reconciliation reports {#v8-reconciliation-reports}
The following table summarizes the reports. For detailed descriptions and report specifications, see [GDR, GRN, and GMR](https://developer.mastercard.com/mastercard-send/documentation/reports/gdr-grn-gmr/index.md).
| Report | Summary | Bulk File IDs | Typical Delivery Time |
|-------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Global Daily Transaction Report (GDR) | Shows all approved and declined transactions processed by the Mastercard Send APIs for the previous day. | Unencrypted: * MTF = TBV6 * Prod = TBN6 Encrypted: * MTF = TCA4 * Prod = TCA2 India unencrypted: * MTF = T55D * Prod = T55C | Daily, 1:05 am Central Standard Time (CST) |
| Global Reconciliation Report (GRN)\* | Shows approved transactions (including lifecycle transactions) that are settled on the report date, including Funding Reversals. The report will include data on days when the Mastercard Settlement Account Management (SAM) system settles. For other days, the files will be delivered but will not contain any transactions. | Unencrypted: * MTF = TBV8 * Prod = TBN8 Encrypted: * MTF = TCA8 * Prod = TCA6 India unencrypted: * MTF = T55F * Prod = T55E | Aligned with Settlement Service cutoff times, see [Report Delivery Times](https://developer.mastercard.com/mastercard-send/documentation/reports/index.md#report-delivery-times). |
| Global Mismatched and Adjustment Report (GMR)\* | Shows transactions that are settled in a different way (and for a different amount) than what was processed and reported by the Mastercard Send APIs. The report will include data when exceptions occur and only on settlement days. Otherwise, the files will be delivered but will not contain any transactions. | Unencrypted: * MTF = TIL8 * Prod = TIL6 Encrypted: * MTF = TJA4 * Prod = TJA2 India unencrypted: * MTF = T55H * Prod = T55G | Aligned with Settlement Service cutoff times, see [Report Delivery Times](https://developer.mastercard.com/mastercard-send/documentation/reports/index.md#report-delivery-times). |
*\* The GRN and GMR totals, added together, will always be equal to the settlement pulls from the Faster Payments Network or Receive Networks (Mastercard, Visa and other Receive Networks).*
These reports are CSV files, variable block record format: record maximum length 27994, block size 27998. The MTF GMR will be empty.
### Report delivery times {#report-delivery-times}
The following table shows the typical delivery times for the GRN and GMR based on the Settlement Service cutoff time. Customers participating in more than one Settlement Service ID (SSID) will receive reports per SSID.
| If the Settlement Service Cutoff time (in CST) is... | MTF Typical Delivery Time || Production Typical Delivery Time ||
| If the Settlement Service Cutoff time (in CST) is... | GRN | GMR | GRN | GMR |
|------------------------------------------------------|-------------|-------------|-------------|-------------|
| 00:00 | 08:00‑09:00 | 13:00‑14:00 | 04:00‑05:00 | 09:00‑10:00 |
| 03:00 | 08:00-09:00 | 13:00-14:00 | 08:00-09:30 | 12:00-13:00 |
| 04:05 | 10:00-11:00 | 15:00-16:00 | 10:00-11:00 | 15:00-16:00 |
| 06:30 | 10:00-11:00 | 15:00-16:00 | 10:00-11:00 | 15:00-16:00 |
| 08:00 | 13:00-14:00 | 18:00-19:00 | 13:00-14:00 | 18:00-19:00 |
| 09:30 | 15:00-16:00 | 20:00-21:00 | 15:00-16:00 | 20:00-21:00 |
| 10:30 | 15:00-16:00 | 20:00-21:00 | 15:00-16:00 | 20:00-21:00 |
| 18:00 | 08:00-09:00 | 13:00-14:00 | 02:30-03:30 | 07:30-08:30 |
| 21:00 | 08:00-09:00 | 13:00-14:00 | 02:30-03:30 | 07:30-08:30 |
For example, if the Settlement Service cutoff time is 08:00 CST, Mastercard Send typically delivers the GRN 13:00--14:00 and the GMR 18:00-19:00 (if any exceptions are generated) for both MTF and Production.
The v8 reports will start once the first transaction is run under the SSID, and they will continue daily even if empty (no data). The GRN and GMR are only generated on local settlement (banking) days determined by the Mastercard SAM system, which exclude currency holidays and local banking holidays. In the Mastercard Send Customer Site, the report names will include the Settlement Cycle number, for example, 'US00000001'.
For the options for receiving Mastercard Send Reconciliation Reports, see the next section.
## Accessing reports {#accessing-reports}
Acquirers, Sponsor OIs, and Direct TIs have several file transfer options for receiving Mastercard Send Reconciliation Reports.
The following table summarizes the connectivity options. Except for the Mastercard Send Suite, all other options require a Mastercard Connect account and have built-in encryption. For additional details, see the [*File Transfer Manual*](https://trc-techresource.mastercard.com/r/bundle/m_fb_en-us/page/d/en-US), available in the [Technical Resource Center](https://trc-techresource.mastercard.com/) on Mastercard Connect.
| Connectivity Option | Requires Software/Hardware Installation? | File Transfer Authentication Type | Delivery to Participant | Offers Automatic Scheduling? | Typical Connectivity Implementation Timeframe |
|--------------------------------------|------------------------------------------------------------|-------------------------------------------------|------------------------------------|------------------------------|-----------------------------------------------|
| Secure Shell FTP (SFTP) | Third-party software: SFTP enabled client/server | Keys Uses file-based certificate authentication | Mastercard push / Participant pull | Yes | 2-3 weeks attended 3-5 weeks unattended |
| Mastercard Data Exchange (MDE) | No | None | Participant pull | No | 2-3 weeks |
| Mastercard File Express (MFE) Client | Windows-based desktop suite SecurID provided by Mastercard | Keys Uses SecurID authentication | Participant pull | No | 2-3 weeks |
| MFE Scheduler 7.0 | Windows-based desktop suite | Keys Uses SSH keys authentication | Participant pull | Yes | 3-4 weeks |
| Mastercard Send Suite | No | None | Participant pull | No | 1 week |
**NOTE:** One Global File Transfer (GFT) endpoint must receive all the reports for a Program participant. The GFT setup activity is part of the Mastercard Send onboarding project and might add time to the implementation. The implementation timeframes shown are approximate and depend on resource availability and system freeze dates.
Acquirers, Sponsor OIs, and Direct TIs may also get Mastercard Send Reconciliation Reports manually from the Mastercard Send Customer Site found on Mastercard Connect.
TIs that do not connect directly to the Mastercard APIs (known as 'Indirect TIs') will receive the reporting that their Acquirer provides.
## Custom fields for reconciliation {#custom-fields-for-reconciliation}
During onboarding, the OI/TI can configure up to four custom fields which will be added to their reconciliation reports: DTR and Recon (v7), or GDR and GRN (v8).
These fields enable the OI/TI to provide custom values in their Funding and Payment Transaction API calls (using the configured custom field names) which will appear in their reports to provide additional transaction reference information that assists with reconciliation and transaction research. For example, participants with multiple programs can use a custom field to identify the associated program for each transaction to help them with reconciliation.
The custom field information is not passed to Receive Networks.
Custom field configuration must be completed during implementation. When configuring multiple custom fields, the participant must indicate the order in which custom fields should be displayed in the reports.
The field name and field values both support alphanumeric characters. The field name maximum length is 40 characters, and the field value maximum length is 200 characters. For additional information and layout, see the "Custom Field Name" table row in the [v7](https://developer.mastercard.com/mastercard-send/documentation/reports/dtr-recon/index.md) or [v8](https://developer.mastercard.com/mastercard-send/documentation/reports/gdr-grn-gmr/index.md) report specifications.