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-03 Miscellaneous_Detail Manual Settlement Transaction Detail File

Overview#

The Evo Payment clearing and settlement system generates a detailed file of all settlement manual transaction records from the previous natural-day cut-off cycle according to the cut-off time specified by the customer, for the customer to perform automated transaction matching and reconciliation processing.
Note :
The file contains online transactions in all transaction statuses (including failed transactions);
If the customer did not generate any online transactions on the previous day, an empty file is generated, retaining only the field names and the 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 generate details in different dimensions based on the different levels configured for the customer in the system. The file codes and report names are distinguished by level as follows:
File LevelFile CodeReport Name Template
Acquirer levelA-File-03Acquirer_Miscellaneous_Detail_(Version No)_(Inscode)_YYYYMMDD
Group levelG-File-03Group_Miscellaneous_Detail_(Version No)_(Groupcode)_YYYYMMDD
Merchant levelM-File-03Merchant_Miscellaneous_Detail_(Version No)_(Merchantcode)_YYYYMMDD
Store levelS-File-03Store_Miscellaneous_Detail_(Version No)_(Storecode)_YYYYMMDD

File Name Field Descriptions#

Each field is connected using an underscore (_), and the field meanings are as follows:
FieldDescription
Fixed valueAcquirer_Miscellaneous_Detail / Group_Miscellaneous_Detail / Merchant_Miscellaneous_Detail / Store_Miscellaneous_Detail, corresponding to that level
Version numberThe first character is the file identifier: P for the production environment and T for the test environment; the last three characters are a numeric number, starting from 001 up to 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 value range of 001–999

File Name Examples#

Production environment (Acquirer level)
Acquirer_Miscellaneous_Detail_P003_88888888_20230108.csv
Test environment (Acquirer level)
Acquirer_Miscellaneous_Detail_T003_88888888_20230108.csv
With batch number (Acquirer level)
Acquirer_Miscellaneous_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 and a .ok suffix (for example, Acquirer_Miscellaneous_Detail_P003_88888888_20230108.csv.ok)
Important : Before pulling and parsing the reconciliation file, the client should first check whether the .ok file with the same name exists to confirm that Evo Payment has completed the file transfer.

Report structure#

Basic File Properties#

PropertyValue
File formatCSV
File encodingUTF-8 with BOM
Newline character\n (0x0A)
Field separatorDouble quotation mark + English comma ","
File content end marker***END*** (last line)

File Generation Time#

Generation cycle: natural-day file, generated every Monday to Friday
Generation time: daily from 10:00–12:00 AM (Evo Payment node system time)

File data elements#

