Blog ·
Amazon retired the XML settlement report. What changes for your reconciliation
Since March 2026 the Flat File V2 settlement report is the only one Amazon produces. Its layout differs from the old reports in a way that doubles every figure if you import it naively.
Amazon's XML settlement report and the original flat-file report were retired on 25 March 2026. Any importer, spreadsheet macro or reconciliation tool built on them stopped receiving data that day. The replacement is Flat File V2, and it is not a rename.
What Flat File V2 looks like
- Tab-separated, one row per charge, not one row per order. A single order can produce several rows: the principal, the commission, the fulfilment fee, a promotion rebate, each with its own amount.
- The kind of charge is in two columns, amount-type and amount-description. Order modifications (for example FBAPerOrderFulfillmentFee) are per order; non-order modifications (FBA storage, subscription fees) are period-level and carry no order id.
- The first row is the deposit total for the settlement period with no transaction type. It is a header, not a charge.
The mistake that doubles everything
Sum the amount column without skipping that first row and the batch total appears twice: once as the header's deposit figure and once as the sum of the charges beneath it. Every reconciled figure in the period is then wrong by exactly the payout. It is an easy mistake because the row looks like data, and a hard one to notice because the result is plausible on a busy month.
What to do
- Treat the first row as the batch header: read its total, then verify that the signed sum of the remaining rows equals it. If they differ, the import is incomplete.
- Group charges by order id for the order-to-settlement check, and separately total the rows without an order id for the period-level fees. Mixing them hides a missing order behind a storage fee.
- Keep TCS separate from fees. It is recoverable credit under CGST section 52, claimed through GSTR-2A/2B against Amazon's GSTR-8, and booking it as a fee overstates your cost of selling.
ezmarketplaces reads Flat File V2 this way: the header row is verified against the signed sum, each charge is matched to its order, and every difference from the expected fee lands in the Recovery ledger with the source row behind it.