KDP Reports Explained: Sales, KENP & Royalties - Self Pub Hub

KDP Reports Explained: Sales, KENP & royalties

Too Long; Didn't Read
  • Reports are not real-time for print books. Paperbacks only show up on your dashboard when Amazon ships the item, not when the customer clicks buy.
  • KENP and Sales are separate metrics. Kindle Unlimited page reads generate royalties from a global fund that changes monthly, while unit sales have a fixed royalty rate.
  • The Month-to-Date report is your source of truth. The main graph is just a visual snapshot. For accurate royalty calculations and currency conversions, you must download the Excel spreadsheets.
  • Returns deduct from current royalties. If a customer returns a book from a previous month, you will see a negative balance in your current month’s report.

I know the feeling well. You just hit publish. You spent months writing, formatting, and agonizing over the cover. Now, you have a browser tab open to your KDP dashboard, and you are refreshing it every hour. Maybe every ten minutes. We all do it.

The Amazon KDP reporting dashboard is the heartbeat of your self-publishing business. It tells you if your marketing works. It tells you if readers enjoy your story. It tells you how much money will hit your bank account in sixty days.

However, understanding kdp reports is harder than it looks. The data can be misleading if you do not know how Amazon counts a "sale." You might see a huge spike in orders but no money in the royalty column. You might see thousands of page reads but struggle to calculate what that means in dollars.

I want to walk you through every tab, chart, and column in your KDP reports. We will strip away the confusion so you can stop obsessing over the refresh button and start making decisions based on real data.

The Dashboard Home: The "Snapshot" View

When you first click on the "Reports" tab in your KDP account, you land on the main dashboard. This is a visual representation of your amazon sales data. It is colorful. It is exciting. It is also the least accurate tool for detailed accounting.

This graph shows you two primary things:

  1. Orders: These are the vertical bars.
  2. KENP (Kindle Edition Normalized Pages) Read: This is the line graph overlay.

Breaking Down the Colors

Amazon uses a color-coded system to differentiate formats.

  • Orange: eBook orders.
  • Grey: Paperback orders.
  • Red: Hardcover orders.
  • Blue line: KENP reads (Kindle Unlimited).

This chart defaults to "Today." I rarely find the "Today" view useful because reporting lags happen frequently. I recommend switching the filter immediately to "Last 30 Days." This gives you a trend line rather than a panic-inducing zero-sales day.

The "Orders" Trap

Here is where most new authors get confused. You ask a friend to buy your paperback. They send you a screenshot of the purchase confirmation. You rush to your dashboard. Zero sales.

You panic. Did Amazon steal the sale? Is the system broken?

The system is working fine. Paperback and Hardcover orders only appear on reports when the book ships. If your friend does not have Prime, or if the book is being printed on demand, that "order" might not show up on your graph for three to five days.

eBooks are different. Because the delivery is digital and instant, eBook orders usually appear within a few hours of the transaction.

The Difference Between Orders and Sales

An "order" is a customer requesting the item. A "sale" is the completion of that transaction where money changes hands. Your dashboard shows orders. Your royalty report shows sales.

There are scenarios where an order never becomes a sale:

  • Credit Card Failures: A customer clicks buy, but their payment method is declined. The order disappears.
  • Cancellations: A customer orders a paperback, then cancels it an hour later before it ships. You might see a grey bar appear and then vanish the next time you refresh.

You must accept that the numbers on the main graph are fluid. They are not finalized until the month closes and the payment report generates.

Deep Dive: Kindle Edition Normalized Pages (KENP)

If you enrolled your book in KDP Select, you make money when subscribers read your book. Amazon does not pay you per download in this program. They pay you per page read.

This adds a layer of complexity to book tracking.

How KENP is Counted

A "page" in KENP is not the same as a page in your Word document. Amazon calculates a standardized font, line height, and margin setting to determine how long your book is.

If your book is formatted with large font and wide margins to look longer, Amazon's system will normalize it back down. This prevents authors from gaming the system to get more money for less content.

Pro Tip: Your formatting choices still matter for user experience, even if the KENP count is standardized. If you want to ensure your interior looks professional and readable, you should look into the best software for book layout to avoid errors that could hurt your read-through rate.

The KENP Royalty Rate

You will notice the dashboard shows "Pages Read" but not "Money Earned" for those reads. This is because the royalty rate changes every month.

Amazon establishes a "KDP Select Global Fund." The amount of money in this pot varies. At the end of the month, they divide the total fund by the total number of pages read across the entire platform.

Typically, the payout hovers between $0.004 and $0.0045 per page.

  • 1,000 pages read ≈ $4.00 – $4.50.
  • 10,000 pages read ≈ $40.00 – $45.00.

You will not know the exact exchange rate until the 15th of the following month. This makes exact financial forecasting difficult for KU authors. You have to work with estimates.

The Month-to-Date Report: Your Detailed View

