Skip to main content
Reports & data

How do I track profit at the SKU level on Amazon?

SKU-level profit requires matching every revenue and cost line to the SKU that generated it. That means pulling settlement reports, product-level ad spend, refunds, storage allocation, and COGS, then attributing each. Doing this manually in Excel takes 4 to 8 hours per month per account; automated tools reduce it to a dashboard view.

MT
CTO at Nova Analytics

Jul 26, 2026 ยท 3 min read

The data you need per SKU

Units sold and gross revenue. Referral fee and FBA fulfilment fee. Refunds and refund reserve. Product-level ad spend (from advertising reports). Monthly storage allocation. Landed COGS per unit.

The manual approach

Download settlement reports and advertising reports per period. Match to SKU via order ID and ASIN. Allocate storage fee by unit-months. Compute per-SKU net profit. Expect 4 to 8 hours per month per account.

How Nova does it

Nova connects via SP-API, pulls every transaction, attributes each fee to the SKU, and shows near-real-time SKU-level profit in Cockpit. No Excel.

Frequently asked questions

Do I need Brand Registry for SKU profit tracking?

No. SKU-level profit works on any professional seller account.

Can Excel handle 500+ SKUs?

Yes technically, but the manual pull becomes unmanageable weekly. Automated tools are the practical answer above 50 SKUs.

Does this include storage fees?

Yes. Storage must be allocated by unit-months to give an honest per-SKU picture.

How often does Nova refresh SKU profit?

Near real time on orders and ad spend, with settlements reconciled every 14 days.

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 days

Related questions