Tracking Etsy profit in a spreadsheet — and where it breaks

Updated September 14, 2026 · 7 min read · Sources checked on publication

We sell software that does this, so the useful thing to say is that a spreadsheet is a perfectly reasonable way to track Etsy profit — for a while. It is free, you already know how to use one, and building it teaches you exactly where the money goes. It also has three specific failure points, and knowing them in advance is more valuable than any template.

What the sheet needs

One row per order, and columns from three different places. The complication that catches people is that Etsy splits the information you need across two files: the Orders CSV knows what sold, and the monthly statement knows what it cost.

Profit per order is then revenue minus every fee, minus the label, minus materials and labor. Group by product and you have the number that matters.

Three things to get right while building it

• Never sum a single statement column. The statement puts sales in the Amount column and fees in Fees & Taxes, so adding up one of them gives you a figure that means nothing. This is the most common spreadsheet error by a distance. See the statement guide.
• Exclude Deposit and Payment rows entirely. They are transfers of money you have already counted. Include them and you count the same revenue twice.
• Keep sales tax out of revenue. For US orders Etsy collects and remits it on your behalf; it was never yours, and leaving it in inflates every total downstream.

Where it breaks

Not immediately, and not dramatically. A spreadsheet stops being reliable in three fairly predictable ways.

1. A material price changes

You typed materials into each product row. Wax goes up 15%. Now every row containing wax is wrong, and nothing in the sheet tells you which those are. You either spend an evening auditing or you accept that your numbers are quietly stale — and most people accept it, because the alternative is tedious.

This is the structural weakness: a spreadsheet stores answers, not the recipe that produced them. Recording materials once and referencing them from products is the fix, and it is awkward to do in a sheet — see costing materials properly.

2. A refund crosses a month

A December sale refunded in January appears as revenue in one month and a deduction in another, in a different file, possibly a different tax year. Handling that by hand means remembering to go back and amend a row you already closed. Two or three of these and your monthly totals stop tying out, usually without you noticing which month broke.

3. You stop updating it

The honest one. The sheet requires a monthly download, a paste, a reconcile and a review, and it competes with actually making things. Most spreadsheets die not from a flaw but from November. A stale sheet is worse than no sheet, because it hands you confident numbers that are wrong and you price the next product from them.

When a spreadsheet is genuinely the right call

We would rather say this than pretend otherwise. Stay with a sheet if you have a handful of products with stable material costs, a few dozen orders a month, and you enjoy the control. At that size the reconciling is quick and the sheet will be accurate. Building it will also teach you the fee structure better than any tool can, which has lasting value even if you later stop.

Move on when updating a material price means editing many rows, when refunds crossing months make you distrust your own totals, or when you notice you last updated it two months ago.

That is the problem MakerMargin was built for — it reads both Etsy files, matches per-order fees to their orders, keeps shop-level costs at shop level, and applies material costs from recipes so a price change updates every affected product at once. You can see your last 30 days free without a card. If you only want to check a single sale, the free fee calculator needs no account at all.

Statement structure and column behaviour reflect the Etsy statement CSVs MakerMargin parses, alongside Etsy’s help centre guidance on monthly statements; the sales-tax treatment is from Etsy’s Fees & Payments Policy, which states Etsy calculates, collects and remits sales tax for orders shipped to US buyers. All read 14 September 2026.