You have the option to search the reconciliation messages and fee collection messages, viewing their details on the screen. These views are helpful because they allow you to search by specific codes or IDs to identify and resolve discrepancies. See the instructions below for more details.
To search for reconciliation messages, complete the steps below:
Go to Cards > Search > Reconciliation messages.
On the Search reconciliation messages page, if necessary, enter additional search parameters and click Search:
From the search results, click the Message ID to access the reconciliation message details. The following screenshot shows the reconciliation message details for a financial position detail received from the clearing system.
To search for fee collection messages, complete the steps below:
Go to Cards > Search > Fee collection messages.
On the Search fee collection messages page, if necessary, enter additional search parameters and click Search:
From the search results, click the Message ID to access the fee collection message details. The following screenshot shows the fee collection message details.
To export Mastercard clearing reports as a CSV file, follow these steps:
Generate the report.
Download it.
The instructions for each process are provided separately.
To generate Mastercard clearing report as a CSV file, follow the steps below:
Go to Cards > Reports > Clearing reports.
On the Card clearing reports page:
Select Mastercard from the Product scheme dropdown.
Select one of the following values from the Report type dropdown:
Choose the date range you're interested in.
Click Export as CSV to generate the report.
To download the generated Mastercard clearing report, proceed with the steps listed below:
Go to Reports > My reports.
Locate your generated report and click the link in the Files column to download it to your computer.
After downloading the CSV file, you can open it in any Excel-like application to view the data organized in columns. The screenshot below shows a filtered version of the report.
On the My reports page, to narrow down your list of reports, use the search function by clicking Search. Filter the reports by generation type, group type, status, or date, then click Search to apply the filters.
Here are the parameters for the fee collection CSV file.
fileDate
The file reference date, parsed from the file ID.
fileId
File ID that uniquely identifies a logical data file to be exchanged between a customer or processor and the clearing system (PDS 0105). The file ID consists of four subfields:
File type, located at positions 1–3;
File reference date, located at positions 4–9;
Processor ID, located at positions 10–20;
File sequence number, located at positions 21–25.
functionCode
The function code indicates a message’s specific purpose (DE 24):
783 – fee collection (clearing system generated).
reasonCode
Message reason code (DE 25):
7621 – ATM balance inquiry fee;
7629 – non-financial ATM service fee (declined transactions).
transactionOriginator
Transaction originator institution ID code (DE 94).
originatorReferenceNumber
The fee collection control number assigned by the originator of the fee collection message (PDS 0137).
processingCode
Transaction code (DE 3):
29 – fee collection (debit to transaction originator);
19 – fee collection (credit to transaction originator).
transactionAmount
The fee collection transaction amount in the transaction currency, excluding any transaction fees (DE 4).
transactionCurrencyCode
Transaction currency code (DE 49).
reconciliationAmount
The transaction amount value, converted to the reconciliation currency (DE 5).
reconciliationCurrencyCode
Reconciliation currency code (DE 50).
additionalData
Additional data contains one or more PDSs that may be required in a message to provide clearing system-related, program-related, or service-specific information when no specific ISO data element is available (DE 48).
reversalIndicator
Message reversal indicator identifies a message as a reversal of a previous message (PDS 0025).
Here are the parameters for the financial position detail CSV file.
fileDate
The file reference date, parsed from the file ID.
fileId
File ID that uniquely identifies a logical data file to be exchanged between a customer or processor and the clearing system (PDS 0105). The file ID consists of four subfields:
File type, located at positions 1–3;
File reference date, located at positions 4–9;
Processor ID, located at positions 10–20;
File sequence number, located at positions 21–25.
messageType
The message type in reconciliation messages identifies the transaction function to which the reconciliation totals pertain (PDS 0372). The message type consists of two subfields:
Message Type Identifier (MTI), located at positions 1–4;
Function code, located at positions 5–7.
messageReasonCode
The message reason code provides the message receiver with the reason for sending this message (DE 25):
6861 – acknowledgement reconciliation;
6862 – notification reconciliation.
reconciledProcessingCode
Reconciled processing code indicates the processing code or transaction type that the reconciliation totals apply to (PDS 0374).
debitsTransactionAmount
The total of transaction amounts that have a debit impact on processing (PDS 0390), expressed in the reconciliation currency.
creditsTransactionAmount
The total of transaction amounts that have a credit impact on processing (PDS 0392), expressed in the reconciliation currency.
netTransactionAmount
The net total of transaction amounts with both debit and credit impacts on processing (PDS 0394), expressed in the reconciliation currency.
netFeeAmount
The net total of fee amounts with both debit and credit impacts on processing (PDS 0395), expressed in the reconciliation currency.
netTotalAmount
The net total of transactions and fee amounts (PDS 0396), expressed in the reconciliation currency.
reconciliationCurrencyCode
Reconciliation currency code (DE 50). The clearing system accumulates totals in the reconciliation currency.
debitsTransactionCount
The number of transactions whose transaction amounts have a debit impact on processing (PDS 0400).
creditsTransactionCount
The number of transactions whose transaction amounts have a credit impact on processing (PDS 0401).
totalTransactionCount
The number of transactions whose transaction amounts have either a debit or a credit impact on processing (PDS 0402).
reversalIndicator
Message reversal indicator identifies a message as a reversal of a previous message (PDS 0025).
Here are the parameters for the file currency summary CSV file.
fileDate
The file reference date, parsed from the file ID.
fileId
File ID that uniquely identifies a logical data file to be exchanged between a customer or processor and the clearing system (PDS 0105). The file ID consists of four subfields:
File type, located at positions 1–3;
File reference date, located at positions 4–9;
Processor ID, located at positions 10–20;
File sequence number, located at positions 21–25.
functionCode
The function code indicates a message’s specific purpose (DE 24):
680 – file currency summary from the clearing system.
messageReasonCode
The message reason code provides the message receiver with the reason for sending this message (DE 25):
6861 – acknowledgement reconciliation;
6862 – notification reconciliation.
transactionCurrencyCode
Transaction currency code (DE 49).
debitsTransactionAmount
The total of transaction amounts that have a debit impact on processing (PDS 0380), expressed in the transaction currency.
creditsTransactionAmount
The total of transaction amounts that have a credit impact on processing (PDS 0381), expressed in the transaction currency.
netTransactionAmount
The net total of transaction amounts with both debit and credit impacts on processing (PDS 0384), expressed in the transaction currency.
debitsTransactionCount
The number of transactions whose transaction amounts have a debit impact on processing (PDS 0400).
creditsTransactionCount
The number of transactions whose transaction amounts have a credit impact on processing (PDS 0401).
totalTransactionCount
The number of transactions whose transaction amounts have either a debit or a credit impact on processing (PDS 0402).
reversalIndicator
Message reversal indicator identifies a message as a reversal of a previous message (PDS 0025).
A card clearing report summarises data from messages sent by card schemes and issuers. Its purpose is to assist the issuer in reconciling transactions and the associated fees for the cards issued.
This chapter provides guidelines on exporting card clearing reports from Tuum and troubleshooting reconciliation issues by extracting transaction details from clearing messages.
