Finance · Reconciliation
Why your Amazon payout never matches your sales report
Open your bank statement next to your Amazon sales report for the same period and the two numbers almost never match. Most sellers assume this is just "Amazon being Amazon" and move on, crediting the difference to fees they've already accounted for. In practice, the gap is usually a mix of things that were never actually checked — and some of them are money that should have come back to you.
A settlement period isn't a sales period
The first mismatch is structural. Amazon pays out on a roughly fortnightly settlement cycle, not a calendar month, and a settlement period rarely lines up with when an order was actually placed. An order sold on the 30th might settle in the following period; a refund issued today can land against a sale from three settlement cycles ago. If you're comparing "sales this month" to "deposit this month," you're comparing two different date ranges by definition — before you've even looked at fees.
What's actually hiding inside the gap
Once the date-range mismatch is accounted for, the real differences tend to fall into a short list:
- Fee reversals and corrections. Amazon periodically re-charges or refunds referral and FBA fees after the fact — often with no notification beyond a line in the settlement file.
- Reimbursements owed to you. Lost or damaged FBA inventory, customer-service refunds Amazon issued without your approval, and weight/dimension fee corrections can all generate reimbursements that are easy to miss if you're not checking line by line.
- Returns processed in a different period than the original sale. A return refunded this month against a sale from last month throws off any report that doesn't explicitly connect the two.
- Storage and long-term storage fees charged against the settlement rather than shown anywhere in your order-level sales data.
None of these are unusual. What's unusual is checking for them — because doing it properly means pulling the raw settlement report, matching every line against the orders it references, and flagging whatever doesn't reconcile. Most sellers don't have the time to do that every settlement cycle, so it only gets done, if at all, once a quarter or once a year, by which point disputing a missed reimbursement is much harder.
Why spreadsheets break down here specifically
Settlement reconciliation is the kind of task spreadsheets are worst at: it needs every order, every refund and every fee line matched against the raw settlement file, for every settlement period, on an ongoing basis — not a one-time audit. A single missed period compounds, because the next period's opening balance no longer ties out either. Sellers running this manually tend to do it once, find a handful of real discrepancies, and then let it lapse because the matching work doesn't get easier the second time.
What reconciling automatically actually catches
When every settlement line is matched against its order automatically, three things become visible that are almost invisible otherwise:
- Reimbursements Amazon owes you but never explicitly surfaces as a to-do item.
- Fee corrections that quietly reduced a payout you'd already mentally banked.
- Whether your true take-home payout, after every adjustment, actually matches your own profit numbers — so "true profit per product" and "what actually landed in the bank" are the same figure, not two separate exercises.
This is also where profit tracking and payout reconciliation stop being two different jobs. A profit number that doesn't reconcile to the actual deposit isn't a profit number you can fully trust — it's an estimate with an unexplained gap sitting underneath it.
How BI Adlytics handles this
BI Adlytics matches every settlement line against its originating order automatically, every settlement cycle, so the gap between "what we think we sold" and "what actually landed in the bank" is explained — not estimated. It's one piece of a wider platform that also covers advertising, true profit, inventory, returns and custom reporting, because reconciliation on its own only answers "did the money arrive" — not "where did the rest of it go."