Author Resource: Sales and Royalties Spreadsheet

Author Resource: Trilogy Rapid Releas... I had a baby! (Well, a book baby)

Author Resource: Sales and Royalties Spreadsheet

Hi, fellow indie authors!

I’m really excited about the spreadsheet I’m sharing with you. I wanted a place to track all my sales from various venues.

You might find this spreadsheet useful if you are US-based, have fifteen or fewer book titles for sale, and sell these books in any or all of the ways below:

Amazon KDP (e-books, paperbacks, Kindle Unlimited)ACX (audiobooks)IngramSpark (paperbacks)Your own website (selling paperbacks, etc.)In-person sales (such as book signings)

You don’t have to sell in all those ways to use this tool; just leave the parts blank that you don’t need.

I’m geeking out over what this spreadsheet does. You’ll enter your book titles once, and they’ll be shown over and over throughout the sheet. You’ll paste in data from reports (such as the downloadable KDP sales report) once a month, and the spreadsheet will add it all up for you, even making the necessary calculations to convert from other currencies to U.S. dollars!

It doesn’t do everything for you! Like I said, you still have to paste in data. If you do in-person and/or website sales, it’ll take a little more work to enter those. But most of your work will happen once a month when you download and paste in data from your various reports, and that shouldn’t take longer than fifteen or twenty minutes once you get the hang of it.

The result? Data, data, data. Monthly and annual sales broken down by book and by where the sale happened (such as US, UK, or Other.) Charts, so you can see which books are performing the best, which months you make the most money, which book formats are earning you the most, and more.

Below are a couple of teaser images from the spreadsheet.