How to Track Etsy Profits in Google Sheets (2026 Seller Guide)

Etsy sellers routinely overestimate their profits because they're looking at revenue, not what's left after Etsy's fees, payment processing, COGS, shipping costs, and self-employment taxes. An Etsy profit calculator in Google Sheets gives you the real number — what you actually keep per sale, per product, and per month. Here's how to build one that works for physical products, digital downloads, and print-on-demand shops alike.

Understanding Every Etsy Fee (2026)

Before you can track Etsy profits, you need to understand exactly what Etsy charges. Most sellers are aware of the transaction fee but miss several other costs that eat into margins.

Adding up the standard fees on a $30 sale with $5 shipping looks like this:

And that's before you account for the actual cost of the item, packaging, and your time. Understanding this math is why an Etsy profit calculator is essential — not optional.

How to Calculate True Profit Per Sale

True profit per sale is the number after you subtract everything: Etsy fees, cost of goods, packaging, shipping costs you absorb (if any), and a portion of monthly overhead like Etsy Plus, Etsy Ads, and any supplies or equipment.

The True Profit Formula

True Profit = Sale Price + Shipping Charged - Etsy Fees - COGS - Packaging - Shipping Cost - Overhead Allocation

Let's run it for the same $30 item:

On a $30 sale, you're keeping $16.87 — a 48% margin. That's actually healthy for physical products. But some sellers do this math and discover they're keeping $5 on a $25 item after COGS and fees. That product needs a price increase or it needs to be cut.

Building Your Etsy Seller Spreadsheet in Google Sheets

Your Etsy seller spreadsheet needs five components working together. Here's the structure:

Tab 1: Fee Calculator (Setup)

Create a reference tab where you enter Etsy's current fee rates. Other tabs reference this so when Etsy changes fees (and they do), you update one place and every calculation updates automatically.

Cells to create:
B1: Listing Fee = 0.20
B2: Transaction Fee Rate = 0.065
B3: Payment Processing Rate = 0.03
B4: Payment Processing Fixed = 0.25
B5: Offsite Ads Rate = 0.15 (or 0.12 if over $10K)
B6: Etsy Plus Monthly = 10

Tab 2: Sales Log

Every sale, logged as it's deposited. Columns: Date, Order ID, Item Name, Sale Price, Shipping Charged, Etsy Fees (auto-calculated), Gross Revenue, Net After Fees.

Tab 3: Product Profit Calculator

Per-product analysis. One row per product SKU. Columns: Product Name, Sale Price, Shipping Charged, Etsy Fees (calculated), COGS, Packaging Cost, Shipping Cost, Overhead Allocation, Net Profit, Profit Margin %.

Tab 4: Monthly P&L

Pulls from Sales Log to show monthly revenue, total fees, COGS, overhead, net profit, and running YTD totals.

Tab 5: Tax Tracker

Net profit YTD, SE tax estimate, quarterly payment schedule, and amounts paid.

Per-Product Profit Tracker

The most valuable part of any Etsy seller spreadsheet is the per-product profit analysis. This tells you which products are worth making, which need price adjustments, and which are actually losing you money.

The Overhead Allocation Formula

Monthly overhead needs to be spread across your units sold. If you pay $10/month for Etsy Plus and sell 40 items, that's $0.25 per item. Formula:

=Monthly_Overhead / Projected_Monthly_Units

Recalculate this quarterly as your sales volume changes.

Adding Your Time as a Cost

Physical product sellers often forget to value their time. If a candle takes 30 minutes to make and you value your time at $20/hour, that's $10 in "labor cost" per candle. Include this in your COGS — otherwise your "profit" is really just the dollar value of your own labor.

Monthly P&L Summary

Your monthly P&L shows whether your Etsy shop is actually a profitable business or an expensive hobby. Here's the structure:

Build this using SUMIFS formulas from your Sales Log and expense records. The YTD column should reference cumulative totals, not just sum January through current month manually.

Tracking Cost of Goods Sold (COGS)

