Get balance report
Retrieve a summarized report for all transactions on a given balance within a given timeframe.
The API also provides a detailed report on all 'prepayments' for Mollie fees that were deducted from your balance during the reported period, ahead of your Mollie invoice.
The alias primary can be used instead of the balance ID to refer to the organization's primary balance.
🔑 Access with
Advanced access token with balance-reports.read
OAuth access with balance-reports.read
Request
- Base URLhttps://api.mollie.com/v2
- URLhttps://api.mollie.com/v2/balances/{balanceId}/report
- Auth
- HTTP bearer
- or OAuth 2Authorization code: https://my.mollie.com/oauth2/authorizeToken URL: https://api.mollie.com/oauth2/tokens scopes: balance-reports.read
Query parameters
The start date of the report, in YYYY-MM-DD format. The from date is 'inclusive', and in Central European Time. This means a report with for example from=2024-01-01 will include transactions from 2024-01-01 0:00:00 CET and onwards.
The end date of the report, in YYYY-MM-DD format. The until date is 'exclusive', and in Central European Time. This means a report with for example until=2024-02-01 will include transactions up until 2024-01-31 23:59:59 CET.
You can retrieve reports in two different formats. With the status-balances format, transactions are grouped by status (e.g. pending, available), then by transaction type, and then by other sub-groupings where available (e.g. payment method).
With the transaction-categories format, transactions are grouped by transaction type, then by status, and then again by other sub-groupings where available.
Possible values: status-balances transaction-categories (default: status-balances)
You can enable test mode by setting the testmode query parameter to true.
Test entities cannot be retrieved when the endpoint is set to live mode, and vice versa.
Response
The balance report object.
Example response
{
"resource": "balance-report",
"balanceId": "bal_gVMhHKqSSRYJyPsuoPNFH",
"timeZone": "Europe/Amsterdam",
"from": "2025-03-31",
"until": "2025-03-31",
"grouping": "status-balances",
"totals": {
"pendingBalance": {
"open": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"close": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"availableBalance": {
"open": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedFromPending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"close": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"open": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"available": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"close": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"available": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"payments": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"refunds": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"chargebacks": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"capital": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"transfers": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"fee-prepayments": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"corrections": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
},
"topups": {
"pending": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"movedToAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
},
"immediatelyAvailable": {
"amount": {
"currency": "EUR",
"value": "10.00"
},
"subtotals": [
{
"sub-totals": [
{
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
],
"count": 50,
"method": "creditcard",
"cardIssuer": "amex",
"cardAudience": "other",
"cardRegion": "domestic",
"feeType": "payment-fee",
"prepaymentPartType": "fee",
"transactionType": "payment"
}
]
}
}
},
"_links": {
"self": {
"href": "https://...",
"type": "application/hal+json"
},
"documentation": {
"href": "https://...",
"type": "application/hal+json"
}
}
}Changes
No recorded changes to this operation across all 1 revision of this API.