Etsy Seller's Worksheet

Etsy Seller's Worksheet

Price:Totally Free!
File Type:Excel Spreadsheet (.xls & .xlsx)
File Size:80kb (.ZIP file; contains two versions)
Last Update:2008-01-20
Current Version:       1.4
Macros:No.
  • Pinterest

Because my wife is an Etsy seller, I have yet another fine reason to build (and modify!) more spreadsheets.

Next up on my list of spreadsheets is my Etsy Seller's Worksheet. It's based upon a spreadsheet offered by the folks behind Etsy themselves. I read through the users' comments, modified a few things, cleaned up a few other things, and ... well, came up with this (presented in Excel 2007):

Etsy Seller's Worksheet - Overview

If that looks like something you'd be interested in, just grab your copy here:

Download Spreadsheet!

I'm thinking that using the Etsy Seller's Worksheet should be fairly self-explanatory — it's not the most complex spreadsheet I've ever seen, after all — but just in case, I'll add a few more details here.

Spreadsheet Overview

I intentionally created the spreadsheet so that it would be very modifiable to users' needs. There are no macros in use, nor will you find password protection. You should be able to add columns and formulas to your heart's content.

The spreadsheet was created in Excel 2007, but it should work just fine in all versions of Excel. It seems to operate normally in OpenOffice Calc, although the colors and graphics are rather harsh there.

Why Use a Monthly Time Period?

After giving it some serious thought, I've decided that the best way to make the spreadsheet as "universally usable" as possible is to track the sales, cost of goods sold (COGS), and sales-tax data on a monthly basis.

To achieve this, you'll want a separate ACTIVITY LOG worksheet for each month. The spreadsheet comes with January's ACTIVITY LOG ready to go, and there's a blank ACTIVITY LOG after that. Whenever you're ready to start a new month, simply copy the blank ACTIVITY LOG worksheet and rename it to reflect the new month. (Instructions are here.)

ITEM CATALOG Worksheet:
Entering Your Items and Such

In its initial form, this worksheet has only four inputs. When you're ready to start, simply overwrite the example data with your own.

Item Catalog Worksheet
  1. Item #
    If you assign each of your products an Item Number, enter it here.
  2. Item Name
    Self-explanatory. The items you enter here will be available by for input (via drop-down menu) on each of your Monthly ACTIVITY LOGS. See below for more info.
  3. Description / Notes
    Self-explanatory.
  4. Quantity on Hand
    Self-explanatory
NOTE: The QUANTITY ON HAND column is not self-calculating; i.e., it doesn't keep up with sales data as you enter it on any other pages in the workbook. If you track this figure (and you should), you'll need to enter it by hand and change it over time, as necessary.

There are plenty of blank columns after that, so with a little setup work on your part, you should be able to track whatever item-specific data you wish.

ACTIVITY LOG Worksheet:
Entering Your Sales, Cost, and Tax Data

As noted above, you'll want to start a new ACTIVITY LOG worksheet for each month. (Instructions for doing so are here.)

Monthly Sales Worksheet

There are quite a few columns to fill in here, but even so, I left some blank ones off to the right of the spreadsheet in case you wish to add even more.

The vast majority of the columns here should be self-explanatory. But here are a few things worth mentioning:

  • When you're filling in the ITEM NAME column, you can select the item from a drop-down menu. Excel creates this menu from the data you listed on your ITEM CATALOG worksheet.
  • Select the ITEM NAME by drop-down menu.
  • As long as you use a new ACTIVITY LOG for each month, you can always see your total monthly Sales Tax Receipts in the dark blue box at the top of that column:
  • Cumulative Monthly Sales Tax
  • The same applies to your Gross Profit (although the box here is green):
  • Cumulative Monthly Gross Profit
 

How to Create New Monthly ACTIVITY LOGS

  1. Right-click the blank worksheet entitled "ACTIVITY LOG -- Blank" and select "Move or Copy..."
  2. Highlight "(move to end)" and place a checkmark by "Create a copy."
  3. Click the [OK] button.
  4. Right-click the newly-created worksheet. Rename it to reflect the new month.

Questions? Comments? Contact Me!

Got a question or issue? Don't hesitate — drop me a line. I'll get back to you as soon as possible!




RSS FeedWant to know when I add to and update my spreadsheets? Subscribe to IYM's feed!


Add to My Yahoo!



Helpful Books
for Etsy Folks!

Success in business requires a willingness to learn and experiment! Here are a few books I've found to be very helpful:






Make a Donation
If you're a user of my Excel spreadsheets and feel that they're worthy of a small donation ... well, that's extremely cool. And I'm truly honored that you'd think so.

The following button will allow you to make a donation (any amount) via Paypal. I would ask, though, that if you're someone who's in substantial debt, and working like crazy to get out, that you please refrain from making a donation to IYM.

Instead, use your intended donation amount as an extra contribution toward your highest-interest debt ... and then drop me an email to tell about how my site or my spreadsheets have helped in some way.

That, I assure you, is payment enough for me.

As always, I am truly grateful for your kindness and continued support!