Free Template November 17, 2026 · 16 min read

Amazon SKU-Level P&L Template (Free Spreadsheet)

An account-level P&L tells you whether the business made money. A SKU-level P&L tells you which products made it and which ones quietly lost it. This template gives you the columns, the formulas and the Seller Central report that fills each one, ready to paste into Google Sheets or Excel.

14 Template Columns
9 Cost Lines Per SKU
1 Hour A Month To Update
$0 Template Cost
Quick Answer

An Amazon SKU-level P&L shows profit for each product, not just the whole account. For each SKU, list units sold and gross sales, then subtract Amazon referral fees, FBA fulfillment fees, storage fees, cost of goods, inbound freight and duty, advertising spend for that SKU, returns and refunds, and promotions, and add back any reimbursements. What remains is contribution profit per SKU; divide by sales for contribution margin. The template below gives these as columns with formulas you can paste into Google Sheets or Excel. Fill sales, units, fees and refunds from Seller Central's transaction or date range reports, advertising from your Sponsored ads advertised product reports, storage from the storage fee reports, and cost of goods and freight from your supplier and freight invoices. Update it monthly. Then sort by contribution profit and margin: scale the strong SKUs, fix the middle and consider cutting the ones that lose money after advertising.

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.

Disclosure

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.

01/12 Section

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.

LevelAnswersUse It For
Account P&LDid the business make money?Tax, cash planning, overall health
SKU P&LWhich 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.

Definition

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.

Watch the video · 3:19
Every Amazon Return Costs the Seller 3 Times (Real Numbers)
Every Amazon Return Costs the Seller 3 Times (Real Numbers)
Subscribe to Evolve Media on YouTube for new videos every week.
02/12 Section

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.

ColColumnWhat Goes In It
ASKU / ASINThe product identifier
BUnits soldNet units for the month
CGross salesProduct sales before fees
DReferral feesAmazon's commission
EFBA fulfillment feesPick, pack and ship
FStorage feesMonthly and aged inventory storage
GCost of goodsUnits x unit cost from your supplier
HInbound freight and dutyUnits x landed freight per unit
IAdvertisingSponsored ads spend for this SKU
JRefunds and returnsRefunded amounts and return costs
KPromotionsCoupons, deals, Vine fees
LReimbursementsCredits from Amazon, entered as a positive
MContribution profitC minus D to K, plus L
NContribution marginM 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.

03/12 Section

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.

SKU,Units,Gross Sales,Referral,FBA Fee,Storage, COGS,Freight,Ads,Refunds,Promos,Reimb, Contribution,Margin # paste the three lines above as one row BOTTLE-24,500,20000,3000,2600,300, 4500,900,3600,700,400,150, =C2-SUM(D2:K2)+L2,=M2/C2 # one row per SKU; copy row 2 down

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%.

Add A Totals Row

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.

04/12 Section

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.

ColumnTypical Source
Units, gross sales, referral fees, FBA fees, refundsPayments 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 feesFulfillment or inventory reports for monthly and aged inventory storage fees
Expected fees per unitFee Preview report, useful for checking charges
AdvertisingAmazon Ads advertised product reports for Sponsored Products and Sponsored Brands
PromotionsPayments transactions for coupon and deal fees; Vine fees
ReimbursementsThe Reimbursements report
COGS and freightYour 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.

05/12 Section

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.
SB spend $1,000 across 3 SKUs SKU A 50% of SB-attributed sales = $500 SKU B 30% = $300 SKU C 20% = $200 # same rule every month, so trends are real

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.

06/12 Section

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.

  1. Duplicate last month's sheet and rename it for the new month. Clear the numbers, keep the formulas.
  2. Download the payments transaction report for the month and pivot it by SKU for units, sales, referral fees, FBA fees and refunds.
  3. Download storage fee reports and enter storage by SKU.
  4. Download advertising reports and enter spend by SKU, allocating shared campaigns with your rule.
  5. Enter promotions and reimbursements by SKU.
  6. Calculate COGS and freight as units sold times landed unit cost.
  7. Check the totals row against your account-level numbers.
  8. 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.

07/12 Section

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.

Scale, Fix Or Kill Monthly Review
Scale
Strong Profit And Margin

More inventory, more ad budget, better creative. These fund the business.

Fix
Thin Margin, Real Demand

Look at the biggest cost line: ads, fees, returns or product cost. Fix that one first.

Kill
Negative After Ads

If fixes fail over a few months, stop advertising, sell through and consider cutting.

Watch
Trend, Not One Month

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.

08/12 Section

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.

09/12 Section

Fixing Thin-Margin SKUs

Fix the biggest cost line first. The SKU P&L tells you which one that is.

Biggest Cost LineFirst Fixes To Try
AdvertisingCut wasted search terms, improve the listing conversion rate, test new creative
FBA feesCheck size tier; smaller packaging can move a product down a tier
StorageSmaller, more frequent reorders; clear aged inventory
RefundsBetter size charts, clearer images and video, fix the product issue in reviews
Cost of goodsRenegotiate with suppliers, order larger quantities, review specs
Price too lowTest 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.

Free Resource

The Ecom Profit Box

Free ecommerce growth guides and templates, including our P&L and margin worksheets.

Get It Free
30 Minutes