This section defines the field elements of the File-03 Miscellaneous_Detail file.
No.Field NameDescription
1Record DateRecord date
2Record TypeRecord type
3Record Reference NumberRecord reference number
4Record Reason CodeRecord reason code
5Record Reference InformationRecord reference information
6PSP IDPayment PSP ID
Appears only in Acquirer-level files
7PSP NamePayment PSP name
Appears only in Acquirer-level files
8Group IDGroup number
Appears only in Acquirer- and Group-level files
9Group NameGroup name
Appears only in Acquirer- and Group-level files
10Merchant IDMerchant number
Appears only in Acquirer-, Group-, and Merchant-level files
11Merchant NameMerchant name
Appears only in Acquirer-, Group-, and Merchant-level files
12Store IDStore number
13Store NameStore name
14Store MCCStore MCC
15Terminal IDTerminal number
16Merchant NationMerchant country
17Merchant CityMerchant city
18Merchant Txn TimeMerchant transaction time
19System Txn TimeEvo Payment system transaction time
20Txn Pay TimePSP transaction time
21API TypeAPI category
22Txn TypeTransaction type
23Payment BrandPayment brand
24Payment Method VariantPayment method
25Merchant Txn IDMerchant transaction number
26Merchant Order ReferenceMerchant order reference information
27System Txn IDEvo Payment transaction number
28PSP Txn IDPSP transaction number
29Original Merchant Txn IDOriginal transaction merchant transaction number
30Original System Txn IDOriginal transaction Evo Payment transaction number
31Original PSP Txn IDOriginal transaction PSP transaction number
32Card NumberCard number (first 6******last 4)
33Funding TypeCard debit/credit indicator
34Product IDCard product identifier
35Product Type IDCard type identifier
36Issuer CountryIssuer country
37Merchant Local AmtMerchant local amount
38Local Tips AmtLocal tip amount
39Local Surcharge Fee AmtLocal additional service fee amount
40Local Capture AmtMerchant confirmed local amount
41Merchant Local CurrMerchant local currency
42Rate of Local to TxnMCP/DCC exchange rate
43Merchant Txn AmtMerchant transaction amount
44Tips AmountTip transaction amount
45Surcharge Fee AmtAdditional service fee amount
46Merchant Capture AmtMerchant confirmed amount
47Merchant Txn CurrMerchant transaction currency
48User Billing AmtUser billing amount
49User Billing CurrUser billing currency
50ECIAuthentication indicator
51Txn Initiation ModeTransaction initiation mode
52LinkPay Order IDLinkPay order number
53Txn StatusEvo Payment system transaction status
54System Result CodeEvo Payment response code
55PSP Result CodePSP response code
56PSP Authorization CodePSP authorization code
57Crossborder FlagCross-border indicator
58Merchant Sttl AmtMerchant settlement amount
59Merchant Discount AmtMerchant discount amount
60Merchant Sttl CurrMerchant settlement currency
61Rate from Merchant Txn to SttlMerchant settlement exchange rate
62MDR RulesMerchant fee billing rule
63MDR AmountMerchant settlement fee
64PSP Interchange FeeInterchange fee (IC)
65PSP Scheme FeeScheme fee (+)
66Acquirer Service FeeAcquirer service fee (+)
67Txn Service FeeMerchant transaction fee
68VAT AmountVAT amount
69WHT AmountWithholding tax amount
70Net Merchant Sttl AmtNet merchant settlement amount
71MetadataRemarks

Samples#

