How to Reconcile Amazon Settlement Reports for Unseen Discrepancies


To reconcile Amazon settlement reports, sellers should download the full settlement report, match every transaction type against internal sales and fee records, and flag line items that don't tie back to a known order or expected fee rate. Hidden ledger adjustments—such as reserve holds, shipping label corrections, and A-to-z Guarantee refunds—often hide in aggregated totals, so sellers need to isolate each transaction category to catch them.
Amazon's settlement reports look straightforward at first glance: a deposit amount, a date range, a handful of summary totals. But underneath that summary sit thousands of individual transactions, and not all of them are what they appear to be. Shipping fee corrections, inventory reimbursements, and reserve adjustments get buried in broad categories, which makes it easy for sellers to miss money they're owed—or worse, miss charges they shouldn't be paying.
This guide walks through how to read an Amazon settlement report line by line, where discrepancies typically hide, and how to build a repeatable audit process that protects your margins.
What is an Amazon settlement report, and why does it need reconciling?
An Amazon settlement report is a summary of all financial transactions tied to your seller account over a specific settlement period, usually every two weeks. It includes product sales, Amazon's fees (referral, fulfillment, storage), refunds, reimbursements, and various adjustments.
Reconciliation means confirming that the numbers in the settlement report match what actually happened in your business: the orders you shipped, the fees you expected to pay, and the inventory you sent to Amazon's warehouses. Without reconciliation, sellers rely entirely on Amazon's math being correct every time—and across millions of transactions processed daily, errors happen more often than most sellers assume.
For FBA sellers especially, reconciliation isn't optional bookkeeping hygiene. It's how you recover money lost to overcharged fees, lost inventory, and processing errors that Amazon won't proactively flag for you.
How do you read an Amazon payment settlement statement?
Start by downloading the full settlement report from Seller Central (Reports > Payments > Date Range Reports), not just the summary view. The summary tells you the total deposit; the full report breaks that deposit into individual transactions.
Each row in the detailed report includes:
Transaction type: Order, Refund, Adjustment, Service Fee, FBA Inventory Fee, and others.
Order ID: Links the transaction to a specific customer order, where applicable.
Amount type and description: Specifies whether the line is a principal payment, a tax, a fee, or a promotion.
Posted date vs. transaction date: These can differ, especially for adjustments tied to orders from previous periods.
The key skill here is separating transactions by type before trying to evaluate totals. Lump-summing an entire settlement period without breaking it into categories is the single biggest reason discrepancies go unnoticed—averages and aggregates smooth over individual errors.
Where do hidden ledger adjustments come from?
Amazon's "Adjustment" transaction type is the catch-all category where most unseen discrepancies live. It covers:
Reserve releases and holds: Amazon withholds a portion of funds as a rolling reserve, then releases it later. If the release amount doesn't match the original hold, that's a discrepancy worth investigating.
FBA inventory reimbursements: When Amazon loses or damages inventory, it may issue a reimbursement—but the reimbursed amount doesn't always match your actual cost of goods.
Shipping label and dimension corrections: Amazon periodically re-measures or re-weighs inventory and retroactively adjusts fulfillment fees, sometimes for shipments from months earlier.
A-to-z Guarantee claims: Customer-initiated refunds that bypass your normal return process and get deducted directly from your settlement.
Because these transactions are coded generically and often reference order IDs that have already been closed out in your books, they're easy to overlook. A seller reconciling only at the summary level will never see them individually.
How do you audit Amazon settlement reports for fee errors?
Choose a reconciliation cadence—settlement-by-settlement is best—and build a repeatable checklist:
Export the full detail report for the period, not just the summary.
Sort by transaction type and total each category separately: sales, refunds, FBA fees, referral fees, storage fees, and adjustments.
Compare referral fees to expected rates. Amazon publishes referral fee percentages by category; if a fee doesn't match the published rate for that product's category, flag it for review.
Cross-check FBA fulfillment fees against your product's size tier. Amazon occasionally misclassifies dimensions or weight, which inflates fulfillment costs.
Match refunds to actual customer returns. Confirm that refund amounts align with the original order value and that Amazon isn't refunding the full amount when only a partial refund was issued.
Isolate every "Adjustment" line and research its origin. This is where reserve changes, reimbursements, and corrections surface.
Reconcile the settlement total against your internal accounting system, whether that's QuickBooks, Xero, or a seller-specific tool.
Sellers managing high order volume may find it worthwhile to automate steps 2 through 6 using a reconciliation tool, since manually parsing thousands of line items every two weeks isn't sustainable at scale. Choose automation if your order volume exceeds a few hundred transactions per settlement period; manual review remains workable for smaller catalogs.
How do you match Amazon settlement data to your internal financials?
Reconciliation only works if your internal records are structured to meet the settlement report halfway. That means:
Recording sales by order ID, not just by date, so you can match individual transactions.
Tracking expected fee rates per SKU, so deviations are easy to spot.
Logging inventory shipments to Amazon's fulfillment centers with expected unit counts, so lost or damaged inventory reimbursements can be checked against actual loss.
When your bookkeeping system and Amazon's settlement data use the same reference points, discrepancies surface as simple mismatches instead of buried needles in a pile of aggregated numbers.
How do you dispute hidden charges in Amazon settlement reports?
Once you've identified a discrepancy, Amazon provides a process for disputing it, though the route depends on the type of error:
Fee errors (incorrect referral or fulfillment fees) are typically disputed through Seller Central's case log, referencing the specific order ID and expected fee calculation.
Lost or damaged inventory disputes require filing within Amazon's reimbursement policy window—missing this window usually forfeits the claim.
A-to-z Guarantee charges can sometimes be appealed if you have documentation showing the claim was invalid.
Document every dispute with the original settlement report excerpt, the expected calculation, and the discrepancy amount. Amazon's support teams move faster when the case includes specific numbers rather than a general complaint.
Building reconciliation into your regular bookkeeping
Treat settlement report reconciliation as a recurring task, not a one-time audit. Set a calendar reminder tied to Amazon's settlement cycle, and review each report within a few days of it closing—discrepancies are easier to dispute and resolve the sooner they're caught. Over time, this process doesn't just recover lost revenue; it gives you a clearer, more accurate picture of your actual margins per SKU, which is something few sellers have without doing this work.
Frequently asked questions
How often should I reconcile my Amazon settlement reports? Reconcile every settlement period, typically every two weeks, rather than waiting for month-end or quarter-end reviews. Discrepancies are easier to dispute and resolve closer to when they occurred.
What's the biggest cause of unseen discrepancies in Amazon settlement reports? The "Adjustment" transaction category is the most common source. It bundles reserve changes, inventory reimbursements, and fee corrections into generic line items that are easy to overlook without a detailed audit.
Can I recover money lost to Amazon fee errors? Yes, if you catch the discrepancy within Amazon's dispute window and provide documentation referencing the specific order ID and expected fee calculation.
Do I need accounting software to reconcile Amazon settlement reports? Not strictly, but matching settlement data to internal records is far easier when your sales and inventory are tracked by order ID and SKU in a dedicated system, such as QuickBooks, Xero, or a seller-specific reconciliation tool.
Who should be reconciling Amazon settlement reports: the seller or an accountant? Either can do it, but whoever handles it needs to understand Amazon's specific transaction types and fee structures. Choose a dedicated e-commerce accountant if your order volume or SKU count makes manual review impractical.



Comments