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. Manual builds should include refunds and product-level PPC explicitly.
Jul 26, 2026 · 3 min read
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 so you can act before your next monthly close catches it.
Try Nova free for 14 daysRelated questions
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).