Amazon Seller Settlement Report Converter
Convert Amazon Seller Flat File V2 settlement reports into a clean 3-tab Excel dashboard. Revenue, fees, net payout, plus the 2026 Released vs Deferred split.
About Amazon Seller payouts
Amazon's bi-weekly settlement reports are notoriously hard to read — 24 columns, thousands of rows, no totals. SettlementToExcel parses the Flat File V2 .txt that Seller Central gives you and returns a 3-tab Excel: Summary (Total Revenue, Refunds, Fees, Net Payout, Released vs Deferred), Fee Breakdown (every Amazon charge grouped), and SKU Analysis (per-SKU net after Amazon fees). File is processed in memory and never stored.
Where to find your file
Seller Central → Reports → Payments → Date Range Reports → Generate Report → Type: Transaction → Format: Tab Delimited
Expected format: Tab-delimited .txt (Flat File V2 Settlement Report)
What fees and charges show up
- Commission (Referral Fee)
- FBA Per-Unit Fulfillment Fee
- FBA Storage Fee + Long-Term Storage Fee
- Subscription (Professional Selling Plan)
- Marketplace Facilitator Tax (Amazon collected, you didn't earn)
- Reimbursements (lost/damaged inventory)
- Refund Commission (Amazon's cut on returns)
How it will work
- Export your payout report from Amazon Seller
- Drop the file on our converter — no login, no API
- Processed entirely in memory and discarded on download
- Download a 3-tab Excel: Summary, Fee Breakdown, per-item analysis
📋 Important — please read
- This tool is provided for accounting assistance and educational purposes only.
- It does not constitute financial, tax, legal, or accounting advice. Consult a licensed professional for advice specific to your situation.
- Always verify any figures against your official Amazon Seller Central reports and your bank statements before filing taxes.
- We are not affiliated with, endorsed by, or sponsored by Amazon.com, Inc. “Amazon” is a trademark of its respective owner.
- See our full disclaimer and terms of service.
Other marketplaces
- TikTok Shop — Convert your TikTok Shop seller payout reports into a clean Excel dashboard. Revenue, platform fees, refunds, and net payout per SKU.
- Whatnot — Turn your Whatnot seller payout CSV into a clean Excel dashboard. Sale price, fees, shipping, refunds, and net per show.
- Shopify Payouts — Reconcile Shopify Payouts to your actual sales. Convert your payout CSVs into a clean Excel with fees, refunds, chargebacks, and net deposit per period.
- eBay — Convert your eBay Managed Payments transaction reports into a clean Excel dashboard. Item price, final value fees, refunds, shipping, and net per listing.