Overview

The Evo Payment clearing and settlement system generates a detailed file of all PSP settlement reconciliation transactions within the previous calendar-day cut-off cycle according to the cut-off time specified by the customer, for customers to perform automated transaction matching and reconciliation processing.

Note :

The file contains online transactions of all transaction statuses (including transactions with failed status);

If the customer generated no online transactions on the previous day, an empty file is generated, retaining only the field names and ending 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 Level and File Code

Evo Payment can generate details of 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 Level	File Code	Report Name Template
Acquirer Level	A-File-04	`Acquirer_PSP_Reconciliation_Detail_(Version No)_(Inscode)_YYYYMMDD`

File Name Field Description

Each field is connected using an underscore (_), and the field meanings are as follows:

Field	Description
Fixed Value	`Acquirer_PSP_Reconciliation_Detail`, corresponding to this level
Version No	The 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 a maximum of `999` (new versions are compatible with old versions)
Inscode/Groupcode/Merchantcode/Storecode	The customer's Acquirer, Group, Merchant, or Store identifier
Date	`YYYYMMDD`, report generation date
Batch Number (Optional)	Added when the Acquirer file is configured with the `Batch Generate Threshold` function, with values ranging from `001`–`999`

File Name Examples

Production Environment (Acquirer Level)

Acquirer_PSP_Reconciliation_Detail_P003_88888888_20230108.csv

Test Environment (Acquirer Level)

Acquirer_PSP_Reconciliation_Detail_T003_88888888_20230108.csv

With Batch Number (Acquirer Level)

Acquirer_PSP_Reconciliation_Detail_P003_88888888_20230108_001.csv

Item	Description
SFTP Mode	Evo Payment is the SFTP Server
Default Directory	`/in/{YYYYMMDD}`
Login Method	Public and private keys
Transfer Completion Marker	An empty TXT file with the same name and `.ok` suffix (e.g., `Acquirer_PSP_Reconciliation_Detail_P003_88888888_20230108.csv.ok`)

Important : Before pulling and parsing the reconciliation file, the client should first check whether the same-named .ok file exists to confirm that Evo Payment has completed the file transfer.

Report structure

File Basic Properties

Property	Value
File Format	CSV
File Encoding	UTF-8 with BOM
Line Break	`\n` (`0x0A`)
Field Delimiter	Double quotation marks + English comma `","`
File Content Ending Marker	`*END*` (last line)

File Generation Time

Generation Cycle: Calendar-day file, generated every Monday through Sunday

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-04 PSP_Reconciliation_Detail file.

