skip to Main Content

Etsy Seller Spreadsheet

5.0 (5 reviews)

Excel template for Etsy shop owners and sellers. Track sales and income in simple steps. Import data from Etsy and analyze results with charts.

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

Managing an Etsy Shop? All in Excel and designed by professional Etsy sellers, this Etsy Seller Spreadsheet is exactly what you need! We know that Etsy bookkeeping and managing all the data at hand might be challenging – if you do not have the right tools.

Therefore we are here to share our secret recipe with you.

Etsy-Seller-Spreadsheet-Template-Someka-S01

Our sales spreadsheet is already designed in a way to accommodate Etsy specific information. Just follow the steps to input your existing raw sales data and expenses. Your reports will be automatically and simultaneously generated.

Etsy Seller Spreadsheet Features

The main target of this Etsy bookkeeping template is to produce meaningful reports from the CSV file. This file can be easily gathered from Etsy account. Afterward, the data is organized and manipulated for the user automatically, providing you with an opportunity to analyze sales numbers.

The template is constructed by three main parts to be followed in order:

1.Settings

2.Input sections

Raw Sales Data: This will be fed from Etsy report. Detailed “Instructions” for users to import data from Etsy are included.

Expense Records: In this area, you will be able to input your expenses using dropdown menus.

3. Output sections

The visual charts and reports include Etsy Sales Summary and Etsy Sales Dashboard.

Navigation Menu

The design of this sheet lets you easily navigate within the Etsy bookkeeping template. Just use the buttons to navigate between settings, input areas and output sections.

Yellow notes are included to help you get going on the Etsy Sales Spreadsheet right away!

Etsy-Seller-Spreadsheet-Template-Someka-S02

Note: Here you may also find detailed and step-by-step instructions to import data from your Etsy account.

Settings

In the settings section, you may define your expense categories as well as monthly sales revenue targets. Your expense category settings will be on the selection options of Expense Records section.

Furthermore, here you may only define your desired currency as well as the date format.

Etsy-Seller-Spreadsheet-Template-Someka-S03

Raw Sales Data

This is the main data input area of the Etsy Seller Spreadsheet. You may import your data from Etsy. Of course, Instructions will help you step by step. You can also check the product video tutorial showcasing this in action.

Etsy-Seller-Spreadsheet-Template-Someka-S04

If you manually input data, fill in all the columns with an asterisk (*) sign. These are:

Sale Date, Item Name, Quantity, Price, Listing ID and Ship Country.

Expense Records

The user will record his expenses with the Year/Month/Category and Amount info. The description is optional. While recording expenses, the user should use the same currency as the listings.

 

Etsy-Seller-Spreadsheet-Template-Someka-S05

Etsy Sales Summary

This is where you will see your sales breakdown. All the data is coming from your raw sales data. In addition, you may use filters to examine your sales.

You may filter the table by sales date, item, quantity, country, and total sales.

Note: Please do not input any data and do not try to manually edit the table.

Etsy Sales Dashboard

The interactive Sales Dashboard section will allow you to analyze results. Furthermore, while analyzing your results, you can use year and month filters to dynamically update the figures and charts. These filters are located on top of the Sales Dashboard section.

Etsy-Seller-Spreadsheet-Template-Someka-S06

The ready-made reporting areas and charts include:

  • # of Items Sold, Total Sales, Total Expenses, Net Income
  • Expense breakdown per expense category, Top 5 Countries by Sales, Yearly Target Actualization, Monthly Targets and Actuals

Etsy-Seller-Spreadsheet-Template-Someka-S07

  • As well as Top three Items and Item-based Sales breakdown per month.

Moreover, for this analysis, you can use the specific filter located near the bottom of the Sales Dashboard section.

Etsy-Seller-Spreadsheet-Template-Someka-S08

Instructions

Although most Etsy Sellers are familiar with importing data from their Etsy account, we have included a detailed explanation on how to perform this action in 3 simple steps:

  • Step 1 – Downloading CSV File from Etsy
  • Step 2 – Importing Data from CSV
  • Step 3 – Copy and Pasting the Data

Detailed instructions can be found within Etsy Bookkeeping Excel Template.

Etsy-Seller-Spreadsheet-Template-Someka-S09

Etsy Seller Spreadsheet Features Summary:

  • Etsy Bookkeeping Spreadsheet in Excel format
  • Direct import from Etsy account
  • Dynamic sales summary report and charts included
  • Informational notes included
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Does not include any VBA code or macros

Etsy Seller Spreadsheet is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

5 reviews for Etsy Seller Spreadsheet

  1. Evvie

    Can I add an extra sheet for my prices?

    • Someka

      Hi Evvie,
      After unlocking your template, you can add extra one or more sheets for your product prices. Please click here to see how to unprotect your sheets.

  2. Jeffery H.

    Great doc for my sales analysis. Only one question: can I also input my sales data from different platforms other than Etsy?

    • Someka

      Hi Jeffery,
      This template is basically designed for Etsy sales analysis. But you may also input manual sales data from other platforms. Please do not forget to fill in all the columns with an asterisk (*) sign; that’s to say you will input Sale Date, Item Name, Quantity, Price, Listing ID and Ship Country.

  3. Jonny Montgomery

    how many products does it have?

    • Meric Benderlioglu

      Hello Jonny,
      The template has no limit for your product listings. You may input data up to 5000 different sales. This could be for various products.

  4. Berenice

    Hii can i change your logo with mine if I purchase?

    • Someka

      Hi Berenice,
      Yes, of course! After purchasing modifiable version, you can remove our logo easily. Please check here for more information.

  5. Roland O.

    Can I also use my Etsy report to see my sales. and I’m not an Excel savvy.

    • Someka

      Hello Roland,
      Yes, this template is totally designed for Etsy shop owners. You don’t need to be an Excel expert. You will get your Etsy report and paste your data, and the template will analyze all your sales. In addition, an instruction page is included for you. Each step is explained one by one. If you have any questions, before or after purchase, please do not hesitate to send them to us at contact@someka.net

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED EXCEL TEMPLATES