Are there unexplained discrepancies in your Amazon settlements?

SELECT
  s.settlement_id,
  s.transaction_type,
  s.amount_type,
  ROUND(s.amount::numeric, 2)                       AS settlement_amount,
  s.posted_date::date                                AS posted_date,
  s.sku,
  CASE
    WHEN o.amazon_order_id IS NOT NULL THEN 'Matched'
    WHEN fe.seller_order_id IS NOT NULL THEN 'Fee match only'
    ELSE 'Unmatched'
  END                                                AS match_status
FROM amazon_settlement s
LEFT JOIN amazon_orders o
  ON o.amazon_order_id = s.order_id
  AND o.order_status NOT IN ('Canceled', 'Cancelled')
LEFT JOIN amazon_financial_events fe
  ON fe.seller_order_id = s.order_id
WHERE s.posted_date::date >= CURRENT_DATE - INTERVAL '90 days'
  AND o.amazon_order_id IS NULL
  AND fe.seller_order_id IS NULL
  AND ABS(s.amount) > 1
ORDER BY ABS(s.amount) DESC
LIMIT 50