It's the 26th of December. By this time next week, it will be next year. And you know what that means? New spreadsheets for 2017!
Yeah, I'm guessing you're not nearly as excited. Neither am I. It's a necessary thing, though. So, this morning I created a new 2017 Sales Totals spreadsheet and a new 2017 Book Sales Data spreadsheet.
Last year, I totally screwed something up and ended up with a mess of both. This year I'm hoping to avoid the mess because I made a template instead of creating a copy of the Book Sales Data sheet. (Creating a copy somehow made all the formulas in the Sales Total Spreadsheet point to the new copy instead of the original, so when I wiped out the 2015 data, it blanked out my original Sales Total sheet. It was awful.) Fingers crossed this all goes super smooth this year.
So, the new spreadsheets are there. I still have work to do, of course, but they exist - waiting patiently for new sales to fill them up. (Fingers crossed there, too.)
It's just my totally anal way of keeping track of sales. The Sales Totals spreadsheet has pretty graphs, too. I'll probably show a few of those when I do a 2016 wrap up post next week.
If you're a writer, how to you keep track of sales? If you're not a writer, do you use spreadsheets for other stuff in your life or work?