Adyen settlement detail report
Adyen's per-batch reconciliation file showing every settled movement, sales, refunds, chargebacks, fees and the payout, for one settlement batch. People look for an "amount" column that does not exist.
The shape, how the file is really laid out
One row per settled event, keyed by Psp Reference (the original payment) and
Modification Reference (the capture/refund/chargeback that settled). Columns
include Merchant Account, Creation Date, TimeZone, Type, Gross Currency, Gross
Debit (GC), Gross Credit (GC), Exchange Rate, Net Currency, Net Debit (NC),
Net Credit (NC), and itemized fees, Commission (NC), Markup (NC), Scheme Fees
(NC), Interchange (NC), plus Batch Number. There is NO single signed amount:
money-in is a Credit, money-out is a Debit, in SEPARATE columns. Type carries
the event: Settled (the capture, money in), Refunded, Chargeback,
SecondChargeback, RefundedReversed, Fee, MerchantPayout, Balancetransfer,
DepositCorrection, InvoiceDeduction. Gross Currency (what was paid) can differ
from Net Currency (what is settled/paid out), reconciled by the Exchange Rate
column; fees are always in Net Currency.
The traps
"Sum the amount" is impossible and "sum one column" is wrong, you must net Net Credit − Net Debit, and only within a single Net Currency.
- Every trap in this export, worked through
- The reconciliation anchor, the total the file asserts about itself
- The refusal cases, when to stop and ask instead of guess
Reference: Adyen Docs, Settlement detail report: structure, Type values, and gross/net debit-credit columns · Adyen Docs, Interchange++ fees and settlement currency / Exchange Rate fields