Spreadsheets are a writer’s best friend

Spreadsheets are a writer’s best friend

So. Spreadsheets. Many of you are probably groaning. I know I did when the idea first struck me. But what better way to keep up with your progress as an author-prenuer as some call it? I tell you, I am hooked. Excel spreadsheets are YOUR friend, people!!

Here is how it broke down:
I went to Amazon and looked at the reports for downloads(ebooks only). I saw their spreadsheets with all the numbers of units posted PER MONTH and the dollar amounts PER MONTH and on what books PER MONTH.

But they didn’t have a figure of accumulated numbers – which is what I wanted.

So, I created a spreadsheet to capture 1. my books 2. my sales numbers in volume 3. my sales dollars per month at a glance with totals at the end of the year.

So far? I am doing WAYYYY better than I thought I was. Can you say, it’s a numbers game??? Well, it is. If you have heard others in the industry say that you need to write more books and release them more often, well, that is totally true. I can prove that with my own books and short stories.

And holidays? OH BOY. Be SURE to publish something for Christmas and for Valentines Day, and for Halloween, and so on…because these times are heavy duty for book purchases and downloads.

I did the best out of the year so far in February with the release of Love Inn and Valentines day. Romance in February is truly something to behold. God bless spreadsheets.

I will update you on the end of the year figures when I have them, but I am just gonna say, 2015 has (so far) been a very good year.

If you know how to work excel, or google spreadsheets, you totally need to do that. It is well worth the time to set up. And really? Who DOESN’T want to know what the $$ rolling in looks like?


About master

Kim Smith is the author of the Shannon Wallace Mysteries, and the Mt. Moriah Series- plus, YA fantasy, and Bizarro fiction. All available on Amazon.

Subscribe to the Zanies See the sidebar to sign up!