Overview

The Evo Payment clearing and settlement system generates a detailed file of all PSP settlement exception and special 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-05	`Acquirer_PSP_Miscellaneous_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_Miscellaneous_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_Miscellaneous_Detail_P003_88888888_20230108.csv

Test Environment (Acquirer Level)

Acquirer_PSP_Miscellaneous_Detail_T003_88888888_20230108.csv

With Batch Number (Acquirer Level)

Acquirer_PSP_Miscellaneous_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_Miscellaneous_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-05 PSP_Miscellaneous_Detail file.

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

Samples

Record Date	Record Type	Dispute Amount Indicator	Record Reference Number	Record Reason Code	Record Reference Information	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	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 Initiation Mode	Txn Status	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
20280729	PSP-First ChargeBack	Full	2817976864	4853	RedactedRecordInfo-A8C320EE6625	58690282	Acquirer2	706728	PSP3	M748857	Merchant30	S50494984671308	Store38	5699	24231686	HKG	RedactedCity-9C6867C77D8F	2028-05-31T15:01:50+08:00	2028-05-31T15:01:50+08:00	2028-05-31T15:01:50+08:00	Payment	Mastercard	0614806957723339537405722	4171790375011699255952177	1684323400047298456052	3929SWEEGIVAG	813839******1365	Debit	MDH	Consumer	DEU	99.20	99.20	EUR	99.20	EUR	07	Cybersource	Success	XPXFRJ	International	34666671569232686537198	20280728	-99.20	EUR	-99.11	EUR	2.01	-97.10
20280729	PSP Fee-Debit	Full	79397409	7800	RedactedRecordInfo-C29D75B6C923	58690282	Acquirer2	706728	PSP3	M748857	Merchant30	S32844641653456	Store41	5815	24231686	HKG	RedactedCity-9C6867C77D8F	2028-06-03T22:34:29+08:00	2028-06-03T22:34:29+08:00	2028-06-03T22:34:29+08:00	Payment	Mastercard	9888338855249954203861320	0672306672696776880658284	4156846414325680319618	5577XTSSWVDUN	376575******3512	Credit	MPL	Consumer	BRA	14.99	14.99	USD	14.99	USD	07	Cybersource	Success	KR6CRS	International	39787765322613466293261	20280728			-14.99	USD		-14.99
20280729	PSP-Second Presentment	Full	3748289443	2700	RedactedRecordInfo-84C0ABB4AA30	58690282	Acquirer2	706728	PSP3	M748857	Merchant30	S30486452156990	Store35	5399	24231686	HKG	RedactedCity-9C6867C77D8F	2028-07-15T16:18:14+08:00	2028-07-15T16:18:14+08:00	2028-07-15T16:18:14+08:00	Payment	Mastercard	4669408210815845735306394	5171324158317610038988321	1009923278643856151951	5131PEKKJSOHL	489932******2400	Debit	MDS	Consumer	NGA	504.59	504.59	HKD	504.59	HKD	06	Cybersource	Success	004416	International	10830822275593064918940	20280728			504.70	HKD	-8.08	496.62
20280729	PSP-First ChargeBack	Full	7732075677	13.7	RedactedRecordInfo-FAB20E45FCE7	58690282	Acquirer2	648654	PSP11	M748857	Merchant30	S56664184318130	Store45	5816	24231686	HKG	RedactedCity-9C6867C77D8F	2028-07-03T18:12:02+08:00	2028-07-03T18:12:02+08:00	2028-07-03T18:12:02+08:00	Payment	Visa	9215225894778977574582241	4393399781277320311486457	5472946178067841076730	760067204391482	624642******1055	Debit	F	Consumer	CAN	91.22	91.22	CAD	91.22	CAD	05	Cybersource	Success	945745	International	85906447517378074241837	20280728	-91.22	CAD	-64.84	USD	1.037474	-63.80
20280729	PSP-First ChargeBack	Full	8097187217	10.4	RedactedRecordInfo-CB10D4498C2E	58690282	Acquirer2	648654	PSP11	M748857	Merchant30	S17332853592011	Store47	5817	24231686	HKG	RedactedCity-B1549BB5014B	2028-06-24T14:53:37+08:00	2028-06-24T14:53:37+08:00	2028-06-24T14:53:37+08:00	Payment	Visa	7132643577762704399335094	3279671681711641095382904	6100995613088524716275	428991064909643	304422******8132	Credit	C	Consumer	TWN	2280.89	2280.89	TWD	2280.89	TWD	07	Cybersource	Success	395844	International	63568863308948660793503	20280728	-2280.89	TWD	-70.60	USD	1.452986	-69.15

File-05 PSP_Miscellaneous_Detail PSP Settlement Exception and Special 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#