Fix 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 Call
10/12 Section

When 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.

  1. Is it losing money, or just thin? A small positive contribution may still be worth keeping if it supports other sales.
  2. 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.
  3. 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.

11/12 Section

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.

12/12 Section

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.

SituationBest Fit
Under 30 SKUs, one marketplaceThis spreadsheet, updated monthly
Many SKUs or marketplacesProfit analytics software that imports Seller Central data
Daily decisions on ads and pricingSoftware with daily updates
Accountant needs reportsBookkeeping 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.

Key Takeaways

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.
Sources

Where This Came From

  1. 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.
  2. Evolve Media Agency, Amazon FBA fees breakdown 2026 (June 2026), for fee components and size tier effects. First-party.
  3. 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.
  4. Template and worked example are Evolve Media Agency illustrations using an invented product. Not accounting or tax advice. First-party.

Questions

Twelve questions sellers ask about tracking profit by SKU.
What is a SKU-level P&L on Amazon?

It is a profit and loss statement calculated for each product rather than the whole account. For each SKU, it subtracts referral fees, FBA fees, storage, cost of goods, freight, advertising, refunds and promotions from sales, adds reimbursements, and shows contribution profit and margin, so you can see which products make or lose money.

How do I calculate profit per SKU on Amazon?

Start with gross sales for the SKU. Subtract referral fees, FBA fulfillment fees, storage fees, cost of goods, inbound freight and duty, advertising spend for that SKU, refunds and returns, and promotions. Add any reimbursements. The result is contribution profit; divide it by gross sales for contribution margin.

Which Seller Central reports do I need for a SKU P&L?

A payments date range or transaction report for sales, units, referral fees, FBA fees and refunds; storage fee reports; Amazon Ads advertised product reports for ad spend; and the Reimbursements report. Business Reports help cross-check units. Cost of goods and freight come from your supplier and freight invoices.

Is this Amazon P&L template free?

Yes. The template is a set of column headers and formulas you can paste into Google Sheets or Excel, shown in section 3. There is nothing to buy or sign up for. More free templates are in the Ecom Profit Box.

How do I allocate Sponsored Brands spend to SKUs?

Use a consistent rule. A common one is splitting Sponsored Brands spend by each SKU's share of the sales those campaigns attributed. If attribution is unclear, split by share of total sales. The exact rule matters less than using the same one every month so trends are meaningful.

Should fixed costs go in a SKU-level P&L?

Usually not. Software, salaries and other overhead stay the same regardless of which products sell, so spreading them across SKUs hides which products earn their keep. Track them at the account level, and use the SKU sheet for contribution profit, which shows whether selling more of a product makes money.

What is a good contribution margin on Amazon?

It depends on your category, price point and overhead. What matters is whether total contribution profit across SKUs covers your fixed costs and leaves profit. Compare SKUs against each other and track each one over time. A falling margin on a SKU is a signal to investigate its biggest cost line.

How often should I update a SKU P&L?

Monthly is enough for most sellers, and takes about an hour once set up. Judge SKUs on trends over about three months rather than a single month, since stock-outs, holidays and promotions can distort any one month. Sellers making daily ad and pricing decisions may prefer software with daily data.

Why does my SKU P&L total not match my account?

Something is missing or double-counted. Common causes are unallocated advertising, storage fees posted in a different month, account-level fees not assigned to SKUs, refunds missing, or reimbursements not entered. Find the gap in the totals row before trusting individual SKU results.

When should I discontinue an Amazon SKU?

Consider it when a SKU loses money after advertising for three or more months and fixes have not worked. First check whether it is truly negative or just thin, whether it drives sales of other products, and what selling through or removing inventory will cost. Then stop advertising, sell through and do not reorder.

Do I include reimbursements in a SKU P&L?

Yes. Reimbursements from Amazon for lost or damaged inventory are real money. Enter them as a positive amount for the SKU they relate to, from the Reimbursements report. Tracking them also shows which products lose units most often, which can point to packaging or handling problems.

Should I use software instead of a spreadsheet?

A spreadsheet works well for catalogs under about 30 SKUs on one marketplace. Profit analytics software helps with larger catalogs, several marketplaces or daily decisions. Building the spreadsheet once by hand is still worthwhile, because it teaches you where each number comes from and helps you catch software errors.

Ian Smith, founder of Evolve Media Agency
Ian Smith
Founder, Evolve Media Agency

Ian founded Evolve Media Agency in 2017 and has spent a decade building Amazon, TikTok Shop and Shopify brands, including his own. The agency produces product photography, video, listing content, email and AI-search visibility work for ecommerce brands in the $1M to $10M range.

Read Ian's Story

Know Which SKUs Pay

Bring your SKU P&L. In 30 minutes we will pick the product where better creative, listings or ads would add the most profit.

14
Template Columns
Free 30-minute call

Want Ian to Look at Your Brand?

Tell us what you sell and where you are stuck. Ian replies within one business day, and you get an email right away with a link to book a free 30-minute call.

  • Brand management, PPC, listings, launches and content
  • Amazon, Shopify and TikTok Shop brands
  • A real reply from Ian, not a sales bot

Rather talk now? Call or text 719-257-3557 or pick a time on Calendly.

Your information stays with us. We never share it.