The last two years on my other blog, I've given away Etsy Goal Spreadsheets for that year. Keeping an Etsy Goal Spreadsheet remains one of the best things I've ever done for my little business. I've heard great things from others who have started using it, too. Naturally, we've got to keep that going!
I've been using it for two years now. It's given me clarity on how much I've been selling week by week. I can see on what days people have been buying stuff. I have gratitude that I have been selling regularly. It's also made me conscious of how things are going for the shop.
All this from just a simple little spreadsheet.
But just tracking isn't enough. You have to know where you're going. So I set an audacious goal. Audacious, but hopefully achievable. What this does for me is enable me to really know how well I am doing from week to week, how close I am (or not) to reaching my goals. And then I can adjust accordingly.
So without any further ado:
Download the Etsy Goal Spreadsheet for 2011
Here's how you use it.
First, add your sales goal (where you'd like to be, sales wise at the end of the year) in the cell below the GOAL cell. (I've put 500 in randomly, but change it to whatever your goal is.)
The first column has weekly dates in it. Along the top are the days of the week. Enter how many sales you've had on any given day. They'll automatically subtract from the Left to Go cell. That's it!
* Feel free to share & change this willy nilly, but please let people know you found it at http://absolutelysmall.com/blog
* This spreadsheet is an .xls file. In other words, it's made to be opened with Excel, but can (hopefully) also be opened by a number of other programs. (Numbers, Open Office, etc.)
* It may be titled Etsy, but of course this spreadsheet would work equally well for Artfire, your own site, or whatever else it is you need to track.
*1/1/11 - The dates have been corrected. However, dates pulling up as #### has been reported. This is not a spreadhseet error. Simply widen the column to make those pound signs go away.
(Thank you Chrystal S & Madeline from the comments for pointing this out!)