Sunday, December 26, 2010

The Etsy Goal Spreadsheet for 2011

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!
Picture of the Etsy Goal Spreadsheet
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!


Notes:
* 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!)

27 comments:

Tweets that mention The Etsy Goal Spreadsheet for 2011 is here! -- Topsy.com said...

[...] This post was mentioned on Twitter by Claire. Claire said: The Etsy Goal Spreadsheet for 2011 is here! http://bit.ly/fnRPSs [...]

Sam said...

Oooh, this is great! I'm working on a blog post for Thursday about setting goals, so I'll be adding this in. Thanks for sharing!

Miranda said...

Thank you so much for making this! I used the 2010 one and loved it! It was rather interesting to see when I was really busy, but seeing the dry spells sometimes can be a little discouraging. xD I did reach my goal of 200 sales though and got 50 more! Woohoo! :D Here's to a great 2011!

Laura said...

Thank you so much for sharing this brilliant tool! I just read your post on the Etsy forums about it and popped by. Tracking goals is a great way to stay focused and this sheet will help me to see the days that are busy and ones that are less so.
Thanks again.

Pam said...

Great little tool! I've downloaded it and will be linking to it in a blog post later this week as well. Thanks!!

Heedless said...

Thanks for the post..I saw this some time ago..maybe the 2010 version and forgot about it...well now its on the desktop:)

Heedless said...

I downloaded, and will share on FB business page...now I just need to make myself use this....the computer should kick out a treat if I fill in a column...don't you think?

tina aka forrestina vintage said...

I'll try it out, thanks. Shared on Twitter and Facebook. :)

Sarah said...

Thanks for making this spreadsheet! I set a lofty goal but I am going to give it a whirl!

Lauren Williams said...

Thank you, this is such a great tool!

Jacqueline Gikow said...

ok, I'll give it a try.

ceeb said...

thank you for this. i hope that you reach your goal & above for sharing this with us!!may the universe reward you with what you want.

Claudia said...

Thank you so much - I'm planning to open up my ETSY store this year so this will help loads!

jeni said...

Thanks. Downloaded it and will try to use this tool in 2011.

jude said...

thank you so much! I love this idea and look forward to seeing how I do this year.. you rock!

Julie Rais said...

Thank you soooo much for sharing this spreadsheet. It is EXACTLY what I need to start the year off on the right foot. Love it!

liz said...

Thank you so much, I love statistics and will give this a really good go.

Dayzee said...

I'm going to try this out and then recommend it to all my team. Thanks for sharing! :)

Valerie said...

Brilliant! So kind of you to share this!

Perenet said...

Thank u so much for sharing !

Chrystal S said...

This is very cool! Thank you so much for sharing! You are awesome! :)
As for the # #### coming up in the date column, the column just needs to be a little wider... Works like a charm!
Thanks again!!! :)

Madeline said...

Thanks so much for making this! I can't wait to try it out! And also, fyi, when dates come up as ######, all you have to do is widen the column.

Erika said...

Brilliant - thank you!

Claire said...

THANK YOU Chrystal & Madeline! I knew there had to be a simple explanation not related to the coding. :)

Susmitha - Veganosaurus said...

Thank you so so so so much! This was an extremely useful tool for me in 2010. Felt so good about almost reaching my little goal! This year, I intend to aim a LOT higher! :D

Goddess bless you for sharing such a lovely gift with all of us! :)

Gem said...

Thank you so so much! I love having something to motivate and record my sales, but generally I'm too impatient to make my own spreadsheet! This is perfect.

Elki said...

This is great, thanks for sharing!

LinkWithin

Blog Widget by LinkWithin

Let Feedburner tell you when Absolutely Small updates