1. Reconciliation Files
Reconciliation Files & Specifications
  • Overview
  • Reconciliation Files
    • File-01 Activity_Detail Online Transaction Detail File
    • File-02 Settlement_Detail Settlement Transaction Detail File
    • File-03 Miscellaneous_Detail Manual Settlement Transaction Detail File
    • File-04 PSP_Reconciliation_Detail PSP Settlement Reconciliation Transaction Detail File
    • File-05 PSP_Miscellaneous_Detail PSP Settlement Exception and Special Transaction Detail File
    • File-06 Interchange_Scheme_Fee_Detail Interchange and Scheme Fee Detail File
    • File-07 PSP_Interchange_Scheme_Fee_Detail PSP Interchange and Scheme Fee Detail File
    • File-08 Network_Token_Cryptogram_Detail Network Token Cryptogram Detail File
  • Card BIN File
    • BIN File
  1. Reconciliation Files

File-06 Interchange_Scheme_Fee_Detail Interchange and Scheme Fee Detail File

Overview#

At the customer-specified daily cut-off time, the Evo Payment clearing and settlement system produces a detail file containing all interchange fees and scheme fees within the previous natural-day cut-off cycle, for customers to perform automated transaction matching and reconciliation.
Note :
The file contains online transactions in all transaction statuses (including transactions with a failed status);
If the customer generated no online transactions on the previous day, an empty file is generated, retaining only the field names and end marker END;
After the large-file splitting function is enabled, a BatchNum (001–999) suffix is added to the file name.

File location and naming rules#

File levels and file codes#

Evo Payment can produce details in different dimensions according to the different levels configured for the customer in the system. File codes and report names are distinguished by level as follows:
File levelFile codeReport name template
Acquirer levelA-File-06Acquirer_Interchange_Scheme_Fee_Detail_(Version No)_(Inscode)_YYYYMMDD
Group levelG-File-06Group_Interchange_Scheme_Fee_Detail_(Version No)_(Groupcode)_YYYYMMDD
Merchant levelM-File-06Merchant_Interchange_Scheme_Fee_Detail_(Version No)_(Merchantcode)_YYYYMMDD
Store levelS-File-06Store_Interchange_Scheme_Fee_Detail_(Version No)_(Storecode)_YYYYMMDD

File name field descriptions#

Each field is connected by an underscore (_), and the field meanings are as follows:
FieldDescription
Fixed valueAcquirer_Interchange_Scheme_Fee_Detail / Group_Interchange_Scheme_Fee_Detail / Merchant_Interchange_Scheme_Fee_Detail / Store_Interchange_Scheme_Fee_Detail, corresponding to that level
Version numberThe first character is the file identifier: P production environment, T test environment; the last three characters are a numeric number, starting from 001 up to a maximum of 999 (new versions are compatible with old versions)
Inscode/Groupcode/Merchantcode/StorecodeThe customer's Acquirer, Group, Merchant, or Store identifier
DateYYYYMMDD, report generation date
Batch number (optional)Added when the Batch Generate Threshold function is configured for the Acquirer file, with a range of 001–999

File name examples#

Production environment (Acquirer level)
Acquirer_Interchange_Scheme_Fee_Detail_P003_88888888_20230108.csv
Test environment (Acquirer level)
Acquirer_Interchange_Scheme_Fee_Detail_T003_88888888_20230108.csv
With batch number (Acquirer level)
Acquirer_Interchange_Scheme_Fee_Detail_P003_88888888_20230108_001.csv

SFTP path and login#

ItemDescription
SFTP modeEvo Payment is the SFTP Server
Default directory/in/{YYYYMMDD}
Login methodPublic/private key
Transfer completion markerEmpty TXT file with the same-name .ok suffix (e.g., Acquirer_Interchange_Scheme_Fee_Detail_P003_88888888_20230108.csv.ok)
Important : Before pulling and parsing the reconciliation file, the client should first check whether the same-name .ok file exists to confirm that Evo Payment has completed the file transfer.

Report structure#

Basic file attributes#

AttributeValue
File formatCSV
File encodingUTF-8 with BOM
Line break\n (0x0A)
Field delimiterDouble quotation marks + comma ","
File content end marker***END*** (last line)

File generation time#

Generation cycle: natural-day file, produced Monday through Sunday each week
Generation time: daily 10:00–12:00 AM (Evo Payment node system time)

File data elements#

