Documentation

Importing Amazon KDP payment reports

Upload an Amazon KDP payment report directly into Royalties HQ — no manual reformatting required.

You can now import an Amazon KDP payment report directly — Royalties HQ extracts each marketplace payment and its breakdown automatically, so there’s no need to reformat the data into a CSV template first.

Importing non-Amazon payments? See Importing publisher income.

How to import a KDP payment report (quick guide)

  1. Download your Payment Report from Amazon KDP (see below).
  2. In Royalties HQ, go to Import > Income Payments.
  3. Upload the .xlsx file you downloaded from KDP.
  4. Royalties HQ extracts each marketplace payment along with its breakdown details.
  5. Review the preview — any duplicate warnings appear highlighted in yellow.
  6. If everything looks correct, confirm the import.

Download the report from KDP

  1. Log in to Amazon KDP.
  2. In the left sidebar, go to Statements > Payments.
  3. Choose a period (a month).
  4. Click Download report to save the .xlsx file.

Important: All payments in the report must have finalised payout amounts. If any row contains “Pending info from Bank” or other non-numeric text in the payout column, the entire file will be rejected. Wait until all payouts have been finalised before importing the report.

Duplicate detection

When creating an income payment — whether via import or manually — Royalties HQ checks for existing payments with the same sales month, marketplace, and amount.

  • Import — a yellow warning banner appears in the preview step. You can still proceed with the import; the warning is informational, not a blocker.
  • Manual creation — a warning appears below the form. Click Create Anyway to confirm.

Duplicate detection helps you avoid accidentally entering the same payment twice, but it won’t prevent you from doing so if the duplicate is intentional.

Bulk delete income payments

If payments were imported in error, you can remove them in bulk from the Income Payments index page:

  1. Use the checkboxes to select the payments you want to delete.
  2. Choose Delete from the bulk actions menu.
  3. Confirm the deletion in the dialog that appears.

Note: Payments that are linked to a sales batch cannot be deleted. Unlink the sales batch first if you need to remove the payment.