Daily Financial Summary — 2025-11-11
Scope: All events in provided feed for 2025-11-11 (primary currency: USD). Numbers are rounded to two decimals where applicable.
Top-level totals (USD)
- Shipment events (orders posted): 30
- Gross product sales (Principal): $2,227.72
- Shipping collected: $42.82
- Promotions (discounts applied): -$42.82
- Sales tax collected: $156.58
- Taxes withheld (Marketplace Facilitator): -$156.58 (net tax cash impact to seller = $0)
- Total refunds & goodwill (principal + goodwill): -$387.94
- Refunds (principal only): -$379.95
- Goodwill adjustment: -$7.99
- Refunds (tax returned): -$28.02 (tax-withheld returned +$28.02; net tax = 0)
- Removal shipment (liquidation) net: Revenue $5.19 & Fee -$2.23 (net +$2.96)
- Positive adjustments (AdjustmentEventList): +$7.99
- Service fees (coupon fees): -$6.89
- Total FBA fulfillment fees (FBAPerUnit, etc.): -$364.39
- Total Amazon commissions (selling fees): -$334.20
- Net (approximate) cash effect for the day, excluding tax flows: $1,198.72
How the net figure was derived (concise)
- Start with product principal + shipping + removal revenue + positive adjustments: $2,283.72
- Less promotions: -$42.82 → $2,240.90
- Less fulfillment & commission & service & removal fees: -$707.71 → $1,533.19
- Less refunds (principal): -$379.95 → $1,153.24
- Add net fee adjustments from refund events (commission adjustments net): +$45.48 → $1,198.72
- Tax line items (collected vs. withheld, refunds) net to ~$0 because Marketplace Facilitator withholding equals collected tax for the day.
Fee breakdown (key cost lines)
| Fee type |
Amount (USD) |
Notes |
| FBA fulfillment (per-unit) fees | -364.39 | Largest single cost category |
| Amazon commissions (referral fees) | -334.20 | ~14.9% of gross product sales |
| Service / coupon fees | -6.89 | Coupon participation/performance |
| Removal liquidation fee | -2.23 | One removal shipment recorded |
| Total direct fees (sum above) | -707.71 | |
Refunds & adjustments (USD)
- Refund events with USD impact: 6 (total principal refunded = -$379.95)
- Refund tax returned to seller: +$28.02 (matches tax refunded)
- Fee adjustments related to refunds:
- Commission-type adjustments credited during refunds (Commission entries): +$56.85
- RefundCommission entries (negative): -$11.37
- Net fee adjustment from refunds (Commission + RefundCommission): +$45.48
- AdjustmentEventList: REVERSAL_REIMBURSEMENT +$7.99 (added to account)
Items sold — top SKUs (volume & principal)
| SellerSKU | Units sold | Principal (USD) |
|---|
| 324521 | 9 | $899.91 |
| 204074 | 6 | $419.94 |
| 493437 | 4 | $239.96 |
| 204075 | 3 | $389.97 |
| 294429 | 3 | $209.97 |
| others (multiple SKUs) | 5 | remaining principal |
Note: the dataset includes a few shipments with $0 principal (promotional or zero-dollar items).
Counts & notable events
- Total shipment records processed: 30
- Refund entries in feed: 10 entries across marketplaces (6 with USD amounts)
- Removal shipments: 1 (customer-return-based wholesale liquidation)
- Service fee events (coupon fees): 2 events totaling -$6.89
- All tax collected was recorded as Marketplace Facilitator tax withheld (tax flow nets to ~0 for seller)
Observations & suggested actions
- Major cost drivers:
- FBA fulfillment fees (~$364) and referral commissions (~$334) together consume the largest share of gross sales for the day (~$698.6).
- Promotions effectively canceled out shipping revenue for the day (shipping collected = $42.82; promotions = -$42.82). Review promotion targeting and shipping/promo strategy to avoid zeroing out shipping or lowering margin unnecessarily.
- Refunds reduced principal by ~$380 (plus goodwill). Review reasons and SKUs that generated refunds: several single-item refunds indicate product returns or buyer issues. Specific SKUs with refunded items: 488299, 434980, 204074, 481376, 453790 (inspect return reasons and product/packaging quality).
- Marketplace Facilitator tax: taxes collected equal taxes withheld for the day (no net tax cash impact). Still, confirm tax reporting for accounting (sales tax collected and remitted by Amazon).
- Top SKU (324521) accounted for 9 units — good volume. Monitor margins by SKU (principal minus FBA & commission) to prioritize profitable SKUs.
- Service/coupon fees are small but tracked: coupon participation/performance fees totaled -$6.89 today. Evaluate coupon ROI.
Quick action checklist
- Compute SKU-level profitability (principal minus commissions minus FBA fees) for top SKUs (start with 324521, 204074, 493437).
- Investigate refunds by SKU and by buyer reason (customer returns, product issues, shipping damage).
- Re-evaluate promotions that cancel shipping revenue — ensure promotions are delivering incremental sales/profits.
- Consider FBA packaging/size optimization or repricing to reduce per-unit fulfillment fees where feasible.
- Reconcile tax reports: confirm Marketplace Facilitator withholdings match collected sales tax in accounting ledger.
If you want, I can:
- Produce a per-SKU P&L for the day (principal minus fees minus refunds per SKU),
- Highlight orders with refunds and extract their SKUs & reasons, or
- Export this summary as CSV/Excel-ready tables.
