Profit and Loss Report

📊 TL;DR: The SellerLegend Profit and Loss (P&L) Report offers a comprehensive, customizable financial overview—grouped by day, week, month, quarter, year, settlement period, product, brand, or product groups—with deep drill-down capabilities and historical FX conversion. Unlike Amazon’s own reports, it gives you gross and net profitability insights with unmatched granularity.

---

What Is It?

The Profit and Loss Report is SellerLegend’s most detailed financial analytics tool. It provides daily, weekly, monthly (and more) profitability breakdowns across your entire Amazon business, allowing you to understand not just what you sold, but how much you truly earned.

Where Amazon’s Payments or Transaction View may offer siloed and aggregate-level visibility, SellerLegend gives you:

• Fine-grained control over grouping (by time period, product, brand, product group, settlement period, etc.)

• Drill-down access to the underlying financial transactions per cell

• Historical FX conversion using mid-market ECB rates

• Side-by-side PPC, COGS, refunds, and adjustments for a real net profit figure

• Intuitive filters and date range selectors to analyze performance across any timeframe

---

How to Access

1. Navigate to Sales and Customers → Profit & Loss Report

2. Use the selectors at the top of the screen to customize the view:

   • Date Selector: Choose relative or fixed date ranges (e.g. “Last 30 Days”, “This Quarter”, “Same Month Last Year”)

   • Group By: Choose how the report is structured:

     • Day / Week / Month / Quarter / Year

     • Settlement Period

     • Products / Brands / Product Groups

   • Marketplace/Group Selector: Select an individual Amazon account or a multi-marketplace group (e.g. “US + JP in GBP”)

---

What’s In The Report?

The P&L table includes the following sections, listed in the order they appear in the report:

1. Units

• Total units sold, returned, and flagged as promotional.

• Promo units are identified based on configurable discount thresholds.

• Promo/Non-Promo split aids in segmenting profitability.

2. Gross Sales

• Product Charges – Total sales before refunds.

• Refunds – Customer refunds deducted from sales.

3. Other Income

Includes Amazon income that is not tied to product sales, e.g.:

• Gift Wrap & Gift Wrap Tax

• Low-Value Goods Tax Rebates

• Reimbursements for inbound issues

• and many more income transactions

4. Other Refunds

Captures non-order-based adjustments (e.g., warehouse reimbursements, restocking fees, shipping charges).

5. Promotions

• Shows total value of discount promotions.

• Tracks how they impact product-level profitability.

6. Amazon Order Fees

• Amazon commission, FBA fees, shipping charges.

• Based only on confirmed shipped orders.

7. Amazon Fee Refunds

• Captures the fee reversals when orders are refunded.

8. Product Adjustments

This section accounts for miscellaneous financial events Amazon reports separately, such as (but not limited to):

• WarehouseLost

• WarehouseDamage

• ReversalReimbursement

• FreeReplacementRefundItems

• CompensatedClawback

9. Gross Profit (by product)

Gross Sales – Refunds – Amazon Order Fees + Other Income
This figure is calculated before general expenses like PPC or business-level costs.

10. Other Amazon Fees

Account-wide charges not easily tied to a specific product, such as:

• Subscription Fees

• Long-Term Storage

• Prep Fees

• Inbound Shipping
  These fees are shown in total and not proportionally split across products due to Amazon API limitations.

Note: The current Amazon reports do not offer a breakdown of these charges per SKU. SellerLegend is actively working on incorporating granular SKU-level fee attribution using the Data Kiosk API (analytics_economics_2024_03_15). Deployment is in development and no ETA can be provided at this time.

11. Gross Profit (overall)

Adds up gross profit by product and deducts any general Amazon fees.

12. Product Expenses

COGS, PPC, and other product-level operating expenses.

13. Business Expenses

Marketplace-level recurring or ad hoc costs, such as:

• Software subscriptions

• Payroll

• Generic admin charges

14. Net Profit

All revenue minus all Amazon fees and internal costs.

15. Net Margin (%)

Net Profit ÷ Gross Sales

16. Net ROI (%)

Net Profit ÷ Cost of Goods Sold
Crucial for comparing product viability.

17. Amazon Payout During Period

The exact payout Amazon issued during the selected period (matching your Seller Central deposit timeline).

18. Memo Transactions

Manual adjustments or accounting entries you’ve recorded (e.g., reconciling external systems).

---

Key UI Features

• 🔍 Click to Drill Down: Every numeric cell can be clicked to reveal the underlying transactions.

• 🧠 Hover Tooltips: Hovering on transaction categories explains Amazon’s sometimes cryptic charge types.

• 📅 Flexible Date Ranges: From “Today” to “Last Quarter”, plus ongoing or relative timeframes.

• 🌍 Currency Conversions: Mid-market rates from the European Central Bank, applied on the actual day of the transaction, not today’s rate.

• 📊 Grouping Options: Switch between groupings by day, SKU, brand, product group, or settlement ID with a single dropdown.

---

Key Seller Benefits

---

Limitations to Note

• Fee apportionment for general Amazon fees (e.g. subscription charges) is currently not available at the SKU level.

• All financial data is as reported by Amazon. Discrepancies between SellerLegend and Seller Central usually stem from data latency or inconsistencies in Amazon’s own reporting APIs.