Navigate to the "Month-to-Date" tab on the left sidebar. This is where the real data lives. This table breaks down sales by marketplace (Amazon.com, Amazon.co.uk, Amazon.de, etc.) and by specific book title.

This section is vital for sales analysis because it shows you where you are selling.

Understanding Marketplaces

New authors often ignore international sales. They focus entirely on the US store. I think this is a mistake. The UK, Canada, and Australia are massive markets for English-language books.

If you see traction in the UK (Amazon.co.uk), you might want to consider running ads specifically for that region.

Price Promotions and Royalty Drops

If you run a price promotion—say, dropping your book from $4.99 to $0.99—your royalties will look different here.

At $4.99, you likely chose the 70% royalty option. You make about $3.40 per sale (minus delivery costs).
At $0.99, you are forced into the 35% royalty option. You make about $0.35 per sale.

When you look at your Month-to-Date report during a promo, you might see 100 sales but only $35 in earnings. Do not be alarmed. This is the math you agreed to. The goal of a price drop is visibility, not immediate profit. To maximize this strategy, you need to understand the mechanics of price control. You can learn more about how to discount my book on amazon properly to ensure the reports reflect what you expect.

Free AI Writing Tool

Stop Staring at a Blank Page

Publy is a distraction-free book editor with AI built in. Brainstorm plot ideas, get instant chapter reviews, or rewrite clunky paragraphs. 3 million free words included.

AI Chat + Ideas Review + Rewrite Export PDF
Start Writing Free
Publy AI Book Editor

The Beta Reports vs. The Old Reports

Amazon recently overhauled the reporting backend. The "New" dashboard (which was in Beta for a long time) is now the standard.

Key Improvements in the New System

  1. ACOS Integration: You can now see ad spend directly alongside royalties in some views.
  2. Format Comparison: It is easier to toggle between eBook, paperback, and hardcover without reloading the page.
  3. Custom Date Ranges: The old system was rigid. The new system allows you to select "Last 90 days," "Year to Date," or custom dates.

I recommend using the "Year to Date" filter regularly. It helps you zoom out. A bad week feels terrible in the moment. But if your yearly trend is pointing up, a bad week is just noise.

The Estimator Tool: Why It Is Just an Estimate

At the bottom of the dashboard, there is a "Royalties Estimator" tool. It converts all your international sales into your home currency.

Warning: This is never 100% accurate.

Amazon uses the exchange rate on the day of the sale to generate this estimate. However, they use the exchange rate on the day of payment (60 days later) to actually pay you.

If the US Dollar strengthens against the Euro over those two months, your actual payout will differ from the estimate. The estimator does not account for:

  • Wire Transfer Fees: Some banks charge for incoming international wires.
  • Tax Withholding: If your country does not have a 0% tax treaty with the US, Amazon withholds 30% automatically. The estimator often shows the gross amount, not the net.

Analyzing Returns

Returns are the painful part of the business. You will see them in your reports.

In the Month-to-Date table, a return shows up as a negative number in the "Units Refunded" column.

How Returns Affect Royalties

If you sold a book in January and got paid for it, and the customer returns it in March, Amazon deducts that royalty from your March payment.

If your March royalties are $50.00, and you have a return from January worth $3.00, your payment will be $47.00.

If you have zero sales in March but one return, your account balance will be negative. Amazon will deduct that negative balance from future earnings. They rarely ask you to send money back; they just wait until you sell more books to square the debt.

Excel Reports: The Power User Move

For true sales analysis, you need to leave the browser. Click the "Generate Report" button and download the Excel spreadsheet.

Why? Because the browser dashboard hides details.
The Excel sheet gives you:

  • Transaction Time: Down to the minute.
  • KENP Read per Title: Exact breakdown if you have a series.
  • Delivery Costs: Exactly how much Amazon charged to deliver the file.

Using Pivot Tables

I strongly suggest learning how to use Pivot Tables in Excel or Google Sheets.

You can take the raw data file, insert a Pivot Table, and ask questions like:

  • "Which book in my series has the best read-through rate?"
  • "Which country has the highest return rate?"
  • "Is my paperback selling better on weekends or weekdays?"

This granular data allows you to optimize your marketing. If you see that Book 1 sells well but Book 2 has zero sales, you have a content problem. Readers are finishing the first book but not wanting the second. That is a sign you need to improve the story, not the ads.

Advertising Data vs. Sales Reports

This is the number one complaint I hear from authors. "My Ad dashboard says I sold 10 books. My Sales dashboard says I sold 6. Where are the missing 4 books?"

There are three reasons for this discrepancy:

  1. The 14-Day Attribution Window: Amazon Ads claim credit for a sale if the customer buys within 14 days of clicking. The Ad dashboard shows the sale on the day of the click. The Sales dashboard shows the sale on the day of the purchase.
  2. KENP Reads: The Ad dashboard estimates royalties from page reads. The Sales dashboard tracks actual pages read day-by-day.
  3. Data Lag: The Ad dashboard is notoriously slow. It can lag by 48 hours or more.

