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.
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 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 reconcile Amazon payouts?
To reconcile a payout: download the settlement report for the matching period, sum every credit (orders, reimbursements) and every debit (refunds, fees, service charges, reserves). The net should equal the amount deposited. If it does not, the delta is usually a reserve, unshipped hold, or currency conversion adjustment.
Where do I find the Amazon settlement report?
Amazon settlement reports live in Seller Central under Reports > Payments > All Statements. Each report covers one settlement period (usually 14 days) and lists every transaction that affected the payout: orders, refunds, fees, adjustments, service fees, and reserves. Download as CSV or the flat file to reconcile.
How do I export my full Amazon transaction history?
For 24+ months of transaction history, use the SP-API Reports endpoint or a connected tool that pulls historically. Seller Central console limits reports to 60 to 90 days depending on the report type. Nova connects via SP-API and can backfill up to 15 months of PPC history and 24 months of order and settlement data.
How do I find hidden Amazon fees eating my margin?
The fees that hurt most are rarely hidden, they are just scattered across multiple Seller Central reports. Check monthly storage, aged inventory surcharges, low-inventory-level fees, inbound placement fees, returns processing, subscription-and-save discounts, and coupon redemption fees. Rebuilding a per-SKU P&L from the Fee Preview and Payments reports usually reveals a 3 to 8 point margin gap.
What is a good net profit margin on Amazon FBA?
A healthy Amazon FBA net profit margin sits between 15% and 25% after fees, COGS, PPC, and refunds. Under 10% usually signals hidden fees or overspending on ads. Established brands with private-label pricing power can hold 25% or more, while resellers and wholesalers typically operate closer to 10% to 15%.