The Merchant Settlement Report summarizes all settlements performed to the merchant during the period for which the report applies to.
The report is generated only when settlement events occur.
You can download the Merchant Settlement Report. See Downloading a Financial Report.
The report is provided in the form of a CSV file. To read it, open it in a spreadsheet.
Current file format version is 1.3
Depending on the merchant activity, the report is generated on a daily basis at 2:00 AM GMT.
Line 1 of the CSV file contains the following information:
Rapyd Merchant Settlement Report
Report version number
Alias of the merchant
the string "From"
Period start date
the string "To"
Period end date
- Headers - Described in the following table.
- Collections - Transactions created by Create Payment or Create Refund. If the merchant has two or more accounts for collections, each account appears on a separate line.
- Disbursements - Transactions created by Create Payout.
Alias of the merchant's account on the Rapyd platform.
The merchant's account number at the merchant's bank. Relevant to collections.
The name of the merchant's bank where the settlement is managed. Relevant to collections.
● Collections - The wallet the funds are collected to and settled from.
Type of transaction. One of the following:
The date the payments are settled. Format: YYYY-MM-DD. Relevant to collections.
The currency of the transactions, as settled with the merchant. Three-letter ISO 4217 code. Relevant to collections.
The currency for the client to pay Rapyd's fees. Three-letter ISO 4217 code.
The total amount settled with the merchant for all transactions that settled on the settlement date, minus the amount of negative settlements from previous days.
Settlement eWallet Account Currency
● Collections - The currency of the funds collected.
Three-letter ISO 4217 code.
Settlement Amount in eWallet Account Currency
The client wallet currency equivalent of the amount settled with the merchant.
Prev Negative Settlement
The total amount that the merchant owes to Rapyd from previous days. Relevant when there is a past negative remittance.
Indicates the aggregate debit.
● Collection - Gross amount of all refunds, including fees.
Sum of all fees paid to Rapyd for debit transactions (refund or payout).
● Payment: Net Debit = Gross Debit
The amount paid to the merchant (payments), including fees. Relevant to collections.
Sum of all fees paid to Rapyd for credit transactions (payments). Relevant to collections.
Net Credit = Gross Credit - Credit Fee
Rapyd Merchant Settlement Report,v1.3,21/04/2020 6:05,MERCHANT_NAME,,,,,,,,,,,,,, Account ID,Account Number,Bank,eWallet ID,Type,Settlement Date,Settlement Currency,Fee Currency,Settlement Amount,Settlement eWallet Account Currency,Settlement Amount in eWallet Account Currency,Prev Negative Settlement,Gross Debit,Debit Fee,Net Debit,Gross Credit,Credit Fee,Net Credit US Dollar Account,123-456789-123,Barclays,ewallet_9b102808ff77880d212e11eaa06754ec,Collection,21/04/2020,USD,USD,20,AUD,30.56,0,0,0,0,21.2,1.2,20 EUR Account,123-123455-123,HSBC,ewallet_9b102808ff77880d212e11eaa06754ec,Collection,21/04/2020,EUR,EUR,289.1,MYR,1293.46,1,10,1,10,315.12,15.11,300.1 N/A,N/A,N/A,,Disbursement,21/04/2020,USD,USD,0,TWD,0,0,3,2.24,0,0,0,0
Updated 13 days ago
|Merchant Monthly Settlement Report|