Documentation

Unified Transaction Report Skill

Seller Central's Date Range Transaction Report for the most recent 90 days, as a CSV. Each row is one payment line item — orders as well as non-order transactions such as refunds, service fees, FBA fees, and adjustments.

Time Period A rolling 90-day window ending yesterday.
Report Format: csv
Coverage: All Amazon Marketplace, Fulfillment by Amazon (FBA), and Amazon Webstore transactions for the account over the window, in the marketplace's currency.

Column reference

ColumnDescription
date/timePosted date/time of the transaction (marketplace time zone).
settlement idThe settlement this transaction was paid out in.
typeTransaction type (e.g. Order, Refund, Service Fee, FBA Transaction fees).
order idAmazon order ID (blank for non-order transactions).
skuYour merchant SKU.
descriptionProduct title or a description of the non-order charge.
quantityUnits for the transaction.
marketplaceMarketplace the transaction occurred in (e.g. amazon.com).
account typeOrder channel (e.g. Standard Orders).
fulfillmentAmazon (FBA) or Seller (merchant-fulfilled).
order city / order state / order postalBuyer ship-to location.
tax collection modelWho remits the tax (e.g. MarketplaceFacilitator).
product salesProduct revenue for the row.
product sales taxSales tax collected on the product.
shipping credits / shipping credits taxShipping charged to the buyer and its tax.
gift wrap credits / giftwrap credits taxGift wrap charged to the buyer and its tax.
Regulatory Fee / Tax On Regulatory FeeRegulatory fee charged and its tax.
promotional rebates / promotional rebates taxPromotions applied and their tax.
marketplace withheld taxTax Amazon withheld and remits on your behalf.
selling feesReferral and variable closing fees.
fba feesFulfillment fees for FBA orders.
other transaction feesShipping chargebacks/holdbacks, per-item fees, and sales-tax collection fees.
otherNon-order transaction amounts (see the type/description for detail).
totalNet amount for the row.
Transaction StatusReleased or deferred.
Transaction Release DateWhen a deferred transaction is released.

Reports with a start date of Jan 1, 2025 or later are indexed by posted date and include both released and deferred transactions.

Example row (values are illustrative):

Example Report:
"date/time","settlement id","type","order id","sku","description","quantity","marketplace","account type","fulfillment","order city","order state","order postal","tax collection model","product sales","product sales tax","shipping credits","shipping credits tax","gift wrap credits","giftwrap credits tax","Regulatory Fee","Tax On Regulatory Fee","promotional rebates","promotional rebates tax","marketplace withheld tax","selling fees","fba fees","other transaction fees","other","total","Transaction Status","Transaction Release Date"
"Jul 1, 2026 1:50:38 AM PDT","12345678901","Order","111-0000000-0000000","EXAMPLE-SKU","Example Product Title","1","amazon.com","Standard Orders","Amazon","FRANKLIN","OH","00000","MarketplaceFacilitator","9.99","0.67","0.74","0","0","0","0","0","-0.74","0","-0.67","-1.50","-2.65","0","0","5.84","Released","Jul 9, 2026 2:53:06 AM PDT"