The Settlement Profitability Report analyzes the profitability of each settlement by incorporating revenues, fees, refunds, other credits & debits along with cost of goods sold (COGS) to calculate the gross margin (GM) and percent (GM %) for each settlement. The report footer displays the totals and averages for all settlements listed.
Click here to view the video for the Amazon Product Ranking report.
Column Headings & Field Mappings
Section
|
Column
|
Table
|
Data Field
|
Type
|
Description
|
Settlement Info
|
Settle ID
|
Settles
|
SettleID
|
Data
|
Settlement ID
|
Feed ID
|
Settles
|
FeedID
|
Data
|
Feed ID related to
|
Start
|
Settles
|
StartDate
|
Data
|
Start Date for the settlement period
|
End
|
Settles
|
EndDate
|
Data
|
End Date for the settlement period
|
Deposit
|
Settles
|
DepDate
|
Data
|
Deposit Date for the settlement period
|
Deposit Amt
|
Settles
|
DepAmt
|
Data
|
Deposit Amount
|
Sales
|
Nbr Ords
|
Settles
|
OrdsCnt
|
Data
|
Number of Orders for the Settlement
|
Revenue
|
Settles
|
SalesRev
|
Data
|
Gross Sales
|
Fees
|
Settles
|
FeesTotal
|
Data
|
Total Sales Fees
|
Cogs
|
Orders
|
Sum of SalesCogs
|
Calculated
|
Cost of Good Sold (COGS) for the settlement period
|
GM
|
|
Proprietary Algorithm
|
Calculated
|
Sales Gross Margin (GM)
|
GM %
|
|
Proprietary Algorithm
|
Calculated
|
Sales Gross Margin Percent (GM %)
|
Refunds
|
Nbr Refunds
|
Settles
|
AdjCnt
|
Data
|
Total Number of Refunds for Settlement
|
Sales
|
Settles
|
AdjSales
|
Data
|
Total Sales Refunded
|
Fees
|
Settles
|
AdjFees
|
Data
|
Total Fees Refunded
|
Credits
|
Settles
|
AdjCredits
|
Data
|
Total Credits Applied
|
Total
|
Settles
|
AdjTotal
|
Data
|
Total Net Refunds for Settlement
|
Rate %
|
|
Proprietary Algorithm
|
Calculated
|
Refund rate percent
|
Other
|
Nbr Trans
|
Settles
|
OthCnt
|
Data
|
Total Count of Other Transactions
|
Amount
|
Settles
|
OthAmt
|
Data
|
Total Amount of Other Transactions
|
Rate %
|
|
Proprietary Algorithm
|
Data
|
Other rate percent
|
Summary
|
Cogs
|
Orders
|
Sum of SalesCogs
|
Calculated
|
Cost of Good Sold (COGS) for the settlement period
|
Expenses
|
|
Fees + Other + Refunds
|
Calculated
|
Total expenses for the Settlement period
|
GM
|
|
Proprietary Algorithm
|
Calculated
|
Settlement Gross Margin (GM)
|
GM %
|
|
Proprietary Algorithm
|
Calculated
|
Settlement Gross Margin Percent (GM %)
|
|