Amazon FBA Settlement Report Sample TSV (Dirty + Clean)
A representative Amazon Seller Central settlement report (150 transactions, TSV format) covering all critical row types: Orders, Refunds, FBA Fees, Adjustments, and Transfers. The 'dirty' version includes Transfer rows (which cause double-counting if not filtered), TSV tab delimiters that Excel silently converts to spaces, and amount-description values with embedded commas that break re-parsing. The 'clean' version collapses to a profit summary ready for QuickBooks import. Ideal for auditing FBA fees or testing automated profit calculation scripts without exposing actual store revenue. All processing runs locally — your financial data never touches a server.
Live Interactive Preview
Live Data Preview
See how this messy amazon data looks before downloading. All processing happens locally in your browser.
💡 Pro Tip: Amazon dumps 28 columns of noise on you. Drop this file into Settlement Cleaner to extract a crisp profit summary (Fees, Commissions, Net) in one click.
⚡ Next Step: TSV acting weird in Excel? Run it through Format Cleaner to fix delimiters and strip invisible characters locally.
Data Schema Definition
| Column | Type | Description |
|---|---|---|
| settlement-id | string | Unique payout cycle identifier. Same ID spans multiple transaction types; never use as primary key alone. |
| type | string | Enum: Order | Refund | Transfer | Fee | Adjustment. Transfer rows are account movements, NOT sales — including them doubles revenue. |
| posted-date-time | timestamp | UTC timestamp in ISO 8601. Settlement cycles span midnight boundaries; daily rollups require date-truncation logic. |
| order-id | string | Amazon order reference. Always null for Fee and Transfer rows; LEFT JOIN to orders table must handle nulls gracefully. |
| sku | string | Seller-defined SKU. Case-sensitive; 'ABC-001' ≠ 'abc-001'. Normalize before grouping. |
| amount-type | string | Enum: ItemPrice | Promotion | ItemFees | Shipping. Determines whether amount is revenue or cost. |
| amount-description | string | Sub-category: Principal, Commission, FBAPerUnitFulfillmentFee. Contains embedded commas in some locales. |
| amount | decimal | Transaction value. Positive = credit, Negative = debit. Sign convention is consistent but counterintuitive for refunds. |
| currency | string | ISO 4217 code (USD, EUR, GBP). Multi-marketplace sellers get mixed currencies in same report. |
| total-amount | decimal | Running settlement total. Redundant but useful for validation; should equal SUM(amount) WHERE type != 'Transfer'. |