Do not try to reconcile these two reports daily. They will never match perfectly. Use the Ad dashboard to manage your bids and the Sales dashboard to manage your cash flow.

If you are struggling to make these numbers make sense, you might need to revisit your strategy. Understanding the cost of acquisition is vital. You should review the breakdown of amazon kdp advertising costs and benefits to ensure you aren't spending more than you earn.

Interpreting "Pre-Orders"

Pre-orders behave strangely in reports.
When a customer pre-orders your eBook, you see the unit count in a separate "Pre-order" report. You do not see the royalty yet.

On release day, two things happen:

  1. All those pre-order units move from the "Pre-order" column to the "Sales" column.
  2. Your "Today" graph spikes massively.

This release day spike is critical for the Amazon algorithm. It tells the system your book is hot. This velocity is what pushes you up the bestseller charts. If you want to maximize this effect, you need to understand how ranking works. Read our guide on how to get your book on the first page of Amazon to leverage your sales data for better visibility.

Note regarding Paperbacks: Amazon KDP (unlike IngramSpark) does not support true pre-orders for paperbacks in the same way. You can release it, but it shows as "Live." This is why many authors use a "soft launch" for paperbacks.

Comparison Table: Reports at a Glance

Report Type Best Used For Frequency of Update
Main Dashboard Quick health check, spotting trends Near real-time (eBooks), Shipping (Print)
Month-to-Date Detailed breakdowns per country/book Daily
Prior Months Tax records, accounting, finalized numbers Monthly (after 15th)
Ad Dashboard Managing CPC, checking ACOS 12-24 hour delay
Excel Downloads Deep analysis, Pivot tables, taxes On Demand

Troubleshooting Missing Sales

Sometimes, a reader swears they bought your book, but you see nothing. Before you open a support ticket, check this list:

  1. Did they buy a Used Copy? If a third-party seller has a used copy (even of a new book), you get $0 royalty.
  2. Is it a Print Book? Wait 5 days for shipping.
  3. Expanded Distribution? If you sell a book through expanded distribution (like a library or a non-Amazon bookstore), that data only updates once a month. It does not show up daily.
  4. Free Downloads? If you ran a "Free Days" promo, those units are in a separate column (Free Units) and do not count toward paid rank or royalties.

Payment Timing: When Do You Actually Get the Money?

Understanding the report is step one. Getting paid is step two.
Amazon pays on a 60-day net schedule.

  • January Sales: You earn the money in January. The month closes.
  • February: Amazon calculates the final numbers.
  • March 29th (approx): The money hits your bank account.

The "Payments" tab in your reports will show you the status.

  • Processing: Amazon is preparing the wire.
  • Paid: The money has left Amazon.

If it says "Paid" but your bank is empty, wait 3 to 5 business days. International wires are slow.

Conclusion

The KDP dashboard is a tool, not a scoreboard. Checking it five times a day will not make you sell more books. It will only increase your anxiety.

Use the dashboard to spot trends. Use the Excel sheets to do your accounting. And remember that the numbers on the screen are just the result of the work you did weeks ago. If you want to change the numbers on the report, you need to change your marketing input.

Stop refreshing. Start writing the next book.

Spreadsheet

The Self-Publishing Launch Checklist (2026)

A week-by-week spreadsheet that walks you through every step of launching your book. Available as an Excel file and Google Sheet.

8-week pre-launch plan Launch day battle plan Post-launch tracker
Download Sheet
Self-Publishing Launch Checklist Preview

Frequently Asked Questions

Why does my KDP dashboard show orders but no royalties?

This usually happens with paperback orders. The order is registered when the customer clicks buy, but the royalty is not credited until the book ships. If the order is cancelled before shipping, the royalty never appears. Alternatively, it could be a free download during a promotion.

How often do KDP reports update?

For eBooks, reports update approximately every 15 to 30 minutes. For print books, data updates only when the item ships, which can take several days. KDP Select page reads (KENP) usually update a few times a day but can lag behind actual reading activity.

What is the difference between the "Prior Months' Royalties" and the dashboard graph?

The dashboard graph is an estimate and a snapshot of activity. The "Prior Months' Royalties" report is the finalized financial document. It accounts for exchange rates, taxes, and final adjustments. Always use the Prior Months report for tax purposes and accounting.

Can I see who bought my book on KDP?

No. Amazon protects customer privacy strictly. You can see how many units were sold and in which country, but you cannot see names, email addresses, or physical locations of your buyers.

Why did my sales rank improve but I have no new sales?

Sales rank is relative to other books. If other books in your category are selling poorly, your rank might drift upward naturally. Also, a borrow on Kindle Unlimited improves your sales rank immediately, even if the reader hasn't read enough pages to generate a royalty yet.

Does KDP show sales from Expanded Distribution immediately?

No. Expanded Distribution sales (sales through other retailers like Barnes & Noble online or libraries via KDP) are reported once a month. They typically appear on your dashboard near the end of the month for sales that occurred the previous month.