Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
Free Download - Excel & Google Sheets

Free Etsy Seller Spreadsheet Spreadsheet Template for Google Sheets & Excel

A row per order - what it sold for, what came off in fees and postage, and what was left. The Free Etsy Seller Spreadsheet template gives you sixteen order rows, derives the net from the sale price, and carries gross sales and net revenue on the strip at the top. Nothing states Etsy's rates: you enter what actually came off. A currency dropdown beside the title relabels the money columns. Google Sheets or Excel, one file. No macros, no VBA.

Essentials Get more value with Essentials Spreadsheet Template View Essentials $19 Ultimate Unlock all features with Ultimate Spreadsheet Template View Ultimate $29
Works in Excel and Google Sheets · CC BY 4.0
etsy-seller-spreadsheet.xlsx
Free Etsy Seller Spreadsheet Spreadsheet Template for Google Sheets & Excel - dashboard preview

Get More with Essentials or Ultimate Etsy Seller Spreadsheet Spreadsheet Templates

Free Etsy Seller Spreadsheet

Spreadsheet Template
Works in Excel and Google Sheets · CC BY 4.0
Works in Excel and Google Sheets · CC BY 4.0
What's Included
  • A row per order on one working sheet
  • A net figure derived from the sale price and what came off it
  • Gross sales and net revenue on the strip at the top
  • Nothing states Etsy's rates - you enter what actually came off
  • A currency dropdown beside the title that relabels the money columns
Most popular
Ultimate Etsy Seller Spreadsheet spreadsheet template - Google Sheets and Excel preview

Ultimate Etsy Seller Spreadsheet

Spreadsheet Template
  • Everything in Essentials
  • An order log with a category on every line
  • Cost and margin per product, with materials, hours and a rate you set
  • A total cost of goods and a net per unit, both derived
  • An inventory sheet with SKU, reorder point, unit cost and supplier
View Ultimate Etsy Seller Spreadsheet Spreadsheet Template $29›

The FinancialAha Free Etsy Seller Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free Etsy Seller Spreadsheet Excel template and a Free Etsy Seller Spreadsheet Google Sheets template from the same download. A row per order, each with what it sold for, what it cost in fees and postage, and what was left. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Free Etsy Seller Spreadsheet spreadsheet template

The FinancialAha Free Etsy Seller Spreadsheet Template runs on a single working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free Etsy Seller Spreadsheet holds.

  1. 01 of 01

    Etsy Sales

    Five columns: the order date, the product, what it sold for, what came off it in fees and postage, and the net. The net is derived, so correcting a fee moves it. The reason a seller needs this and not a sales report is the gap between the two numbers on either side. A shop that reads its gross and feels fine is a shop that has not looked at what a small item nets after listing, transaction, processing and postage. Putting the two figures side by side per order, and again as totals at the top, is the whole job of the sheet. Fees and postage share a column on this build. That is a simplification, and it is the one worth knowing about: it tells you what an order left you with, but not whether the shortfall was Etsy's cut or the courier's. The Essentials build splits them, and adds what the materials cost. Nothing here states Etsy's fee rates. You enter what actually came off the order, which is the only figure that stays right when the rates change.

    FinancialAha Etsy Seller Spreadsheet spreadsheet template - Etsy Sales sheet

  2. Included guide

    How to Use

    A step-by-step guide on its own tab, covering how to replace the sample values, where the spare rows sit, and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Free Etsy Seller Spreadsheet Spreadsheet template for Google Sheets

Upload the Free Etsy Seller Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Etsy Seller Spreadsheet Google Sheets template needs no conversion step and the net figures recalculate exactly as they do in Excel.

Free Etsy Seller Spreadsheet Google Sheets template setup

A Google Sheets copy suits a shop run from a phone as much as a desk, which is where most orders get logged.

Running the Free Etsy Seller Google Sheet

The Free Etsy Seller Google Sheet is filled in per order or per batch. Nothing in it depends on how often you update it - the totals read whatever rows are filled in.

Also available as:

Free Etsy Seller Spreadsheet Spreadsheet template for Excel

The Free Etsy Seller Spreadsheet Excel download is a plain .xlsx. Excel opens this Free Etsy Seller Spreadsheet Excel template directly, with no import step and no compatibility prompt. There are no macros and no VBA in the file.

