Skip to content
Bookalyze
Start free

Amazon settlements: bring in, upload, post

Every Amazon settlement comes in on its own and reads line by line. Upload older ones, or rebuild years of history from one date range transaction report, then post each as one entry.

Bring them in

Where in the app: Commerce → Settlements

The daily job brings in new settlement reports; Bring in settlements asks straight away. Amazon lists about the last 90 days, and rations requests hard, so a first look can take a few rounds. It needs the Finance and Accounting role.

Older settlements

Upload settlement files (admins) takes two kinds of file. Both are read in your browser.

FileWhere in Seller CentralGood for
Flat File V2Payments → All statementsOne settlement per file
Date range transaction reportPayments → Reports Repository → Transaction, custom rangeEvery settlement back to the start, in one CSV, plus older orders

The transaction report has no reserve lines, so Bookalyze works out what Amazon held back and released from each payout, and the payouts still match your bank. Settlements already here are kept as they are.

Read a settlement

Each settlement's page groups its lines in plain names ("Referral fee", not "Commission") with subtotals: sales, refunds, promotions, Amazon fees, tax on Amazon's fees, advertising, tax Amazon collects and pays, reimbursements, held back and released, other. A settlement whose lines don't add up to Amazon's total says Check.

A negative settlement (fees and refunds above sales, say a quiet month with the plan fee) shows No payout: Amazon charges your card or carries it into the next one.

Post it

With the accounts chosen (see How payouts post), Post to books makes one entry dated the period's last day, referenced with Amazon's settlement ID. A settlement in another currency (Amazon.ae in a Canadian company) posts at that day's rate and says so.

What you should see

What you should see

  • The list shows each settlement's period, marketplace, deposit date and amount
  • Ready to post, then In books · match deposit, then In books · deposit matched
  • Nothing earned left in the clearing account once deposits are matched

Read next

  • How payouts post to your books

    Choose an account for each kind of money (sales, refunds, fees, ads, tax, held back) and a clearing or balance account for the payout, pick the day posting starts, then post by hand or automatically. The same idea for Amazon, Walmart, Noon and eBay.

    Read the guide

  • Match each payout to its bank deposit

    Matching pairs a marketplace payout with the deposit in your bank and moves that deposit to the clearing or balance account, so your sales are counted once. Works in any bank account and any currency.

    Read the guide

  • Connect Amazon: get your Selling Partner API keys

    Create a private Selling Partner API app for your own seller account, give it the roles Bookalyze needs, and paste its client ID, client secret and refresh token. About 15 minutes, plus Amazon's review of a new developer profile.

    Read the guide