MyProfit

Settlements

The payouts Amazon sends you, what is in each one, and downloads for QuickBooks Desktop.

Amazon pays you in settlements: roughly every two weeks it adds up your sales, subtracts its fees, refunds and any reserve, and deposits the rest. MyProfit loads each settlement report for North American accounts.

The Settlements page

Settlements lists your payouts in the current marketplace's currency, newest first, with the last 90 days added up at the top. Each payout shows its sales, refunds, Amazon fees (and their share of sales), Other (reimbursements, sales tax Amazon collected and paid for you, money held back or released), what was paid to you, and its profit (below).

Open a payout to see:

  • Where the money went: from sales down to the deposit, one line per kind of fee or credit, with each fee's share of sales.
  • Profit from this payout: the deposit down to profit (below).
  • By product: units, sales, refunds, Amazon fees, what each SKU netted in this payout, its cost of goods and its profit. For profit by order date instead, see Products.
  • Other charges and credits: storage, inbound placement, subscription, reimbursements, reserves and the rest of what isn't tied to an order.
  • Downloads: every line as a spreadsheet, and three files for QuickBooks Desktop's Batch Enter Transactions: invoices and credit memos (sales by SKU), bills (Amazon's fees and other lines) and the sales tax deposit. Together they add up to the payout.

A payout marked Partly loaded has lines that don't add up to what Amazon paid yet, usually because loading it was interrupted. MyProfit finishes it the next time it reads that report.

Profit by settlement

A payout's profit starts from what Amazon deposited, so it lines up with your settlement report:

  • Paid to you, less the sales tax, reserves and loan repayments in it: they move money but aren't income.
  • Less the cost of goods: the landed cost of the units sold in the payout, at the cost in force on each order's date (from Costs).
  • Plus the cost of refunded units back in stock: units refunded in the payout that Amazon put back into sellable stock. Returns keep arriving for a few weeks, so a recent payout's profit can still move.
  • Less ads paid by card: if the payout has no ad charges, Amazon billed your Sponsored Products to your card, so the ad spend over the payout's dates is taken off here.

Its margin is profit as a share of the payout's sales. Units sold without a cost are flagged, since they make profit look higher than it is. This is profit by payout; the Overview, Products and Profit & loss pages show profit by order date, so the two differ for any period whose orders and payouts don't line up.

Where else settlements show up

  • Profit: settled fees replace Amazon's estimates on each order, and storage fees and reimbursements come from settlements. See How MyProfit works out profit.
  • One order: Money from Amazon on an order's page lists the settlement lines Amazon posted for it, each linked to its payout. See Finding an order.
  • Xero: each settlement becomes one entry in your books that matches the deposit. See Xero and QuickBooks.

When settlements arrive

MyProfit checks for new settlement reports every afternoon (Pacific), and matches their figures to your orders that evening.

See it with your own Amazon data. MyProfit is free for 30 days, then $19.99 a month. No credit card to start. Start your free trial