Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Converted from version 'Beta'.


Page Properties


Description

A list of all settlement entries processed by Matercard.  The list is retrieved directly from Mastercard via the Mastercom API and is updated daily.  Operations Managers and Finance Managers utilize this report to reconcile settlement accounting and identify potential gaps.

Category


Multiexcerpt
MultiExcerptNameparent


Report KeyMASTERCOMRECONCILIATIONREPORT
Report TypeList
Fields

Acquirer Reference Number, Card Acceptor Business Code, Card Acceptor Id, Card Acceptor Name, Card Issuer Reference Data, Cardholder Billing Amount, Cardholder Billing Currency Code, Cardholder Billing Currency Exponent, Claim Id, Clearing Cycle Id, Clearing Date, Conversion Rate Reconciliation, End Date, Event ID, File Id, Function Code, Message Number, Message Reason Code, MTI, Original Amount, Original Amount Currency Code, Original Amount Currency Exponent, Primary Account Number, Processing Code, Reason for Rejection, Reconciliation Currency Code, Reconciliation Currency Exponent, Reconciliation with fees Amount, Report Id, Retrieval Reference Number, Reversal Flag, Sender's DE 05 without fees Amount, Start Date, Transaction Amount, Transaction Currency Code, Transaction Currency Exponent, Transaction DateTime, Transaction Destination Institution Id Code, Transaction Fee Amount, Transaction Life Cycle Id, Transaction Originator Institution Id Code, Transaction Status

Filter ParametersStart Date >= Last 30 days and End Date <= Today and Any Claim Id and Any MTI 
Sample Export




Export Sample

Field Descriptions

FieldDescription
Claim Category

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Category

Claim Reason

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Reason

Card Number

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptCard Number 1

Card Type

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptCard Type

Contact Date

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptContact Date

Full Name

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptFull Name

Claim ID

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim ID

Dispute ID

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptDispute ID

