Are you looking for test card numbers?

Would you like to contact support?

Marketpay icon

Reconcile fees

Reconcile fees debited from your platform's liable account.

This page is for the classic Adyen for Platforms integrations. If you are just starting your implementation, refer to our new integration guide instead.

Your platform incurs fees, such as processing fees for each received transaction and fees for premium features.

Adyen deducts fees from settlement and debits them from your platform's liable account. To reconcile these fees, you can get the totals and the breakdown from the following reports.

Invoice deduction

The monthly invoice takes into account the fees that were already deducted in the Payment accounting report and Settlement details report. Aside from fees, the monthly invoice also includes rebates, which you can get if you achieve preferable tiered pricing during any given month.

Any outstanding debits for fees or credits for rebates outlined in the monthly invoice will be debited or credited from the settlement. These are reported as InvoiceDeduction types in the Settlement details report.

Reconcile total fees

To reconcile the total fees debited from your liable account, we recommend using the Settlement details report. If you want, you can also match the total fees with the Marketplace Payments accounting report.

When reconciling total fees, make sure you check:

  • That the reports are from the same reporting period.
  • The time zone of the reports.

Reports are generated at different periods and can be based on different time zones; if reconciliation fails, mismatches in reporting periods or time zones are the common causes.

To reconcile total fees:

  1. Calculate the total fees from each Settlement details report.
    • Total fees = Total of Gross Credit columns - Total of Gross Debit columns - XASTransfer row
      The XASTransfer row is the the net amount settled to the accounts in your platform.

  2. Get the sum of the total transactional fees, other fees, and the monthly invoice deduction (if present) from each Settlement details report.
    • Total fees = Total of Commission + Markup + Scheme Fees + Interchange columns + Fee + InvoiceDeduction rows

  3. Calculate the total of the Fee record types and the monthly invoice deduction (if present) from each Marketplace Payments accounting report.
    • Total fees = Total of Fee + InvoiceDeduction rows

The Total fees in the 3 computations should match.

Examples

We show selected rows and columns below to illustrate how you reconcile fees debited from your platform's liable account. To get complete reports, refer to Reporting documentation.

Selected columns from Marketplace Payments accounting report

Let's take, for example, the 9.72 EUR fee deducted from the settlement for your platform's liable account. To reconcile these fees, start with getting the Payment PSP reference and the Payment merchant reference number.

In the sample report below, we group the transactions that have the same references by using different colors for each.

Account holder Account Payment PSP reference Payment merchant reference number Main currency Main amount Record type

LiableAccountHolderPlatform

1234567

852584129291587A

REF_001

EUR

60

Credited

AccountHolder_1

7891012

852584129291587A

REF_001

EUR

240

Credited

LiableAccountHolderPlatform

1234567

853781278121997C

REF_002

EUR

-2

Debited

AccountHolder_2

3823129

853781278121997C

REF_002

EUR

-48

Debited

LiableAccountHolderPlatform

1234567

852584132050336H

REF_003

EUR

30

Credited

AccountHolder_2

3823129

852584132050336H

REF_003

EUR

120

Credited

LiableAccountHolderPlatform

1234567

EUR

-9.72

Fee

AccountHolder_1

7891012

EUR

-240

Payout

Next we take the Settlement details report to match the Payment PSP reference and the Payment merchant reference number.

Selected columns from Settlement details report

In the Settlement details report, match the PSP reference and Merchant reference with the references from the Marketplace Payments accounting report. We find that the fees are associated with three settled transactions: two payments and one refund.

Merchant account PSP reference Merchant reference Type Gross currency Gross debit Gross credit Net currency Net debit Net credit Commission Markup Scheme Interchange

YourMerchantAccount

852584129291587A

REF_001

Settled

EUR

300

EUR

297.6

0.6

0.2

1.6

YourMerchantAccount

853781278121997C

REF_002

Refunded

EUR

50

EUR

54

4

YourMerchantAccount

852584132050336H

REF_003

Settled

EUR

150

EUR

147

3

YourMerchantAccount

Fee

EUR

0.32

YourMerchantAccount

XASTransfer

EUR

390.28

We can then break down the Fee row in the Marketplace Payments accounting report by computing the following from the Settlement details Report:

  • Settlement details Commissions + Markup + Scheme + Interchange columns + Fee row = Marketplace Payments accounting report Fee
  • 9.4 EUR + 0.32 EUR = 9.72 EUR

If you want to go further, we can take the Payment accounting report to track the remaining 0.32 EUR unreconciled fee.

Selected columns from Payment accounting report

We show selected rows and columns below to illustrate finding the processing fees. In a full report, if you filter on a reference, you get multiple rows for different payment statuses. To get a complete report, refer to Payment accounting report.

In the Payment accounting report, we find the processing fees associated with settled transactions and for a refused transaction (in red).

The total processing fees incurred for all transactions is equal to 0.32EUR.

Merchant account PSP reference Merchant reference Record Type Payment Currency Received Processing Fee Currency Processing Fee

YourMerchantAccount

852584129291587A

REF_001

Received

EUR

500

EUR

-0.08

YourMerchantAccount

853781278121997C

REF_002

SentForRefund

EUR

0

EUR

-0.08

YourMerchantAccount

852584132050336H

REF_003

Received

EUR

150

EUR

-0.08

YourMerchantAccount

881584131869379D

REF_004

Received

EUR

100

EUR

-0.08

YourMerchantAccount

881584131869379D

REF_004

Refused

EUR

-100

See also