Guide

How to Reconcile Amazon Ad Sales with KDP Royalties

Amazon ad-attributed sales and KDP royalties measure different values. Reconcile them by matching books, formats, countries, dates, and currencies.

By Publisher Ads · Published · 5 min read

Amazon ad-attributed sales will not equal KDP royalties because they measure different things. Advertising reports show retail sales value attributed to ad interactions, while KDP reports show the publisher's royalty earnings under the relevant book format, price, delivery, territory, and program terms. Reconciliation means aligning scope and explaining the bridge between them, not forcing the two totals to match.

Define the two sides of the reconciliation

Start with exact labels:

  • Ad-attributed sales: retail value Amazon associates with advertising activity under the report's rules.
  • Ad spend: chargeable advertising cost in the ad account and marketplace.
  • KDP royalty: the publisher's earnings recorded for an order under the applicable KDP terms.
  • Organic-classified sales: a reporting residual outside the ad-attributed total, not proof that advertising did or did not influence those sales.

ACoS uses spend divided by ad-attributed retail sales. It does not use royalties. Advertising contribution instead asks whether royalty income covers ad spend.

This distinction explains the most common apparent mismatch. A hypothetical $100 in attributed paperback sales does not mean the publisher earned $100. Printing cost, royalty terms, price, and marketplace affect the retained amount.

Match the scope before comparing totals

Choose a completed period and write down:

  1. Advertising account and profile
  2. Marketplace and currency
  3. Advertised book or ASIN
  4. Book format and edition
  5. Start and end dates
  6. Time zone where relevant
  7. Report extraction date

Pull the KDP data for the same title, format, marketplace, and dates as closely as the available reports allow. Do not combine US advertising spend with worldwide royalties and call the result a campaign return. Do not compare a paperback campaign with royalties from every edition unless you explicitly label that as a wider book-level view.

Amazon's book advertising reporting guide explains campaign, targeting, and search-term reporting. Those reports answer advertising questions; they are not royalty statements.

Build a bridge instead of seeking equality

Create a small worksheet with separate columns:

Field Source
Ad spend Amazon Ads report
Attributed orders Amazon Ads report
Attributed sales value Amazon Ads report
Total format orders KDP report
Total format royalties KDP report
Currency and country Both sources

Then calculate two different measures:

ACoS = ad spend ÷ ad-attributed sales × 100

Advertising contribution = in-scope royalty income − ad spend

The first describes advertising cost relative to attributed retail sales. The second describes whether the chosen royalty pool covered advertising cost. Neither is complete business profit after editing, cover, formatting, software, tax, and overhead.

For a hypothetical example, suppose a US paperback campaign records $30 spend and $120 attributed sales. Its ACoS is 25%. If the carefully matched KDP royalty total for the chosen scope is $27, advertising contribution is negative $3. The lower-looking ACoS did not guarantee profit because retail value and retained royalty differ.

The break-even ACoS guide explains how actual royalty contribution can be translated into a planning threshold.

Expect timing differences

Do not expect every report to settle at the same moment. Recent attributed activity can change, billing can appear later, and KDP reporting follows its own processing. Avoid inventing one fixed waiting period for every marketplace and report.

Instead:

  • Record when each export was produced.
  • Mark the newest days as provisional.
  • Re-run the same fixed date range later.
  • Compare changes rather than silently replacing the original numbers.

This produces an audit trail. If a total moves, you can tell whether the difference came from a later extraction or a changed filter.

Orders after a campaign pause also require care. An attributed order visible after the pause may relate to advertising activity from before it. The charges-after-pausing guide shows how to separate delivery dates from billing and reporting dates.

Handle formats and editions explicitly

Paperback, hardcover, Kindle, and audio editions can have different identifiers, prices, costs, royalty terms, and reporting pathways. A campaign may advertise one edition while a shopper buys another. Whether and how that appears in a particular report should be read from the report's own definitions rather than assumed.

For a conservative reconciliation, begin with the advertised format and marketplace. Then add a separate wider view for the whole title if that helps a business decision. Label it “book-level” and do not represent every included royalty as ad-attributed.

The same caution applies to series effects. Advertising book one may coincide with later orders for other books, but a timing pattern does not prove causation. Keep directly reported attribution separate from broader catalog observations.

Deal with currency deliberately

Never add dollar, pound, euro, and other currency amounts into one total without conversion. Either keep each marketplace separate or choose a documented exchange-rate method and conversion date.

For operational decisions, marketplace-level views are often clearer because bids, spend, prices, and reader behavior are local. A consolidated management view can follow, but it should retain the conversion assumptions.

Currency mistakes can also make a sound campaign look extreme. A numeric “100” beside one currency is not equivalent to “100” beside another.

Investigate mismatches in a fixed order

If the reconciled totals still look wrong, check:

  1. Did both exports use the same start and end dates?
  2. Are the account, marketplace, and currency identical?
  3. Is the advertised ASIN the intended edition?
  4. Did one side include all formats or countries?
  5. Are recent days still provisional?
  6. Were refunds, adjustments, or canceled orders treated consistently?
  7. Did a second campaign advertise the same book?
  8. Did the book's price or availability change?

Avoid “fixing” the mismatch by applying a generic royalty percentage to ad sales. Use actual statement figures when available. Amazon provides the direct advertising console and reports, while KDP remains the source for publishing royalties.

Use reconciliation for a decision

Once the scope is sound, decide what the view is for. A campaign-level view helps with targets and bids. A book-level view helps decide how much advertising the title can support. A catalog-level view helps allocate cash, but can hide weak editions unless you retain the lower-level detail.

Publisher Ads provides tools for publishers to monitor and manage Amazon Ads and can show Book Profit as royalty income minus advertising spend when the necessary data is connected. That figure remains an advertising-contribution view rather than full net income. The low-ACoS book-profit guide explains this boundary.

A useful reconciliation finishes with an explanation: which book, format, country, currency, and dates were included; which data remained provisional; and what decision the result supports. The goal is a trustworthy comparison, not matching two values that were never designed to be identical.

Questions people ask

Why do Amazon ad sales not equal KDP royalties?

Ad sales are attributed retail sales value, while KDP royalties are the publisher's earnings under the relevant format and marketplace terms.

Can I match one ad order directly to one royalty row?

Match grouped book, format, and marketplace totals. Matching identifiers help define scope but do not establish an order-by-order attribution link.

Should I compare ad spend with ad sales or royalties?

ACoS uses ad-attributed sales value. For advertising contribution, compare spend with actual royalty income in a consistently defined scope.

Do later KDP sales prove an ad caused them?

No. Timing can guide investigation, but organic and attributed reporting are different and correlation alone does not prove causation.

More from the blog