4.11 Clearing Report Example
Below is an example of a Clearing Report. For a description of the XML schema, see Clearing Report XML Schema
Copy
<?xml version="1.0" encoding="utf-8"?>
<Transactions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<CardFinancial>
<RecordType>ADV</RecordType>
<FinId>13961572160</FinId>
<AuthId>13960479573</AuthId>
<PresentmentID>4762187967</PresentmentID>
<LocalDate>20240212185514</LocalDate>
<LocalDateUTC>0212185517</LocalDateUTC>
<SettlementDate>20240213</SettlementDate>
<SchemeSettlementDate>20240213</SchemeSettlementDate>
<SchemeReconciliationDate>20240213</SchemeReconciliationDate>
<CycleNumber>02</CycleNumber>
<Card PAN="5792362775619123" product="MCRD" programid="POCKIT05" productid="1463" branchcode="MAES" />
<Account no="236277561" type="01" />
<TxnCode direction="debit" Type="pos" Group="pos" ProcCode="000000" />
<TxnAmt value="1.70" currency="826" />
<CashbackAmt value="0.00" currency="826" />
<BillAmt value="1.70" currency="826" rate="1.000000000" />
<ApprCode>186022</ApprCode>
<Trace auditno="838474" origauditno="838474" Retrefno="95KZ3KKL1G4B" />
<MerchCode>35918643</MerchCode>
<Term code="45928071" location="TESCO STORES 5928" street="UNIT 1" city="PECKHAM" country="GB" inputcapability="0" authcapability="1" />
<Schema>MCRD</Schema>
<Txn cardholderpresent="0" cardpresent="1" cardinputmethod="7" cardauthmethod="0" cardauthentity="0" TTI="" />
<MsgSource value="67" domesticMaestro="no" />
<Fee value="0.0034" value2="0.00" currency="826" direction="credit" />
<FeeAmt value="0.00" currency="826" direction="debit" />
<FeeClass interchangeTransaction="no" type="1" code="1" />
<SettlementAmt value="1.70" currency="826" rate="1.000000000" />
<ARN>05272464044910021854241</ARN>
<FIID>015804</FIID>
<RIID>017962</RIID>
<ReasonCode />
<Classification MCC="5411" />
<Response approved="yes" />
<OrigTxnAmt value="1.70" currency="826" />
<CCAAmount value="0.00" currency="826" included="no" />
<SettlementIndicator>8</SettlementIndicator>
<Additional_Amt_DE54 />
<BSA>4</BSA>
<PaymentToken id="65357508" creator="MC-MDES" expdate="2026-12-31" type="CL" status="00" creatorstatus="A" wallet="ANDROID" devicetype="M" lang=" " activationexpiry="" activationmethod="" />
</CardFinancial>
<CardFee>
<CardFeeId>60004771191762</CardFeeId>
<LocalDate>20240213000000</LocalDate>
<SettlementDate>20240213</SettlementDate>
<Card PAN="1271184867621123" product="MCRD" programid="CXNCON" productid="5965" branchcode="00000000" />
<Account no="118486762" type="01" />
<TxId>13959754302</TxId>
<FeeClass interchangeTransaction="yes" type="5" code="1020" />
<LoadUnloadId>0</LoadUnloadId>
<Desc>Interregional non-financial ATM interchange</Desc>
<FeeAmt value="0.16" currency="826" direction="debit" />
<Amt value="0.16" currency="826" direction="debit" />
<ReasonCode>7621</ReasonCode>
<Recon date="20240213" cycle="01" />
</CardFee>
<MasterCardFee>
<RecordType>FC</RecordType>
<MastercardFeeId>30230566</MastercardFeeId>
<MTID>1740</MTID>
<Function_Code_024>783</Function_Code_024>
<Conversion_Rate_Reconciliation_009>0.927419</Conversion_Rate_Reconciliation_009>
<Additional_Data_048>001500724021200137020240212111437000005020148008840297820158031MCC1010501 24021301 NNNNNNN015906711918 0000020683 1EU00000008M24021301240213010165001M01910012</Additional_Data_048>
<LocalDate>20240213000000</LocalDate>
<SettlementDate>20240213</SettlementDate>
<FeeClass interchangeTransaction="no" type="0" code="0" memberID="016387" />
<Desc />
<FeeAmt value="1.24" currency="840" direction="credit" />
<Amt value="1.15" currency="978" direction="credit" />
<ReasonCode>7827</ReasonCode>
<Data_Record_072>INTERCHANGE EDP ADJUSTMENT FOR PROCESS DATE 24/02/12</Data_Record_072>
<DE93_Txn_Dest_ID>016387</DE93_Txn_Dest_ID>
<DE94_Txn_Orig_ID>003285</DE94_Txn_Orig_ID>
<File_ID_PDS0105>T112.0012402130000001218101101</File_ID_PDS0105>
<FileProcessDate>20240213010716</FileProcessDate>
<Recon date="20240213" cycle="01" />
<Settlement date="20240213" cycle="01" />
</MasterCardFee>
<CardChrgBackRepRes>
<RecordType>CB</RecordType>
<ChgbackRepresId>13961291974</ChgbackRepresId>
<LocalDate>20240128011034</LocalDate>
<SettlementDate>20240213</SettlementDate>
<Card PAN="5793048266747123" product="MCRD" programid="POCKIT05" productid="1463" branchcode="" />
<Account no="304826674" type="01" />
<TxnCode direction="credit" Type="pos" Group="pos" ProcCode="000000" />
<TxnAmt value="0.00" currency="826" />
<CashbackAmt value="0.00" currency="826" />
<BillAmt value="0.00" currency="826" rate="1.000000000" />
<ApprCode>192625</ApprCode>
<Trace auditno="483714" origauditno="483714" Retrefno=" " />
<MerchCode>5ZUIIHJWQRTRO6H</MerchCode>
<Term code="I1MB3WHP" location="UKBBRONZ" street="13 Earnock Street" city="HAMILTON" country="GB" inputcapability="0" authcapability="0" />
<Schema>MCRD</Schema>
<Txn cardholderpresent="" cardpresent="" cardinputmethod="0" cardauthmethod="" cardauthentity="" TVR="0" TTI="" />
<MsgSource value="67" domesticMaestro="no" />
<Repeat>1</Repeat>
<SettlementAmt value="0.00" currency="826" rate="1.000000000" date="20240128" />
<Fee value="0.00" currency="826" direction="debit" />
<ARN>85383904027000018942110</ARN>
<FIID>018505</FIID>
<RIID>017962</RIID>
<ReasonCode>4853</ReasonCode>
<Classification MCC="5977" />
<OrigTxnAmt value="38.53" currency="826" />
<PartialReversal>false</PartialReversal>
<SettlementCycle xsi:nil="true" />
<ReconciliationDate xsi:nil="true" />
<ReconciliationCycle xsi:nil="true" />
<Usage>0</Usage>
<Pending_Billing_Amount>38.53</Pending_Billing_Amount>
<Additional_Amt_DE54 xsi:nil="true" />
<ChargebackRefNum>9212389842</ChargebackRefNum>
</CardChrgBackRepRes>
</Transactions>