Why Tracking Royalties Across Platforms Matters
Self-publishing has never been more accessible, but it's also more fragmented. You might have a paperback on Amazon, an ebook on Draft2Digital, an audiobook on ACX, and a hardcover through IngramSpark. Each platform sends royalty reports in different formats, at different times, with different terminology.
Without a system to consolidate and analyze this data, you're flying blind. You won't know which format is actually making you money, which retailers are underperforming, or whether your pricing strategy is working.
The good news: tracking royalties across multiple self-publishing platforms isn't complicated. It just requires a plan.
The Challenge: Why Each Platform Reports Differently
Before we talk solutions, let's acknowledge the problem. Here's what you're dealing with:
- Amazon KDP reports monthly, with a 60-day lag. They show units sold, list price, royalty rate, and net royalties.
- IngramSpark sends quarterly reports (sometimes with delays). They break down sales by channel: bookstores, libraries, print-on-demand.
- Draft2Digital updates sales daily and pays monthly, but aggregates some retailers under "other retailers."
- ACX (audiobooks) reports per-finished-hour royalties or per-unit sales, depending on your contract type.
- Apple Books, Google Play, Kobo each have their own reporting dashboards and payment schedules.
Add different currencies, payment holds, and refund deductions, and you've got a data puzzle.
Step 1: Set Up a Master Spreadsheet
The simplest system is a spreadsheet. You don't need fancy software right away—a Google Sheet or Excel file works fine.
Create columns for:
- Date (when you're logging the data)
- Platform (Amazon, IngramSpark, Draft2Digital, etc.)
- Format (ebook, paperback, hardcover, audiobook)
- Units Sold (in the reporting period)
- Gross Revenue (before fees)
- Royalties Paid (what you actually received)
- Royalty Rate (%)
- Notes (price changes, promotions, anomalies)
At the bottom, use SUM formulas to calculate total royalties by platform, by format, and by month. This gives you a quick snapshot of where your money is coming from.
Step 2: Establish a Monthly Reporting Routine
The key to accurate tracking is consistency. Pick a day each month—say, the 15th—and log into each platform to pull your latest numbers.
For Amazon KDP: Go to Reports > Sales Dashboard. Download the monthly report as a CSV. Note the reporting period (usually 2 months behind).
For IngramSpark: Check My Account > Royalties. They update quarterly, but you can track estimated sales in real-time under Sales Reports.
For Draft2Digital: Their dashboard updates daily, so you can pull a month-end snapshot from Earnings > Reports.
For ACX: Log into your royalty dashboard. Note whether you're earning per finished hour (PFH) or per unit sold, since the payout model is different.
Spend 10–15 minutes entering these numbers into your master sheet. That's it. Do this monthly, and you'll never be confused about your sales again.
Step 3: Account for Timing and Lag
Here's where it gets tricky: platforms don't report on the same schedule.
Amazon pays 60 days after the end of the month (so March sales = May payment). IngramSpark pays quarterly and can be slow. Draft2Digital pays monthly but only after a 45-day hold.
To avoid confusion, create two sheets in your spreadsheet:
- Sales Sheet — Log the sales that occurred during a given month, regardless of when you're paid.
- Payment Sheet — Log actual deposits to your bank account, with the date received and the platform.
This way, you can see both your earned royalties (sales) and your actual cash flow (payments). They won't match month-to-month, but you'll understand why.
Step 4: Identify Trends and Anomalies
Once you've logged 3–6 months of data, patterns emerge. Maybe your paperback sales spike in Q4. Maybe Draft2Digital drives more consistent ebook sales than Amazon, even if the absolute numbers are lower. Maybe one retailer suddenly dropped your book's visibility.
Use your spreadsheet to calculate:
- Average monthly royalties by platform — Are you earning $500/month from Amazon and $50 from IngramSpark? That tells you where to focus marketing effort.
- Royalty rate by format — Ebooks might earn 25–35% royalties, while paperbacks earn 10–20%. Knowing this helps you decide which formats to prioritize.
- Year-over-year growth — Is your income growing month-to-month? By how much?
If you see a sudden drop in sales on one platform, investigate. Did a retailer delist your book? Did Amazon change its algorithm? Did you forget to renew a Select enrollment? These questions matter.
Step 5: Use Tools to Automate (Optional)
If you publish multiple books or want more sophisticated analytics, consider tools that aggregate data across platforms:
- AuthorEarnings (now Authorify) — Tracks Amazon sales and provides market insights.
- Reedsy Dashboard — Pulls data from multiple retailers in one place.
- Vook or BookShop.org analytics — If you're selling through those channels.
If you're using SelfPublishing.pro, the platform includes a Sales Reports dashboard where you can view royalties and download spreadsheets for books you've distributed through the service. This consolidates data for books you've published via SPP, though you'll still need to track other retailers separately.
Step 6: Reconcile Payments to Your Bank Account
Once a month, compare your spreadsheet's "Payment Sheet" to your actual bank deposits. They should match (or be very close).
If there's a discrepancy:
- Check the platform's payment history. Did they hold a payment? Issue a late deposit?
- Verify currency conversions if you're receiving payments in multiple currencies.
- Look for refunds or chargebacks that might reduce your payout.
This reconciliation catches errors early and keeps you honest about your actual income.
Practical Example: A Multi-Format Book
Let's say you published a novel in three formats:
- Ebook on Amazon KDP and Draft2Digital
- Paperback on Amazon KDP and IngramSpark
- Audiobook on ACX
Your monthly tracking might look like this:
January Sales (example):
- Amazon KDP Ebook: 120 units @ $2.99 = $210 royalties
- Amazon KDP Paperback: 45 units @ $12.99 = $180 royalties
- Draft2Digital Ebook: 18 units = $45 royalties
- IngramSpark Paperback: 12 units = $24 royalties
- ACX Audiobook: 8 PFH @ $25/hour = $200 royalties
- Total January Royalties: $659
Now you can see that your ebook is your strongest performer (138 units), your paperback is second (57 units), and your audiobook, while fewer in volume, has the highest per-unit royalty. This data informs your next marketing push.
Common Mistakes to Avoid
Don't mix sales and payments. A sale in January might not pay out until March. Track them separately to avoid confusion.
Don't forget about refunds. Amazon and other retailers process refunds, which reduce your net royalties. Your spreadsheet should account for this.
Don't ignore currency differences. If you're earning in GBP, EUR, or CAD, note the exchange rate at the time of payment. Your actual USD equivalent might vary.
Don't set it and forget it. Monthly logging takes 15 minutes. Skipping months means you'll have gaps in your data and won't catch problems early.
Scaling Up: When to Hire Help
If you're publishing 5+ books or earning $5,000+ per month across platforms, it might be worth hiring a bookkeeper or using accounting software like QuickBooks to automate the process.
But for most indie authors, a well-organized spreadsheet is enough. The key is discipline: log your data monthly, reconcile quarterly, and review your trends annually.
Final Thoughts: Knowledge Is Power
Tracking royalties and sales data across multiple self-publishing platforms isn't glamorous, but it's essential. When you know exactly where your income is coming from, you can make smarter decisions about pricing, marketing, and which formats to prioritize.
Start simple: a spreadsheet and a monthly routine. As your publishing career grows, you can add tools and automation. But the foundation—consistent, accurate tracking—is something every self-published author should master from day one.
