Self-Publishing (KDP) Royalty Tracker in Google Sheets

The Self-Publishing (KDP) Royalty Tracker in Google Sheets logs every book edition across 16 columns, calculates 6 of them for you with formulas, and drives 1 headline royalty card plus 4 live charts from a single data table. Setup takes under 10 minutes: replace the 15 sample rows with your own titles and every number, rank and chart redraws itself.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace subscription tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

This is a one-page kdp royalty tracker in google sheets — charts and one big KPI card sitting directly above the data-entry table, not a multi-tab workbook. It runs entirely in your browser, needs no macros and no add-ons, and your download is a PDF containing a “Make a copy” link that drops your own editable copy into your Google Drive.

⚠️ An important note before you buy: this template is an independent spreadsheet and is not affiliated with, endorsed by or connected to Amazon or Kindle Direct Publishing. It does not connect to KDP, does not import your sales reports and uses no API. You type or paste your units sold and royalty rates in yourself, straight from your KDP dashboard — which is exactly why it also works for titles sold anywhere else, not only on Amazon.

🔑 Key Features of the KDP Royalty Tracker in Google Sheets

📚 One row per book edition, not per book. The same title sold as an eBook (Kindle), a Paperback, a Hardcover and an Audiobook is four rows, each with its own list price, royalty rate and print cost — so a title earning 70% on Kindle and 60% on paperback is measured honestly instead of averaged into a single misleading number.

🧮 Six columns calculate themselves. Book ID, Royalty / Unit, Gross Royalty, Net Royalty, Royalty Rank and % of Total are all formulas. Royalty / Unit is List Price × Royalty Rate − Delivery / Print Cost, and it is floored at zero, so a mistyped print cost cannot push a book into negative earnings and corrupt your totals.

🏆 Automatic ranking and income share. Royalty Rank orders every edition by net royalty and % of Total shows what slice of your income each one carries. In the sample data one title carries 24.2% of all royalties while another carries 1.5% — the kind of gap that decides where your next marketing hour goes.

📊 Four charts wired straight to the table. They read the data columns directly using the built-in Aggregate option across rows 16–1000, so a book you add tomorrow appears in the charts immediately. There are no hidden helper tables anywhere in the file.

🌍 Marketplace-aware. Amazon.com, Amazon.co.uk, Amazon.de, Amazon.ca and Amazon.com.au all appear in the sample data as separate rows, so a title selling in five stores is five tracked lines rather than one blurred total.

🔽 Dropdowns that grow with you. Format, Marketplace and Status pull from a separate List tab (rows 2–500). Add a new marketplace or a new format there and it appears in the dropdown automatically — no re-setup, no script editing.

💱 Currency you control. Money columns are formatted in $ by default. Select them, use Format → Number, and switch to ₹, € or £ for your home marketplace in seconds.

📦 What’s Inside the Self-Publishing Royalty Tracker

The file ships as three visible pages plus a List tab that feeds the dropdowns. Here is what each one does.

Page 1: Royalty Tracker

The working page. A large Total Net Royalty card sits on the left, followed by four charts: Book Count by Format, Book Count by Status, Net Royalty by Book and Gross vs Net Royalty. Below them is the 16-column entry table — Book ID, Book Title, Format, Marketplace, List Price, Units Sold, Royalty Rate, Delivery / Print Cost, Royalty / Unit, Gross Royalty, Net Royalty, Status, Royalty Rank, % of Total, Last Sale Date and Notes — pre-filled with 15 sample rows you overwrite.

Page 2: How to Use

A plain-English setup page written into the file itself: how to replace the sample rows, which columns are formulas and must not be typed over, how to update after each KDP sales report, how the List-tab dropdowns work, and the one-time 10-second Data → Data validation step that turns the Format, Marketplace and Status cells into the coloured chips you see in the screenshots.

Page 3: Explore More Templates

A curated page of recommended NextGenTemplates products with category, format and price, a set of “Browse All” category links, and a WELCOME15 coupon code worth 15% off your next purchase.

📊 KDP Royalty Tracker in Google Sheets vs. an Excel Royalty Spreadsheet vs. Book Report / ReaderLinks

For authors who want their royalty numbers in one editable sheet they own — including the sales a KDP-only tool never sees — without paying a monthly fee, the Self-Publishing Royalty Tracker sits in the sweet spot.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Indie authors with 3–100 book editions across Kindle, paperback, hardcover and audiobook
• Self-publishers selling in several Amazon marketplaces who want per-store visibility
• Authors who also sell direct, through other retailers, or at events, and need one sheet that holds all of it
• Small presses and author-services VAs who report royalties back to a handful of writers
• Anyone who wants a kindle royalty tracker template they can edit and keep forever

❌ This template is NOT for:

• Authors who want royalties pulled in automatically — this tracker has no KDP connection and never will
• Publishers splitting royalties across co-authors, agents and estates with contractual tiers
• Anyone needing tax-ready accounting, VAT handling or an audit trail — this is an income tracker, not bookkeeping software
• Writers with no Google account, since the download is a “Make a copy” link into Google Drive

