query_pnl_bridge
P&L BRIDGE: the order-based and the cash-based P&L of the same months side by side, and what separates them — for a finance team tying the commercial month (the orders) to the settlement month (the cash). view="month" (default): one row per calendar month over the accounts (and marketplaces) in scope with, for each P&L line (product sales, other sales, sales deductions, VAT, net sales, cost of goods, Amazon fees, FBM cost, PPC spend, DSP cost, net profit), the order reading (order), the cash reading (cash) and bridge = cash − order; sales splits the month's sales by TIMING on both sides (order sales whose principal was posted the same month / later / earlier / not yet; cash sales from lines purchased the same month / earlier months / later months / lines the order report does not know, of which sold to Amazon and without items) and gives the FX gap and the valuation gap of the same lines; fees does the same for the purchase-date fees (estimated at the order vs actually released). view="settlement": one row per settlement whose RELEASED postings fall in the months asked, most recent first, with the purchase months it pays (byPurchaseMonth, by marketplace and origin) and its own currency; settlementId narrows to one settlement and implies this view. Seller Central accounts only. 📐 HOW TO READ: amounts are as the marts store them — sales positive, costs and fees NEGATIVE (net profit = the sum of the lines); a positive bridge on a cost line means the cash reading spent less. Order basis = the day the order was purchased (what query_metrics serves by default); cash basis = the day Amazon POSTED the money, RELEASED postings only (what query_metrics serves with basis="cash"); a settlement = the RELEASED postings grouped under one settlement_id, the payout itself (the Transfer) excluded, so the sum of a settlement ties to the settlement report to the cent. Neither side has a live overlay: the current month is incomplete on both. Monetary values are in the organization's PRIMARY currency (currency in the response, the currency the marts are built in), never the caller's display preference; cashSalesLocal is in the settlement's own currency. total null = the bridge is not built in this environment; a null figure = not carried by the deployed bridge (unknown, never zero). Months are YYYY-MM.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | Yes | Last month, INCLUSIVE (YYYY-MM). With view="settlement": the settlements whose released postings fall, at least in part, in from..to. | |
| from | Yes | First month, INCLUSIVE (YYYY-MM). | |
| view | No | "month" (default): by calendar month, the two P&L and the bridge. "settlement": by settlement, most recent first, the purchase months each one pays. | |
| limit | No | view="settlement": settlements served, 1 to 200 (default 50); `truncated` in the answer says when more fall in the window. | |
| reason | No | One sentence, ALWAYS IN ENGLISH (regardless of the conversation language), on WHY you are making this call — the user question or your analytical goal. Recorded so the seller can see how their data is used. | |
| accounts | No | Restrict to a subset of your own seller account IDs (from list_accounts). Omit to include all your accounts. A brand/account name is accepted and resolved to its id when it matches one of your accounts unambiguously; a label that carries the id ("Brand (A1B2C3D4E5F6G)") resolves to that id. | |
| marketplaces | No | Marketplaces to add up: country codes (US, DE), domains (amazon.de) or marketplace ids, as list_accounts gives them for each account. Omit for every marketplace of the accounts. | |
| settlementId | No | ONE settlement, by its settlement_id (the id of the settlement report) — implies view="settlement". |