Most Etsy pricing advice stops at “cover your costs and add a bit.” The Etsy Pricing Tool does the arithmetic instead: it applies Etsy’s real fees to every listing you have, then puts a target price next to what your competitors actually charge.
What a sale actually leaves you
On My Products, the Profit on regular price and Profit on sale price column groups apply the listing fee, the transaction fee, and payment processing to each row. In the worked example a $7.99 order leaves $2.29 — a 28.7% margin — and you get the same answer on your sale price, so you can see what a discount really costs.
One thing sellers most often forget is fee-bearing: Etsy’s transaction fee applies to the shipping you charge, not just the item. Charge $5.00 for postage that costs you $4.10 and you do not keep ninety cents. The workbook keeps what you charge and what you pay as separate columns for exactly that reason.
Offsite Ads, in its own column
Offsite Ads behaves unlike every other fee: it only bills when a shopper buys after clicking one of Etsy’s off-site ads, and it is the biggest fee you pay when it fires. The threshold is a one-way door — once your shop has ever passed $10,000 in any 365-day stretch, the rate drops to 12% and Offsite Ads becomes mandatory for the life of the shop. It does not revert if your sales fall again. Put your best-ever 365-day total on the Setup tab and the workbook picks the right rate and applies the $100 per-order cap.
A price to aim at
The Pricing Recommendation blends the prices of the competitors you have matched to a listing into one figure, compares it to yours, suggests a target a set percentage under it, and says About right, Room to raise, or Priced above target. Two dials on Setup control it: an adjustment to the blended price, and how far under to aim — 10% by default.
It is a blend, not a crystal ball. It knows what your rivals charge. It does not know that yours is hand-finished or ships in a day — so treat it as the start of a decision, not the end of one.
What it deliberately doesn’t do
This tier does the money math. It does not score your tags — that is the Etsy SEO Tool. It does not import your Etsy statement — that is the Etsy Financial Tool. If you want the tracking without any of the fee math, the Etsy Product Tool is the cheaper start. All four live together in the Etsy Seller Toolkit.
Excel or Google Sheets, your choice
It runs the same way in Excel on Windows, Excel on a Mac, Google Sheets, and LibreOffice — every formula uses functions all of them share. The download includes a one-click link to your own native Google Sheet copy: choose Make a copy and the whole workbook lands in your Drive, formulas and all. Not a lossy import of a spreadsheet file — a real Sheet.
Nothing is locked. The formulas are visible, the settings are exposed, and there is no subscription. Own it, don’t rent it.
Want to try the math first? The free Etsy Fee & Tag Checker runs the same fee arithmetic on a single listing — no signup.
Ardent Workshop is not affiliated with, endorsed by, or sponsored by Etsy, Inc. Figures shown come from a fictional example shop and are illustrative — nothing here is tax, accounting, or financial advice.
