Reconciliation - Mastercard

The reconciliation report includes the Reconciliation/1644 messages from the Mastercard T112 IPM Clearing file.

Format: CSV
File name: [ClientName_Reconciliation_YYYYMMDD].csv
Frequency: Daily
Stored in: Client-hosted SFTP folder
Product applicability: Local Store of Value: Prepaid/Debit, Credit and Remote Store of Value: Prepaid/Debit, Credit

Data fields

Use the table below to help you interpret the data in .CSVformat.

❕

As Paymentology parses through this data from Mastercard, you should refer to your Mastercard documentation to fully understand the use of this data.

Sample file

PY__File_ID,PY__Network,PY__MTID,PY__Created_Date,DE24__Function_Code,DE25__Message_Reason_Code,DE26__Merchant_Category_Code,DE48_0148__Currency_Exponents,DE48_0165__Settlement_Indicator,DE48_0300__Reconciled_File,DE48_0302__Reconciled_Member_Activity,DE48_0358__Reconciled_Business_Activity,DE48_0359__Reconciled_Settlement_Activity,DE48_0367__Reconciled_Card_Program_Identifier,DE48_0368__Reconciled_Transaction_Function_Group_Code,DE48_0370__Reconciled_Account_Range,DE48_0374__Reconciled_Processing_Code,DE48_0375__Member_Reconciliation_Indicator_1,DE48_0378__Original_Reversal_Totals_Indicator,DE48_0380__Debits_Transaction_Amount_In_Transaction_Currency,DE48_0381__Credits_Transaction_Amount_In_Transaction_Currency,DE48_0384__Amount_Net_Transaction_In,DE48_0390__Debits_Transaction_Amount_In_Reconciliation_Currency,DE48_0391__Credits_Transaction_Amount_In_Reconciliation_Currency,DE48_0392__Debits_Fee_Amounts_in_Reconciliation_Currency,DE48_0393__Credits_Fee_Amounts_in_Reconciliation_Currency,DE48_0394__Amount_Net_Transaction_in_Reconciliation_Currency,DE48_0395__Amount_Net_Fee_in_Reconciliation_Currency,DE48_0396__Amount_Net_Total_in_Reconciliation_Currency,DE48_0400__Debits_Transaction_Number,DE48_0401__Credits_Transaction_Number,DE48_0402__Total_Transaction_Number,DE49__Currency_Code_Transaction,DE50__Currency_Code_Reconciliation,DE62__Additional_Data_2,DE71__Message_Number,DE93__Transaction_Destination_Institution_ID,DE100__Receiving_Institution_ID
418,M,1644,12:55.9,685,6862,,35208402,M,1.24061E+22,,DMC3050041EW24060602    NNNNNNN,,,,,0,,O,D0000000000142842,C0000000000000000,D0000000000142842,D0000000000103670,C0000000000000000,00D000000000000000,00C000000000001183,D0000000000103670,C000000000001183,D0000000000102487,16,0,16,352,,,71486,27831,27831
423,M,1644,46:50.0,680,6862,,1242,,1.23053E+22,,,,,,,,,,D0000000000025061,C0000000000000000,D0000000000025061,,,,,,,,10,0,10,124,,,3133,27831,27831
423,M,1644,46:50.0,680,6862,,2032,,1.23111E+22,,,,,,,,,,D0000000002676279,C0000000000025400,D0000000002650879,,,,,,,,45,1,46,203,,,64138,27831,27831