COGS is the biggest source of inaccuracy in Etsy profit tracking. It's also one of the most impactful — underestimating COGS by $2/unit doesn't sound like much, but at 200 units/month that's $400/month in phantom profit you're counting that doesn't exist.

What Goes Into COGS for Physical Products

• Raw materials — yarn, resin, wood, wax, metal, clay, fabric, etc.
• Consumables — sandpaper, glue, paint, dye, wick, fragrance oil
• Packaging materials — boxes, bags, tissue paper, ribbon, crinkle paper, labels
• Thank-you cards and inserts — if you include them
• Your labor — valued at your target hourly rate

What Goes Into COGS for Digital Products

Digital products have near-zero variable COGS — once created, each download costs almost nothing to deliver. Your costs are largely fixed (software subscriptions, one-time design time, Etsy fees). Track fixed costs as overhead, amortized over expected lifetime sales. Example: if you spend 10 hours creating a template (valued at $30/hr = $300), and you expect to sell 200 units, that's $1.50 COGS per sale.

Tracking COGS Per Product

Create a COGS calculator tab where you list each ingredient/material for each product, its unit cost, and the quantity used per item. The spreadsheet multiplies quantity × unit cost to give you total material cost per unit. Sum all materials for your product COGS.

Update this whenever your material costs change — supplier price increases can quietly destroy margins if you're not recalculating periodically.

Etsy Taxes: What You Owe and How to Track It

Etsy income is self-employment income and is taxed accordingly. Here's what Etsy sellers need to track for tax purposes:

1099-K Threshold (2026)

Etsy is required to send you a 1099-K if you received over $5,000 in gross sales processed through Etsy Payments (2026 threshold — this has changed frequently, verify current rules). Regardless of 1099 status, all income is taxable. Track it yourself rather than waiting for Etsy's annual statement.

Deductible Business Expenses for Etsy Sellers

What Etsy Does NOT Deduct for You

Etsy collects and remits sales tax on your behalf in most U.S. states (marketplace facilitator laws). But Etsy does not track your COGS, shipping costs, supply purchases, or equipment expenses. Those are your responsibility to track and deduct on Schedule C.

FAQ: Etsy Profit Tracking in Google Sheets

Can I use Etsy's own reports instead of building a tracker?

Etsy's built-in finance reports show your gross revenue and fees, but they don't track COGS, time, or overhead — so they can't show you true profit. You need to supplement Etsy's data with your own cost tracking. Download Etsy's CSV exports monthly and import them into your Google Sheet to avoid manual entry of sales data.

How do I handle refunds and returns in my tracker?

Log refunds as negative entries in your Sales Log on the date the refund was issued. Etsy refunds the transaction fee and payment processing fee but not the listing fee. Note this in your tracker — refunds appear as negative revenue plus a partial fee reversal.

How should I price my products to hit a target margin?

Work backward from your target margin. If you want a 50% margin after all costs: Sale Price = Total Costs / (1 - Target Margin). If total costs per unit are $12 and you want 50% margin: $12 / 0.50 = $24 minimum price. Add Etsy fees to total costs in this calculation.

What's the difference between gross profit and net profit for Etsy?

Gross profit = Revenue minus COGS only. Net profit = Revenue minus COGS minus all operating costs (fees, overhead, shipping). Most Etsy sellers should focus on net profit — gross profit looks healthier but doesn't reflect the real business picture after fees eat 10–18% of revenue.

Do I need accounting software or is Google Sheets enough?

For Etsy sellers making under $100K/year, a well-built Google Sheets tracker handles everything you need. It's free, shareable with a CPA, and more flexible than most entry-level accounting software. If you're managing inventory, multiple staff, or complex supply chains, dedicated software like QuickBooks or A2X (Etsy-specific) may be worth it.

Related reading: How to Track Multiple Side Hustles in Google Sheets · How to Track Your Home Bakery Business in Google Sheets · Freelance Tax Deductions Checklist 2026