Free Etsy Seller Spreadsheet Excel template setup

The same Free Etsy Seller Spreadsheet Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Free Etsy Seller Spreadsheet download to choose between.

Free Etsy Seller Spreadsheet Excel notes

The Free Etsy Seller Spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt.

Opening the Free Etsy Seller Spreadsheet spreadsheet Excel file

Nothing in the Free Etsy Seller Spreadsheet Excel template is version-specific, so this Free Etsy Seller Spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Free Etsy Seller Spreadsheet spreadsheet template tracks

A row per order. This is what the Free Etsy Seller Spreadsheet Template records for each:

Order Date
when it sold
Product
what it was
Sale Price ($)
what the buyer paid
Fees + Ship ($)
what came off it, as one figure on this build
Net ($) auto
derived, and what the order actually left you

Compare builds

FinancialAha Etsy Seller Spreadsheet spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free This page Essentials View Spreadsheet Template Ultimate View Spreadsheet Template
Working sheets 1 2 6
Orders logged 16 40 150
Fees and shipping split apart – Yes Yes
Materials cost per order – Yes On the product sheet
Cost and margin per product – – Yes
Your own time costed in – – Yes
Inventory with reorder points – – Yes
Fee calculator for a single sale – – Yes
Charts – 1 1

The FinancialAha Free Etsy Seller Spreadsheet Template logs each order with fees and postage as one figure. The Essentials Etsy Seller Spreadsheet Template takes forty, splits Etsy fees from shipping and adds what the materials cost, so the net is a real profit rather than a residue. The Ultimate Etsy Seller Spreadsheet Template takes a hundred and fifty, adds cost and margin per product with your own hours costed in, an inventory tracker with reorder points, and a fee calculator for a single sale.

Compare the other builds: Essentials Etsy Seller Spreadsheet spreadsheet template or the Ultimate Etsy Seller Spreadsheet spreadsheet template .

Good to know

Notes on working in the Free Etsy Seller Spreadsheet spreadsheet template

  • Net is the sale price less the fees-and-postage figure, worked out on every row.
  • The two headline figures are gross sales and net revenue, so the gap between them sits on the page rather than in your head.
  • Fees and postage share a column, so the sheet says what an order left you but not which side took it.
  • Nothing states Etsy's rates - you enter what actually came off, which stays right when the rates change.
  • Splitting fees from shipping, and adding materials, starts at the Essentials build.
  • The dropdown beside the title relabels the money columns. It changes the label and nothing else.

How the Etsy Seller Spreadsheet template works

The Free Etsy Seller Spreadsheet Template logs each order on a row of its own - the date, the product, what it sold for, what came off in fees and postage, and the net, which is derived. Gross and net sit side by side at the top, because the gap between them is the thing sellers underestimate: a shop that reads its gross and feels fine is a shop that has not looked at what a small item nets after listing, transaction, processing and postage.

When this template helps

01

You sell on Etsy and want to see what an order actually leaves you.

02

You suspect your smaller items are not worth listing and want to check.

03

You want a record that does not depend on the platform's own reporting.

04

You prefer a spreadsheet you control over a seller app.

Tips to get the most out of it

  • Entering what actually came off an order, rather than a rate looked up somewhere, is what keeps the net column true as fees move.
  • The distance between gross and net is what the two tiles are placed to show, and it is wider than a per-order fee suggests.
  • Logging an order once it has settled keeps the fee figure to hand while you are entering it.

Common mistakes to avoid

  • Logging the sale price and forgetting the postage you paid rather than charged.
  • Reading gross as income. It is the number before the platform and the courier take theirs.
  • Leaving out what the item cost to make, which the Essentials build records.
  • Logging in batches at month end, by which point the small orders are hard to reconstruct.

How to Use the Free Etsy Seller Spreadsheet Spreadsheet Template

1
Date the order
And name what sold.
2
Enter the sale price
What the buyer paid.
3
Enter fees and postage
What actually came off the order.
4
Read the net
Derived per order, and totalled at the top.
Ultimate
Etsy Seller Spreadsheet Ultimate
Ultimate ($29) gives each part its own sheet, with deeper reporting on top.
View Ultimate $29

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