Record DateRecord TypeRecord Reference NumberRecord Reason CodeRecord Reference InformationPSP IDPSP NameGroup IDGroup NameMerchant IDMerchant NameStore IDStore NameStore MCCTerminal IDMerchant NationMerchant CityMerchant Txn TimeSystem Txn TimeTxn Pay TimeAPI TypeTxn TypePayment BrandPayment Method VariantMerchant Txn IDMerchant Order ReferenceSystem Txn IDPSP Txn IDOriginal Merchant Txn IDOriginal System Txn IDOriginal PSP Txn IDCard NumberFunding TypeProduct IDProduct Type IDIssuer CountryMerchant Local AmtLocal Tips AmtLocal Surcharge Fee AmtLocal Capture AmtMerchant Local CurrRate of Local to TxnMerchant Txn AmtTips AmountSurcharge Fee AmtMerchant Capture AmtMerchant Txn CurrUser Billing AmtUser Billing CurrECITxn Initiation ModeLinkPay Order IDTxn StatusSystem Result CodePSP Result CodePSP Authorization CodeCrossborder FlagMerchant Sttl AmtMerchant Discount AmtMerchant Sttl CurrRate from Merchant Txn to SttlMDR RulesMDR AmountPSP Interchange FeePSP Scheme FeeAcquirer Service FeeTxn Service FeeVAT AmountWHT AmountNet Merchant Sttl AmtMetadata
20280729Merchant Deposit-Collect98306850823657-139-1l208912r3sz9i01m1RedactedRecordInfo-F0DD3E6B4169A694982Group7M735816Merchant24S002072Store275621HKGRedactedCity-062235E8EC8D2028-07-29T10:22:37+08:002028-07-29T10:22:37+08:00Deposit Collection59598400788582-783-7c211b560o5t89n9275w8yr6402oh2vy06054267758272-530-3i144191d1tk945946998309048-925-op01mi36wi3n1l0366461386e91r52zi-1112.96USDInternational-1112.96USDCombination0.00-1112.96
20280729Merchant Risk-Hold41547545885472-875-p4136470qdg60n2k76RedactedRecordInfo-CCABABCCD752A399378Group8M392761Merchant25S123017Store285816HKGRedactedCity-9C6867C77D8F2028-07-29T10:22:32+08:002028-07-29T10:22:32+08:00Risk Hold59606066635182-445-96h5859x25s02715ato6ho366r6d399d85308433419762-394-i0183545plu2839788746004466-194-0w727amy0u4718e523q6vx3d81161656-0.25USDInternational-0.25USDCombination0.00-0.25
20280729Merchant Deposit-Return91548135543102-O500468-782-725451206uz108ow7uRedactedRecordInfo-C66D69338BA2A399378Group8M392761Merchant25S123017Store285816HKGRedactedCity-9C6867C77D8F2028-07-29T10:22:38+08:002028-07-29T10:22:38+08:00Deposit Return96075908025646-Q143651-788-i537yn5br8073n8p2j22b754q160xv3r65371034888927-D049640-450-6335267538273639558-R007848-501-0y0x4j7q38y284flgeaz854c2u730r621080.06USDInternational1080.06USDCombination0.001080.06
20280729Merchant Risk-Release56194276313042-F122747-823-r24999e010291230gnRedactedRecordInfo-D2202B0441CFA482660Group4M505070Merchant26S434840Store297399HKGRedactedCity-9C6867C77D8F2028-07-29T10:22:38+08:002028-07-29T10:22:38+08:00Risk Release79152186849947-H595639-918-n70f942zirn61154j19173s00nr3831073027676410762-H606948-895-z189353697806686894-Y902060-585-h33293x8is3a10m3p3c78ef4o404x0860.65USDInternational0.65USDCombination0.000.65
20280729Merchant Fee-CreditGU54643334429960VpRedactedRecordInfo-FC5201E9D9B6evonetPSP9A482660Group3M563769Merchant7S977122Store75816HKGRedactedCity-062235E8EC8D2028-07-29T10:22:21+08:002028-07-29T10:22:21+08:00RefundVisaJH15544613507787Io92754643466570NG88895664432412Ma08803246923815HE13604085177223Tu04351238555695JZQM536585895653899770983sye3nmk-309722446714124141657724688354449843236654119.26USDInternational19.26USDCombination0.0019.26
20280729Merchant Dispute-Debit17874055014311299056332678536PSP3A694982Group7M659658Merchant27S700722Store305621HKGRedactedCity-9C6867C77D8F2028-07-20T09:31:18+08:002028-07-28T10:17:47+08:00ChargebackMastercardBE6493389369337016Y1440965162496517325657BFK028GF82395wuw-6013872147621989613161111436354533******847552.93USD-76.01AUDsuccess773492International-52.93USDCombination0.00-52.93
20280729Merchant Fee-Debit4534249873618331732746574188768PSP10A694982Group7M566071Merchant28S030051Store315621HKGRedactedCity-9C6867C77D8F2028-07-01T14:23:54+08:002028-07-28T10:17:47+08:00Installation FeeJCBPO9481202542002589B7289468674292692726187469655829216aek-0322739639111472479166340594510563******8955551.62USDsuccess716877International-551.62USDCombination0.00-551.62
20280729Merchant Dispute-CreditGU54643334429960VpRedactedRecordInfo-FC5201E9D9B6evonetPSP9A482660Group3M563769Merchant7S977122Store75816HKGRedactedCity-062235E8EC8D2028-07-29T10:22:21+08:002028-07-29T10:22:21+08:00Reversal of ChargebackVisaJH15544613507787Io92754643466570NG88895664432412Ma08803246923815HE13604085177223Tu04351238555695JZQM536585895653899770983sye3nmk-309722446714124141657724688354449843236654119.26USDInternational19.26USDCombination0.0019.26
Previous
File-02 Settlement_Detail Settlement Transaction Detail File
Next
File-04 PSP_Reconciliation_Detail PSP Settlement Reconciliation Transaction Detail File
Built with