Skip to main content

Attribute storage fees and ad spend to products

Storage and advertising are real costs of selling a product, but they arrive as one bill for the whole account. SKU.io can turn Amazon's storage fee and aged inventory surcharge reports, its monthly AWD storage charge, and your Amazon Ads spend, into cost entries that are already split across the products that incurred them. Each product's margin in the Profitability and Contribution Margin reports then carries its own share.

Before you begin​

  • Your Amazon connection is set up, and its FNSKUs are mapped to your products. A fee for an unmapped FNSKU can't be placed on a product.
  • For ad spend, connect Amazon Ads. See Connect Amazon Ads and attribute spend.

Turn storage fees into cost entries​

  1. Go to Apps & Integrations → Amazon → FBA → Storage Fees.

  2. Turn on Create cost entries from this report. The line under it changes to "On — reports become cost entries with allocations."

    The Create cost entries from this report switch on the Storage Fees page

  3. To build entries now from the reports already imported, click Process Cost Entries. It doesn't fetch anything new from Amazon.

  4. Repeat on the Aged Inventory Surcharge tab for the long-term storage surcharge.

The switch is the same setting as Automatically create cost entries from FBA storage fee reports on the FBA Settings tab, and it applies to each Amazon connection separately.

What you get​

  • One cost entry per month, with the type Amazon FBA Storage Fees or Amazon Aged Inventory Surcharge.
  • One allocation per product, carrying that product's fees for the month. Fees in another currency are converted, and the allocations add up to the entry exactly.
  • A link back. On the Storage Fees list, the Cost Entry column links each fee row to its entry.

If Amazon revises a month's report, the next run rebuilds that month's entry and its allocations.

Fees that couldn't be placed​

When a fee row's FNSKU isn't mapped to a product, its amount stays Unallocated on the entry, and the entry lists each unmatched FNSKU with its Product Name (from Amazon). Map them under FNSKU Product Mapper, then click Process Cost Entries again.

Estimates against what Amazon charged​

The storage fee report is Amazon's estimate. Once the matching charge appears in a settlement, the entry shows Settlement Reconciliation: Estimated (report), Actual (settlement) and the Variance. Until then, it shows Awaiting Settlement. The monthly storage fee usually settles early in the following month, and the aged inventory surcharge in the same month. Reconciliation is shown for information. It doesn't change the entry or its allocations.

AWD storage fees​

Amazon Warehousing and Distribution (AWD) storage is charged as one total for the month. It arrives as the AWD Storage Fee line in the next month's settlement, usually in the first week. With Create cost entries from this report turned on, SKU.io turns each month's charge into a cost entry automatically when it processes that settlement. You don't download or record anything.

  • One cost entry per month, with the type Amazon AWD Storage Fees.
  • The amount is what Amazon charged: the base fee less any discount, plus any correction Amazon posts later. Fees in another currency are converted.
  • The split across products is an estimate. Amazon doesn't say how much each product cost, so SKU.io spreads the charge by the space each product took up: units held × cubic feet. Units come from Amazon's daily AWD stock, averaged over the month. Amazon's daily stock is kept for about 90 days, so for an older month SKU.io uses its own AWD stock at month end instead. If any product held that month has no dimensions, the whole month is split by units held.

The entry's Settlement Reconciliation panel says this in a note headed The split across products is an estimate, with what the split was weighted by and which stock it used.

A stocked FNSKU that isn't mapped to a product keeps its share as Unallocated, as with FBA storage fees. Map it under FNSKU Product Mapper, and the entry is rebuilt the next time a settlement is processed. A month with a charge but no AWD stock on record is still recorded, with the whole amount unallocated. A month that Amazon credits back to nothing drops to $0.00.

The settlement line still posts through your settlement mappings. A cost entry is for reporting only and doesn't post to your books, so the fee isn't counted twice.

Ad spend​

With Create cost entries from ad spend turned on for your Amazon Ads connection, each day's Sponsored Products spend becomes a cost entry of type Amazon Advertising, split across the products the advertised SKUs are matched to. Spend on unmatched SKUs stays unallocated until you match them. See Connect Amazon Ads and attribute spend.

3PL storage and other fees​

Third-party warehouse invoices aren't read automatically. To place a 3PL's monthly storage invoice on the products stored there:

  1. Record the invoice as a cost entry.
  2. Allocate it to the products, by your own amounts or with Quantity Based or Volume Based across a document's lines.

For a large invoice broken down by SKU, use Import with the With Allocations format: one row per SKU, all sharing the invoice's Reference.

Per-order shipping charges from a 3PL are different. They belong on the sales order, as with VeraCore fulfillment costs.

Next steps​

Last verified: