Skip to content

P&L and margin by product ​

Access from: Profitability → P&L and Profitability → Margin by product

The P&L (profit and loss statement) brings together on one screen what you sell, what the sales channels charge you, what you spend on advertising, what the product costs you and your own expenses, and tells you how much is left: the contribution margin and, at the end, the net profit.

Epinium calculates it with the data from your Amazon Seller Central and Vendor Central accounts and with the product costs and own expenses you add. If you have none of those accounts connected, the screen only shows a message asking you to connect one.

What it includes and what it does not ​

The P&L goes down to net profit: what is left after paying the channel, advertising, the product and your own expenses (staff, agency, 3PL, software…).

  • Variable expenses (the ones per unit sold, as a % of sales or as a % of advertising) are subtracted in each channel and product, before contribution margin.
  • Fixed expenses (salaries, software, the 3PL fee…) belong to the whole account: they are subtracted after contribution margin and lead to net profit.

You add the expenses yourself, in Costs and expenses → Own expenses. With no expenses loaded, net profit equals contribution margin.

It does not include taxes.

All amounts are shown in your profile currency. If you sell in several marketplaces, each amount is converted at the exchange rate of the day it happened.

Product cost and own expenses, from the Business plan on ​

Product cost, own expenses, contribution margin, margin on net sales, net profit and cost coverage are available from the Business plan on.

With a lower plan, the P&L goes down to advertising: you see sales, fees and advertising, but not what each product costs. Where you would normally see the margin, the cards and columns are instead called Margin excl. product cost and Margin excl. product cost on sales: without product cost that figure is not your real margin, it is a margin before paying what each product costs you.

The waterfall lines ​

LineWhat it is
Gross salesWhat you sold in the period. Broken down into Seller sales and Vendor sales.
RefundsWhat you paid back to customers as refunds.
PromotionsThe discounts you gave your customers: Subscribe & Save, Seller Central promotions, Other promotions (coupons and the rest) and Shipping discounts. Free shipping does not count: the shipping charge and its discount cancel out. In the waterfall it only shows if you have any.
Amazon reimbursementsWhat Amazon pays you for stock it lost or damaged in its warehouses. In the waterfall it only shows if you have any.
Other incomeShipping paid by your customers. In the waterfall it only shows if you have any.
Net salesGross sales minus refunds and promotions, plus Amazon reimbursements and other income. It is the base for the margin and the % of net sales of each line. The TACoS, as in the dashboards, is calculated over gross sales.
CommissionsWhat the sales channel charges for each sale: Referral fee, Deal and coupon fees, Digital services fee and Closing fee.
LogisticsShipping of the units: FBA shipping (what Amazon charges), Own shipping (the per-unit shipping cost you add), FBA inbound shipping and Stock removal and disposal.
StorageWhat Amazon charges for keeping your stock in its warehouses.
Returns costsWhat Amazon charges for returns: Refund administration fee and FBA returns processing. In the waterfall it only shows if you have any.
Other feesThe rest of the channel's charges that do not go in any of the lines above.
Net proceedsNet sales minus the channel's fees and logistics, including your Own shipping.
AdvertisingAd spend, with one line per campaign type (Sponsored Products, Sponsored Brands, Sponsored Display).
Product costCost of goods sold: your per-unit cost for the units sold minus the returned ones.
Variable expensesYour own expenses that depend on what you sell: per unit sold, as a % of net product sales (without Amazon reimbursements or shipping) or as a % of advertising spend. Broken down into one line per category (Agency, Logistics and warehouse…).
Contribution marginWhat is left after all of the above.
Fixed expensesYour own expenses that do not depend on what you sell, such as salaries or software, with one line per category. They belong to the whole account: they are not split between channels or products.
Net profitContribution margin minus fixed expenses.

The P&L screen ​

Filters ​

  • Period, compared with another period just like in the dashboard.
  • Connection and Country, to see a specific account or marketplace.
  • Clusters, to see only the products of one or more of your clusters. It is also in Margin by product.
  • Aggregation: Monthly or Daily. It changes the columns of the table and of the trend chart.

The daily view covers up to 366 days. If you choose a longer period, we show the P&L by month and tell you with a message.

Up to which day there is data ​

Below the filters a grey note may show up to which day the data is confirmed, for example: Sales and fees up to 17 October · product cost up to 17 October. Amazon confirms sales a few days late (a bit more in Vendor), and product cost is calculated once they arrive. The following days may still change; the note goes away on its own once the data arrives.

