The Collected Fees report lists all transactions crediting or debiting your platform’s Fees Wallet: pay-ins, transfers, refunds, and payouts where your platform has set a positive or negative FEES amount. The report can contain data from the previous 2 years, and the maximum period of data the report can contain is 1 year. You can access this report in the Dashboard in Reports > Fees wallets tab. Contact your platform’s Dashboard admin if you don’t see the Reports feature in the side navigation. In the Dashboard, as well as running reports manually, you can schedule reports to be generated automatically at regular intervals, such as daily, weekly, monthly, and quarterly.

​
Columns

The Collected Fees report has the following available columns and columns used by default.
ColumnDescriptionIncluded by default
ClientIdUnique identifier associated with the API keyYes
TransactionIdUnique identifier of the transactionYes
CreationDateUnix timestamp of the date and time at which the transaction was createdYes
CreationDate:ISOISO format of the date and time at which the transaction was createdNo
ExecutionDateUnix timestamp of the date and time at which the transaction was executedYes
ExecutionDate:ISOISO format of the date and time at which the transaction was executedNo
AuthorIdUnique identifier of the user at the source of the transactionYes
DebitedWalletIdUnique identifier of the debited walletYes
CreditedWalletIdUnique identifier of the credited walletYes
CreditedFundsCurrencyCurrency of the credited amountYes
CreditedFundsAmountAmount of the credited funds in the currency of the credited amountYes
DebitedFundsCurrencyCurrency of the debited amountYes
DebitedFundsAmountAmount of the debited funds in the currency of the debited amountYes
FeesAmountAmount of the fees in the currency of the feesYes
FeesCurrencyCurrency of the feesYes
TypeType of the transaction: PAYIN, TRANSFER, CONVERSION, PAYOUTYes
NatureNature of the transaction: REGULAR, REPUDIATION, REFUND, SETTLEMENTYes
PaymentTypePayment type of the pay-inYes
TagCustom data added to the objectYes

​
Generate via API

1

Set up webhooks

The API endpoint for the Collected Fees report uses webhooks to notify your chosen URL that a report is ready for download.The time it takes for a report to be generated depends on the quantity of data. If exporting large amounts of data via API, ensure you have these webhook event types set up to know when to fetch the report:
  • REPORT_GENERATED – Indicates that a report is ready for download at the DownloadURL
  • REPORT_FAILED – Indicates that a report was not generated successfully
2

Define filters and columns

The Collected Fees report can be filtered by:
  • Currency – Filter the report to the Fees Wallet of one currency.
If the currency filter is not sent, the report contains data on all currencies.The columns set by default are listed above. You can customize this in the Columns parameter by sending the full list of columns you wish to see in the report.
3

Run the report

Run the report by calling the POST Create a Report endpoint with the ReportType set to COLLECTED_FEES.Send your desired date period in the AfterDate and BeforeDate fields, which refers to the transaction CreationDate. Ensure that the difference between them is no more than 12 months and the AfterDate is not more than 24 months ago.Send your defined filters in the Filters parameter and, if not using the default columns, the full list of columns you wish to include in the Columns parameter.
COLLECTED_FEES
{
    "Tag": "Created using the Mangopay API Postman collection",
    "DownloadFormat": "CSV",
    "ReportType": "COLLECTED_FEES",
    "AfterDate": 1740787200,
    "BeforeDate": 1743544740,
    "Filters": {
        "Currency": "EUR"
    }
}
The API response shows the Status as PENDING, indicating that the report is being generated.
COLLECTED_FEES
{
    "Id": "report_01JVVQDDZ4AT67C2W62ZNK2DC2",
    "Tag": "Created using the Mangopay API Postman collection",
    "CreationDate": 1747908474,
    "ReportDate": null,
    "Status": "PENDING",
    "ResultCode": null,
    "ResultMessage": null,
    "DownloadFormat": "CSV",
    "DownloadURL": null,
    "ReportType": "COLLECTED_FEES",
    "Sort": "CreationDate:DESC",
    "AfterDate": 1740787200,
    "BeforeDate": 1743544740,
    "Filters": {
        "Currency": "EUR"
    },
    "Columns": [
        {
            "Name": "ClientId",
            "IsDefault": true
        },
        {
            "Name": "TransactionId",
            "IsDefault": true
        },
        {
            "Name": "CreationDate",
            "IsDefault": true
        },
        {
            "Name": "ExecutionDate",
            "IsDefault": true
        },
        {
            "Name": "AuthorId",
            "IsDefault": true
        },
        {
            "Name": "DebitedWalletId",
            "IsDefault": true
        },
        {
            "Name": "CreditedWalletId",
            "IsDefault": true
        },
        {
            "Name": "CreditedFundsCurrency",
            "IsDefault": true
        },
        {
            "Name": "CreditedFundsAmount",
            "IsDefault": true
        },
        {
            "Name": "DebitedFundsCurrency",
            "IsDefault": true
        },
        {
            "Name": "DebitedFundsAmount",
            "IsDefault": true
        },
        {
            "Name": "FeesAmount",
            "IsDefault": true
        },
        {
            "Name": "FeesCurrency",
            "IsDefault": true
        },
        {
            "Name": "Type",
            "IsDefault": true
        },
        {
            "Name": "Nature",
            "IsDefault": true
        },
        {
            "Name": "PaymentType",
            "IsDefault": true
        },
        {
            "Name": "Tag",
            "IsDefault": true
        }
    ]
}
4

Download when ready

The report is ready for download when its status changes from PENDING to GENERATED, which triggers the REPORT_GENERATED webhook.Call the GET View a Report endpoint to retrieve the DownloadURL value where you can download the report.If the Status changes to FAILED, triggering the REPORT_FAILED webhook, then more information about why the report could not be generated is available in the ResultCode and ResultMessage.
5

Repeat process as needed

The Collected Fees report is valid for 31 days. After this, its Status changes to EXPIRED at it is no longer available for download.You can re-generate another report with the same parameters and update the date range for the latest period.
Note – You can schedule reports in the DashboardThe Dashboard features a scheduling feature that enables you to automatically generate the same report daily, weekly, monthly, or quarterly.