If you're just starting out and you haven't gotten the hang of spreadsheets yet, here's something to help!
This spreadsheet assumes that your e-books are priced at $2.99. The royalty estimates for Amazon and Smashwords will give you a slightly high estimate - there are fields to fill in actual royalties for the month. It will highlight the highest sellers/earners, per-site and overall. It includes a sheet for each month, plus a yearly total sheet that will sum up the other 12.
It's an .ods file, which will work with OpenOffice. It's free - if you don't have a certain other office software suite, you should go download it!
Again, this spreadsheet is certainly not perfect, but it could be a good starting point. Off the top of my head it contains examples of (fairly simple) functions and conditional formatting.
Good luck! :)
This is amazing! I can't thank you enough. Now that I see how the formulas work I'm playing around with it and having a grand old time. The only thing that I think is notably missing is a way to track returns, which is something I'd like to do in case trends start to develop. Also, it's easier than I thought to account for a 35% royalty sale on Amazon - just enter it as .5 of a sale! Which is kind of depressing if you think about it, really. Who wants to sell half a book?
ReplyDeleteGlad it helps! :) I didn't even think to track Amazon returns - if I get the chance, I might go back in and add a column for that, it wouldn't be too hard. And that's a clever way to deal with the 35% royalty sales!
Delete