Amazon Payouts

On a monthly basis, Amazon pays out our book sales per Amazon domain/currency group. In the KDP backend, under Reports > Statements > Prior Months' Royalties you can download a monthly royalty report, listing all sales under the tab Paperback Royalty.

There is a spreadsheet of past payments: https://docs.google.com/spreadsheets/d/1V9VqdaJUb2iaHgC8eVM8wr5lXWviM6zL0Em-psOsO68/edit?usp=sharing 

• Copy the ledger into the pertinent cells of the spreadsheet Data tab.
• In the Summary per Currency tab, copy the cells of the previous month, this will generate Total Book Printing Costs and Total KDP Fee per currency.
  
• The Total Summary tab gives the totals
• For the conversion rate of each currency, use the date of OBC payment notice and historic exchange rate on that date (or next non-bank holiday): https://www.x-rates.com/historical/?from=USD&amount=1&date=2025-04-05
• Put in the fees separately as a journal entry set on the first of the previous month:
  DEBIT KDP Fees / Book Printing
  CREDIT Book Sales