Amazon Seller Central to Snowflake

Amazon fees do not live in one SP-API report. We load each source for the question it answers, so fees by SKU, margin and payouts can all be checked against Amazon.

Book a Call

The short answer

Amazon seller data comes from three places: financial events or transactions for posted fees, settlement reports for the cash Amazon paid out, and FBA and Product Fees sources for estimates, storage and reimbursements. What usually breaks is mixing those three in one fee column, missing recent fees that post days after the sale, and backfill requests that return empty results instead of an error.

What you can load from Amazon Seller Central

Posted fees and transactions
Fee components recorded by the Finances API, used for fees by SKU between settlements. Recent orders can take up to 48 hours to appear.
Settlement reports
The cash Amazon tied to each deposit. Amazon generates these on its own schedule, so we list and download them rather than request them.
FBA fee, storage and reimbursement reports
Estimated selling and fulfillment fees, estimated monthly storage per ASIN, and itemized reimbursements with their reasons.
Fee estimates for a SKU
Product Fees estimates at a hypothetical price, useful before a price change. They are planning values and never reconcile to a payout.

How we set it up

  1. 1

    Pull settlements on a schedule

    We list the settlement reports Amazon has generated with getReports, download each with getReportDocument, and use each settlement as the boundary for its deposit.

  2. 2

    Load transactions with a lookback

    We load current transaction data from Finances API v2024-06-19 and revisit recent days on every run, so late fees land without being charged twice.

  3. 3

    Load FBA reports separately

    Storage estimates, reimbursements and estimated fees go into their own tables, labelled as estimates or adjustments, not as posted charges.

  4. 4

    Reconcile and label coverage

    We reconcile each settlement against the posted fees in its window and show which fee components have arrived for recent orders.

What breaks, and how we handle it

Settlement reports cannot be requested
createReport does not accept settlement report types. A job that keeps trying gets an error. Pull the reports Amazon already generated instead.
Wide date windows return nothing
In the legacy v0 financial events call, a PostedAfter to PostedBefore window over 180 days returns an empty response, not an error. We backfill in shorter windows.
Recent days look too profitable
Fees post days after the sale, so the latest days show sales without all their costs. We replace estimates one fee component at a time and label recent days as provisional.
Finances v0 is being retired
Amazon will remove listFinancialEvents and related v0 operations on August 27, 2027. New pipelines should use listTransactions in v2024-06-19.
Fees billed by Amazon for other channels
Amazon can bill fulfillment fees for orders sold on your website. We assign those costs by the sales channel of the order, not by the company that sent the invoice.

What we build on top of the Amazon Seller Central data

  • Fee ledger tagged as estimate, posted charge or settlement cash
  • Settlement reconciliation against posted fees
  • Contribution by SKU with fee coverage labels
  • Refresh bridge explaining why margin changed

Common questions

Why don’t my Amazon fees match my payout?

A payout is a settlement, not a calendar period. Fees posted in a month can fall into different settlements, and deferred transactions are money Amazon has not released yet. Use the settlement report for cash and posted fees for activity.

Where do Amazon fees by SKU come from?

From posted fee components in the Finances API, placed beside the matching order lines. Estimated fee reports and Product Fees estimates are useful for planning but are not what Amazon charged.

Why does yesterday’s Amazon margin change?

Sales arrive before all of their fees. As actual fees post they replace the matching estimates, and refunds and adjustments can change the number again. Show what is estimated, posted and still missing.

Do I need to migrate off the Finances API v0?

Yes, by August 27, 2027 for listFinancialEvents and its related operations. Event groups still come from v0 listFinancialEventGroups, which you can tie to v2024-06-19 transactions.

Can storage fee estimates go into monthly costs?

Use them for per-ASIN attribution and planning only. The actual storage charge appears as a posted service fee in the financial data and on the settlement report.

Want Amazon Seller Central data you can trust?

Bring the Amazon Seller Central reports that don't match. We'll trace them to the source and show you where to start.

Book a Call