Settlement net per SKU
settlement_profit_by_skuGroups Amazon settlement report lines by SKU to show units, orders, sales, fees, net, and net per unit, while keeping unattributed charges in a separate group so totals match exactly.
Instructions
Groups the lines of an Amazon settlement report by SKU and returns, for each SKU, units, orders, sales, fees by bucket, net and net per unit. Lines Amazon booked without a SKU (storage, subscription, most reimbursements) are kept as their own unattributed group instead of being spread across products, so the SKU nets plus that group equal the report's net exactly. Set include_lines to see the individual lines behind one SKU.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"path": "<path>"
},
"name": "settlement_profit_by_sku"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end | No | End date (YYYY-MM-DD, inclusive), compared with each line's posted date — the day Amazon moved the money. Omit for the whole report. | |
| sku | No | Optional: return only this SKU. | |
| path | Yes | Path to the settlement report file. | |
| start | No | Start date (YYYY-MM-DD, inclusive), compared with each line's posted date — the day Amazon moved the money. Omit for the whole report. | |
| include_lines | No | Include the individual settlement lines per SKU (default false). |