A spreadsheet only tells you the truth about your shop if it has the right columns. Leave out a fee layer, or mix up what the buyer paid with what actually landed in your account, and every total below it is wrong. Here's the minimum column set, the fee detail most sellers miss, and where free options stop being enough.
Before comparing tools, it helps to know what the tool (or your own spreadsheet) actually has to hold. At minimum, that's one row per order with these columns:
| Column | What goes in it |
|---|---|
| Order date | So totals can be grouped by month or season. |
| Shop / platform | Etsy, Shopify, eBay, etc. — required if you sell in more than one place. |
| Order total (buyer paid) | Item price + shipping charged + gift wrap charged. This is the base Etsy's percentage fee is calculated on, not just the item price. |
| Etsy transaction fee | 6.5% of the order total above. |
| Payment processing fee | A percentage plus a flat fee, varies by country. U.S. example: 3% + $0.25. |
| Listing fee | $0.20 per listing — charged once per listing whether or not it sells, so it isn't purely a per-sale line. |
| Shipping cost (actual) | What you paid to ship — postage and packaging — not what the buyer was charged. |
| Materials / COGS | What the item actually cost you to make or source. |
| Estimated profit | Order total minus the three fee rows, minus actual shipping cost, minus materials. |
| Estimated margin % | Estimated profit divided by order total. |
The three fee rows in the middle of that list — transaction, processing, and listing — are the part people build a spreadsheet without, then wonder why the profit column looks better than their bank balance.
These three numbers are simple once you know them, but easy to encode wrong in a spreadsheet formula:
If you just need to check one listing, or one order, you don't need a spreadsheet at all. The free Etsy Fee Calculator takes the order total, the two fee rates, shipping, and materials, and returns an estimate on the spot — no signup, nothing leaves your browser.
That works fine order by order. It stops scaling the moment you want a monthly or store-level total: a calculator doesn't remember the last order you checked, so getting a month's number means re-entering every order from that month by hand, and getting a combined number across shops means adding up separate totals yourself outside the tool. That's the point where a spreadsheet built once with the columns above — or something that builds those rows for you — starts saving real time instead of costing it.
Searching for an Etsy profit tracker spreadsheet turns up the same handful of options repeatedly. Here's how they differ, based on what each vendor states on their own current pricing page.
| Option | Cost | How data gets in | Offline, no account |
|---|---|---|---|
| Build your own spreadsheet | Free | You type every row by hand | Yes |
| Paper+Spark Etsy Seller Spreadsheet | $97 one-time | Copy/paste your Etsy data in; built-in formulas do the math. Other income sources (PayPal, eBay, craft shows) are consolidated the same way. | Yes — it's a file you own |
| Craftybase Studio (the brand is now Stocksmith) | $49/mo, or $41/mo billed annually | Automatic daily order sync from connected sales channels | No — cloud account required |
Pricing checked directly on each vendor's own site: Paper+Spark — shop.paperandspark.com/products/etsy-seller-spreadsheet (July 2026). Craftybase Studio — stocksmith.io/pricing (July 2026); Craftybase rebranded to Stocksmith in July 2026, and Studio continues as its lower-priced tier for smaller shops under the new company.
The trade-off underneath that table is simple. Manual entry costs nothing but your own time, every month, indefinitely. A subscription automates the import but keeps billing whether or not you log in that month. A one-time spreadsheet or tracker sits between the two: pay once, keep the file, and the only recurring cost is however long exporting and re-importing a CSV takes you each month.
Whichever option from the comparison above ends up fitting your shop, the fastest way to check a single order right now — before building out a full spreadsheet or evaluating a paid tool — is the free Etsy Fee Calculator. It covers the same order total, fee, and cost columns described above, one order at a time, with no signup and nothing you enter leaving your browser.
This page and the tools it links to are an independent project — not created, affiliated with, endorsed by, or sponsored by Etsy, Inc. "Etsy" is a trademark of Etsy, Inc. The Etsy fee numbers cited above come from Etsy's own help articles, checked as of the update date shown at the top of this page; Etsy can change its fee schedule, so confirm current rates directly with Etsy before a pricing decision that matters. Competitor names, features, and prices are likewise quoted from each vendor's own current pricing page as of the date noted — mentioning them is a comparison, not an endorsement or a criticism. None of this is tax advice, and no figure here is a guaranteed payout.
← How Etsy Fees Work: the fee layers explained, with a worked example
How to price duty into an Etsy listing: the DDP gross-up formula
Every Etsy fee, one sourced table (CSV download) →
This page provides estimates for informational purposes only, not tax or financial advice — please consult a licensed professional for decisions specific to your situation.
Etsy is a trademark of Etsy, Inc. This content is not created or endorsed by Etsy, Inc.