Overview

The Evo Payment clearing and settlement system generates a detailed file of all settlement 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 Level	File Code	Report Name Template
Acquirer level	A-File-02	`Acquirer_Settlement_Detail_(Version No)_(Inscode)_YYYYMMDD`
Group level	G-File-02	`Group_Settlement_Detail_(Version No)_(Groupcode)_YYYYMMDD`
Merchant level	M-File-02	`Merchant_Settlement_Detail_(Version No)_(Merchantcode)_YYYYMMDD`
Store level	S-File-02	`Store_Settlement_Detail_(Version No)_(Storecode)_YYYYMMDD`

File Name Field Descriptions

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

Field	Description
Fixed value	`Acquirer_Settlement_Detail` / `Group_Settlement_Detail` / `Merchant_Settlement_Detail` / `Store_Settlement_Detail`, corresponding to that level
Version number	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 `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 `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_Settlement_Detail_P003_88888888_20230108.csv

Test environment (Acquirer level)

Acquirer_Settlement_Detail_T003_88888888_20230108.csv

With batch number (Acquirer level)

Acquirer_Settlement_Detail_P003_88888888_20230108_001.csv

Item	Description
SFTP mode	Evo Payment is the SFTP Server
Default directory	`/in/{YYYYMMDD}`
Login method	Public/private key
Transfer completion marker	Empty TXT file with the same name and a `.ok` suffix (for example, `Acquirer_Settlement_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

Property	Value
File format	CSV
File encoding	UTF-8 with BOM
Newline character	`\n` (`0x0A`)
Field separator	Double 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-02 Settlement_Detail file.

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

Samples

PSP ID	PSP Name	Group ID	Group Name	Merchant ID	Merchant Name	Store ID	Store Name	Store MCC	Merchant Nation	Merchant City	Merchant Txn Time	System Txn Time	Txn Pay Time	Txn Type	Payment Brand	Payment Method Variant	Merchant Txn ID	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	ECI	Txn Status	System Result Code	PSP Result Code	PSP Authorization Code	Crossborder Flag	Merchant Sttl Amt	Merchant Sttl Curr	MDR Rules	MDR Amount	Net Merchant Sttl Amt
26523394_90244173_Hrqoqceyrkthg	PSP8	A735966	Group6	M286567	Merchant23	S160474	Store25	5399	JPN	RedactedCity-74099BA09AFA	2028-07-05T00:49:04+09:00	2028-07-05T00:49:04+09:00	2028-07-05T00:49:07+09:00	Payment	Visa	Recurring	NeVGTYMOVGhMB6jMa0URDm0HOD4DF	642149322650253445331730014130	0205064736274728188011				355644******5494	Debit	N	Consumer	KOR	2346	2346	JPY	05	Success	S0000	AUTHORIZED	360805	International	2346	JPY	Fixed Percentage	-70	2276
26523394_90244173_Hrqoqceyrkthg	PSP8	A735966	Group6	M286567	Merchant23	S160474	Store25	5399	JPN	RedactedCity-74099BA09AFA	2028-07-05T17:14:51+09:00	2028-07-05T17:14:51+09:00		Refund	Visa	Recurring	WtEFQQZWJLMPrX8psFFnojxrKOSN	996631999132553482135934128483	4524861081769715421785	ZuMNEsAx5OHZdN2AxUl6Rii0m1SR	023252084567341672876579584939	6256288209245114546719	912058******9906	Credit	F	Consumer	VNM	-1022		JPY		Success	S0000	VOIDED	656162	International	-1022	JPY	Fixed Percentage	30	-992
21095229_46778033_Xqivuopk	PSP8	A735966	Group6	M286567	Merchant23	S160474	Store25	5399	JPN	RedactedCity-74099BA09AFA	2028-07-05T00:00:36+09:00	2028-07-05T00:00:36+09:00		Refund	Mastercard	Recurring	JdVJXZXY9sP59GD1oQZD2zaKkONR	719563044268562131349184629598	8347494672782183649032	LvZIXnL9hsPquyzPyqBI35vV6EHJ	481913982199818826585319517358	6325298796438306434981	602233******9742	Credit	MCS	Consumer	JPN	-2798		JPY		Success	S0000	VOIDED	194946	Domestic	-2798	JPY	Fixed Percentage	66	-2732
21095229_46778033_Xqivuopk	PSP8	A735966	Group6	M286567	Merchant23	S160474	Store25	5399	JPN	RedactedCity-74099BA09AFA	2028-07-05T12:19:16+09:00	2028-07-05T12:19:16+09:00	2028-07-05T12:19:20+09:00	Payment	Mastercard	Recurring	TxPILu3Sz4ewam3rl8AtquBAP2JdC	596651524322398282649745253022	9496521140990556433472				897426******5587	Credit	MCT	Consumer	JPN	17073	17073	JPY	01	Success	S0000	AUTHORIZED	819780	Domestic	17073	JPY	Fixed Percentage	-405	16668

File-02 Settlement_Detail Settlement Transaction Detail File

Overview#

File Location and Naming Rules#

File Levels and File Codes#

File Name Field Descriptions#

File Name Examples#

SFTP Path and Login#

Report structure#

Basic File Properties#

File Generation Time#

File data elements#

Samples#