| name | amazon-seller-integration |
| description | > Integration skill for Amazon Seller Central settlement reports and date range reports. Activate when the user uploads an Amazon settlement report, Amazon seller CSV, or mentions Amazon Seller Central, FBA, or Amazon payouts. |
| license | AGPL-3.0-or-later (code) / OpenAccountants Guide License v1.0 (content) |
| metadata | {"source":"openaccountants","jurisdiction":"GLOBAL","category":"integration","quality":"source-cited draft","openaccountants_url":"https://openaccountants.com/skills/amazon-seller-integration","obligation":"INT"} |
Amazon Seller Central Integration Skill v1.0
General reference only. This skill is general tax/accounting reference material for AI-assisted workflows. It has not been reviewed for any specific person's facts, documents, elections, deadlines, residency, filing status, or local procedures. Do not rely on it to file, pay, amend, or take a tax position without review by a qualified professional in the relevant jurisdiction.
Section 1 — Platform Overview
Amazon Seller Central is the platform used by third-party sellers on Amazon's marketplace. It handles product listings, order management, fulfilment (FBA or FBM), advertising, and financial settlements. Amazon operates marketplaces in 20+ countries including the US, UK, Germany, France, Italy, Spain, Japan, Australia, India, and Canada.
Amazon's financial data is exceptionally complex because every order generates multiple line items: product price, shipping credits, gift wrap, promotional rebates, FBA fees, referral fees, taxes, and more. Each line item is a separate row in the settlement report.
Section 2 — Export Formats
| Format | Use Case |
|---|
| TSV (Tab-separated) | Settlement Report V2 (GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2). The primary financial report. |
| CSV | Date Range Reports (custom period exports from Payments dashboard). |
| XML | Settlement Report XML version (legacy). |
| PDF | Summary reports, account activity PDFs (for overview, not line-item data). |
The Settlement Report V2 is the most important export for bookkeeping. It covers one settlement period (typically 14 days) and includes every financial event. Date Range Reports allow custom period selection but use a slightly different format.
Section 3 — Column Mapping
Settlement Report V2 (Flat File)
| Column Header | Meaning |
|---|
| settlement-id | Unique settlement period identifier. All rows in one settlement share this ID. |
| settlement-start-date | Start of the settlement period (ISO 8601). |
| settlement-end-date | End of the settlement period (ISO 8601). |
| deposit-date | Date Amazon deposited funds to the seller's bank account. |
| total-amount | Total settlement amount deposited. Only populated on the first row. |
| currency | Three-letter ISO currency code (USD, GBP, EUR). |
| transaction-type | Order, Refund, Service Fee, Adjustment, Transfer, Liquidations, other (see Section 4). |
| order-id | Amazon order ID (e.g., 111-1234567-1234567). Blank for non-order transactions. |
| merchant-order-id | Seller's own order reference (if set). |
| adjustment-id | Identifier for adjustment transactions. |
| shipment-id | FBA shipment ID. |
| marketplace-name | Which Amazon marketplace (amazon.com, amazon.co.uk, amazon.de, etc.). |
| amount-type | Category of the amount: ItemPrice, ItemFees, Promotion, ItemWithheldTax, other. |
| amount-description | Specific fee/charge name (see Section 4 for complete list). |
| amount | The monetary value. Positive = credit to seller, negative = debit from seller. |
| fulfillment-id | AFN (Fulfilled by Amazon / FBA) or MFN (Merchant Fulfilled). |
| posted-date | Date the transaction was posted. |
| posted-date-time | Full timestamp of posting (ISO 8601). |
| order-item-code | Amazon's internal line item identifier. |
| merchant-order-item-id | Seller's own line item reference. |
| merchant-adjustment-item-id | Seller's adjustment reference. |
| sku | Product SKU. |
| quantity-purchased | Number of units in the order. |
| promotion-id | Promotion identifier if a promotion was applied. |
Section 4 — Transaction Type Codes
transaction-type values
| Value | Meaning |
|---|
| Order | Revenue from a customer order |
| Refund | Refund issued to customer (reverses order amounts) |
| Service Fee | Amazon service charges (subscription, advertising, FBA storage) |
| Adjustment | Manual adjustments (reimbursements, corrections) |
| Transfer | Settlement deposit to seller's bank account |
| Liquidations | FBA liquidation proceeds |
| other | Catch-all for miscellaneous events |
amount-type values
| Value | Meaning |
|---|
| ItemPrice | Revenue components: Principal (product price), Shipping, GiftWrap, etc. |
| ItemFees | Amazon fees: Commission (referral fee), FBAPerUnitFulfillmentFee, ShippingHB, etc. |
| Promotion | Promotional discounts funded by the seller |
| ItemWithheldTax | Tax withheld by Amazon on behalf of the seller |
| other | Miscellaneous amounts |
Key amount-description values
| amount-description | Meaning |
|---|
| Principal | Product sale price (revenue) |
| Shipping | Shipping credit from buyer |
| ShippingTax | Tax on shipping |
| Tax | Product tax collected |
| GiftWrap | Gift wrapping fee |
| Commission | Amazon referral fee (percentage of sale price) |
| FBAPerUnitFulfillmentFee | FBA pick, pack, and ship fee per unit |
| FBAPerOrderFulfillmentFee | FBA per-order fee |
| FBAWeightBasedFee | FBA weight-based shipping fee |
| ShippingHB | Shipping handling fee |
| StorageRenewalBilling | FBA monthly/long-term storage fees |
| Subscription | Professional seller subscription ($39.99/mo) |
| PromotionShipping | Seller-funded free shipping promotion |
Section 5 — Fee Structure
| Fee Type | How It Appears |
|---|
| Referral fee (Commission) | transaction-type = Order, amount-type = ItemFees, amount-description = Commission. Typically 8–15% depending on category. Negative amount. |
| FBA fulfilment fee | transaction-type = Order, amount-type = ItemFees, amount-description = FBAPerUnitFulfillmentFee. Per-unit fee based on size/weight. |
| FBA storage fee | transaction-type = Service Fee, amount-description = StorageRenewalBilling. Monthly and long-term storage charges. |
| Professional seller subscription | transaction-type = Service Fee, amount-description = Subscription. $39.99/month. |
| Advertising fees | Separate report (Sponsored Products). Not in the settlement report. |
| Refund administration fee | When Amazon refunds a customer, the original referral fee may be partially retained. Appears as a positive ItemFees amount on the Refund row. |
Multiple fee rows per order are normal. A single order may generate 5–10 rows: Principal, Shipping, Tax, Commission, FBAPerUnitFulfillmentFee, Promotion, etc.
Section 6 — Tax-Relevant Fields
| Field | Notes |
|---|
| amount-description = Tax | Sales tax / VAT collected on the product price. |
| amount-description = ShippingTax | Tax on shipping charges. |
| amount-type = ItemWithheldTax | Tax withheld and remitted by Amazon (Marketplace Tax Collection). Applies in US states where Amazon collects tax on behalf of sellers. |
| marketplace-name | Determines which country's tax rules apply. |
| currency | Tax currency matches the marketplace currency. |
| Shipping address (not in settlement) | Full address needed for US sales tax nexus determination. Available in the Orders report, not the settlement report. |
In the US, Amazon collects and remits sales tax in Marketplace Facilitator states. The seller sees ItemWithheldTax but does NOT owe this tax — Amazon pays it. In the EU/UK, Amazon may collect VAT under certain schemes (IOSS, OSS). Always cross-reference with the Amazon VAT Transaction Report for EU sellers.
Section 7 — Multi-Currency Handling
| Scenario | How It Appears |
|---|
| Single marketplace | All rows in one currency matching the marketplace (USD for .com, GBP for .co.uk, EUR for .de/.fr/.it/.es). |
| Multiple marketplaces | Separate settlement reports per marketplace. Each in its own currency. |
| Amazon Currency Converter | If enabled, Amazon converts foreign marketplace revenue to the seller's home currency. Settlement total-amount is in home currency. Individual rows are in marketplace currency. |
| Cross-border FBA | Inventory in one country, sold in another. Settlement reports are per-marketplace regardless of inventory location. |
Amazon does NOT show exchange rates in the settlement report. If using Amazon Currency Converter, the effective rate must be calculated from the marketplace-currency amounts vs the total-amount in home currency.
Section 8 — Reconciliation Tips
- One settlement report per settlement period. Typically 14-day cycles. You need all settlement reports to cover a full accounting period.
- total-amount = bank deposit. The total-amount on the first row should match the bank deposit from Amazon. This is the anchor for reconciliation.
- Multiple rows per order. A single order generates rows for Principal, Shipping, Commission, FBA fees, Tax, Promotions. Sum all rows for a given order-id to get the net impact.
- Aggregate by amount-type for P&L. Sum all ItemPrice amounts = Revenue. Sum all ItemFees amounts = Amazon fees (cost of sales). Sum all Promotion amounts = Promotional discounts.
- Refund rows mirror order rows. A refund generates the same row types (Principal, Shipping, Commission) but with reversed signs. The Commission refund may be less than the original (Amazon retains a refund admin fee).
- Service Fee rows are separate from orders. Storage fees, subscription fees, and other service charges have no order-id. Group these as operating expenses.
- Transfer row = settlement total. The row with transaction-type = Transfer and a negative amount represents the payout to your bank. Its absolute value should equal total-amount.
Section 9 — Common Gotchas
- Hundreds of rows per settlement. A settlement with 50 orders may have 300+ rows because each order has 5–10 amount lines. Do not count rows as transactions.
- EU decimal format. European marketplace exports use comma as decimal separator (95,00 not 95.00). Check the locale before parsing.
- Tax collected ≠ tax owed (US). In Marketplace Facilitator states, Amazon collects and remits. The tax rows are informational, not money owed by the seller.
- Promotional rebates reduce revenue. Seller-funded promotions (free shipping, percentage-off coupons) appear as negative Promotion amounts. Subtract from gross revenue.
- FBA reimbursements. When Amazon loses or damages inventory, reimbursements appear as Adjustment rows. These are not revenue — they are compensation for lost inventory.
- Currency Converter hides FX risk. If using Amazon's converter, the settlement is in your home currency but individual rows are in the marketplace currency. The FX spread is Amazon's profit, not visible in the report.
- Advertising costs are in a separate report. Sponsored Products, Sponsored Brands, and Sponsored Display fees do NOT appear in the settlement report. They are deducted in a separate settlement or charged to a card.
- Negative settlements. If refunds + fees exceed revenue in a period, Amazon may charge the seller's card or carry a negative balance forward. The total-amount will be negative.
Section 10 — Sample Data
settlement-id settlement-start-date settlement-end-date deposit-date total-amount currency transaction-type order-id merchant-order-id adjustment-id shipment-id marketplace-name amount-type amount-description amount fulfillment-id posted-date posted-date-time order-item-code merchant-order-item-id merchant-adjustment-item-id sku quantity-purchased promotion-id
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 1847.32 GBP
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 GBP Order 206-1234567-8901234 FBA12345 amazon.co.uk ItemPrice Principal 29.99 AFN 2026-03-02 2026-03-02T14:23:00+00:00 12345678901234 WIDGET-001 1
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 GBP Order 206-1234567-8901234 FBA12345 amazon.co.uk ItemPrice Shipping 3.99 AFN 2026-03-02 2026-03-02T14:23:00+00:00 12345678901234 WIDGET-001 1
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 GBP Order 206-1234567-8901234 FBA12345 amazon.co.uk ItemFees Commission -4.50 AFN 2026-03-02 2026-03-02T14:23:00+00:00 12345678901234 WIDGET-001 1
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 GBP Order 206-1234567-8901234 FBA12345 amazon.co.uk ItemFees FBAPerUnitFulfillmentFee -3.21 AFN 2026-03-02 2026-03-02T14:23:00+00:00 12345678901234 WIDGET-001 1
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 GBP Refund 206-9876543-2109876 FBA12346 amazon.co.uk ItemPrice Principal -19.99 AFN 2026-03-05 2026-03-05T09:15:00+00:00 98765432109876 GADGET-002 1
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 GBP Refund 206-9876543-2109876 FBA12346 amazon.co.uk ItemFees Commission 2.40 AFN 2026-03-05 2026-03-05T09:15:00+00:00 98765432109876 GADGET-002 1
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 GBP Service Fee amazon.co.uk other Subscription -25.00 2026-03-01 2026-03-01T00:00:00+00:00
18906543210 2026-03-01T00:00:00+00:00 2026-03-15T00:00:00+00:00 2026-03-17 GBP Transfer -1847.32 2026-03-17 2026-03-17T06:00:00+00:00
Disclaimer
This skill and its outputs are provided for informational and computational purposes only and do not constitute tax, legal, or financial advice. Open Accountants and its contributors accept no liability for any errors, omissions, or outcomes arising from the use of this skill. All outputs must be reviewed and signed off by a qualified professional before filing or acting upon.
Source: OpenAccountants — open tax Guides for AI, reviewed by named CPAs/CAs/EAs. Quality: source-cited draft. For always-current figures and named-accountant backing, connect the OpenAccountants MCP server (openaccountants-mcp).
