How to read an Amazon settlement report (flat file V2)

What each line and column of Amazon's flat file V2 settlement report means, the amount types, and three quick checks to see if a payout came up short.

Natium Labs

4 min read ·

Every Amazon payout comes with a settlement report. It is the one place that shows, line by line, how Amazon got from what your customers paid to what landed in your bank. It is easy to skip, because it looks like a wall of codes, but it reads easily once you know that every line is one amount, with three columns telling you what the amount is for.

This guide covers the flat file V2, the tab-separated version of the report that Seller Central offers for each settlement.

The column and amount names below are the ones Amazon's Seller Central help documents for the flat file V2. We haven't yet checked them against a downloaded Amazon.in file, so yours may differ slightly. If a name doesn't match, look for the nearest one.

Downloading it

  1. In Seller Central, open Payments → All Statements.
  2. Pick the account type (electronic transactions, or cash on delivery) and the dates, then search.
  3. For each settlement, choose Download Flat File V2. If the file isn't ready yet, request it first.

Menu names are Amazon's own and sometimes change. Keep the file as it is: opening and saving it in Excel can change long ids and dates, and then they no longer match anything.

The first line is the settlement itself

The first data line has no order on it. It holds the settlement's own details: the settlement-id, the start and end dates, the deposit-date and the total-amount Amazon sent to your bank. Everything below it should add up to that total.

Every other line is one amount

From the second line on, each line is a single amount for a single order, refund or adjustment. The columns that matter:

ColumnWhat it tells you
order-idThe Amazon order, such as 402-1234567-1234567. Empty for account-level charges.
posted-dateWhen Amazon booked the amount, not when the order was placed.
sku, quantity-purchasedThe product and how many units.
fulfillment-idAFN for FBA, MFN for orders you ship yourself (Easy Ship or Self Ship).
transaction-typeOrder, refund, or another kind of transaction.
amount-typeThe group the amount belongs to: price, fees, promotion or other.
amount-descriptionWhat exactly the amount is.
amountThe amount itself. Money to you is positive, money to Amazon is negative.

One order usually has several lines: one for the price, one for the commission, one for the closing fee, perhaps one for shipping and one each for TCS and TDS.

What the amount types mean

amount-typeCommon amount-descriptionWhat it is
ItemPricePrincipal, Shipping, GiftWrapWhat the customer paid for the item, its delivery and gift wrap. Negative on a refund.
ItemFeesCommissionThe referral fee.
ItemFeesFixedClosingFee, VariableClosingFeeThe closing fee per unit.
ItemFeesFBA and delivery feesFulfilment and shipping charges.
ItemFeesRefundCommissionAmazon's fee for processing a refund.
PromotionYour promotionsDiscounts you funded. Not a fee.
other-transactionReserves, reimbursements, account feesMoney held back or released, SAFE-T and lost or damaged reimbursements, and account charges such as storage.

TCS and TDS show as their own lines. Both are tax held back from your payout that you claim back later; our TCS and TDS guide explains how.

Three checks worth doing

The lines add up to the total. Add every amount below the first line. The sum should equal the total-amount on the first line. If the total is lower than the lines add up to, the settlement was paid short of its own lines.

Fees come back on refunds. When you refund an order, the refund normally carries a positive Commission line: the referral fee coming back to you, less the RefundCommission Amazon keeps for processing it. How much comes back follows Amazon's refund rules for your category, but a refund with no commission line at all is worth a closer look.

Closing fees match the price band. The closing fee depends on the item's price and how it was fulfilled. Check a few orders against the Amazon fee calculator, which has the bands from Amazon's fee page.

Reserves are held, not lost

Amazon can hold part of a settlement back as a reserve and release it in a later one. A reserve line is not a deduction you lose: look for its release in a later settlement before you treat it as missing.

Part of Settlement reports explained: what every marketplace, courier and payment-gateway report holds, where to download it, and how to check it.

Was this useful?

Written by Natium Labs

Natium checks every marketplace, courier and payment-gateway payout against the orders it came from, and shows you anything that came up short. We write about the fees and rules behind those payouts, with sources.

Responses

What are your thoughts?

We email you a link to confirm, then read each comment before it's shown. Privacy

No responses yet. Questions from other sellers are welcome.

Were you actually paid this?

A calculator shows what an order should pay. Natium checks what each payout really paid: upload the settlement report you already download, and see anything that came up short, with the proof. Finding shortfalls is free, no card.