Last updated: 2026-08-12 · Column list from Amazon's official SP-API documentation. Value enumerations are not published by Amazon and are collected from third-party documentation and from real reports. Corrections and new values are welcome — they get added here.
| Item | Value |
|---|---|
| Current report type | GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 (Seller Central sellers) |
| Deprecated | GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE, GET_V2_SETTLEMENT_REPORT_DATA_XML |
| Delimiter | Tab |
| How it is produced | Automatically scheduled by Amazon — it cannot be requested on demand |
| Where to download | Seller Central → Payments → All Statements → Download Flat File V2 |
| Retention | Roughly the last 90 days (about six settlement periods) |
The file extension is commonly .txt or .csv while the contents are tab-separated. Detect the delimiter, do not trust the extension.
settlement-id · settlement-start-date · settlement-end-date · deposit-date · total-amount · currency · transaction-type · order-id · merchant-order-id · adjustment-id · shipment-id · marketplace-name · amount-type · amount-description · amount · fulfillment-id · posted-date · posted-date-time · order-item-code · merchant-order-item-id · merchant-adjustment-item-id · sku · quantity-purchased · promotion-id
Amazon's documentation lists these column names but does not give data types or nullability.
| amount-type | amount-description values seen |
|---|---|
ItemPrice | Principal · Shipping · GiftWrap · Goodwill · RestockingFee · Tax · ShippingTax |
ItemFees | Commission · FBAPerUnitFulfillmentFee · FBAWeightBasedFee · GiftwrapChargeback · ShippingChargeback · RefundCommission · VariableClosingFee · MarketplaceFacilitatorVAT-Principal · MarketplaceFacilitatorVAT-Shipping · DigitalServicesFee |
Shipment-Fees | FBAPerOrderFulfillmentFee · FBATransportationFee |
other-transaction | Current Reserve Amount · Previous Reserve Amount Balance · Storage Fee · Refund Reimbursal · StorageRenewalBilling · DisposalComplete · ShippingHB · Subscription Fee |
Promotion | (seen as a type; descriptions vary by account) |
These gaps are the reason most reconciliation tools quietly get things wrong. Stating them plainly:
| Gap | Consequence |
|---|---|
No official enumeration for transaction-type. The Order / Refund / Transfer / Liquidations list circulating online has no citable Amazon source. | Any tool that hard-codes those four will silently drop rows it doesn't recognise. This parser classifies nothing and shows every value. |
No official enumeration for amount-type or amount-description. | New fee codes appear without notice. A hard-coded mapping goes stale silently. |
| No documented sign convention. | Whether a fee is negative is inferred, not specified. |
| No documented character encoding. | Non-ASCII SKU or product names can corrupt on import. |
| No documented summary-row structure. In practice the first row carries only settlement-id, the dates, total-amount and currency. | Read as a data row, it double-counts the total. |
| No data types or nullability for any of the 24 columns. | Parsers guess. |
Under amount-type = other-transaction you will find Current Reserve Amount and Previous Reserve Amount Balance. Amazon withholds part of the money and releases it in a later period. Compute "order revenue minus fees" without these and the total will never equal the deposit. This is the single most commonly missed item.
posted-date is when an individual line occurred. Settlement is cut by settlement-start-date → settlement-end-date. These do not have to coincide, and across a month boundary they usually don't. If your ERP aggregates by posted-date while Amazon settles by period, the two use different definitions — nothing is wrong with the data. Aggregate by settlement period.
A single order-id appears as several rows — Principal on one, Commission on another, the FBA fee on a third. To attribute to a SKU you must group by order-id plus order-item-code. Grouping by order-id alone merges an order containing two different items.
quantity-purchased is restated on every row belonging to the same order item. Summing the column multiplies the quantity by the number of rows. De-duplicate by order-id + order-item-code first. This one is easy to miss because nothing errors — you just get a plausible wrong number.
Flat File V2 has one currency column and no exchange-rate column. Figures from different settlements in different currencies cannot be summed. Group by currency and keep them apart.
I build data pipelines and reconciliation tooling, and I spent several years in cross-border e-commerce before that. This parser runs entirely in your browser because financial exports are not something you should have to upload to a stranger. If you find a fee code that isn't listed above, send it over to support@nexusaistart.com — the reference gets updated and everyone benefits. If you need several accounts archived and merged automatically each month, that's the paid version of this: support@nexusaistart.com
Version 1.3 · 2026-08-12 · Contact support@nexusaistart.com
The fee-code reference below is updated as new values turn up. Your copy is static; the current one is always at nexusaistart.com/tools/amazon-settlement-parser/