This section defines the field elements of the File-06 Interchange_Scheme_Fee_Detail file.
No.Field nameDescription
1Acquirer IDAcquirer ID
Appears only in Acquirer-level files
2PSP IDPayment PSP ID
Appears only in Acquirer-level files
3Group IDGroup number
Appears only in Acquirer- and Group-level files
4Merchant IDMerchant number
Appears only in Acquirer-, Group-, and Merchant-level files
5Store IDStore number
6Merchant Txn IDMerchant transaction number
7Merchant Order ReferenceMerchant order reference information
8System Txn IDEvo Payment transaction number
9PSP Txn IDPSP transaction number
10Original Merchant Txn IDOriginal Merchant transaction number
11Original PSP Txn IDOriginal PSP transaction number
12Merchant Txn TimeMerchant transaction time
13Payment BrandPayment brand
14Txn TypeTransaction type
15PSP MCCPSP's MCC, Merchant category
16Txn StatusEvo Payment system transaction status
17Merchant Txn AmtMerchant transaction amount
18Merchant Txn CurrMerchant transaction currency
19Funding TypeCard debit/credit indicator
20Card Program IDCPI identifier. Applicable only to Mastercard; current values include MCC and DMC.
21Product IDCard product ID
22Product Type IDCard category identifier
23Issuer CountryIssuer country/region
24Acquirer NationCountry/region where the Acquirer is located
25Merchant NationCountry/region where the Merchant is registered
26Crossborder FlagCross-region indicator
27Payment ScenarioTransaction scenario: online/offline
28IC FeeInterchange fee identifier, fixed value: Interchange Fee
29IC Fee IndicatorCard scheme Interchange Fee ID
30IC Fee NameInterchange fee name
31IC Fee Rule FlagInterchange fee rule identifier, with values and meanings shown below.
32IC Fee RuleInterchange fee rule
33Scheme FeeScheme fee identifier, fixed value: Scheme Fee
34Scheme Fee Service CodeScheme fee code
35Scheme Fee NameScheme fee item name
36Scheme Fee Rule FlagScheme fee rule identifier
37Scheme Fee RuleScheme fee rule
38Scheme Fee Service Code, Scheme Fee Name, Scheme Fee Rule Flag,Scheme Fee RuleRepeats sequentially as a group

Samples#

