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

Tracking book sales and royalties becomes confusing when reports come from multiple platforms, formats, 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 you 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 top-performing books, platform-wise revenue, and month-wise royalty trends.

Whether you publish via Amazon KDP (including KU), Kobo, Apple Books, Google Play Books, IngramSpark, or direct sales, this dashboard supports clearer reporting and stronger income tracking for authors and small publishers.

What’s Included:

• Book master database (title, series, ISBN/ASIN, format—customizable)
• Platform-wise sales tracker (Amazon KDP, Kobo, Apple, Ingram, Direct—customizable)
• Royalty rate and payout calculation fields (customizable for each platform)
• Month-wise sales and royalty reporting dashboards
• Format-wise performance tracking (ebook/paperback/hardcover/audiobook)
• KU / page-read tracking fields (optional, customizable)
• Payout schedule and payment received tracker (date, amount, status)
• Returns/refunds impact tracking fields (optional, customizable)
• Multi-currency tracking fields (optional, for international royalties)
• Year-to-date royalty summary and book-wise ranking views

Key Benefits:

• Centralizes royalties, sales, and payouts across platforms in one place
• Improves earnings visibility with book-wise and platform-wise insights
• Tracks payout status to avoid missed or delayed payments
• Helps identify best-performing titles and profitable platforms faster
• Supports smarter pricing and marketing decisions using trend reporting
• Saves time by reducing manual consolidation of platform reports
• Maintains organized records for accounting and tax preparation
• Ideal for self-published authors and small publishers

Get your Author Book Royalty & Multi-Platform Sales Tracker today and streamline your venue operations while maximizing revenue and customer satisfaction.