KDP sales report dashboard

Drop the report files you download from KDP Reports. You get your units sold, refunds, Kindle Unlimited pages read and royalties by month, by book, by format and by Amazon store, with charts and a summary you can save. Your files never leave your browser.

An honest note: I built this from the column names in KDP's own help pages and tested it on made-up files, not on a real author's report. If one of your files does not read properly, tell me which report it was and what went wrong (please don't send the file itself).

1. Get your report from KDP

  1. Sign in at kdpreports.amazon.com.
  2. Choose a report on the left. Prior Months' Royalties is the official monthly record. The Dashboard and Orders reports cover recent days.
  3. Pick the dates and books, then click Download report (KDP's help says "click Download report in the top right corner").

2. Drop the files here

Or drag them onto this box. Excel files (.xlsx) and CSV. Drop several months at once: a row that appears in two files is counted once.

The sample is a made-up file with three made-up books. None of it is real sales.

Private by design. The files are read by your own browser. Nothing is uploaded, sent or saved, and closing the page forgets them.

Your totals show here once a file is read. Try the sample file to see what you get.

What the numbers mean

Royalties stay in their own currency. KDP pays each store in its own money, and this page has no exchange rate to use, so dollars, pounds and euros are added up apart and never mixed. On its Prior Months' Royalties report KDP says: "For prior months, we use the exchange rate on the last day of the month." So what reaches your bank can differ from these sums.

Net units are units sold minus units refunded. KDP's words: "Net Units Sold = Units Sold – Units Refunded. This is the basis of your royalty calculation."

KENP read is Kindle Unlimited pages read. The money for those pages comes from the KDP Select Global Fund. The Dashboard's KENP tab has pages only. The Prior Months' Royalties download has a "Kindle+ royalties" column on its KENP tab, and an "Audible royalties" column on its Audible Royalty tab, and this page adds both to your royalties in their own currency.

Orders (Paid Units and Free Units) count books ordered, not royalties earned, so they sit in their own columns and are never added to units sold.

When a file has the Combined sales tab and the eBook, Paperback and Hardcover tabs, the page reads the format tabs and skips Combined sales, because it holds the same rows. A Total Earnings tab is a summary, so it is not added again. Any column the page does not know is listed under the file as "Not read", and so is any number it cannot read.

Keep going with your numbers

To keep these numbers month after month next to your price and ad spend, the Author Numbers Kit is the spreadsheet I made for it.

To see what one sale of a book earns before you change its price, use the KDP royalty calculator.

Column names and their meaning from KDP's help pages, checked 17-Nov-26: Sales and Royalties Report, Prior Months' Royalties Report, Orders Report and KDP Reports. KDP can change its files at any time. If yours look different, the page lists what it could not read rather than guess.

More free tools: the KDP royalty and print cost calculator, the book sales calculator, the author copies calculator, the Barnes & Noble Press royalty calculator, the book price calculator and the Etsy fee calculator for books. See all the free tools.

Want more of these numbers next month?

I've published 230 books, and the free checklist is the 12 steps I follow for every one, from choosing a topic to setting up the book's marketing.

You get the free checklist and Chris's emails. Unsubscribe any time. Privacy policy