If you have no product cost loaded, the note does not mention it. In a product's detail, the note only covers that product's account and country.

Indicators ​

At the top you see Net sales, Net proceeds, Contribution margin, Margin on net sales, Net profit and TACoS. Each one shows how much it changed against the compared period. Margin on net sales is compared in percentage points (ppt).

If net profit cannot be calculated, it shows - with the reason below: With all connections if you have a filter on, or No access to the whole account if your user does not see every connection.

Period waterfall ​

A bar chart that goes from gross sales to net profit, subtracting each block: variable expenses before contribution margin and fixed expenses after it. Without fixed expenses, or if net profit cannot be calculated, it ends at contribution margin. Hovering a bar shows its amount and what share of net sales it is.

Trend ​

Net sales and costs for each month (or each day), with the contribution margin line and the Previous period margin line. Incomplete periods look lighter because their figures may still change.

P&L by month / P&L by day ​

The table with every line of the waterfall, one column per month (or per day), the Total and the % of net sales of each line. Variable and fixed expenses are broken down by category, with the standard categories and the ones you created.

With Detailed P&L on, each line is broken down into its items: for example, promotions by type or commissions by fee. Items at 0 for the whole period are not shown, and a line with a single item is not broken down.

A month that is ongoing, has just closed or is not fully covered by the period is marked (partial): sales channels publish some charges late and its figures may still change.

Advertising by sales channel ​

A table that crosses where you sell with where you advertise. Each row is a sales connection and the columns are the spend on each advertising platform, the Net proceeds and the Margin on net sales of that connection, which already deducts its advertising. The Total row adds them all up.

Messages you may see ​

MessageWhy it appears
Incomplete product costSome sales in the period have no product cost. Without it, the margin shows higher than it really is. The message tells you what share of gross sales has a cost and has the Add costs button.
Estimated costYou sold more units than you had plus the ones you recorded buying. Those sales have a cost, the latest average cost, but no longer with a recorded purchase behind it. It shows in the coverage message, with what share of sales carries an estimated cost. That share is already inside the sales with a cost: it is not added on top. You can see it product by product in Margin by product, with the Estimated coverage column. Record your latest purchase to make it exact.
Costs that start laterNo sale in the period has a cost, but you have costs loaded with a later date. The message tells you from which day they apply. If you already paid the same before, load them again with the date they apply from.
Cluster without Sponsored BrandsYou filtered by cluster: advertising only includes the spend of its products. Sponsored Brands and campaign spend that does not belong to a specific product are left out, because they belong to no cluster.
Storage on a single dayIn the daily view: Amazon charges storage once a month, so the whole charge falls on a single day. It does not happen by month.
RecalculatingYou have just added or changed costs and the P&L is being recalculated. It shows a progress bar, the figures stay frozen and the costs of that account are locked until it finishes. Then the amounts update.
Net profit not availableYour fixed expenses belong to the whole account, so with a connection, country or cluster filter the P&L ends at contribution margin. It also happens if your user does not have access to every connection of the account. It only shows if you have fixed expenses loaded.
No own expensesYou have no own expenses yet, so the P&L ends at contribution margin. It comes with an Add expense button to create the first one without leaving the P&L. It only shows if your user can edit the catalog.
No dataThere are no sales or fees for the chosen period and connections.
Sales have not arrived yetNo sale in the period is confirmed yet. It does not mean you did not sell: wait a few days or choose an earlier period.
Plan without product costYour plan does not include product cost: the P&L goes down to advertising. The message has the Unlock with Business button.

How to complete product cost ​

Available from the Business plan on. The margin is only real when every sale has a product cost. It can be a fixed cost or the average cost of the purchases you record. You can add it in two ways:

  1. From the coverage message of the P&L or of Margin by product, with the Add costs button, which opens the cost import from a file.
  2. Product by product, in the Cost tab of its detail.

Both ways only appear if you can edit the catalog and your plan includes product cost.

Each cost applies from its Valid from date: earlier sales do not have it. If you load it without a date, it applies from today, and past periods stay without cost. Also, the margin of the last few days takes a few days to reflect it, as long as Amazon takes to confirm the sales.

All the details in Product costs.

Margin by product ​

In Profitability → Margin by product you have the same figures, but one row per product and marketplace: sales, refunds, promotions, net sales, each fee, advertising, product cost, variable expenses, contribution margin and Margin on net sales, with their change against the compared period, and TACoS.

