Your Amazon deposit can grow while half your catalog loses money. Only a SKU-level P&L shows which half.
Most Amazon sellers know their total sales and roughly know their total profit. Far fewer know profit by product. That gap hides expensive problems: a best-seller that only breaks even after ad spend, a slow product eating storage fees, a variation that gets returned twice as often as its siblings. This template makes those visible in about an hour a month.
Evolve Media Agency is a creative and marketing agency, not an accounting firm, and this template is a management tool, not tax or accounting advice. It is free with no strings. The Ecom Profit Box linked below is also free. Report names in Seller Central change from time to time, so search the Reports menu if a name here does not match yours.
If you are new to Amazon P&Ls, start with our guide to reading your Amazon P&L, which explains each cost line. This post gives you the per-SKU template and how to fill it.
What Is A SKU-Level P&L?
A SKU-level P&L is a profit and loss statement broken out by product. Instead of one profit number for the account, you get one for every SKU.
Our Amazon P&L guide recommends building the P&L at two levels: the account level, which gives the verdict, and the SKU level, which shows the cause. The account level tells you profit fell. The SKU level tells you it fell because one product's ad costs doubled.
| Level | Answers | Use It For |
|---|---|---|
| Account P&L | Did the business make money? | Tax, cash planning, overall health |
| SKU P&L | Which products made or lost it? | Pricing, ad budgets, reorders, cutting products |
This template focuses on contribution profit: what each SKU earns after all the costs that rise and fall with its sales, before fixed overhead like software and salaries. That is the number that tells you whether selling one more unit of a product makes you money.
The account-level and SKU-level views often disagree in useful ways. An account can be profitable overall while a third of its SKUs lose money, propped up by a few strong products. Or an account can look thin while one or two products are excellent and the rest drag the total down. In both cases, the SKU view tells you what to do next: put more behind the winners, fix or drop the losers.
A SKU-level P&L is a profit and loss statement calculated separately for each product SKU, subtracting that product's Amazon fees, product and freight costs, advertising, returns and promotions from its sales to show contribution profit and margin per product.
Subscribe to Evolve Media on YouTube for new videos every week.
The Template Columns
The template has fourteen columns: identifiers, sales, nine cost and credit lines, and three results. One row per SKU, one sheet per month.
| Col | Column | What Goes In It |
|---|---|---|
| A | SKU / ASIN | The product identifier |
| B | Units sold | Net units for the month |
| C | Gross sales | Product sales before fees |
| D | Referral fees | Amazon's commission |
| E | FBA fulfillment fees | Pick, pack and ship |
| F | Storage fees | Monthly and aged inventory storage |
| G | Cost of goods | Units x unit cost from your supplier |
| H | Inbound freight and duty | Units x landed freight per unit |
| I | Advertising | Sponsored ads spend for this SKU |
| J | Refunds and returns | Refunded amounts and return costs |
| K | Promotions | Coupons, deals, Vine fees |
| L | Reimbursements | Credits from Amazon, entered as a positive |
| M | Contribution profit | C minus D to K, plus L |
| N | Contribution margin | M divided by C |
The nine cost and credit lines match the cost categories in our P&L guide, minus fixed overhead such as software and salaries, which belongs at the account level. Enter costs as positive numbers; the formula subtracts them.
You can add columns as your needs grow. Common additions are sessions and conversion rate from Business Reports, which help explain why a SKU's sales changed, and ad spend as a percentage of sales, sometimes called TACoS, which shows how dependent a product is on advertising. Keep the core fourteen the same so months stay comparable.
Copy The Template: Paste-Ready Version
Copy the block below into cell A1 of a blank Google Sheet or Excel sheet. In Google Sheets, use Data, then Split text to columns, with comma as the separator if it does not split automatically. Row 2 is a worked example for an invented product; replace it with your own SKUs.
Paste each set of lines as a single row, joining them without line breaks, or type the headers across row 1 and the example across row 2. Then format column N as a percentage.
In the example, 500 units at $40 bring $20,000 in sales. After $3,000 in referral fees, $2,600 in FBA fees, $300 in storage, $4,500 in product cost, $900 in freight, $3,600 in advertising, $700 in refunds and $400 in promotions, plus $150 in reimbursements, contribution profit is $4,150, a margin of about 20.8%.
Under your last SKU, add a totals row with =SUM() for columns B through M and the margin formula for N. Your totals should roughly match your account-level numbers for the month. If they do not, something is missing or double-counted.
A few formatting habits make the sheet easier to use. Freeze the header row so it stays visible as you scroll. Use conditional formatting to shade negative contribution profit red and margins below your target amber. And keep one sheet per month in the same file, so you can compare a SKU across months side by side.
Where Each Number Comes From In Seller Central
Most columns come from three or four Seller Central reports. Names and menu paths change over time, so if a name does not match, search the Reports menu for the key word.
| Column | Typical Source |
|---|---|
| Units, gross sales, referral fees, FBA fees, refunds | Payments reports: a date range or transaction report for the month, filtered by SKU |
| Units and sessions (cross-check) | Business Reports, sales and traffic by child item |
| Storage fees | Fulfillment or inventory reports for monthly and aged inventory storage fees |
| Expected fees per unit | Fee Preview report, useful for checking charges |
| Advertising | Amazon Ads advertised product reports for Sponsored Products and Sponsored Brands |
| Promotions | Payments transactions for coupon and deal fees; Vine fees |
| Reimbursements | The Reimbursements report |
| COGS and freight | Your supplier invoices and freight bills, not Seller Central |
The transaction-level payments report is the backbone. It lists each order with its sales and fees, so you can total them by SKU with a pivot table. Download it as a spreadsheet, then build a pivot with SKU as rows and amount types as columns.
Amazon cannot see your product cost, freight or overhead. Our P&L guide makes this point directly: Amazon's reports are half the equation. Keep a separate sheet with each SKU's landed unit cost, updated whenever a new shipment changes it.
Landed cost per unit is the product cost plus freight, duty and any prep or inspection costs, divided by units in the shipment. If shipments arrive at different costs, use a weighted average or the cost of the batch you are currently selling. Our landed cost guide covers how to calculate it properly, including tariffs.
Allocating Ads, Storage And Shared Costs
Some costs do not arrive neatly by SKU. Allocate them with a simple, consistent rule rather than skipping them.
- Sponsored Products: the advertised product report shows spend by advertised SKU. Use it directly.
- Sponsored Brands and Brand Store ads: these often feature several products. Split spend by each SKU's share of attributed sales, or by share of total sales if attribution is unclear.
- Storage: storage reports usually break fees out by product. If yours does not, allocate by cubic feet stored.
- Inbound placement and prep fees: allocate by units in each shipment.
- Vine and promotions: charge to the SKU that ran them.
- Fixed overhead: leave it out of the SKU sheet. Track software, salaries and services at the account level.
The exact rule matters less than using the same one every month. Consistency is what makes month-to-month changes meaningful. Write your allocation rules at the top of the sheet so anyone updating it follows them.
Do not chase perfect precision. A SKU P&L that is roughly right and updated every month is far more useful than a perfect one that takes a week to build and never gets updated. If an allocation is a close call, pick a reasonable rule, note it, and move on.
How To Fill It Each Month
Once set up, the monthly update takes about an hour for a typical catalog. Follow the same steps every month.
- Duplicate last month's sheet and rename it for the new month. Clear the numbers, keep the formulas.
- Download the payments transaction report for the month and pivot it by SKU for units, sales, referral fees, FBA fees and refunds.
- Download storage fee reports and enter storage by SKU.
- Download advertising reports and enter spend by SKU, allocating shared campaigns with your rule.
- Enter promotions and reimbursements by SKU.
- Calculate COGS and freight as units sold times landed unit cost.
- Check the totals row against your account-level numbers.
- Sort by contribution profit and note what changed from last month.
Storage fees often post for the prior month, so they can lag. Pick a convention, such as recording storage in the month it is charged, and stick with it.
If an hour a month sounds like too much, start with your top ten SKUs by sales. They usually account for most of the money, and most of the surprises.
Assign the update to one person and put it on the calendar, for example the second week of each month once storage fees have posted. A P&L that depends on someone remembering to do it tends to stop being updated within a few months.
How To Read Your SKU P&L
Sort SKUs by contribution profit, then by contribution margin, and put each into one of three groups. Our P&L guide calls this the scale, fix or kill decision.
More inventory, more ad budget, better creative. These fund the business.
Look at the biggest cost line: ads, fees, returns or product cost. Fix that one first.
If fixes fail over a few months, stop advertising, sell through and consider cutting.
Judge on three months. One bad month can be a stock-out or a holiday.
Contribution margin tells you efficiency; contribution profit tells you size. A product with a 40% margin on $500 of sales matters less than one with 15% on $50,000. Look at both.
A simple chart helps here: plot each SKU with sales on one axis and margin on the other. Products in the high-sales, high-margin corner are your core. Products in the low-sales, low-margin corner are the first candidates for review.
Watch the cost columns as percentages of sales too. If advertising for one SKU climbs from 12% to 25% of its sales, that is the story, even if its profit is still positive. Our contribution margin playbook goes deeper on reading margins.
Add a short notes column for context: "stocked out 10 days," "ran Lightning Deal," "price raised $2." Months later, those notes explain the spikes and dips that would otherwise send you chasing problems that were really one-off events.
What A SKU P&L Usually Reveals
The first time most sellers build a SKU-level P&L, a few patterns show up again and again.
- A best-seller with a thin margin. High sales, heavy advertising, little left over. It looks like a hero in Seller Central and a break-even in the P&L.
- A quiet profit engine. A product with modest sales and almost no ad spend that earns more profit than the best-seller.
- A storage drain. A slow product whose storage and aged inventory fees eat most of its profit.
- A return problem. One variation, often a size, with far higher refunds than its siblings.
- A size tier penalty. A product whose packaging puts it in a higher fulfillment fee tier than necessary.
- Unclaimed reimbursements. Lost or damaged units that were never reimbursed.
Each of these has a clear next action. A thin-margin best-seller needs better ad efficiency or a price review. A storage drain needs a smaller reorder or a promotion to sell through. A return problem needs better sizing information or listing images. A size tier penalty may need a packaging change. Our FBA fees breakdown covers fee tiers and how packaging affects them.
Fixing Thin-Margin SKUs
Fix the biggest cost line first. The SKU P&L tells you which one that is.
| Biggest Cost Line | First Fixes To Try |
|---|---|
| Advertising | Cut wasted search terms, improve the listing conversion rate, test new creative |
| FBA fees | Check size tier; smaller packaging can move a product down a tier |
| Storage | Smaller, more frequent reorders; clear aged inventory |
| Refunds | Better size charts, clearer images and video, fix the product issue in reviews |
| Cost of goods | Renegotiate with suppliers, order larger quantities, review specs |
| Price too low | Test a modest price increase and watch conversion |
The listing is often the cheapest fix for a high ad cost. A product page that converts better makes every ad click cheaper per sale. Clear images, a demo video and answers to the common questions in reviews can lift conversion without touching the ad account.
Give each fix a month or two before judging, and change one thing at a time where you can, so you know what worked.
Keep a simple log of fixes next to the P&L: the date, the SKU, what changed and what you expect to happen. When the next month's numbers arrive, check the log. Over a year, it becomes a record of which levers actually move profit for your products, which is worth more than any general advice.
The Ecom Profit Box
Free ecommerce growth guides and templates, including our P&L and margin worksheets.
Get It FreeFix Your Thin-Margin SKUs
Bring your SKU P&L. We will pick the product where better listing creative or ads would add the most profit, whether or not you hire us.
Book A CallWhen To Cut A SKU
Consider cutting a SKU when it loses money after advertising for three or more months and the fixes have not worked. Before you cut, check three things.
- Is it losing money, or just thin? A small positive contribution may still be worth keeping if it supports other sales.
- Does it drive sales of other products? Some products bring in customers who buy your other items. Check whether buyers of this SKU also buy others.
- What does exiting cost? Remaining inventory has to be sold through, removed or disposed of, each with costs.
If it still loses money after those checks, stop advertising it, sell through remaining stock with a modest promotion if needed, and do not reorder. Our SKU rationalization guide covers how to prune a catalog without hurting the products that work.
Cutting a weak SKU often improves the whole account. It frees cash tied up in inventory, cuts storage fees and lets you put ad budget behind the products that earn it.
It also simplifies operations: fewer purchase orders, fewer listings to maintain and fewer products to photograph and advertise. For a small team, that time is often worth as much as the money.
Common SKU P&L Mistakes
Most SKU P&Ls go wrong in the same few ways.
- Leaving out advertising. Without ad spend per SKU, the P&L flatters every advertised product.
- Using sale price instead of landed cost. Cost of goods should include freight and duty, either in COGS or in its own column.
- Ignoring refunds and returns. High-return products look profitable until refunds are counted.
- Skipping storage. Slow movers hide their real cost in storage and aged inventory fees.
- Changing allocation rules. Switching how you split shared ad spend makes trends meaningless.
- Judging on one month. Stock-outs, holidays and promotions distort single months. Look at a rolling three-month view before acting.
- Forgetting reimbursements. Credits from Amazon are real money and belong in the sheet.
- Mixing fixed costs in. Spreading salaries across SKUs hides which products actually earn their keep.
The totals row is your safety check. If the sum of your SKUs does not roughly match your account-level sales, fees and ad spend for the month, find the gap before trusting any single row. Our guide to the true cost of an Amazon sale lists the costs sellers most often miss.
Build It Yourself Or Use Software
A spreadsheet is enough for most sellers with a few dozen SKUs. Profit analytics software makes sense when the catalog or the time cost grows.
| Situation | Best Fit |
|---|---|
| Under 30 SKUs, one marketplace | This spreadsheet, updated monthly |
| Many SKUs or marketplaces | Profit analytics software that imports Seller Central data |
| Daily decisions on ads and pricing | Software with daily updates |
| Accountant needs reports | Bookkeeping software for the account level; this sheet for SKU decisions |
Whichever you choose, the decisions are the same: which products to scale, which to fix and which to cut. The tool only changes how fast you get the numbers.
Even with software, build the spreadsheet once by hand. It teaches you where every number comes from, which makes you much better at spotting when software gets something wrong.
What a P&L will not do is grow sales. Once you know which SKUs earn the most, the next step is giving those products the listing, creative and ads that sell more of them. Grab more free templates in the Ecom Profit Box, and use our free FBA fee calculator to check fees for new products before you list them.
What To Remember
- A SKU-level P&L shows contribution profit for each product, revealing which SKUs earn money and which lose it after Amazon fees, product costs and advertising.
- Each SKU row subtracts referral fees, FBA fees, storage, cost of goods, freight, advertising, refunds and promotions from gross sales, and adds reimbursements.
- Contribution margin equals contribution profit divided by gross sales, and should be read alongside total contribution profit.
- Amazon's reports cannot see product cost, freight or overhead, so cost of goods and freight come from supplier and freight invoices.
- Shared costs such as Sponsored Brands spend should be allocated by a consistent rule, such as share of attributed sales, every month.
- Sort SKUs by contribution profit and margin each month to decide which to scale, fix or cut, judging on three months rather than one.
- A totals row that matches account-level numbers is the check that the SKU P&L is complete.
Where This Came From
- Evolve Media Agency, How to read your Amazon P&L (May 2026), for the nine cost categories, account versus SKU levels and the scale, fix or kill decision. First-party.
- Evolve Media Agency, Amazon FBA fees breakdown 2026 (June 2026), for fee components and size tier effects. First-party.
- Amazon Seller Central payments, business, inventory, fee preview and reimbursements reports (cited by name; login required), for where each number comes from. First-party Amazon; report names change over time.
- Template and worked example are Evolve Media Agency illustrations using an invented product. Not accounting or tax advice. First-party.


