Etsy Profit Tracker | True Profit After Fees & COGS | Kill Keep Scale | Tax Prep | Excel Google Sheets
Originally published: 12/06/2026 11:43
Last version published: 12/06/2026 12:11
Publication number: ELQ-59323-2
View all versions & Certificate
certified

Etsy Profit Tracker | True Profit After Fees & COGS | Kill Keep Scale | Tax Prep | Excel Google Sheets

True profit after every Etsy fee, COGS & tax reserve. Auto fee calc for 5 countries. Kill/Keep/Scale verdicts. 13 tabs. Excel & Google Sheets.

Description
Do you know your true profit after every Etsy fee, your COGS, and your taxes — or just your revenue?


Most Etsy sellers track revenue. This file tracks what you actually keep.
Enter a sale, select your country, and every fee layer calculates automatically:

  • Listing fee

  • Transaction fee

  • Payment processing

  • Offsite ads


Then COGS is deducted. Then your tax reserve. The number left is your true profit — not an estimate.



WHAT'S INSIDE (13 TABS)
✦ Auto Fee Calculator — US, UK, AU, CA, DE rates built in
✦ True Profit — after fees, COGS, and expenses
✦ Kill/Keep/Scale — automatic verdict on every listing
✦ Pricing Simulator — see exact profit before changing a price
✦ 90-Day Revenue Forecast — gap to target, break-even per new listing
✦ Market Intel — competitor price positioning tool
✦ Tax Prep — quarterly estimates from your actual P&L
✦ Dashboard — year-at-a-glance KPIs, 2025–2028
✦ P&L — monthly profit & loss, auto-calculated



COMPATIBLE WITH
✔ Excel 2019 and Excel 365 ✔ Google Sheets (import as .xlsx) ✔ No macros. No subscriptions.



HOW IT WORKS


  1. Open the Start Here tab — 5 minutes to set up

  2. Enter your country once in Shop Settings

  3. Log sales in the Sales tab — everything else calculates automatically




Not affiliated with or endorsed by Eloquens Inc.Fee rates verified May 2026. Digital download — all sales final once downloaded.

This Best Practice includes
1 Excel Model

Acquire business license for $49.00

Add to cart

Add to bookmarks

Discuss

Further information

This tool gives Etsy sellers a complete picture of what they actually
keep — not just what they earn. Objectives:

• Calculate true profit on every sale after Etsy fees, COGS, and
tax reserve — automatically, with no manual math
• Identify which listings to Kill, Keep, or Scale based on real
margin data, not gut feel
• Forecast 90-day revenue and see the gap to your monthly income target
• Estimate quarterly tax obligations from your actual P&L
• Simulate price changes before making them live
• Benchmark your pricing against competitor listings using the
Market Intel tool
• Operate across 5 countries (US, UK, AU, CA, DE) with auto-updated
fee rates, currency, and tax deadlines

• Etsy sellers with active listings in any product category —
digital downloads, physical products, or both
• Sellers managing 2 or more listings who need objective data
to decide where to focus
• Sellers currently pricing by intuition who want to understand
their real margin before Etsy fees compound
• Shop owners in the US, UK, Australia, Canada, or Germany —
fee rates and tax deadlines are pre-loaded for all five
• Sellers who also have business expenses (ads, packaging, tools)
and want those deducted before seeing true profit
• Anyone preparing for quarterly estimated taxes who wants
estimates generated from their actual Etsy P&L

• Sellers outside the five supported countries — fee calculations
will be approximate; manual adjustment is required in the Fees tab
• Etsy shops with Etsy Payments not enabled — payment processing
fee calculations assume Etsy Payments is active
• Sellers needing multi-currency reporting within a single shop
(e.g. listing in GBP and USD simultaneously)
• Users who require VAT filing support — this tool estimates
your income tax reserve only; Etsy remits VAT/GST on your behalf
in most jurisdictions, but VAT registration obligations are not covered
• Businesses with complex entity structures (S-corp, partnership,
multi-owner LLC) — the Tax Prep tab is designed for sole proprietors
and single-member LLCs only


0.0 / 5 (0 votes)

please wait...