Download the Adyen Settlement Detail Report (CSV) for the settlement batch from the Adyen Customer Area or via the Report API; the report contains one row per transaction with processing currency and settlement currency amounts.
Identify the exchange rate applied per transaction by dividing the settlement currency amount by the processing currency amount for cross-currency rows.
Group transactions by processing currency to compute total gross sales, refunds, and fees in each currency before conversion.
Net the FX conversion gain or loss per batch: compare the settlement currency total against the equivalent amount at the mid-market rate on the settlement date.
Map each batch to the corresponding bank deposit using the batch reference number; reconcile the netted settlement amount against your bank statement credit.
Post FX differences to a foreign exchange gain/loss ledger account in your accounting system, separate from revenue.
Known gotchas
Adyen settles in the configured settlement currency, which may differ from both the processing currency and the cardholder's home currency — ensure your report parsing handles three-currency transaction rows.
Adyen's interchange and scheme fee lines appear in the same settlement report as transaction lines but must be separated before revenue recognition — filter by record type field.
Settlement report availability has a lag after the settlement date; build an automated check for report availability before attempting reconciliation rather than running on a fixed schedule.
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp