Self Publishing Author Business Tracker Spreadsheet, Excel and Google Sheets, Book Royalty Tracker, KENP, Book Launch Planner

Self Publishing Author Business Tracker Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Track every book's royalties, Kindle Unlimited pages, ad spend and costs, see which books really make money, plan your launches and hit your word-count goals, all in one place. Perfect for self-published and indie authors. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers). ★ WHAT'S INCLUDED ★ • 14 tabs with a clickable Start Here page and a How To Use guide with FAQ • Dashboard: 16 KPI tiles (income, net profit, last full month, KU earnings, ad spend, ACOS, ad ROI, books published, units sold, best book, top platform, read-through, words this month, writing streak, next launch, launch progress), month by month table, top books, income by platform, next launch tasks, writing goals and 5 charts • Books catalog (30 books): series and book number, genre, status, launch date, formats (ebook, paperback, hardcover, audiobook), ISBNs, ASIN, word count, page counts, prices and KU enrollment, with units, income, KENP pages, ad spend, expenses, net profit, ROI and a status check for each book • Royalties (1,500 rows): one row per book, platform, format and month with units, returns, KENP pages and royalty earned. KU earnings use the monthly KENP rate you enter • Ads (500 rows): spend, impressions, clicks, orders and ad sales with CTR, cost per click, conversion, ACOS, estimated royalty, profit, ROI and a Scale up / Profitable / Tweak / Cut verdict, plus totals by book and by ad platform • KENP Pages: pages read per book for all 12 months with KU earnings and full-read equivalents • Income by Month: every platform and every format month by month, with ad spend, expenses, net profit and margin • Book Profit: income, ad spend, book costs, net profit, ROI, series read-through and income per 1,000 words for every book • Expenses (500 rows): editing, covers, ISBNs, formatting, audiobook production and more, tagged to a book or to general costs • Launch Checklist: 40 ready-made launch tasks in 5 phases with due dates counted from launch day, overdue alerts and progress by phase (room for 60 tasks) • Writing Log (1,000 sessions) and Writing Goals: words per hour, daily goal check, project targets with pace and projected finish date, streaks and a month calendar of your words • 14 charts in total and sample data from an indie author with 5 published books and 4 in the works ★ PERFECT FOR ★ ✓ Self-published and indie authors ✓ Authors publishing on Amazon KDP, Kindle Unlimited, IngramSpark, Draft2Digital, Kobo, Apple Books and more ✓ Authors running Amazon, Facebook or BookBub ads ✓ Writers planning a book launch or a series ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload to Google Drive and open with Google Sheets) • 4 files included: an Excel version + a Google Sheets edition, each as a Samp