Settlement Report
Settlement Report gives you a complete breakdown of the data included in a specific payout.
It shows all transactions, fees and deductions that are part of a single settlement - a payout from your Mollie balance to your bank account. This provides a detailed breakdown of amounts received, helping you reconcile your transactions.
The transactions included in the report are all those that impacted the available balance and took place between the current and the last settlement.
Each Settlement Report contains three main categories:
-
Revenue - money coming into your balance:
- Payments - successful payments from your customers
- Split Payments - successful payment routes
- Captures - captured amounts from authorized payments
- Chargeback Reversals - chargebacks that were resolved in your favor
- Returned Refunds - refunds that couldn't be processed and were returned
- Other credit balance movements, like top-ups or corrections
-
Deductions - money coming out of your balance:
- Refunds - money returned to your customers
- Chargebacks - disputed payments reversed by the customer's bank
- Route reversals - reversal of a route
- Other credit balance movements, like corrections
-
Costs - fees associated with your transactions, for example:
- Payment method Fees - fees for processing payments
- Chargeback Fees - fees charged when a chargeback occurs
- Refund Fees - fees for processing refunds
- Notification Fees - fees for payment notifications
- Fee Reimbursements - refunded fees
- Invoice Rounding - small rounding corrections on invoices
- Invoice Compensation - adjustments to invoice amounts
Costs and rolling reserves data will be aggregated per settlement.
Web App view of Settlement Report
You can find Settlement Report in the Mollie Web App under Merchant Dashboard > Reports > Settlements.
You can export these reports manually or fetch them using the Settlements API.
Settlement Exports
You can export your Settlement Report in multiple formats to use with your bookkeeping software or for your own analysis.
Available export formats:
CSV*
*Headers in Dutch for NL and in English for all other markets.PDFMT940*
*The opening balance is zero, and the ending balance is the total amount of the transfer.CODA
Example report:
| Date | Payment method | Currency | Amount | Status | ID | Description | Consumer name | Consumer bank account | Consumer BIC | Settlement currency | Settlement amount | Settlement reference | Amount refunded |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| yyyy-mm-dd hh-mm-ss | blik | PLN | 70.93 | paidout | tr_xxxxxxxxx | Payment description | Alex Smith | IBAN | BIC consumer bank | EUR | 16.28 | 12345678.1234.12 | |
| yyyy-mm-dd hh-mm-ss | ideal | EUR | 1251.00 | paidout | tr_xxxxxxxxx | Payment description | Sam Taylor | IBAN | BIC consumer bank | EUR | 1251.00 | 12345678.1234.12 | |
| yyyy-mm-dd hh-mm-ss | pointofsale | EUR | 25.00 | paidout | tr_xxxxxxxxx | Payment description | EUR | 25.00 | 12345678.1234.12 | ||||
| yyyy-mm-dd hh-mm-ss | refund | EUR | -279.00 | tr_xxxxxxxxx | Payment description | EUR | -279.00 | 12345678.1234.12 | -279.00 | ||||
| yyyy-mm-dd hh-mm-ss | EUR | -2.88 | tr_xxxxxxxxx | Withheld fees [Mollie invoice ID] | EUR | -2.09 | 12345678.1234.12 |
Settlements API
Settlements API provides programmatic access to your settlement data, giving you flexibility to integrate settlement information into your own architecture.
For customers processing higher transaction volumes, using API is a preferred method as it eliminates manual work, ensures efficient automation routine and allows you to handle large volumes of transactions quickly.
Aggregated view
The API returns aggregated amounts grouped by payment method and type, making it easy to get a high-level overview of your settlement. You can retrieve totals for:
- Revenue - total amounts aggregated by payment method.
- Costs - fees aggregated by type and/or payment method.
- Refunds - returned amounts aggregated by payment method.
Detailed transaction data
For a more granular analysis, you can fetch detailed transaction data. This allows you to drill down into individual transactions from your settlement. The data lists:
- Payments - individual payment transactions.
- Refunds - individual refund transactions.
- Chargebacks - individual chargeback transactions.
- Captures - individual capture transactions.
This detailed view gives you a complete transaction-level data for advanced reconciliation or integration with your bookkeeping systems.
Read more about fetching settlement data via API in our Settlement API documentation.
Updated about 3 hours ago