Skip to main content
Amazon integration

Match Amazon settlement reports to orders and shipments, through month-end close

Amazon settlements are usually cut every 14 days, and one order arrives as several lines: item price, fees, refunds. BATI CIS matches settlement report lines to sales by order and product, carries over sales whose settlement has not arrived in the sales month, and continues through month-end close and ERP journal entries.

Why Amazon settlements don't line up with sales right away

The Amazon documents behind these points are listed at the bottom of this page.

Settlement periods don't follow the sales month

Settlements are usually cut every 14 days and cross month ends. Proceeds can also be held for a while before they settle, so this month's sales often land in next month's settlement.

One order becomes several lines

The Flat File V2 settlement report puts amounts in three columns: amount type, amount description and amount. One order spreads over lines for item price, selling fees, promotions and refunds, and each line appears in the settlement period in which it was released.

Receiving KRW changes the amount again

With the Amazon Currency Converter for Sellers (ACCS), proceeds are converted at the rate on the transfer day and a fixed 1.5% fee is deducted for KRW, so the dollar or yen amount in the report differs from the won that reaches the bank.

One report, one currency

Every order, adjustment and fee amount in a settlement report is in one currency. Selling in stores with different currencies, such as the US and Japan, means combining the per-currency reports at an exchange rate you choose.

How BATI CIS handles it

Amazon data is organized in the same format as other channels and 3PL shipment data, and goes into reconciliation and month-end close together with them.

  1. 1

    Collect

    Amazon orders and settlement reports are collected per store and organized in the same format as other channels.

  2. 2

    Match

    Settlement lines are matched to sales by order and product, and fees, refunds and adjustments are applied to those sales.

  3. 3

    Carry over

    Sales whose settlement has not arrived in the sales month are carried into the next month and matched in the month the settlement arrives.

  4. 4

    Entries

    Fees and net sales by store and product become journal entries in the format your ERP expects.

Finance reviews only what doesn't match

Matched settlements go straight to entries; only these three stay on the review list.

Sales without a settlement

Sold, but not in a settlement report yet. Reviewed together with the amounts carried over to next month.

Settlement lines without a sale

Fees, adjustments and charges that don't link to an order. Check whether it is an account-level charge or a missing order.

Amounts that differ

The same order, settled for a different amount than expected. Check refunds, promotions and fee changes.

From November 11, 2026 there is one SP-API settlement report format: Flat File V2

Amazon removed the SP-API XML settlement report and the original Flat File settlement report on November 11, 2026, leaving Flat File V2 (SP-API changelog, all marketplaces). Amazon told EU and Japan sellers in its seller forums that both formats would be discontinued from March 31, 2022, and this removal was announced in the SP-API changelog, so check integrations that pull reports through SP-API first. Since November 11 calls for the old formats fail, and pulling V2 through the API needs the Finance and Accounting role.

Published customer case

K-Beauty Brand C: finance team month-end close from 3 days to 3 hours

A K-beauty brand selling on global channels such as Amazon, Shopee and TikTok Shop. Results vary by setup.

Finance team month-end close
3 days → 3 hours

Common questions about Amazon settlements

How often does Amazon settle?

Settlement periods are usually cut every 14 days, and the payout goes to your registered account when a settlement closes. When receiving KRW through the Amazon Currency Converter for Sellers, funds arrive within 1–5 business days. Proceeds can be held for a while, so the sale date, settlement date and deposit date can all differ.

Where do I get Amazon settlement reports?

In Seller Central, use All Statements under Payments (legacy view) or Finance Report (new view). The current settlement period cannot be downloaded; generated reports stay available for 90 days, and past periods can be regenerated with Request Report. Through SP-API, settlement reports cannot be requested or scheduled; Amazon generates them and you find them with getReports.

What if I still use the XML or the original Flat File settlement report?

In SP-API, calls for either format fail from November 11, 2026, and only Flat File V2 remains. V2 carries the same information in fewer columns, with price columns condensed into amount type, amount description and amount, so existing processing may need to change.

Why does the KRW deposit differ from the settlement report?

The Amazon Currency Converter for Sellers uses the rate of Amazon's partner currency provider on the transfer day and charges a fixed 1.5% for KRW regardless of sales or seller tier. The gap between the report currency and the won deposit comes from that rate and fee.

How does BATI CIS reconcile Amazon settlements?

Settlement report lines are matched to sales by order and product, and fees, refunds and adjustments are applied to those sales. Sales whose settlement has not arrived in the sales month are carried over and matched when the settlement arrives, and finance reviews only the differences that remain.

Related articles

Articles are in Korean.

Start by telling us your Amazon stores, other channels and 3PLs

Enterprise builds start with the inquiry form. We scope the channels, logistics and ERP integration together, and a dedicated manager supports rollout and operations.

Contact sales