Profit and loss from an Amazon settlement report
read_settlement_reportReads Amazon settlement reports from your disk to show exact sales, refunds, fees, net and per-SKU profit. Use it to verify what Amazon actually paid without uploading files.
Instructions
Reads an Amazon settlement report (the tab-separated flat file from Seller Central → Payments → Reports Repository) from this computer and returns what Amazon actually settled: sales, refunds, promotions, referral and FBA fees, storage, subscription, reimbursements and the net, plus units, orders, average price, FBA fee per unit and referral rate. With a unit cost it also returns profit after product cost. Amounts are exact to the cent. The file never leaves this machine.
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": "read_settlement_report"
}
}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. | |
| path | Yes | Path to the settlement report file (absolute, relative, or starting with ~). | |
| 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. | |
| cogs_per_unit | No | Optional landed cost per unit in the report's currency, e.g. "7.40". Used to compute profit after product cost. |