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-07 PSP_Interchange_Scheme_Fee_Detail PSP 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 PSP 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-07Acquirer_PSP_Interchange_Scheme_Fee_Detail_(Version No)_(Inscode)_YYYYMMDD

File name field descriptions#

Each field is connected by an underscore (_), and the field meanings are as follows:
FieldDescription
Fixed valueAcquirer_PSP_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_PSP_Interchange_Scheme_Fee_Detail_P003_88888888_20230108.csv
Test environment (Acquirer level)
Acquirer_PSP_Interchange_Scheme_Fee_Detail_T003_88888888_20230108.csv
With batch number (Acquirer level)
Acquirer_PSP_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_PSP_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-07 PSP_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-level files
4Merchant IDMerchant number
Appears only in Acquirer-level files
5Store IDStore number
Appears only in Acquirer-level files
6Merchant Txn IDMerchant transaction number
Appears only in Acquirer-level files
7Merchant Order ReferenceMerchant order reference information
Appears only in Acquirer-level files
8System Txn IDEvo Payment transaction number
Appears only in Acquirer-level files
9PSP Txn IDPSP transaction number
Appears only in Acquirer-level files
10Original Merchant Txn IDOriginal Merchant transaction number
Appears only in Acquirer-level files
11Original PSP Txn IDOriginal PSP transaction number
Appears only in Acquirer-level files
12Merchant Txn TimeMerchant transaction time
Appears only in Acquirer-level files
13Payment BrandPayment brand
Appears only in Acquirer-level files
14Txn TypeTransaction type
Appears only in Acquirer-level files
15PSP MCCPSP's MCC, Merchant category
Appears only in Acquirer-level files
16Txn StatusEvo Payment system transaction status
Appears only in Acquirer-level files
17Merchant Txn AmtMerchant transaction amount
Appears only in Acquirer-level files
18Merchant Txn CurrMerchant transaction currency
Appears only in Acquirer-level files
19Funding TypeCard debit/credit indicator
Appears only in Acquirer-level files
20Card Program IDCPI identifier. Applicable only to Mastercard; current values include MCC and DMC.
Appears only in Acquirer-level files
21Product IDCard product ID
Appears only in Acquirer-level files
22Product Type IDCard category identifier
Appears only in Acquirer-level files
23Issuer CountryIssuer country/region
Appears only in Acquirer-level files
24Acquirer NationCountry/region where the Acquirer is located
Appears only in Acquirer-level files
25Merchant NationCountry/region where the Merchant is registered
Appears only in Acquirer-level files
26Crossborder FlagCross-region indicator
Appears only in Acquirer-level files
27Payment ScenarioTransaction scenario: online/offline
Appears only in Acquirer-level files
28IC FeeInterchange fee identifier, fixed value: Interchange Fee
Appears only in Acquirer-level files
29IC Fee IndicatorCard scheme Interchange Fee ID
Appears only in Acquirer-level files
30IC Fee NameInterchange fee name
Appears only in Acquirer-level files
31IC Fee Rule FlagInterchange fee rule identifier, with values and meanings shown below.
Appears only in Acquirer-level files
32IC Fee RuleInterchange fee rule
Appears only in Acquirer-level files
33Scheme FeeScheme fee identifier, fixed value: Scheme Fee
Appears only in Acquirer-level files
34Scheme Fee Service CodeScheme fee code
Appears only in Acquirer-level files
35Scheme Fee NameScheme fee item name
Appears only in Acquirer-level files
36Scheme Fee Rule FlagScheme fee rule identifier
Appears only in Acquirer-level files
37Scheme Fee RuleScheme fee rule
Appears only in Acquirer-level files
38Scheme Fee Service Code, Scheme Fee Name, Scheme Fee Rule Flag，Scheme Fee RuleRepeats sequentially as a group
Appears only in Acquirer-level files

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
61383750026687A5M4056284S158896321776722304800160990994167463avtfianreutifbdgd46855299693203536970467735678073476072028-07-27T17:00:27+07:00VisaPayment4121Success1000VNDCreditNConsumerVNMVNMVNMDomesticonlineInterchange FeeTAXI0VND_-7IncentiveFALSEScheme Fee4B1102020ACQUIRING LICENSE FEES - DOMESTIC0USD_-0.0000020004CSF07600ACQUIRER CARD SERVICE FEE DOMESTIC CREDIT VOLUME FEE0USD_-0.0000220004F56G4104DOM NNSS NON ATM ACQUIRER (CREDIT, 4F56G)0USD_-0.0008000004J56G6174DOM NON ATM - VIP ACQUIRER NON-FINANCIAL (VISA, 4J56G) (CREDIT)0USD_-0.0012000004Z9910004VISA SECURE PROGRAM FEE - TRANSACTION FEE0USD_-0.025000000CSRF001CLEARING AND SETTLEMENT INTERCHANGE REPORT FEE0USD_-0.000000000NTPF001NON-TRANSACTIONAL PROCESSING FEE0USD_-0.003024000
61383750026687A5M1482494S975268696173266700022179798942356635RDsKdeYhqju453593353140377537999473881340223173134722794426921076440497916631546403402028-07-27T17:00:29+07:00VisaRefund4900Success10000VNDDebitFConsumerVNMVNMVNMDomesticonlineInterchange FeeUTILITIES0VND_50IncentiveFALSEScheme Fee4F56G4108DOM NNSS NON ATM ACQUIRER (DEBIT, 4F56G)0USD_-0.0008000004J56G6178DOM NON ATM - VIP ACQUIRER NON-FINANCIAL (VISA, 4J56G) (DEBIT)0USD_-0.001200000CSRF001CLEARING AND SETTLEMENT INTERCHANGE REPORT FEE0USD_-0.000000000
61383750498528A7M3987066S43445647267513929dpy4173pd84kx5a119l293j00781337w5054io76199lp40be7e84392f4w01RGF7PTOTY13122028-07-28T00:21:36+07:00MastercardPurchase5814Success35000VNDCreditMCCMWBCommercialSGPVNMVNMInternationalofflineInterchange Fee65Intraregional Commercial Super Premium0VND_-707IncentiveFALSEScheme Fee2AB1906LAuthorization Acquirer Processing Fee ( LVP - Cross-Border)0USD_-0.0225000002CF2001Acquirer Authorization Connectivity Fee0USD_-0.0000000002CF3001Clearing Sender Connectivity Fee0USD_-0.0000000002CF3002Clearing Receiver Connectivity Fee0USD_-0.0000000002DN1400Acquirer Cross-border Purchase (Base)0USD_-0.0093100002DORSSF11Regional Safety and Security Fund—International Purchase0USD_-0.0002660002F19900Safety Net Acquirer Fee0USD_-0.0015000002GC1240EREarly Reconciliation Service Fee0USD_-0.0008000002GC797Tiered IPM Acquirer Inter-Country0USD_-0.060000000NTPF001Non-transactional Processing Fee0USD_-0.003798000TGC79924Tiered IPM Issuer International0USD_-0.000000000
61383750026687A7M0477145S454709436152558vqj23327v4196iil883g1367736843s630o3du75sya7h422ei58rro5h181356cy4518hb36592joq1554p386y7m541km6950932273827172028-07-28T05:16:31+07:00VisaPre-auth Cancellation7011Success2000000VNDCreditIConsumerIDNVNMVNMInternationalofflineScheme Fee4F3529005ACQUIRER ISA - INTRA-REGIONAL ACQUIRER - POS BASE0USD_-0.3040000004F4030000IAF INTRA-REGIONAL POS FEES0USD_-0.1520000004J42C5140INTL POS - VIP ACQUIRER NON-FINANCIAL (VISA) (4J42C)0USD_-0.065000000
61383750498528A7M6842886S298670269945649q35jqva7i2269j7d35590l04613247h19md06si3h5559v13790582c064oxvyrva086172k9w888j7hd2r4j9qph97t3qrGJS7XV6FU55322028-07-28T13:17:21+07:00MastercardPurchase Reversal5814Success415000VNDDebitDMCMRDConsumerTHAVNMVNMInternationalofflineScheme Fee2AB1909Authorization Acquirer Processing Fee-Reversal (Cross-Border)0USD_-0.025000000
61383750026687A7M6147462S77447813945712l04wbnmf8a7w8243sv2b9km70jss0l63cu985530t3065jlax85c932866r112gs7789562071771462028-07-28T18:27:03+07:00VisaPurchase5499Failed1VNDCreditFConsumerVNMVNMVNMDomesticofflineScheme Fee4J56G6174DOM NON ATM - VIP ACQUIRER NON-FINANCIAL (VISA, 4J56G) (CREDIT)0USD_-0.001200000
Previous
File-06 Interchange_Scheme_Fee_Detail Interchange and Scheme Fee Detail File
Next
File-08 Network_Token_Cryptogram_Detail Network Token Cryptogram Detail File
Built with