9.9 - Early Reconciliation Report
Each report contains detailed information about each approved transaction related to one partner. Files are generated and delivered to Rapyd SFTP server 2-4 hours after each file delivered to us from partner's processor.
The filename is constructed as follows: YMMDD + File ID + ".erf". For example: 40225001.erf
The generation of this file is only started upon request.
Information
Please note that this page is only relevant to Payment Facilitators
9.9.1 - Early Reconciliation
Field name | Length/type | Description |
---|---|---|
TransactionID | 12 | Transaction ID, Merchant Reference Number |
TransactionLifecycleId | 15 | Identifier assigned by card schemes (not unique) |
TerminalID | 8 | Rapyd terminal ID |
AcquirerReferenceNumber | 23 | Acquirer Reference Number (ARN). Unique ID in Rapyd system |
AgreementNumber | 6 | Rapyd agreement number |
ReferenceData | 50 | Merchant assigned reference data. Also called merchantReferenceData |
TransactionDate | 10 | Date of the businesss transaction, in general the date the authorization message was submitted, YYYY-MM-DD |
ReconciliationAmount | decimal | Gross amount settled with the merchant in the merchants settlement currency (i.e. fees have not been netted) |
ReconciliationCurrency | 3 | Agreement settlement currency |
TransactionAmount | decimal | If dcc then dcc amount, if multicurrency then multicurrency amount else original amount |
TransactionCurrency | 3 | Transction currency |
CardScheme | 1 | V(isa), M(asterCard), A(MEX) etc |
CardNumber6_4 | 19 | Masked Primary Account Number (PAN) |
SettlementKey | 6 | SALE05, REFU06, CASHAD etc. indicates the sign of the transaction amount |
TransactionType | 2 | Rapyd Transaction Type, indicates the mode of acquisition, i.e. chip read in a contactless terminal (45) |
BatchNumber | 10 | Batch number (i.e. BatchID ) as assigned by the Merchant or Processor |
MerchantName | 25 | DBA name |
MerchantCountry | 3 | Merchant country |
MerchantCategoryCode | 4 | Merchant category code or MCC |
ValitorProcessingTime | 19 | Time when transaction is created in Rapyd system (yyyy-MM-dd HH:mm:ss) |
InterchangeFeeRegion | 50 | Domestic, intra-europe, interregional etc |
InterchangeMarketName | 50 | Icelandic, German, European etc |
InterchangeCardCategory | 50 | Corporate, consumer, business etc |
InterchangeTransactionCategory | 50 | Card Present, 3D Secure etc |
CardUsage | 1 | Card usage classification (0=Uncategorized, 1=Credit, 2=Debit) |
CardIssuerCountry | 3 | Cardholder country / Issuer country |
BaseCostFixed | decimal | Base cost fixed. Base cost is sum of fixed and percentage calculated fee. This is the fixed amount |
BaseCostPercent | decimal | Base cost percent. Base cost is sum of fixed and percentage calculated fee. This is the percentage calculated amount |
BaseCost | decimal | Interchange in merchant settlement currency |
MerchantPriceFixed | decimal | Rapyd fixed fee, flat rate per transaction |
MerchantPricePercentage | decimal | Rapyd percent fee, percentage of volume (reconciliation amount) |
MerchantPrice | decimal | Rapyd total fee, this includes interchange and scheme fee for I++ |
PartnerPriceFixed | decimal | Price to partner, fixed |
PartnerPricePercentage | decimal | Price to partner, percent |
PartnerPrice | decimal | Total price to partner |
SchemeFeeCurrency | decimal | Scheme fee currency code |
SchemeFeeFixed | decimal | Scheme fee fixed amount in scheme fee currency |
SchemeFeePercentage | decimal | Scheme fee percentage |
SchemeFee | decimal | Total scheme fee amount, fixed and percentage, in scheme fee currency |
SchemeFeeBase | decimal | Total scheme fee amount in agreement currency |
MulticurrencyFeePercent | decimal | Multicurrency fee percentage |
MultiCurrencyFee | decimal | Total multicurrency fee |
SponsoredMerchantID | 8 | Unique ID for submerchants |
9.9.2 - Example
TransactionID|TransactionLifecycleId|TerminalID|AcquirerReferenceNumber|AgreementNumber|ReferenceData|TransactionDate|ReconciliationAmount|ReconciliationCurrency|TransactionAmount|TransactionCurrency|CardScheme|CardNumber6_4|SettlementKey|TransactionType|BatchNumber|MerchantName|MerchantCountry|MerchantCategoryCode|ValitorProcessingTime|InterchangeFeeRegion|InterchangeMarketName|InterchangeCardCategory|InterchangeTransactionCategory|CardUsage|CardIssuerCountry|BaseCostFixed|BaseCostPercent|BaseCost|MerchantPriceFixed|MerchantPricePercentage|MerchantPrice|PartnerPriceFixed|PartnerPricePercentage|PartnerPrice|SchemeFeeCurrency|SchemeFeeFixed|SchemeFeePercentage|SchemeFee|SchemeFeeBase|MulticurrencyFeePercent|MultiCurrencyFee|SponsoredMerchantID|
402534026064| |20067784|75127414025132562963185|078620||2024-01-25|6115.0000|352|6115.0000|352|M|559543******4824|SALE05|44|0106001975|Chloes Clothes |352|5651|2024-01-25 20:15:06|MC Domestic|Iceland|Premium Credit|Card Present|0|352|0.0000|18.0000|18.0000|0.0000|0.1000|31.5420|0.0000|0.0000|0.0000|978|0.0050|0.1093|0.0498|7.4270||0.0000||
402534026065| |20067784|75127414025132562963193|078620||2024-01-25|5520.0000|352|5520.0000|352|M|520618******1109|SALE05|44|0106001975|Chloes Clothes |352|5651|2024-01-25 20:15:06|MC Domestic|Iceland|Premium Credit|Card Present|0|352|0.0000|16.0000|16.0000|0.0000|0.1000|28.2966|0.0000|0.0000|0.0000|978|0.0050|0.1093|0.0454|6.7766||0.0000||
402534026067| |20067784|74346984025132562963601|078620||2024-01-25|1990.0000|352|1990.0000|352|V|444442******7671|SALE05|44|0106001975|Chloes Clothes |352|5651|2024-01-25 20:16:19|VISA Domestic|Iceland|Consumer Card|Card Present|2|352|0.0000|3.9365|3.9365|0.0000|0.0500|6.7545|0.0000|0.0000|0.0000|978|0.0087|0.0274|0.0124|1.8230||0.0000||
402514863704|464025491176816|20099216|74743004026000191637041|353083||2024-01-25|-750.0000|352|-750.0000|352|V|454890******9640|OCT08|18|4012520004|Lucky Lotto |352|7995|2024-01-25 20:02:52|VISA Domestic|Iceland|Consumer Card|Funds Disbursement|1|352|0.0000|1.8957|1.8957|0.0000|0.5800|4.3500|0.0000|0.0000|0.0000|978|0.0340|0.0071|0.0344|5.1021||0.0000||
402514863705|464025617014503|20099216|74743004026000191637059|353083||2024-01-25|-4690.0000|352|-4690.0000|352|V|453985******4247|OCT08|18|4012520004|Lucky Lotto |352|7995|2024-01-25 20:02:52|VISA Domestic|Iceland|Consumer Card|Funds Disbursement|1|352|0.0000|11.8547|11.8547|0.0000|0.5800|27.2020|0.0000|0.0000|0.0000|978|0.0340|0.0071|0.0363|5.3818||0.0000||
402514863706|304025818069328|20099216|74743004026000191637067|353083||2024-01-25|-3720.0000|352|-3720.0000|352|V|426562******5185|OCT08|18|4012520004|Lucky Lotto |352|7995|2024-01-25 20:02:52|VISA Domestic|Iceland|Consumer Card|Funds Disbursement|2|352|0.0000|9.4029|9.4029|0.0000|0.3500|13.0200|0.0000|0.0000|0.0000|978|0.0340|0.0071|0.0358|5.3130||0.0000||
405911002542|MSIG3KU7G0227 |20005901|75290454060132871855399|357962||2024-01-25|4.5000|978|4.5000|978|M|673400*********5068|SALE05|44|0229xkkYQX|Books by Carl |528|5942|2024-01-25 20:00:02|MC Domestic|Netherlands|Consumer Debit|Card Present|0|528|0.0200|0.0000|0.0200|0.0000|0.0320|0.0297|0.0000|0.0000|0.0083|978|0.0053|0.0676|0.0083|0.0083||0.0000|18050558|
405909003284|MSI2TA4AW0227 |20005901|75290454060132871855407|357962||2024-01-25|5.6500|978|5.6500|978|M|673706*********9756|SALE05|44|0229xkkYQX|Books by Carl |528|5942|2024-01-25 20:01:08|MC Domestic|Netherlands|Consumer Debit|Card Present|0|528|0.0200|0.0000|0.0200|0.0000|0.0320|0.0309|0.0000|0.0000|0.0091|978|0.0053|0.0676|0.0091|0.0091||0.0000|18050558|
405912003318|MSIHBPZ7G0227 |20005901|75290454060132871855415|357962||2024-01-25|6.1500|978|6.1500|978|M|679107*********3837|SALE05|44|0229xkkYQX|Books by Carl |528|5942|2024-01-25 20:03:05|MC Domestic|Netherlands|Consumer Debit|Card Present|0|528|0.0200|0.0000|0.0200|0.0000|0.0320|0.0315|0.0000|0.0000|0.0095|978|0.0053|0.0676|0.0095|0.0095||0.0000|18050558|