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

šŸš§

New Version Coming up!

The next version of the Merchant Monthly Settlement Report will released on March 1st, 2022.

During period until March 1st, 2022 both the current and new beta version of the Monthly Settlement report will be published simultaneously, providing the necessary time to learn and adapt existing processes and systems.
Starting February 1st, a monthly settlement report will be published both in the old and the new format.

The new Merchant Settlement report was adapted to fit the exact structure of the existing daily settlement report, and will simply reflect the daily settlements on a monthly basis.

Report specifications can be found on the Merchant Settlement Report page.

Main changes:

  1. Unused columns have been removed
  2. Indication on Reserve amounts held on each settlement record
  3. Breakdown on the monthly settlements performed throughout a calendar month from Rapyd

Please reach out to our supportt team if you have any questions and/or feedback on the new 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 Structure

Header Format

Line 1 of the CSV file contains the following information:

šŸ“˜

Timestamps Format

All timestamps should be in UTC.

FieldValue
Report TitleMerchant Monthly Settlement Report
VersionVersion number.
MerchantAlias of the merchant.
FromStart of the report.
YYYY-MM-DD hh:mm:ssTimestamp at start.
ToEnd of the report.
YYYY-MM-DD hh:mm:ssTimestamp at end.

Data Format

šŸ“˜

Transactions

  1. Transactions closed within a day (again, UTC time) will be considered for settlement starting that day. I.e. the system's cutoff time is 12:00AM UTC
FieldValue
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 IDAlias of the merchant's account on the Rapyd platform. Relevant to collections.
Wallet IDThe wallet token from which the funds were settled.
Settlement DateThe date when the funds were settled.
CurrencyThe settlement currency.
Three-letter ISO 4217 code.
MDRThe sum of all MDR fees paid to Rapyd during the report period, in the settlement currency.
Fixed FeeThe sum of all transaction fees paid to Rapyd during the report period, in the settlement currency.
FX MarkupThe sum of all FX fees paid to Rapyd during the report period, in the settlement currency.
Minimum Monthly FeeThe applied minimum monthly fee amount
Minimum Monthly Fee CurrencyThe minimum monthly fee currency.
Three-letter ISO 4217 code.
Total FeesThe 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.
SettlementThe 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 10 months 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.