The Variable expenses column is the share of your variable own expenses that falls on each product. Fixed expenses do not show here: they belong to the whole account and are not split between products.

With Edit columns you can show columns that come hidden: the ASIN, the Fees and logistics subtotal and the weight of each cost on net sales.

The Cost coverage column tells you what share of that product's sales has a cost. That way you quickly find the products that are missing one. If you record purchases, in Edit columns you can add the Estimated coverage column: what share of each product's sales carries an estimated cost.

Without product cost in your plan, the Product cost and Cost coverage columns show faded with a crown: they are not real figures, they show that column is for the Business plan and above.

The No product assigned row groups the amounts that come without a product, mostly advertising spend that is not tied to any product.

The detail button of each row opens the product detail, if the product is still in your catalog.

Margin by cluster ​

In Margin by product, the By cluster tab gives one row for each of your clusters, with the same columns as the product table and the margin first. Under the name you see how many products the cluster has, whether or not they sold in the period. By default they are sorted from most to least contribution margin; the ones with no activity in the period go last, with "-".

Under the clusters there can be up to three more rows:

RowWhat it includes
No clusterThe products in your catalog that are not in any cluster. Under the name you see how many there are, whether or not they sold. It shows up if it has amounts in the period or in the compared one.
No catalog productWhat is not tied to a product: campaign advertising (Sponsored Brands, Display), account fees and sales of products that are not in your catalog. It shows up if it has amounts in the period or in the compared one.
TotalYour whole account, with the page filters and each product counted once. A product that is in two clusters counts in both rows, so the rows can add up to more than the Total.

With the Clusters filter on, the table only shows the chosen clusters, without No cluster or No catalog product, and the Total is that of those clusters together, with each product counted once. The filter search also helps you find a specific cluster.

Each product counts in the clusters it is in today, in earlier months too: if you add a product to a cluster today, its past sales start counting in it.

If you have no clusters yet, the tab explains what they are for and lets you create the first one. You can also create one with Create cluster, at the bottom of the Clusters filter: it opens in a separate tab. If your plan allows no more clusters, the button changes to Upgrade your plan to create clusters and explains what the next plan gives you.

Cluster detail ​

The detail button of a cluster opens a window with its own period, connection and country. They start the same as the page's, and changing them does not touch the table outside. It has two tabs:

  • P&L: the cluster's profit and loss month by month, with the weight of each line on its net sales and the % in account column, the weight of that same line across your whole account. The cost lines where the cluster does worse than the account, and the final margin if it is lower, carry a notice; hover over it to see how many points worse it is than the account. That is what explains why a family leaves less margin than the rest.
  • Products: the products of the cluster, from worst to best margin. If some had no sales or costs with those filters, a notice tells you how many are missing.

Margin in the product detail ​

In the detail of a Seller or Vendor product, the Margin tab repeats the same P&L indicators for that product, with three of its own additions:

  • Cost breakdown: a donut showing the share of commissions, logistics, advertising, product cost and variable own expenses over total costs, with a message naming the block that changed the most against the compared period. Product cost does not count for that message if it was not loaded in one of the two periods.
  • TACoS breakeven: a message that says whether that product's ad spend is within what its margin can afford or has gone over, and by how many points. If the period is missing product cost, it only warns you when you go over: the margin shows inflated and it cannot be sure you have room to spare.
  • Trend and the table by month, same as the rest of the P&L.

If the product is missing a cost and you can edit the catalog, the coverage message has a button that takes you to its Cost tab.

If the product has not sold in the chosen period, no cards or charts are shown: just a message.

The Cost tab, where you add the product's cost one by one, requires the Business plan: on lower plans it shows locked with a crown, and trying to open it takes you to the plans screen.

Margin leaks ​

To see which products lost margin versus the previous period, how much it costs you and which cost caused it, use Margin leaks, on the Business and Master plans.

Inventory ​

To see how much money you have tied up in Amazon's warehouses valued at cost, how long each stock lasts and how much storage you will pay until it sells, use Inventory, on the Business and Master plans.

Saved views ​

Both screens work with views, like the rest of Epinium. Epinium gives you a starting view in each one (Monthly P&L, and All products and By cluster in Margin by product). To save your filters (a connection, the daily aggregation…) use Duplicate View and give the copy a name.

Epinium Documentation