No.	Field Name	Description
1	Acquirer ID	Acquirer ID Appears only in Acquirer-level files
2	Acquirer Name	Acquirer name Appears only in Acquirer-level files
3	PSP ID	Payment PSP ID Appears only in Acquirer-level files
4	PSP Name	Payment PSP name Appears only in Acquirer-level files
5	Group ID	Group number Appears only in Acquirer-level files
6	Group Name	Group name Appears only in Acquirer-level files
7	Merchant ID	Merchant number Appears only in Acquirer-level files
8	Merchant Name	Merchant name Appears only in Acquirer-level files
9	Store ID	Store number Appears only in Acquirer-level files
10	Store Name	Store name Appears only in Acquirer-level files
11	Store MCC	Store MCC Appears only in Acquirer-level files
12	Terminal ID	Terminal number Appears only in Acquirer-level files
13	Merchant Nation	Merchant country Appears only in Acquirer-level files
14	Merchant City	Merchant city Appears only in Acquirer-level files
15	Merchant Txn Time	Merchant transaction time Appears only in Acquirer-level files
16	System Txn Time	Evo Payment system transaction time Appears only in Acquirer-level files
17	Txn Pay Time	PSP transaction time Appears only in Acquirer-level files
18	API Type	API category Appears only in Acquirer-level files
19	Txn Type	Transaction type Appears only in Acquirer-level files
20	Payment Brand	Payment brand Appears only in Acquirer-level files
21	Payment Method Variant	Payment method Appears only in Acquirer-level files
22	Merchant Txn ID	Merchant transaction ID Appears only in Acquirer-level files
23	Merchant Order Reference	Merchant order reference information Appears only in Acquirer-level files
24	System Txn ID	Evo Payment transaction ID Appears only in Acquirer-level files
25	PSP Txn ID	PSP transaction ID Appears only in Acquirer-level files
26	Original Merchant Txn ID	Original transaction Merchant transaction ID Appears only in Acquirer-level files
27	Original System Txn ID	Original Evo Payment transaction ID Appears only in Acquirer-level files
28	Original PSP Txn ID	Original transaction PSP transaction ID Appears only in Acquirer-level files
29	Card Number	Card number (first 6******last 4) Appears only in Acquirer-level files
30	Funding Type	Card debit/credit indicator Appears only in Acquirer-level files
31	Product ID	Card product identifier Appears only in Acquirer-level files
32	Product Type ID	Card category identifier Appears only in Acquirer-level files
33	Issuer Country	Issuing country Appears only in Acquirer-level files
34	Merchant Local Amt	Merchant local amount Appears only in Acquirer-level files
35	Local Tips Amt	Tip local amount Appears only in Acquirer-level files
36	Local Surcharge Fee Amt	Additional service fee local amount Appears only in Acquirer-level files
37	Local Capture Amt	Merchant confirmed local amount Appears only in Acquirer-level files
38	Merchant Local Curr	Merchant local currency Appears only in Acquirer-level files
39	Rate of Local to Txn	MCP/DCC exchange rate Appears only in Acquirer-level files
40	Merchant Txn Amt	Merchant transaction amount Appears only in Acquirer-level files
41	Tips Amount	Tip transaction amount Appears only in Acquirer-level files
42	Surcharge Fee Amt	Additional service fee amount Appears only in Acquirer-level files
43	Merchant Capture Amt	Merchant confirmed amount Appears only in Acquirer-level files
44	Merchant Txn Curr	Merchant transaction currency Appears only in Acquirer-level files
45	User Billing Amt	User billing amount Appears only in Acquirer-level files
46	User Billing Curr	User billing currency Appears only in Acquirer-level files
47	ECI	Authentication indicator Appears only in Acquirer-level files
48	Txn Initiation Mode	Transaction initiation method Appears only in Acquirer-level files
49	LinkPay Order ID	LinkPay order ID Appears only in Acquirer-level files
50	Txn Status	Evo Payment system transaction status Appears only in Acquirer-level files
51	System Result Code	Evo Payment response code Appears only in Acquirer-level files
52	PSP Result Code	PSP response code Appears only in Acquirer-level files
53	PSP Authorization Code	PSP authorization code Appears only in Acquirer-level files
54	Crossborder Flag	Cross-border indicator Appears only in Acquirer-level files
55	PSP ARN	Dual-message presentment settlement number Appears only in Acquirer-level files
56	PSP Settlement Date	PSP settlement date Appears only in Acquirer-level files
57	PSP Txn Amt	PSP transaction amount Appears only in Acquirer-level files
58	PSP Txn Curr	PSP transaction currency Appears only in Acquirer-level files
59	Direct FX Rate	PSP transaction exchange rate Appears only in Acquirer-level files
60	PSP Sttl Amt	PSP settlement amount Appears only in Acquirer-level files
61	PSP Discount Amt	PSP discount amount Appears only in Acquirer-level files
62	Acquirer Discount Amt	PSP Merchant discount amount Appears only in Acquirer-level files
63	PSP Sttl Curr	PSP settlement currency Appears only in Acquirer-level files
64	Rate for PSP TXN to Sttl	PSP settlement exchange rate Appears only in Acquirer-level files
65	PSP Interchange Fee	PSP IC fee Appears only in Acquirer-level files
66	PSP VAT Amount	PSP value-added tax Appears only in Acquirer-level files
67	PSP WHT Amount	PSP withholding tax Appears only in Acquirer-level files
68	PSP Net Sttl Amt	PSP net settlement amount Appears only in Acquirer-level files
69	PSP Batch	Settlement batch number Appears only in Acquirer-level files

