Understanding Your Amazon Settlement Report: A Field-by-Field Guide
A comprehensive guide to reading Amazon's settlement report, explaining every field from settlement IDs and dates to item-level pricing, fees, and transaction types. Essential for accurate bookkeeping and financial reconciliation.
Overview
Amazon's settlement report is one of the most important financial documents available to sellers, providing a detailed breakdown of every transaction that affects your account balance during a settlement period. Understanding each field in this report is essential for accurate bookkeeping, tax preparation, and identifying discrepancies in your payments. This guide walks through every column you may encounter and explains what each data point means for your business.
Key Points / What Sellers Need to Know
- Each product gets its own line — The settlement report lists every individual product within an order on a separate row, including partial or full refunds, making it possible to trace revenue and fees at the item level.
- Not all fields appear for every seller — The columns visible in your report depend on your selling plan and inventory file templates, so you may not see every field described here.
- Settlement periods have defined date ranges — Each report covers a specific window between a start date and end date, with a separate deposit date indicating when funds actually transfer to your bank account.
- All transactions share one currency — Orders, adjustments, fees, and other account events within a single report are denominated in the same currency, simplifying reconciliation.
- Non-order events are included — Beyond product sales, the report also captures subscription fees, account-level adjustments, and other financial events that impact your balance.
Report Structure and Settlement Fields
Every settlement report is anchored by a unique settlement ID, a numeric identifier that can be up to 20 digits long. The report header includes three critical dates: the settlement start date, the settlement end date, and the deposit date. The deposit date tells you when Amazon will initiate the transfer of your net proceeds to your linked bank account. The total amount field shows the final figure being deposited, reflecting all sales revenue minus fees, refunds, and adjustments. For example, a total amount of 1,113.54 USD means that is the net sum arriving in your account for that period.
Analysis & Recommendations
Why This Matters
Settlement reports are the primary financial record for Amazon sellers. Understanding each field helps sellers catch fee errors, verify refund accuracy, and maintain proper accounting for tax compliance.
Key Takeaways
- Each product in an order gets its own line in the settlement report, including refunds
- The report includes non-order events like subscription fees and account adjustments
- All monetary fields support up to 18 digits before the decimal for precise financial tracking
- Order IDs containing letters may not be searchable in all Seller Central tools
Recommended Actions
- →Review your settlement reports each pay period to catch fee discrepancies or missing reimbursements
- →Cross-reference the posted-date and deposit-date fields to understand the timing gap between transactions and actual bank deposits
- →Use the SKU and order-item-id fields to reconcile Amazon data with your own inventory and accounting systems
Comments
Join the discussion
Log in or create an account to share your thoughts on this update.
No comments yet. Be the first to share your thoughts!