Author Royalty Spreadsheet | Multi Platform Book Sales Tracker | Self Published Author | Google Sheets

Tracking book sales and royalties across multiple platforms becomes confusing when reports come from different dashboards, currencies, and payout schedules. This Author Book Royalty & Multi-Platform Sales Tracker helps authors track sales, royalties, formats, and payouts in one centralized system—so you can keep tracking in one place, understand true earnings, and make smarter publishing decisions.

This is a ready-to-use, professionally designed, and fully customizable Excel dashboard created to simplify operations and improve profitability. It enables authors and publishers to log book-wise sales (ebook, paperback, hardcover, audiobook), track platform-wise royalty rates, record earnings, and monitor payout status without messy spreadsheets. Everything is structured to give you an at-a-glance view of which books and platforms generate the most revenue, month-wise trends, and total royalties earned.

With automated summaries and clean reporting views, you can analyze best-selling titles, track marketing impact (optional), and prepare organized records for accounting and tax time. Whether you publish via Amazon KDP, Kindle Unlimited, Kobo, Apple Books, Google Play Books, IngramSpark, or direct sales, this dashboard supports clearer reporting and stronger income tracking.

What’s Included:

• Pre-built Excel dashboard for multi-platform book sales and royalty tracking
• Book master database (title, series, format, ISBN/ASIN—customizable)
• Platform-wise sales tracker (Amazon KDP, Kobo, Apple, Ingram, direct—customizable)
• Royalty calculator fields (royalty rate %, delivery/printing cost fields optional)
• Month-wise sales and royalty reporting dashboards
• Format-wise performance tracking (ebook/paperback/audiobook)
• Payout schedule and payment received tracker (date, amount, status)
• Returns/refunds impact fields (optional, customizable)
• Currency tracking fields for international royalties (optional)
• Fully customizable fields for your publishing platforms and formats

Key Benefits:

• Centralizes book sales and royalty tracking in one place
• Improves earnings visibility across multiple platforms and formats
• Tracks payout status to avoid missed payments
• Helps identify best-performing books and sales channels
• Supports better marketing and pricing decisions using trends
• Saves time with automated summaries and dashboard views
• Keeps organized records for taxes and accounting
• Ideal for self-published authors and small publishers

Get your Author Book Royalty & Multi-Platform Sales Tracker today and streamline your publishing income tracking while maximizing clarity, control, and customer satisfaction.