Samples

Acquirer ID	Acquirer Name	PSP ID	PSP Name	Merchant ID	Merchant Name	Store ID	Store Name	Store MCC	Terminal ID	Merchant Nation	Merchant City	Merchant Txn Time	System Txn Time	Txn Pay Time	Txn Type	Payment Brand	Merchant Txn ID	Merchant Order Reference	System Txn ID	PSP Txn ID	Original Merchant Txn ID	Original System Txn ID	Original PSP Txn ID	Card Number	Funding Type	Product ID	Product Type ID	Issuer Country	Merchant Txn Amt	Merchant Capture Amt	Merchant Txn Curr	User Billing Amt	User Billing Curr	ECI	Txn Status	PSP Result Code	PSP Authorization Code	Crossborder Flag	PSP ARN	PSP Settlement Date	PSP Txn Amt	PSP Txn Curr	PSP Sttl Amt	PSP Sttl Curr	PSP Interchange Fee	PSP Net Sttl Amt	PSP Batch
58690282	Acquirer1	706728	PSP3	M748857	Merchant30	S09064179106867	Store33	5815	24231686	HKG	RedactedCity-9C6867C77D8F	2028-07-27T17:12:01+08:00	2028-07-27T17:12:01+08:00	2028-07-27T17:12:01+08:00	Payment	Mastercard	9733145214968137160115661	9842610812896189825862633	5602217438884706829678	5550RFMV5V3UM				807543******2857	Debit	MDS	Consumer	ZAF	14.99	14.99	USD	14.99	USD	02	Success	00	X74549	International	29835692993264043071213	20280728	14.99	USD	14.99	USD	-0.24	14.75	Qflix6
58690282	Acquirer1	706728	PSP3	M748857	Merchant30	S52881997254208	Store34	4722	24231686	HKG	RedactedCity-9C6867C77D8F	2028-07-27T19:15:05+08:00	2028-07-27T19:15:05+08:00		Refund	Mastercard	4344400242678259803829681	4498349114353376525723007	2747471327334792887297	6040IGSY030IH	6157241367746588266720098	FQFM6210681188103894396878	025131678925479	684401******6015	Credit	MCW	Consumer	HKG	-386.34	-386.34	HKD	-386.34	HKD	07	Success	00	J30228	Domestic	40377082438677763353127	20280728	-386.34	HKD	-386.34	HKD	3.28	-383.06	Qflix6
58690282	Acquirer1	706728	PSP3	M748857	Merchant30	S22685876812360	Store36	5499	24231686	HKG	RedactedCity-9C6867C77D8F	2028-07-27T15:42:41+08:00	2028-07-27T15:42:41+08:00	2028-07-27T15:42:41+08:00	Payment	Mastercard	9781810679832729498522442	7132788157856669723656058	3033792879265682865219	2265VQE9G8Q08				054002******7165	Credit	MCW	Consumer	HKG	0.10	0.10	HKD	0.10	HKD	05	Success	00	043783	Domestic	64551615593282564278670	20280728	0.10	HKD	0.10	HKD	0.00	0.10	Qflix6
58690282	Acquirer1	648654	PSP11	M748857	Merchant30	S30486452156990	Store35	5399	24231686	HKG	RedactedCity-9C6867C77D8F	2028-07-27T17:01:40+08:00	2028-07-27T17:01:40+08:00		Refund	Visa	7955917717634153668530950	7334519880366286338130583	4422116838928724147840	069473963721151	9411213916048929800756642	IWMU9477921149575454576651	763358436253525	224653******1643	Debit	F	Consumer	UZB	-72.13	-72.13	HKD	-72.13	HKD		Success	85	822904	International	93957574090449477849188	20280728	-72.13	HKD	-72.130000	HKD	0.721300	-71.408700

File-04 PSP_Reconciliation_Detail PSP Settlement Reconciliation Transaction Detail File

Overview#

File Location and Naming Rules#

File Level and File Code#

File Name Field Description#

File Name Examples#

SFTP Path and Login#

Report structure#

File Basic Properties#

File Generation Time#

File data elements#

Samples#