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中文
Etsy Seller Spreadsheet Ultimate ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Etsy Seller Spreadsheet Spreadsheet Template for Google Sheets & Excel

Forty orders on one log, with Etsy fees, shipping and materials split into three columns, so the net reads as profit rather than residue. The Essentials Etsy Seller Spreadsheet template records a quantity and an order number on every line, which is what lets you find an order again weeks later, and sits a dashboard in front of the log. Google Sheets and Excel, one file. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Etsy Seller Spreadsheet Spreadsheet Template
$29
Essentials Etsy Seller Spreadsheet spreadsheet template - Google Sheets and Excel preview

What's Included

  • Forty orders on one log
  • Etsy fees, shipping and materials as three separate columns
  • An order number for finding an order again weeks later
  • Quantity recorded per order
  • A net profit that counts what the item cost to make
  • A dashboard with gross sales, net and total costs, plus a chart
  • A currency dropdown that relabels the money columns across both sheets
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • Forty orders on one log
  • Etsy fees, shipping and materials as three separate columns
  • An order number for finding an order again weeks later
  • Quantity recorded per order
Ultimate - $29
  • 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
  • A fee calculator for a single sale, with an offsite-ads toggle
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Etsy Seller Spreadsheet Template is a two-sheet workbook for Google Sheets and Excel, with a How to Use guide on a third tab. It works as an Essentials Etsy Seller Spreadsheet Excel template and an Essentials Etsy Seller Spreadsheet Google Sheets template from the same download. Forty orders with Etsy fees, shipping and materials split apart, so the net is a profit rather than a residue. No macros, no VBA.

Inside the workbook

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

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

  1. 01 of 02

    Order Log

    Forty orders with the date, an order number, the item, the quantity, the sale price, and then the three things that come off it separately: Etsy's fees, the shipping, and what the materials cost. Splitting those three is what turns a net figure into something you can act on. An order that nets badly because of postage is a packaging or a pricing problem; one that nets badly because of materials is a sourcing problem; one that nets badly because of fees is neither, and there is nothing to be done about it. A single combined figure tells you the order was disappointing and stops there. The materials column is the one sellers most often leave out of their own spreadsheets, and it is the one that decides whether a shop is a business or a hobby with receipts. A net that ignores what the thing cost to make is not a net. The order number is worth filling in even though nothing reads it. It is what lets you find the order again when a buyer writes eight weeks later.

    FinancialAha Etsy Seller Spreadsheet spreadsheet template - Order Log sheet

  2. 02 of 02

    Dashboard

    Six figures. Gross sales across all orders, the net after fees, shipping and materials, and the total of those three costs on the top row; how many orders were logged, what an order averaged in gross, and what an order averaged in profit on the second. The cost total beside the gross is the reading worth taking - on a handmade item it is routinely a larger share of the sale price than people carry in their heads. Average profit per order is the one to watch as volume grows, because it is the figure that says whether more orders would actually help. A pie chart splits the costs into fees, shipping and materials.

    FinancialAha Etsy Seller Spreadsheet Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering what each column expects, what the net includes, 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

Essentials Etsy Seller Spreadsheet Spreadsheet template for Google Sheets

Upload the Essentials Etsy Seller Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Etsy Seller Spreadsheet Google Sheets template needs no conversion step and the chart comes across intact.

Essentials Etsy Seller Spreadsheet Google Sheets template setup

A Google Sheets copy suits a shop logged from a phone between orders rather than at a desk on Sundays.

Running the Essentials Etsy Seller Google Sheets template

The Essentials Etsy Seller Google Sheet is filled in per order. The materials column is the one worth entering while you still remember what went into the thing.

Also available as:

Essentials Etsy Seller Spreadsheet Spreadsheet template for Excel

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

Essentials Etsy Seller Spreadsheet Excel template setup

The same Essentials 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 Essentials Etsy Seller Spreadsheet download to choose between.

Essentials Etsy Seller Spreadsheet template notes for Excel

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

Opening the Essentials Etsy Seller Spreadsheet spreadsheet Excel file

Nothing in the Essentials Etsy Seller Spreadsheet Excel template is version-specific, so this Essentials 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 Essentials Etsy Seller Spreadsheet spreadsheet template tracks

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

