You sold something today. You check for the fees and the profit on it, and they’re not there. You check tomorrow. Still not there. You start to wonder if something’s broken.
Nothing’s broken. You’ve just run into how Amazon’s data actually flows — and once you understand the order it arrives in, the “missing” numbers stop being a mystery and start being predictable.
The data gets cleaner as it climbs a ladder
Your profitability data isn’t one source. It’s a ladder, and each rung is cleaner than the one below it.
Rung 1 — Order reports. Fast and immediate. The moment an order is placed, it’s here. But it knows nothing about fees — just what sold and for how much.
Rung 2 — Raw transactions. This is where the fee truth lives: every referral fee, fulfillment fee, refund, and adjustment. But it’s messy. A single order can spread across several separate rows — one for the sale, others for each fee, discount, or refund component — and it arrives delayed (more on that in a second).
Rung 3 — sl_transactions_pivot. The Data Hub collapses that mess into one clean row per order. All those scattered transaction lines, reconciled and readable.
Rung 4 — The profit views. sl_daily_sku_profit and sl_daily_venue_profit build on the clean pivot, then join in storage fees and both advertising sources. This is the top of the ladder — the trustworthy number.
When a report seems “wrong,” it’s almost always because you’re reading a lower rung than you think, or because the higher rung hasn’t been populated yet. Which brings us to the delay.
Why today’s sale isn’t in your fee data yet: DD+7
Here’s the rule that explains the lag. Amazon now holds your funds under a policy called DD+7 — the “delivery date based reserve.” (You’ll see third-party tools abbreviate it “DDBR,” but Amazon’s own wording is just “DD+7 / reserve period of seven days after delivery date.”)
The mechanics: a transaction’s money moves from “deferred” to “available” 7 calendar days after the order is confirmed delivered — not 7 days after it ships, and not 7 days after the sale. (For untracked, low-cost items, Amazon measures from the estimated delivery date.) There’s no seller opt-out, and it applies to both FBA and FBM. If you’ve been selling for a while, you may remember your payouts getting slower at some point as Amazon rolled this out — this is why.
Stack that on top of Amazon’s normal ~14-day disbursement cycle, and the gap between “I made the sale” and “the money and its fees are settled and visible” is routinely 7 to 14+ days. So:
- Orders show up immediately (Rung 1).
- Transactions and settlement — the fees, the real profit — show up days later, after delivery + DD7 + the disbursement cycle.
This is why “what I sold today” and “what I’ve actually been paid for” are never the same number on the same day. It’s not your reporting lagging. It’s Amazon holding the money.
One more source of “my numbers don’t match”: ads
A small heads-up you’ll need later. Your advertising spend shows up in one of two different places depending on how you pay for it — drawn from your Amazon balance (deducted from your payout) or billed to a credit card (never touches your payout). It’s one path or the other, not both, and that’s the classic “my ad spend doesn’t add up” trap — depending on your setup, your payout might not mention your ad cost at all. We resolve it completely in Module 5, when we read venue profit. For now, just file it away: ad spend lives in one of two places depending on how you pay.
Try this in your account
Open Claude with the Amazon MCP Server connected and watch the lag happen live:
“Show me my orders from the last 3 days, then show me which of those orders already have transaction and fee data attached.”
You’ll see fresh orders sitting there with no fee data yet — the DD7 delay, visible in your own account. Wait a week and ask again, and the fees will have filled in. Once you’ve seen it with your own SKUs, the delay stops feeling like a glitch and starts feeling like a schedule you can plan around — which is exactly why we read venue profit monthly, not daily.
Part 4 of 7 in Level 1: Understanding Amazon Profitability.
← Previous: The Fee Maze: SKU-Level vs Account-Level Fees | Next: SKU Profit: Which Products to Keep, Kill, or Cuddle →