Skip to product information
1 of 8

InkSheet Studio

Etsy Seller Profit Tracker Spreadsheet, Listing Profit Calculator, Etsy Fee Calculator, Google Sheets, Tax Summary Included

Etsy Seller Profit Tracker Spreadsheet, Listing Profit Calculator, Etsy Fee Calculator, Google Sheets, Tax Summary Included

Regular price $2.69 USD
Regular price $9.99 USD Sale price $2.69 USD
Sale Sold out
Quantity

INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.

You know your sales. Do you know your profit — per listing?

A listing can look like a winner and quietly lose money on every single sale once the transaction fee, payment processing, the regulatory fee, the listing fee, your ad spend and an Offsite Ads fee land on it. In the sample shop inside this file, one little keychain loses $1.27 on every sale — at 110 sales a month. The sellers who catch that are the ones who price from their real numbers. This tracker puts those numbers in front of you, listing by listing.

Transparency note: every design in our shop is AI-assisted then hand-finished — this spreadsheet was created with the help of an AI generator, then hand-built, formula-checked and finished by our shop.

WHAT'S INSIDE — 5 TABS
• Start Here — a plain-English guide plus the Fee Settings block: every Etsy rate in one editable place (transaction 6.5%, payment processing 3% + $0.25 per order, regulatory 0.59%, listing fee $0.20, Offsite Ads 15% — sample rates, labeled as samples). Every formula in the file reads those cells, so when a rate changes you change one number and the whole file follows.
• Listing Profit Board — one row per listing: price, shipping charged, your materials, packaging, shipping paid and ad spend per sale, whether the sale came through Offsite Ads, and your units per month. The sheet figures the full fee stack, your profit per sale, your margin, your monthly profit, and a verdict on every row — Healthy, Thin, or Losing money. It ships with 14 fictional sample listings (digital and physical) so you can watch it work.
• Pricing Calculator — type a price and see the full fee stack, profit and margin figured three ways side by side: no Offsite Ads fee, Offsite at 12%, and Offsite at 15%. Plus a reverse block: tell it the profit you want per sale and it solves the price you need to charge.
• Monthly Snapshot — your year month by month: units, gross, total fees and profit, all pulling from the Board's weighted averages — plus a Year-End Totals summary block (total gross, total fees, total profit) to keep with your own records at tax time.
• Goal Planner — set a target monthly profit and see your current monthly profit (pulled live from the Board), the gap, and exactly how many extra sales of your best-margin listing would close it, with your progress as a percentage.

HOW THE FEES ARE FIGURED
Per sale: Gross = Price + Shipping Charged. Transaction Fee = Gross × 6.5%. Processing Fee = Gross × 3% + $0.25. Regulatory Fee = Gross × 0.59%. Listing Fee = $0.20. Offsite Fee = Gross × 15%, only on rows you mark Offsite = Yes (the Calculator also shows a 12% column for shops on that tier). Total Fees adds your Ads per Sale. Profit per Sale = Gross − materials − packaging − shipping paid − Total Fees. Margin = Profit ÷ Gross. All rates come from the Fee Settings block on Start Here — check them against Etsy's current fee schedule, because rates change and some vary by country and sales tier.

THE SAMPLE DATA
The Board ships loaded with 14 fictional listings — a digital planner keeping $20.52 of its $24.99 price, a candle, a mug, a scarf with free shipping, a bath salt jar running Thin at a 12.8% margin, and that keychain losing $1.27 a sale — so every formula, verdict and total is working before you type a thing. The Snapshot carries a sample year of unit counts, and the Goal Planner starts from a sample $8,000 target. Replace the samples with your own listings and numbers; the formulas stay.

REQUIREMENTS: Microsoft Excel for the .xlsx file delivered with this listing, or a free Google account for the Google Sheets version (the copy link is inside delivery.pdf). Nothing to install. This spreadsheet is a bookkeeping aid, not tax advice — confirm your obligations with a tax professional.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit. Error fixes are always free.

View full details