Reconcile fees

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.

• Settlement details report: contains a breakdown of fees for settled transactions.
• Payment accounting report: contains a breakdown of all transaction-related fees, including those that have not settled.
• Payment processing invoice: contains totals for fees incurred during the month, including those charged on a monthly basis.

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.

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.

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.

See also