Acquirer IDPSP IDGroup IDMerchant IDStore IDMerchant Txn IDMerchant Order ReferenceSystem Txn IDPSP Txn IDOriginal Merchant Txn IDOriginal PSP Txn IDMerchant Txn TimePayment BrandTxn TypePSP MCCTxn StatusMerchant Txn AmtMerchant Txn CurrFunding TypeCard Program IDProduct IDProduct Type IDIssuer CountryAcquirer NationMerchant NationCrossborder FlagPayment Scenario
12065194255623M421412HwUFCIJCybUMf3BjeDz68VvUnRlOS_9KlOYPCODyuFUh4AjeSj32UnYxRyZC_72028-07-27T13:20:45+00:00MastercardPayment5399Success0.46SGDCreditMCCMCOCommercialSGPSGPSGPDomesticonlineInterchange Fee61Standard (61)0SGD_-0.01IncentiveFALSEScheme Fee2AB1003LAcquirer LVP Fee0SGD_0.0193395002AB1906LAuthorization Acquirer Processing Fee ( LVP - Domestic)0SGD_0.0019339502AB3406Digital Assurance Acquirer Fee - Unauthenticated (Credit)0SGD_0.0000920002AB3415LDigital Security Fee Auth (Credit) Low Value (Domestic)0SGD_0.0001289302AB3506Digital Assurance Acquirer Fee—Non Tokenized (Credit)0SGD_0.0001840002CB4111Domestic Mastercard Interchange Purchase Volume (Credit)0SGD_0.0001610002CF2001Acquirer Authorization Connectivity Fee0SGD_0.0000122482F19900Safety Net Acquirer Fee0SGD_0.0019339502GC1240EREarly Reconciliation Service Fee0SGD_0.0010314402GC1915Digital Security Fee on Clearing (Credit) Acquiring (Domestic)0SGD_0.000092000NTPF001Non-transactional Processing Fee0SGD_0.005830830
1206519452624637M421412MlQHMXM1zvlDTMM1ww7u4eORkDGL_2QjAXWQA9viaQNXZ0bh2d9gGEtIFP_22028-07-27T16:40:38+00:00VisaPayment5817Failed92.35USDDebitNConsumerSGPSGPSGPDomesticonlineScheme Fee4J56A6178DOM NON ATM - VIP ACQUIRER NON-FINANCIAL (VISA, 4J56A) (DEBIT)0USD_0.0050000004Q6510011ADDRESS VERIFICATION SERVICE - ACQUIRER FEE0USD_0.010000000
12065194255623M421412NuDWFRME1KvZYJIxreGlioYgFQvS_3CdDTKFJS6CxMLBYzpoHimrJkEZfF_02028-07-27T21:05:39+00:00MastercardPayment5399Success7.53SGDCreditMCCMCSConsumerVNMSGPSGPInternationalonlineInterchange FeeYGIntraregional Consumer Rate III—Base—Core0SGD_-0.10IncentiveFALSEScheme Fee2AB1906LAuthorization Acquirer Processing Fee ( LVP - Cross-Border)0SGD_0.0290092502AB3406Digital Assurance Acquirer Fee - Unauthenticated (Credit)0SGD_0.0030120002AB3415LDigital Security Fee Auth (Credit) Low Value (Cross-Border)0SGD_0.0001289302AB3506Digital Assurance Acquirer Fee—Non Tokenized (Credit)0SGD_0.0030120002CF2001Acquirer Authorization Connectivity Fee0SGD_0.0000122482DA4311Acquirer International Purchase0SGD_0.0000000002DN1400Acquirer Cross-border Purchase (Base)0SGD_0.0527100002DORSSF11Regional Safety and Security Fund—International Purchase0SGD_0.0015060002F19900Safety Net Acquirer Fee0SGD_0.0019339502GC1240EREarly Reconciliation Service Fee0SGD_0.0010314402GC1915Digital Security Fee on Clearing (Credit) Acquiring (Cross-Border)0SGD_0.0060240002GC797Tiered IPM Acquirer Inter-Country0SGD_0.1031440002MF47301SEA Travel Marketing and Acceptance Fund (Clearing)0SGD_0.007530000NTPF001Non-transactional Processing Fee0SGD_0.006276240
1206519452624637M421412BvGOOtF1RaTZ3RCViNWsVfZq0WeJX_2LrXVSnW9OzJS7BQZxFScVkQd0RgUX_52028-07-27T10:17:06+00:00VisaPayment5399Success4.47SGDCreditCConsumerCHNSGPSGPInternationalonlineInterchange FeeAP ALT SIG0SGD_-0.09IncentiveFALSEScheme Fee4B1102010ACQUIRING LICENSE FEES - INTERNATIONAL0SGD_0.0002235004B11A3800MSV FEES (OFF-US) - INTERNATIONAL (4B11A)0SGD_0.0020115004F3529005ACQUIRER ISA - INTRA-REGIONAL ACQUIRER - POS BASE0SGD_0.0178800004F35A9412INTL POS ACQUIRER (4F35A) - BASE0SGD_0.0193395004F4030000IAF INTRA-REGIONAL POS FEES0SGD_0.0089400004J42A5140INTL POS - VIP ACQUIRER NON-FINANCIAL (VISA) (4J42A)0SGD_0.0322325004VAS03154ACQUIRER MULTI-CURRENCY NON-DOMESTIC SETTLEMENT CHARGE0SGD_0.011175000NTPF001NON-TRANSACTIONAL PROCESSING FEE0SGD_0.008447500
12065194255623M421412HMQLLGBeUjPbyM0ecv7ehBnJeFBG_7MFQNRBUfMdNamQ6npn3hhLrHxCBT_0XBQXJZsjMdNHI5LYnXI7LsVTKJ7I2028-07-27T12:48:23+00:00MastercardCancel7311Success300.00THBDebitDMCMDTCommercialTHASGPSGPInternationalonlineScheme Fee2AB1909LAuthorization Acquirer Processing Fee-Reversal ( LVP - Cross-Border)0THB_0.756225000
12065194255623M421412WfHFEBTChibtwOchu7EfQlWVX4Z9H_9ZlOXMXOLqqiytOgxt5UwDnUBD4X1E_3UwDWDPdwQ7o93X5qkNQDaXm9TxXY2028-07-27T05:32:57+00:00MastercardMerchandise Credit5817Success31.63CADCreditMCCMPLConsumerCHNSGPSGPInternationalonlineInterchange FeeYHIntraregional Consumer Rate III—Base—Premium0CAD_0.32IncentiveFALSEScheme Fee2AB1906Authorization Acquirer Processing Fee (Cross-Border)0CAD_0.0351600002CF2001Acquirer Authorization Connectivity Fee0CAD_0.0000133612DA4330Acquirer International Credit0CAD_0.0000000002DN1000Acquirer Cross-border Purchase (Enhanced)0CAD_0.4744500002F19900Safety Net Acquirer Fee0CAD_0.0021096002GC1240EREarly Reconciliation Service Fee0CAD_0.0011251202GC797Tiered IPM Acquirer Inter-Country0CAD_0.1125120002LY7106Clearing Acquirer Non-Local Currency Fee0CAD_0.0316300002MF47301SEA Travel Marketing and Acceptance Fund (Clearing)0CAD_0.031630000
Previous
File-05 PSP_Miscellaneous_Detail PSP Settlement Exception and Special Transaction Detail File
Next
File-07 PSP_Interchange_Scheme_Fee_Detail PSP Interchange and Scheme Fee Detail File
Built with