The Rapyd Client Portal Developer Hub

Welcome to the Rapyd Client Portal developer hub. You'll find comprehensive guides and documentation to help you start working with Rapyd Client Portal as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Merchant Monthly Settlement Report

The Merchant Monthly Settlement Report summarizes all settlement events and applied fees for a given calendar month.

You can download the *Merchant Monthly 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.

File Version

Current file format version is 2.0

Reporting Frequency

Reports are produced on a monthly basis, depending on the merchant activity during the previous calendar month, at 2:00AM GMT, on the 3rd of each month.

File Format

Header Format

Line 1 of the CSV file contains the following information:

Field

Value

Report Title

Merchant Monthly Settlement Report

Version

Version number.

Merchant

Alias of the merchant.

From

Start of the report.

YYYY-MM-DD hh:mm:ss

Timestamp at start.

To

End of the report.

YYYY-MM-DD hh:mm:ss

Timestamp at end.

Data Format

Field

Value

Type

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.
Issued Bank Account - Transactions collected via the bank account issuing platform.

Account ID

Alias of the merchant's account on the Rapyd platform. Relevant to collections.

Wallet ID

The wallet token from which the funds were settled.

Settlement Date

The date when the funds were settled.

Currency

The settlement currency.
Three-letter ISO 4217 code.

MDR

The sum of all MDR fees paid to Rapyd during the report period, in the settlement currency.

Fixed Fee

The sum of all transaction fees paid to Rapyd during the report period, in the settlement currency.

FX Markup

The sum of all FX fees paid to Rapyd during the report period, in the settlement currency.

Minimum Monthly Fee

The applied minimum monthly fee amount

Minimum Monthly Fee Currency

The minimum monthly fee currency.
Three-letter ISO 4217 code.

Total Fees

The sum of all fees paid to Rapyd during the report period, in the settlement currency.
Total Fees = MDR + Fixed Fee + FX Markup
NOTE: Does not include currency exchange fees, applied to transactions when using the Payment/Payout with FX API.

Gross Amount

Collection: Gross Amount = Settlement + Total Fees
Disbursement: The sum of all payout transactions during the report period, in the settlement currency.

Settlement

The total amount settled with the merchant for all transactions that settled during the reporting period.
Collection: Settlement = Gross Amount - Total Fees
Disbursement: Sum of the amounts of the payout fees that merchant paid during the report period.

Example Report File

Merchant Monthly Settlement Report,v2.0,Rapyd Merchant Name,From,01/11/2020,To,01/12/2020
Type,Account ID,Wallet ID,Settlement Date,Currency,MDR,Fixed Fee,FX Markup,Minimum Monthly Fee Amount,Minimum Monthly Fee Currency,Total Fees,Gross Amount,Settlement
Collections,N/A,ewallet_a12a3bcd5678e05126eb4e69ccdab65f,2020-11-10,USD,110.98,39.50,293.60,1000.00000,USD,444.08,29362.99,28918.91

Updated 13 days ago

Merchant Monthly Settlement Report


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.