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
- In Seller Central, open Payments → All Statements.
- Pick the account type (electronic transactions, or cash on delivery) and the dates, then search.
- 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:
| Column | What it tells you |
|---|---|
order-id | The Amazon order, such as 402-1234567-1234567. Empty for account-level charges. |
posted-date | When Amazon booked the amount, not when the order was placed. |
sku, quantity-purchased | The product and how many units. |
fulfillment-id | AFN for FBA, MFN for orders you ship yourself (Easy Ship or Self Ship). |
transaction-type | Order, refund, or another kind of transaction. |
amount-type | The group the amount belongs to: price, fees, promotion or other. |
amount-description | What exactly the amount is. |
amount | The 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-type | Common amount-description | What it is |
|---|---|---|
| ItemPrice | Principal, Shipping, GiftWrap | What the customer paid for the item, its delivery and gift wrap. Negative on a refund. |
| ItemFees | Commission | The referral fee. |
| ItemFees | FixedClosingFee, VariableClosingFee | The closing fee per unit. |
| ItemFees | FBA and delivery fees | Fulfilment and shipping charges. |
| ItemFees | RefundCommission | Amazon's fee for processing a refund. |
| Promotion | Your promotions | Discounts you funded. Not a fee. |
| other-transaction | Reserves, reimbursements, account fees | Money 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
No responses yet. Questions from other sellers are welcome.