Reports

Velocity Report:
Report Refreshes daily, any changes made will reflect in the next refresh

Removal and Disposal report: Updates several times a day.

Importing Lead times in bulk will probably not happen in order to avoid users tracking all items that they will not replenish. 
  

Inventory Valuation Report: 

Is not available before July 2015 (When the report was created) or if the users account was not linked to Amazon during the time frame.

This is a snap shot report or like an image taken of a users inventory.  any changes made will not reflect on past reports, so if a user needs to use this report for taxes but has not entered their COGS they would need to manually calculate these in the file.

Profitability Report Calculations

Get all Orders and Refunds(including Refunds from any Profitability Report).
 
Calculate according to the data source using formula below:

ROI = Total Net Profit / Total Buy Cost * 100(if Total Buy Cost > 0)

ROI = 0(if Total Buy Cost = 0)

Total Buy Cost = sum(Order Buy Cost) - sum(Refund Buy Cost)
 Total Net Profit = sum(Order Net Profit) - sum(Refund Net Profit)

More info from Dev: 

The data source is from sales and refunds for all of these four reports, and the On Hand is from Inventory.

For the ASIN Profitability report,
The Orders are from the orders(order count).
The Units Per Order are from the orders(order item shippedqty/order count).
The Revenue is from the orders less the refunded orders.
The Cost/Unit is from the orders(buy cost of orders/order item shippedqty).
The Profit is from the orders less the refunded orders.
The ROI is from the orders less the refunded orders(profit/buy cost of orders and refuneded orders).

For the SKU Profitability report, it is the same as ASIN Profitability report.

For the Category Profitability report,
The Units Sold are from the orders(order item shippedqty).
The Revenue is from the orders less the refunded orders.
The % Of Revenue is from the orders less the refunded orders(this item divided by Total Revenue).
The Profit is from the orders less the refunded orders.
The ROI % is from the orders less the refunded orders(profit/buy cost of orders and refuneded orders*100).

For the Supplier Profitability report, it is the same as Category Profitability report.
User reached out asking what information he could add to the Profitability report to match the Net Profit on the Profit and Loss:

Here are calculations for what is included in the Supplier Profitability Report from the P&L and what is not

Things on the P&L to add to get Supplier Profitability values:

Sales

Refunds

MFN Shipping Credit

Shipping Credit

Shipping Credit Refunds

Gift Wrap Credits

Gift Wrap Credit Refunds

Promotional Rebates

Promotional Rebate Refunds

Restocking Fee

Good Will

Cost Of Goods Sold (from Sales and Refunds ONLY, so export each report for the dates you want and sum the Buy Cost/Cost per Unit Credit columns)

Selling Fees

FBA Transaction Fees

FBA Transaction Fee Refunds

Sales Tax Service Fee

Sales Tax Service Fee Refunds

MFN Shipping Label Cost

MFN Shipping Label Cost for Return

Selling Fee Refunds

Refund Administration Fee

Closing Fee Refunds

FBA Customer Return Per Order Fee/FBA Customer Return Per Unit Fee/FBA Customer Return Weight Based Fee

Parts of P&L that are not in the Supplier Profitability Report

Reimbursement

Cost of Goods Sold (from Reimbursements and Removals/Disposals ONLY, so export each report for the dates you want and sum the Buy Cost/Buy Cost Adj columns)

FBA Inventory and Inbound Service Fees (all EXCEPT the FBA Customer Return Per Order Fee/FBA Customer Return Per Unit Fee/FBA Customer Return Weight Based Fees)

Cost of Advertising

Amazon Pro Subscription

Is this article helpful?
0 0 0