How do I build an ASIN-level P&L from Amazon reports?
Combine settlement data (revenue, fees, refunds), advertising reports (ad spend per SKU via product-level attribution), and your COGS file. Roll up weekly and monthly per ASIN. Most sellers underestimate refunds and product-level PPC when they build this themselves.
The data sources
Settlement report: gross revenue, referral fee, FBA fee, storage, refund revenue and cost. Advertising reports: product-level ad spend. Inventory report: units on hand and COGS. Business Reports: sessions and CVR for context.
The formula
Net revenue = gross revenue - returns. Contribution margin = net revenue - referral fee - FBA fee - COGS - product ad spend - refund reserve. Do it per ASIN, per week, over 90 days.
Frequently asked questions
Can I do this in a spreadsheet?
Yes, but the settlement report is 20+ columns and joining across weeks by SKU is tedious. Nova does this natively.
Do I need Vendor data?
Only if you sell 1P as well as 3P.
How often should I refresh?
Weekly at minimum, daily is ideal for active SKUs.
See this in Nova
Nova surfaces this metric per SKU in near real time so you can act before your next monthly close catches it.
Try Nova free for 14 daysRelated questions
How do I run a cohort analysis for Amazon consumable SKUs?
Group customers by first-purchase month for the SKU. Track how many buy again in months 1, 2, 3, and so on. Amazon does not give you customer identifiers, so you approximate with the Repeat Purchase Behavior report at brand level plus S&S subscriber data.
What is the difference between Amazon Business Reports and Brand Analytics?
Business Reports show what happened on your listings: sessions, page views, buy box, unit-session percentage. Brand Analytics shows what shoppers did across the whole marketplace: which search terms drove clicks and purchases, which ASINs share cart with yours, and repeat purchase behavior.
How do I calculate profit per unit on Amazon?
Profit per unit on Amazon equals sale price minus referral fee, FBA fulfilment fee, per-unit COGS, allocated ad spend, and a refund reserve. A quick formula: Profit/unit = Price - (Referral% x Price) - FBA fee - COGS - (Ad spend / units sold) - (Refund rate x Price).
How do I get VAT invoices from Amazon?
For sellers on EU or UK marketplaces, Amazon provides VAT invoices through the Tax Document Library and the Amazon VAT Calculation Service. Enable VCS to auto-issue compliant B2B invoices to buyers. Download seller-facing fee invoices monthly from Reports > Tax Document Library.