How to Track Book Royalties Across Platforms: A Guide for Indie Authors

Most indie authors start with one store and one dashboard. Then the second book goes wide, the paperback moves to IngramSpark, an audiobook appears on ACX, and suddenly the answer to a simple question, "How much did my books earn last month?", lives in six places that disagree on dates, currencies and even what counts as a sale.

This guide shows how to track book royalties across platforms without losing an evening every week to copy and paste. It covers how the major stores report and pay, a spreadsheet structure that works, the trackers worth paying for, and a monthly routine for checking that every payment actually arrived. If you also sell from your own site, the same system covers it; our guide to selling books directly from your website explains that channel.

One note before the details. Spreadsheets and ready-made trackers suit nearly every independent author. Small presses that pay several authors, narrators or translators a share of each title sometimes need reporting no store app offers, and they tend to commission it from a custom software development partner rather than bending a tool built for solo writers. We come back to that choice near the end.

Why is it hard to track book royalties across platforms?

Each platform was built to show its own numbers, not to fit into yours. Four differences cause most of the confusion:

1. Report formats. Every dashboard exports different columns, and some split ebooks, print and page reads into separate reports.
2. Timing. A sale in March can be paid in May by one store and in June by another, so monthly totals never line up neatly.
3. Currencies. Amazon reports each marketplace in its local currency and pays each marketplace separately; aggregators often convert for you.
4. Reporting lag. Aggregators such as Draft2Digital can only show a sale once the retailer reports it to them, so recent days may be missing or revised later.

The fix is not a better dashboard. It is one record of your own, updated on a schedule, that translates every source into the same columns.

How each platform reports sales and pays royalties

Every store pays monthly but on its own delay, from a few days for your own website store to about 90 days for IngramSpark. The table summarises the platforms most indie authors use. Payment timing and thresholds change, so treat it as a starting map and confirm the current terms in each dashboard's help pages.

For Amazon, the timing rule is set out on the KDP "When will I get paid?" help page, including the longer delay for Expanded Distribution. Most other stores publish a similar schedule in their help centres. Apple and Google have their own steps for setting up payments, which we cover in how to publish on Apple Books and how to publish on Google Play Books.

What is the difference between sales, royalties and payments?

They are three different numbers, and mixing them is the most common tracking mistake.

• Sales are units: how many copies, page reads or listens a store recorded.
• Royalties are what you earned on those sales after the store's share, delivery fees or printing costs, in the store's currency.
• Payments are the money that actually lands in your bank, often months later, converted to your currency and sometimes minus withholding tax or bank fees.

Track all three. Units tell you whether marketing worked. Royalties tell you what a month was worth. Payments tell you whether you were paid what you were owed. A launch month can look huge in units and modest in royalties if most of the sales came from a 99-cent promotion.

How to build a royalty tracking spreadsheet

A spreadsheet is free, private and completely under your control. The trick is to keep raw data and summaries apart, so a new month never breaks your formulas.

Step 1: create one row per title, format, store and month

Use one tab called Data with these columns:

• Month of sale (for example 2026-10)
• Platform and marketplace (KDP US, KDP UK, Kobo, D2D: Apple)
• Title, series and pen name
• Format (ebook, paperback, hardcover, audiobook, page reads)
• Units
• Royalty in the original currency, and the currency code
• Exchange rate and royalty in your home currency
• Expected payment month
• Payment received (date and amount), filled in later

Step 2: paste each store's export into the same shape

Download the monthly report from each dashboard and map its columns onto yours. The first month is slow. After that it takes minutes, because every store exports the same layout each time.

Step 3: add summary tabs

Build pivot tables from the Data tab: royalties by month, by title, by platform and by pen name. Never type figures into the summaries; let them recalculate from the data.

Step 4: add a payments check

A final tab compares expected payments with what arrived. Any month where the difference is more than a few cents gets a note, and a follow-up with the store if it persists.

Which royalty tracking tools are worth using?

Once you publish wide or run more than a handful of titles, a tracker can do the importing for you. These are the main types; check each tool's current list of supported stores and pricing before you subscribe.

Whatever you pick, keep exporting raw reports to your own folder each month. A tracker that closes or changes its pricing should never take your sales history with it.

A monthly routine for tracking book royalties

Thirty minutes once a month is enough for most authors. Put it in the calendar for the same day each month, after the stores have closed the previous month.

1. Download last month's reports from every store and aggregator and save them in a dated folder.
2. Import or paste them into your tracker or spreadsheet.
3. Check Kindle Unlimited page reads once Amazon has announced the monthly rate, and update the estimate.
4. Mark any payments that arrived and compare them with the months they cover.
5. Note what changed: a promotion, a new release, a price change, an ad campaign. Next year you will want to know why March was strong.
6. Look at royalties per title and per format, and decide one thing to act on, such as a price test or a series reorder.

How do you check that every payment arrived?

Reconciling means matching what the stores said you earned with what the bank received. It catches missing payments, failed bank details and threshold holds before they become a year-old mystery.

• Match payments by store and marketplace, not by total. Amazon alone may send several payments a month.
• Expect small differences from currency conversion and bank fees; investigate anything larger.
• Watch payment thresholds. Some stores hold small balances until they reach a minimum, so a missing payment may simply be waiting.
• Check for returns and adjustments, especially on print through IngramSpark, which can reduce a later payment.
• If a payment is overdue by more than a month, contact the store's support with the report month, title and amount.

When does a custom royalty dashboard make sense?

For most authors, never: a spreadsheet or a subscription tracker covers the job. A custom system becomes worth discussing when the arithmetic, not the data collection, is the hard part. Typical signs:

• You run a small press and must send each author a royalty statement with their own contract terms.
• Titles carry splits with co-authors, illustrators, translators or royalty-share narrators.
• You sell through your own store, Kickstarter and several distributors, and want one view of net income per title.
• You need statements and payouts produced automatically each quarter, with an audit trail.

In that case the work is a small piece of business software: importers for each distributor's statement, a contract and split model, and a reporting layer. Write down your contract rules and gather a year of sample reports first, whether you buy a publisher platform or have one built. Clear examples are what make either option accurate.

Records to keep for taxes and co-authors

Good tracking pays off most at tax time. Keep the monthly reports from every store, the payment confirmations and your spreadsheet for as long as your tax rules require. In the United States, stores typically issue tax forms for royalty income; authors outside the US usually submit a tax form to the store to claim treaty rates on withholding. Rules differ by country, so check with an accountant who knows author income.

If you share income with a co-author or narrator outside the store's own split, send them a short statement each period from the same data. It prevents disputes and makes it easy to answer the question every collaborator eventually asks: "How is the book doing?" For broader business advice, the Authors Guild publishes guidance on contracts and royalties for working writers.

Once your figures live in one place, you can see which series earns, which format to invest in, and when it is time to spend on a better author platform. Our step-by-step guide to building an author website is a good next read when that moment comes.

Royalties you never reconcile are royalties you are only assuming you were paid.

Questions about tracking book royalties

Massimo Marino Author Editorial Team

Independent reader guides, science notes and writing craft.