Excel
Sheets
Privacy by default
Your numbers stay in your own file
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away

Frequently Asked Questions

What is the difference between the free, Essentials, and Ultimate Free Etsy Seller Spreadsheet spreadsheet template?

Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build, with more worked out for you rather than typed. Ultimate ($29) goes further again, splitting the template across more working sheets and adding deeper reporting on top. What each tier holds differs by template - the comparison table on every template page lists it exactly.

Which Free Etsy Seller Spreadsheet spreadsheet template should I download?

Essentials is the fuller build of this template for ongoing use, and the comparison table on this page lists exactly what it adds. The Free version is a good fit for one-off planning or trying out the layout.

Can I upgrade the Free Etsy Seller Spreadsheet spreadsheet template later?

Yes. Essentials is a one-time $19 purchase with no subscription. What it adds depends on the template: some builds gain capacity and a dashboard, others richer detail in the same layout. The comparison table on this page lists the differences exactly.

Is the FinancialAha Free Etsy Seller Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free Etsy Seller Spreadsheet Google Sheets template, and the net figures recalculate exactly as they do in Excel.

Is the FinancialAha Free Etsy Seller Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Free Etsy Seller Spreadsheet Excel template opens directly in Excel with no import step. There are no macros and no VBA in the file.

Will the FinancialAha Free Etsy Seller Spreadsheet Excel file open in older versions of Excel?

Yes. The Free Etsy Seller Spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

Does the Free Etsy Seller Spreadsheet work out the Etsy fees for me?

No, and that is deliberate. You enter what actually came off the order, which is the only figure that stays right when the rates change. A fee calculator for a single sale is on the Ultimate build.

Why are fees and postage in one column in the Free Etsy Seller Spreadsheet?

It is a simplification. This build tells you what an order left you with, but not whether the shortfall was the platform's cut or the courier's. The Essentials build splits them and adds materials.

Is the net figure calculated in the Free Etsy Seller Spreadsheet template?

Yes. It comes from the sale price less what came off, so correcting a fee moves it.

Does the Free Etsy Seller Spreadsheet account for what the item cost to make?

No. Materials are on the Essentials build, and a full cost-per-product sheet with your own hours costed in is on Ultimate.

How many orders does the FinancialAha Free Etsy Seller Spreadsheet hold?

Sixteen, with twelve filled in the sample. The Essentials build takes forty and the Ultimate build a hundred and fifty. For a seventeenth here, right-click a row inside the table and choose Insert - both totals expand to include it.

How do I open the Free Etsy Seller Spreadsheet spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

Can I use the Free Etsy Seller Spreadsheet spreadsheet template for commercial work?

All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.

More Free Business Finance Templates

Cash Flow Statement

A line per movement across one period, arriving with sample entries, and what you expected sitting beside what actually happened. The Free Cash Flow Statement spreadsheet template takes inflows positive and outflows negative so a single column nets out, and the strip at the top carries both totals and whether the period finished cash positive. Sixteen lines with free-text labels, so the list matches your business. Google Sheets or Excel. No macros, no VBA.

Free

Profit & Loss Projection

Revenue and costs sit on the same list, told apart by sign, with a projected figure in one column and an actual in the next. The Free Profit & Loss Projection spreadsheet template runs sixteen lines to net income both ways, and its Difference column reads correctly whether the row is income or expense. Projected and actual net income are restated at the top. Google Sheets or Excel. No macros, no VBA.

Free

Sales Forecast

A line per product or service, forecast across four quarterly columns, with a year total derived on each line and every quarter totalled down the page. The Free Sales Forecast spreadsheet template holds fourteen lines, so revenue splits by what you sell rather than sitting as a single number, and it puts first quarter, last quarter and the year total on a strip at the top. One working sheet, Google Sheets or Excel. No macros, no VBA.

Free

Startup Costs

Sixteen lines, each with what you budgeted beside what it actually came to and the gap between them worked out as budgeted less actual, so a positive number means the line came in under. The Free Startup Costs spreadsheet template ships with sample lines for the costs people forget, permits, deposits and first-year insurance among them, and totals at the foot and again on the strip at the top. Google Sheets or Excel. No macros, no VBA.

Free
Etsy Seller Spreadsheet
Free · $19 · $29
View Essentials $19