Amazon settlement report (Flat File V2, Payments > Reports Repository)
The tab-delimited statement covering one disbursement cycle, every charge, fee, refund and adjustment that nets to a single bank deposit. It is mistaken for a monthly sales report; it is a settlement-period cash statement.
The shape, how the file is really laid out
Tab-separated (.txt/TSV), not comma. The FIRST data row is a summary header
where settlement-id, settlement-start-date, settlement-end-date, deposit-date,
total-amount and currency are filled and the per-transaction columns are blank.
Every following row is a transaction line where those summary columns are blank
and transaction-type, order-id, sku, amount-type, amount-description, amount,
quantity-purchased, posted-date and marketplace-name are filled. A single order
is SPLIT ACROSS MANY ROWS keyed by amount-type/amount-description: one row for
ItemPrice/Principal (positive), separate rows for ItemPrice/Tax, Promotion
(negative), and ItemFees lines such as the referral Commission and the FBA
per-unit fulfilment fee (both negative). The settlement window is set by the
disbursement schedule, so start/end dates straddle calendar months.
The traps
Sign trap: revenue is positive, every fee/refund/promo is NEGATIVE, and the load-bearing key is the free-text amount-description, sum "amount" blindly and you net fees against sales without meaning to.
- 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: Amazon Seller Central Help, Flat File V2 Settlement Report / statement column definitions (documentation)