Convert a Amazon Flat File V2 settlement report to QuickBooks or Xero

Including multi-year catch-up - with the footing check that proves the conversion is right.

Why Amazon settlements resist clean bookkeeping

One Amazon settlement is dozens of amount types spread across hundreds of rows: ItemPrice Principal beside ItemPrice Tax beside ItemFees Commission beside FBA per-unit fulfillment fees, promotions posting as negative sales, reserves moving money that was never yours to spend. The Flat File V2 is comprehensive and utterly indifferent to how accounting works - the same order appears on many rows, and the settlement total is the only number your bank ever sees. Mapping amount types into accounts is where sellers either lose a weekend per settlement or give up and book net deposits, destroying their margin data.

How the Amazon file maps to your books

Multi-year catch-up on Amazon

The subscription incumbents cap downloadable history at 24 months, which is a product decision, not a data limit - Seller Central date-range reports go back much further. FootingKit converts whatever period a Flat File V2 covers, so a three-year backfill is twelve to thirty-six files converted under identical rules, each settlement footed against its own stated total-amount.

Importing into QuickBooks Online

1. In QBO, go to Banking → Upload transactions and choose the FootingKit QuickBooks CSV.
2. Select the 3-column layout (Date, Description, Amount) - the file is already in that layout.
3. Map each summarized line to your accounts: Sales to income, Platform fees to merchant fees expense, Refunds against income.
4. Match each payout's lines against the corresponding bank deposit. Because every payout foots to the cent, the match is exact - no plug entries.

QuickBooks bank feeds want one line per money movement against a deposit, so FootingKit summarizes each payout into category lines dated to the deposit date; order-level detail stays in the reconciliation report, out of your register.

Importing into Xero

1. In Xero, open the bank account, choose Import a statement, and upload the FootingKit Xero CSV.
2. The file uses Xero's statement layout (*Date, *Amount, Payee, Description, Reference) - no column mapping needed.
3. Create bank rules once for the Payee names and Xero codes recurring lines automatically from then on.
4. Reconcile each payout group against the real deposit; the Reference column carries the payout id so groups filter cleanly.

Xero statement imports work best when each payout arrives as a small set of coded lines, so FootingKit groups by payout and carries the payout id in the Reference field - bank rules handle the recurring coding from the second month on.

Can you really go past 24 months?

Yes. Conversion is per-file with no history cap; if Seller Central will export the period, FootingKit will convert it.

How are reserves handled?

Reserve transfers post as their own category, never netted against sales, so your settlement reports explain why a deposit was smaller than your sales suggest.

Convert your Amazon file - done-for-you from $149

FootingKit converts marketplace settlement reports into QuickBooks- and Xero-ready books, footed to the penny.