Your Settlement Report is the financial truth of your Amazon business. Everything else — your orders, your inventory, your ads — eventually shows up here as money in or money out. Download it from Reports → Payments → Settlement and open it in Excel or Google Sheets.
The 4 columns that matter most
Transaction type
This tells you what each row is. The ones to pay attention to: order (revenue), refund (money you paid back), FBA inbound transportation fee, FBA fulfillment fee, storage fee, and FBA_REIMBURSEMENT. Filter by each one separately to understand your cost breakdown.
Amount
Negative numbers are money Amazon took from you. Positive numbers are money owed to you. Simple enough — but the dangerous ones are small negative amounts repeated thousands of times. Filter by transaction type = "FBA fulfillment fee" and look for unexpected variations in fee amounts for the same ASIN. If your product's fee keeps changing, Amazon may have miscategorized your product's size.
Quantity
Always cross-reference quantity against your order reports. If you see refund transactions where quantity = 1 but no corresponding positive adjustment in your FBA Inventory Ledger, that's a reimbursement case — you were refunded for a unit you never got back.
Order ID / ASIN
For any row that looks wrong — unexpected fee, large refund, missing reimbursement — you can trace it back to the original order using the Order ID. This is your audit trail. Document everything you dispute with the relevant Order ID and transaction date.
Three things to check every payout cycle
1. Total refunds vs last cycle — A sudden spike in refunds for one ASIN usually means a product quality issue or a fake return scheme. Catch it early.
2. Storage fees vs inventory level — If your storage fees went up but your inventory went down, something's wrong. Amazon may be billing you for inventory that's already been removed or disposed of.
3. FBA fulfillment fees by ASIN — Sort by ASIN and look for any ASIN where the fee per unit has changed unexpectedly. This is how you catch fee discrepancies before they compound over hundreds of orders.
The 14-day window matters
Amazon's reimbursement claims process has time limits — most cases must be filed within 18 months of the transaction, but the sooner you spot discrepancies, the easier it is to resolve them with accurate supporting data. Make the Settlement Report check a monthly ritual.
Let Vikreya do the reconciliation for you
Upload your Settlement Report and FBA Inventory Ledger. Get every fee anomaly, discrepancy, and reimbursable case flagged automatically — no spreadsheet expertise needed.
Analyze my settlement report →