Etsy Profit Tracker Spreadsheet | Inventory Tracker for Makers with Recipe COGS, True Profit Per Listing, Fee Calculator, No Subscription

Meet the candle maker who sells out at every market, ships forty orders a month, and still cannot tell you which of her candles makes money. Her best seller might be her worst earner. She only finds out at tax time, in one big blurry number, when it is too late to fix a price.

That knot is familiar to almost every solo maker. You price from the cost of wax and a feeling. Etsy takes a listing fee here, a transaction fee there, a processing fee you never see itemized per sale. Shipping quietly eats a dollar here and two dollars there. By the time the payout lands, the math that would tell you the truth is scattered across three statements and a shoebox of receipts.

The thing standing in your way is not effort. You already work hard. It is that no tool at your size shows you the one number that matters: what you actually kept on each listing, after every fee and every gram of material. The big inventory services show it, and the billing adds up fast. At published prices, checked November 2026: Pro is $20/mo billed annually = $240/yr, and it has no Schedule C report. Studio is $41/mo billed annually = $492/yr, or $49 month to month, and the tax report starts here. Indie is $83/mo billed annually = $996/yr, or $99 month to month, and automatic material deduction is only here. For a small shop, that subscription can stop making sense.

Leave it scattered and the cost is real. A listing priced five dollars too low does not lose five dollars once. It loses it on every order, all year, while looking like a success. A year of that can quietly cost more than the tools you were avoiding paying for.

So here is the guide your shelf was missing: the Etsy Maker Profit Tracker, a one time spreadsheet for Microsoft Excel and Google Sheets. You list your materials once, with what a pack costs. You build one recipe per product, and the workbook turns it into a true cost per item. When you record making a batch, your materials come out of stock on their own. When you log a sale, the Etsy fee engine for the fees on a sale runs on it: the $0.20 listing fee (allocated per item sold), the 6.5 percent transaction fee, payment processing, the regulatory fee if your country has one, and the Offsite Ads fee when an ad made the sale, capped at $100 per order the way Etsy caps it. What is left, after your shipping cost and your materials, is your true profit on that listing, shown on a dashboard next to the Etsy fees on the sales in this workbook.

You also price with it. Tool 1: I have a price shows the profit at that price. Tool 2: I want a margin works out the price you need, fees included, for retail and wholesale. At year end, it prepares your numbers on a tax summary mapped to the 2025 US Schedule C lines, with a Canada worksheet for your T2125 and GST/HST return. And it starts with a filled in example candle shop, so you set up by following a real shop, not by learning a database.

Picture your next price review. You open one tab and see every listing ranked by what it actually earned you. Your weakest listing is not a suspicion anymore, it is a number, and you fix its price or retire it that same evening. Your strongest listing gets the market table, the ad budget, and the new scent. Tax season stops being a shoebox and becomes a worksheet you already filled in all year.

That is who you become with this workbook: the maker who knows. Not the maker who hopes the payout was fair. The maker who can say what each candle, soap, scarf, or cutting board earned, and who prices the next batch like it.

What is inside

- One workbook, 12 tabs, for Microsoft Excel and Google Sheets
- Materials library with cost per unit that updates every recipe when a supplier price changes (60 ready rows)
- Recipe costing for up to 12 products, bundles included: a bundle is just another recipe
- Manufacture log that deducts recipe materials and adds finished stock on its own
- Stock tab with OK, LOW, and below zero flags for materials and finished goods, plus an adjustments column for breakage and assembled sets
- Sales log with the Etsy fee engine for the fees on a sale on every row (300 ready rows): listing, transaction, processing, regulatory, and Offsite Ads fees, capped per order, true profit per sale
- Import tab with a paste layout for Etsy's CSV downloads and a monthly statement check: match Etsy's statement, or land within a few cents, and the Import tab shows you the difference
- Pricing tab: Tool 1 (I have a price) and Tool 2 (I want a margin), plus a wholesale row
- Dashboard: Etsy fees on the sales in this workbook, profit by listing, best 3 and worst 3, profit by month, and a stock attention count
- Tax Summary: US Schedule C preparation (2025 form) and a Canada worksheet for your T2125 and GST/HST return
- A second workbook, fully filled in: the Willow and Wick example candle shop, three months of data
- Quick Start Guide, full User Manual with one sale worked step by step, and an FAQ, as PDFs

Honest limits, in plain words

This workbook does not sync with Etsy or any other shop. Nothing imports on its own. Sales go in by typing, or by pasting from Etsy's own CSV downloads into the Import tab and copying each item across by hand. Stock counts cover this workbook only: no multi channel live stock, and nothing pushes counts back to Etsy. There is no lot or batch tracing and no compliance reporting. The Tax Summary prepares your numbers; it is not a tax return and it is not tax advice. True profit here means after materials, packaging, shipping, and Etsy fees. It does not put a price on your own time. If you want your time counted, put an amount in Other cost per item in the recipe and every sale will carry it. Fees this workbook does not count: listing renewals on items that have not sold, Etsy Ads (the separate ad program, not Offsite Ads), currency conversion fees, and the tax Etsy charges on its own fees. It is built for solo and low volume makers, up to roughly 250 order lines a month. If you outgrow it, that is a good problem, and we would rather tell you now than after you pay.

Kollaz is not affiliated with or endorsed by Etsy, Inc.

Questions sellers ask

Is there a subscription?
No. CA$85, one payment, and the file is yours. No monthly order line cap and no tiers. Room as shipped: 12 products, 60 materials, 300 sales rows; the manual shows how to add sales rows, and a second copy holds another 12 products.

What if I get stuck?
Message us through Etsy: use the Contact shop owner button on the Kollaz shop page. Tell us your workbook version (on the START HERE tab), which tab you are on, and what you expected to see. A screenshot of the row helps more than a paragraph.

Does it work in Google Sheets?
Yes. It is a standard spreadsheet file using only common formulas, and it calculates the same way in Excel, Google Sheets, and LibreOffice.

I sell in Canada. Does it handle that?
Yes. Set your currency to CAD and copy the Canada line from the country table on the Settings tab: processing is 3% + 0.25 CAD on Canadian and US orders (4% + 0.25 CAD on other international orders), and the regulatory operating fee is 0.50% since June 2026. The Tax Summary has a Canada worksheet for your T2125. If you gave Etsy your GST/HST number, Etsy does not collect GST/HST on your physical goods and you must charge and remit it yourself; the worksheet and the manual explain where that goes.

Can it handle gift sets and bundles?
Yes. A bundle is a recipe like any other. List every item in the set as an ingredient and the set gets its own cost, stock, and profit line. Sets assembled from shelf stock use the adjustments column, and the manual shows how.

How long does setup take?
The example shop is filled in so you can copy its shape; most of the setup is typing your materials list once. The Quick Start Guide is one page, in the order the tabs want to be filled.