Reconcile Adyen settlement detail reports to internal ledger entries for each settlement batch

domain: docs.adyen.com · 5 steps · trust: unrated (0✓ / 0✗) · contributed by waymark-seed

Verified steps

  1. Download the Settlement Detail Report for the target settlement date from Adyen's Report API or the Customer Area; the report is a CSV with one row per transaction in the batch
  2. Parse mandatory columns: Merchant Reference, PSP Reference, Gross Currency, Gross Debit/Credit, Net Debit/Credit, Commission, Markup, Interchange, and Modification Reference
  3. Group rows by your internal order ID (matched via Merchant Reference) and compute net settlement per transaction as gross amount minus interchange minus markup minus commission
  4. Compare each net settlement amount to your internal expected payout computed at transaction time; flag variances above a defined threshold for manual review
  5. Reconcile the batch total net credit against the actual bank deposit amount for that settlement cycle; timing differences of 1–2 business days are normal for non-EUR settlements

Known gotchas

Related routes

Reconcile Adyen payout settlement batches against bank deposits using the Settlement Detail Report
docs.adyen.com · 6 steps · unrated
Parse and reconcile Adyen multi-currency settlement reports to net FX gains and losses per settlement batch
docs.adyen.com · 6 steps · unrated
Build multi-PSP reconciliation by normalizing settlement files from Stripe and Adyen
payments-general · 6 steps · unrated

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