⚙️ How to Use the KDP Royalty Tracker in Google Sheets

1. Open the PDF in your download and click the “Make a copy” link. An editable copy lands in your own Google Drive.
2. Open the List tab and set your own Formats, Marketplaces and Statuses in rows 2–500. Everything you add appears in the dropdowns.
3. Go to the tracker page and replace sample rows 16–30 with your own editions. Fill only Book Title, Format, Marketplace, List Price, Units Sold, Royalty Rate (enter 0.70 for 70%) and Delivery / Print Cost.
4. Leave Book ID, Royalty / Unit, Gross Royalty, Net Royalty, Royalty Rank and % of Total alone — they are formulas and fill themselves.
5. Select column C, then D, then L, and use Data → Data validation → Advanced options → Display style: Chip to get the coloured pills shown in the screenshots. One-time, about ten seconds.
6. After each KDP sales report, paste in the new Units Sold and update Last Sale Date. The Total Net Royalty card, the ranks and all four charts refresh instantly.

💼 Real-World Use Cases

Priya publishes thrillers and has 22 editions live. Before this sheet she opened four KDP marketplace reports each month and added them up by hand. Now she pastes units sold into one book royalty tracker in google sheets, sees that her Kindle box-set title carries nearly a quarter of her income, and stops spending ad budget on the paperback earning $89 a year.

Marcus writes non-fiction and sells at conferences as well as on Amazon. A KDP-only dashboard never saw the 200 copies he moved from a table at the back of a room. He adds a “Direct / Events” entry to the List tab, types those sales in as their own marketplace line, and finally has a royalty figure that matches his bank account.

Anita runs author services for six self-publishing clients. She keeps one copy of the tracker per author in a shared Drive folder, sends each writer a view-only link, and answers “how much did I make last month?” with one screenshot instead of a spreadsheet rebuild.

❓ Frequently Asked Questions

Does the KDP Royalty Tracker in Google Sheets connect to my Amazon KDP account?

No. The KDP Royalty Tracker in Google Sheets has no API, no sync and no connection to Amazon or Kindle Direct Publishing, and it is not affiliated with or endorsed by them. You enter or paste units sold and royalty rates from your own KDP dashboard, which is also what lets you track non-Amazon sales.

How long does setup take?

Under 10 minutes. Click the “Make a copy” link in the PDF, set your Formats and Marketplaces on the List tab, then overwrite the 15 sample rows with your own editions. The six formula columns, the Total Net Royalty card and all four charts update as you type.

How does this compare to Book Report or ReaderLinks?

Those tools read your Amazon account automatically and charge roughly $10–$20 a month. This Self-Publishing Royalty Tracker is a one-time $12.99 purchase you own and can edit, and it tracks any marketplace you type in — including direct, event and non-Amazon sales those tools never see.

Can I track audiobooks and hardcovers, not just Kindle eBooks?

Yes. Format is a dropdown containing eBook (Kindle), Paperback, Hardcover and Audiobook, and each format gets its own row with its own royalty rate and print cost. Add any other format you need on the List tab and it joins the dropdown.

Do I need Excel or any macros to use this?

No. This is a pure Google Sheets file with no macros, no add-ons and no scripts to authorise. You need a free Google account and a browser. It also opens in the Google Sheets mobile app if you want to check royalties on your phone.

What happens when I add more than 15 books?

Nothing breaks. The formulas and all four charts cover rows 16 to 1000, so roughly 985 editions are supported out of the box. New rows join the Royalty Rank order, the % of Total split and every chart automatically.

How do I track KDP royalties in Google Sheets if I sell in several currencies?

Convert each marketplace’s royalty into your home currency before entering it, then use Format → Number to set the money columns to ₹, € or £. Knowing how to track kdp royalties in google sheets across stores is mostly a matter of keeping one consistent currency in the sheet.

👤 About the Author

Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PKAnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

If you sell more than books, these pair well with this tracker. The Print-on-Demand Sales Tracker in Google Sheets covers merch and POD products on the same one-page layout, and the Digital Product Sales Tracker in Google Sheets handles courses, presets and downloads. For affiliate and referral income from your book funnels, the Affiliate Marketing Income Tracker in Google Sheets is the natural companion.

Want the wider view instead of one tracker? The Publishing Dashboard in Google Sheets is a multi-page analytics build for publishing operations. Browse the full Google Sheets Templates range, or the Google Sheets Trackers collection if you want more one-page tools like this one.

Two more author-focused trackers — a Freelance Writing Pitch & Submission Tracker and a Book Writing & Word Count Tracker, both in Google Sheets — are being prepared and will be listed shortly.

Useful official references while you set this up: Amazon KDP’s own royalty documentation explains the 35% and 70% rates and delivery costs behind the numbers you enter, and Google’s guide to data validation covers the dropdown and chip settings used on the Format, Marketplace and Status columns.

📖 Click here to read the detailed blog post about the Self-Publishing Royalty Tracker

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

📅 Last updated: September 2026