Sales Tracker reads the Royalties report from Amazon KDP. It does not read the Payments report.
Download the right file
- In KDP, go to Reports, then Royalties.
- Choose a date range and click Download.
- KDP gives you an XLSX file with your combined sales, ebook, paperback and hardcover royalties, and a KENP sheet if you have Kindle Unlimited page reads. All of these import together.
The Prior Month Royalties download also works. The month is taken from its Sales Period.
If you download the Royalties or Kindle Unlimited report as CSV instead of XLSX, import each file separately. Sales Tracker works out which one it is.
Import it
- Open Sales Tracker and go to the Import tab.
- Drop the file on the drop zone or click Select File.
- Leave Platform on Auto-Detect (or choose Amazon KDP) and click Import File.
Page reads that show Pending
KDP doesn't put a price on Kindle Unlimited page reads until the month has closed. Those rows show Pending in the royalty column on the Dashboard tab.
Once KDP shows the amount in your report, click Enter amount next to Pending, type the royalty and click Save. This fills in the row without importing the report again, which would create duplicates.
If you see a Payments report message
If the import says the file is an Amazon KDP Payments report, you've downloaded the wrong report. Go back to Reports, then Royalties, and download that one instead.