Disputed AmountAmount in dispute at time of reporting
Pending SinceDate and time the dispute moved to Recovery and the Execute Chargeback assignment was generated
ChipOnCardVROL: Chip card?
PinPreferringCardVROL: PIN preferring chip card? 
CardholderDeniesAuthorizingIndVROL: Certification that the cardholder denies authorizing or participating in the disputed transaction
WhatIncorrectAboutTransactionVROL: What is incorrect about this transaction
AccountStatusVROL: What is the status of the account?
AuthorizationRequestDeclinedValidDataIndVROL: Certification that the authorization request would have been declined if valid data had been provided
IncorrectCurrencyReasonVROL: Incorrect Currency Reason
IssuerMasterFileAccountNumberIndVROL: Is the account number on the issuer's master file?
ReceiptAccountNumberMatchIndVROL: Does the account number on the receipt match the cardholder's account number or token?
CardholderReceiptAccountNumberVROL: What is the account number on the cardholder's receipt
TransactionCodeIncorrectVROL: How is transaction code incorrect?
RolTransactionIdThe rolTransactionID of the valid transaction
CardholderReceiptAmtVROL: What is the amount on the cardholder's receipt
ExplainWhyCreditRefundProcessedInErrorVROL: Explain why the credit refund was processed in error
BothTransactionsOnSameAcctNumberIndVROL: Are both transactions for the same merchant and on the same card?
IssuerOrCardholderOtherAcctWithDiffVisaCardIndVROL: Is the other transaction for the same merchant and on a different Visa Card owned by the same Issuer/Cardholder?
OtherTranSameMerchantIndVROL: Is the other transaction paid by other means? 
WhatWasNotReceivedVROL: What was not received?
PurchasedInfoVROL: Provide detailed description of what was purchased and an explanation of the dispute
ExpectedReceiptDateTimeVROL: What was the last expected receipt date and time?
MerchandiseDeliveredWrongLocationVROL: Was the merchandise delivered late or to the wrong location?
DidCardholderCancelPriorExpectedDateVROL: Did the cardholder cancel prior to the expected date?  
CancellationDateVROL: Cancellation Date
CancellationMethodVROL: Cancellation Reason
DisputeDueToVROL: This dispute is due to
MerchandiseOrServicesVROL: What was purchased?
DamagedOrDefectiveOrderInfoVROL: What was ordered and how it was damaged or defective?
WhatWasOrderedVROL: What was ordered?
DescCounterfeitMerchandiseVROL: Describe the counterfeit merchandise
InfoMerchandiseToBeCounterfeitVROL: Provide information about the entity that indicated the merchandise to be counterfeit
MerchandiseWasCounterfeitDateVROL: Date the cardholder received the merchandise or received notification that the merchandise was counterfeit
WhereIsMerchandiseLocatedVROL: Where is the merchandise located?
MerchandiseIdentifiedAsCounterfeitVROL: Certification the merchandise was identified as counterfeit by one of the following
WhatWasPurchasedVROL: Describe what was purchased?
HowMerchandiseOrServiceMisrepresentedVROL: How was the merchandise or service misrepresented?
DidCardholderCancelVROL: Did the cardholder cancel?
MerchantAcceptCancellationIndVROL: Did the merchant accept the cancellation?
ServiceReceivedDateVROL: Date services were received
CreditVoucherTransactionReceiptVROL: Was a credit voucher, voided transaction receipt or refund acknowledgement given?
CreditVoucherTransactionReceiptDatedVROL: Is the credit voucher, transaction receipt, or refund acknowledgement dated?
CreditVoucherOrTransactionReceiptDateVROL: Date of credit voucher, transaction receipt or refund acknowledgement
ChReceivedOrExpectedMerchandiseVROL: Date the cardholder received or expected to receive the merchandise
CardholderReceiveMerchandiseIndVROL: Did cardholder receive the merchandise?
MerchandiseReceivedDateVROL: Date merchandise was received
CardholderReturnMerchandiseIndVROL: Did the cardholder return the merchandise?
CardholderReturnedMerchandiseDateVROL: Date cardholder returned the merchandise
ReturnedMerchandiseReceivedDateVROL: Date merchant received returned merchandise
ReturnMethodVROL: Return Method
HowMerchandiseReturnedVROL: Explain how the merchandise was returned
ShippingTrackingNumberVROL: Tracking Number
CardholderAttemptReturnMerchandiseVROL: Did the cardholder attempt to return the merchandise?
AttemptedReturnDateVROL: Date of attempted return
HowChAttemptReturnAndDispOfMerchandiseVROL: Provide a detailed description of how the cardholder attempted to return and the disposition of the merchandise
MerchantRefuseAdviseVROL: Provide certification of one of the following
CardholderAttemptToResolveVROL: Did the cardholder attempt to resolve the dispute with the merchant?
AttemptToResolveProhLocalLawVROL: Is attempt to resolve prohibited by local law or regulations?
DetailsOfLocalLawVROL: Provide details of local law or regulations
CancellationPolicyProvidedIndVROL: Was a cancellation policy provided?
ServiceTypeVROL: Type of Service
DateOfServiceVROL: Date of service or expected service
CertificationGuaranteedReservationVROL: Certification of one of the following
TimeshareDateVROL: Date of the timeshare, or the date the contract or related documents were received
OrderDetailsNotAsDescribedVROL: Provide details of what was ordered and not as described
MerchandiseServiceReceivedDateVROL: Date merchandise or service was received
MerchantDescDoNotMatchMerchandiseOrServicesVROL: Does the dispute involve merchandise or services provided that do not match the merchant's verbal description?
MerchandiseOrServicesDifferFromDescribedOnReceiptVROL: Did the merchandise or services differ from what was described on the receipt?
PurchasedInfoAndQualityIssueVROL: Provide information about what was purchased and the quality issue
CardholderFirstNotifiedIssuerDisputeDateVROL: Date the cardholder first notified the issuer of the dispute
CorrectCurrencyVROL: Processed through VisaNet as [currency code]; what was the correct currency
[followed by unlabeled alpha currency code dropdown]
CardholderDidNotAgreeDCCVROL: Certification that the Cardholder did not agree to Dynamic Currency Conversion and did not make an active choice
DisputeAmountChangeReasonVROL: Why are you changing the dispute amount?
CardholderMerchantPreviousNegotiationEvidenceVROL: Is there evidence of previous ongoing negotiations between the cardholder and merchant?
ExplainPrevNegotiationVROL: Explain the previous ongoing negotiations between the cardholder and merchant
WhenNegotiationsBeginVROL: When did the negotiations begin?