Self-Published Author Income Tracker Excel — books & formats, income log, expenses, and a monthly P and L dashboard. Know what every line actually pays — and whether the month actually made money. Built for…
About this template
Self-Published Author Income Tracker Excel — books & formats, income log, expenses, and a monthly P and L dashboard. Know what every line actually pays — and whether the month actually made money. Built for Self-published authors with paperbacks, ebooks, planners, and audiobooks across platforms who get one blended royalty number and no idea which title paid for its editing and cover.
$39
Excel & Google Sheets template — instant download on Etsy
Books & Formats — Every book and format: gross royalties, copies sold, royalty per copy, add-on revenue from direct and signed sales, total revenue, and direct editing, cover, and production cost allocated to that title. Change a royalty and the totals update.
Income Log — Every book line: date, book, entry, copies, rate pulled from sheet 1 by formula, amount, and whether it was billable. Add-on rows are priced per entry, and free promotional copies are logged as non-billable.
Expenses — every overhead cost by category (Ads, Editing, Design, Software, Printing, Fees, Other), with quantity, cost per unit, and a monthly cost for each.
Monthly P and L — revenue, direct cost, ads, editing, design, software, printing, fees, other and other expenses by month, Jan-Dec, with net profit and margin. Revenue is a formula from the Income Log; direct cost is a formula from sheet 1.
Dashboard — total revenue, books and formats, units, billable vs non-billable units, units vs target, average revenue, direct cost, expenses, net profit and margin, best and weakest lines, revenue by line, costs by category, and units by line.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Self-Published Author Income Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Self-Published Author Income Tracker track?
The Self-Published Author Income Tracker tracks Books & Formats; Income Log; Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 lines; gross revenue 14,870; add-on revenue 430; total revenue 15,300; direct cost 5,810.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.