Date
when it sold
Order #
what lets you find it again when a buyer writes weeks later
Item
what it was
Qty
how many
Sale Price ($)
what the buyer paid
Etsy Fees ($)
what the platform took
Shipping Cost ($)
what it cost to send
Materials ($)
what it cost to make, which is the column most sellers leave out
Net Profit ($)
what is left once all three come off

Compare builds

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

Feature Free View Spreadsheet Template Essentials This page 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 Free Etsy Seller Spreadsheet Template logs each order with fees and postage as one figure. The FinancialAha Essentials Etsy Seller Spreadsheet Template takes forty and splits Etsy fees, shipping and materials apart, so a bad net can be traced to which of the three caused it. 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: Free Etsy Seller Spreadsheet spreadsheet template or the Ultimate Etsy Seller Spreadsheet spreadsheet template .

Good to know

Notes on working in the Essentials Etsy Seller Spreadsheet spreadsheet template

  • Splitting fees, shipping and materials is what turns a disappointing net into a problem you can name.
  • A net that ignores what the thing cost to make is not a net.
  • The materials column is worth entering while you still remember what went into the item.
  • The order number is what lets you find an order again when a buyer writes eight weeks later.
  • On a handmade item the three costs together come to a larger share of the price than a rough estimate suggests.
  • The currency dropdown on the dashboard relabels the money columns across both sheets. It changes the label only and does not convert the numbers.

How to Use the Essentials Etsy Seller Spreadsheet Spreadsheet Template

1

Log the order

Date, order number, item and quantity.

2

Enter the sale price

What the buyer paid.

3

Split the costs

Etsy fees, shipping and materials separately.

4

Read the net

What is left once all three come off.

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.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

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

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Etsy Seller Spreadsheet Google Sheets template needs no conversion step and the chart comes across intact.

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

Yes. The download is a plain .xlsx, so the Essentials Etsy Seller Spreadsheet Excel template opens directly in Excel with no import step, and the chart is a native Excel chart.

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

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

Why does the Essentials Etsy Seller Spreadsheet split fees, shipping and materials?

Because a bad net means something different in each case. Postage is a packaging or pricing problem, materials is a sourcing problem, and fees are neither. One combined figure tells you the order was disappointing and stops there.

Why does the materials column in the Essentials Etsy Seller Spreadsheet matter so much?

Because a net that ignores what the thing cost to make is not a net. It is the column sellers most often leave out of their own spreadsheets.

What is the order number for in the Essentials Etsy Seller Spreadsheet?

Finding the order again when a buyer writes eight weeks later. Nothing in the sheet reads it.

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

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

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

Forty. The Free build takes sixteen and the Ultimate build a hundred and fifty.

How do I open the Essentials 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.

More Essentials Business Finance Templates

Cash Flow Statement

Twelve months across the page, with operating, investing and financing activities grouped into sections of their own and an annual total closing the grid. The Essentials Cash Flow Statement spreadsheet template carries the cash position month to month - you enter January's opening balance and the rest link forward - and follows the usual accounting convention on the working-capital lines. Three working sheets. Google Sheets and Excel. No macros, no VBA.

$19

Profit & Loss Projection

Year one is what you enter; years two and three are worked out from six assumptions you set - revenue, cost of goods sold and operating expense growth, plus a tax rate. The Essentials Profit & Loss Projection spreadsheet template runs thirteen lines from revenue through gross profit and margin, operating income, EBITDA, interest and income before tax, down to net income, with a dashboard over the top. Google Sheets and Excel. No macros, no VBA.

$19

Sales Forecast

Ten product lines forecast across twelve months, then the same ten again recording what actually happened, with the variance worked out per month in money and as a percentage. The Essentials Sales Forecast spreadsheet template gives every line an annual total and a share-of-total figure, and reports the year total and the implied growth on a dashboard. Two working sheets, Google Sheets and Excel. No macros, no VBA.

$19

Startup Costs

Fourteen one-time costs and twelve monthly operating ones stay on lists of their own, each line carrying an estimate, an actual, the variance and a per-cent-spent figure. The Essentials Startup Costs spreadsheet template builds a first-year total from both, one-time plus twelve months of operating, and sets up to six funding sources against it. A notes column records what each figure assumes. Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview
See Freelancer Ultimate Pack 8 templates included • Save $113

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →