Adding an Amazon Product Expense as a Source will make daily unit expenses available on your managed database. It will also add product expense reporting to your profit and loss analyses.

Where Product Expenses Data Appears

Datasets: your product expenses (COGS) will flow in the following tables:

FINANCE.FINANCE_COGS

FINANCE.FINANCE_COGS_SKUFINANCE_PROFIT

FINANCE.FINANCE_PROFIT_LEDGER

FINANCE.FINANCE_PROFIT_METRICS

Dashboards:

• Seller Finances and Supply Chain on Power BI: Product expenses data will be included in profit and loss reporting.
• Analytics Essentials on Looker: Product expenses data will be included in profit and loss reporting.

Uploading Product Expenses

1. Download the CSV template.
2. Fill in the template with:
   • Account ID: Seller Central Account ID.
   • Marketplace: Domain name.
   • ASIN: Product identifier.
   • Start/End Date: Duration the cost applies.
   • Product Cost: Per-unit cost of goods sold.
   • Currency: Currency for the cost.
3. Save in CSV UTF-8 format.
4. Upload the CSV file.
5. Review and correct any errors.
6. Click Finish.

<aside> 💡

The system always uses the most recent upload to calculate final product expenses.

To Edit Previously Uploaded Data:

1. Re-upload the updated values for the affected products and date range.
2. The system will automatically overwrite the old data with your new submission. </aside>

<aside> ℹ️

Updates take up to 24 hours.

</aside>