Your Etsy Payout Is Not Your Profit. Here Is the Ledger.

Payout is not profit

Etsy shows a sale. Then it shows a deposit. Those two numbers are not the same, and neither one is profit.

The sale is gross merchandise: item price plus shipping you charged plus gift wrap if you charged it. The deposit is what left Etsy’s payment account after marketplace fees. Profit is what is left after that deposit is reduced by refunds, cost of goods, and the shop bills that never attach to a single order — software, ads you switched on, packaging bought in bulk, mileage to the post office, and listing fees you paid whether or not that SKU sold this week.

Sellers who skip the ledger make the same three mistakes:

1. Calling the deposit “what I made.” The deposit already had fees taken out. It has not yet had COGS or overhead taken out.
2. Ignoring listing fees because they are small. Twenty cents is small once. It is not small across a catalog you renew all year. Etsy charges the listing fee when you publish, not when the item sells (Etsy Help, Fee Basics).
3. Dumping Canva, ads, and cardstock into “COGS.” Per-order materials are cost of goods. A monthly subscription is overhead. Mixing them makes every SKU look worse than it is, or every month look better than it is, depending on which pile you stuffed.

You can keep this on paper. The point of a spreadsheet is that the fee math is a formula, so you do not re-add December in April.

The three required Etsy fees (plus the optional ones)

Etsy’s public fee pages name three required selling fees and then the optional services. Confirm the live numbers on Etsy Help: Fees and Taxes and Fee Basics before you lock a price. Rates below are what those pages stated when this article was written (5 September 2026). They are not a promise Etsy will keep them.

Two rules that keep the log honest:

• Transaction fee is not processing fee. Etsy says so on the fee page. If you collapse them into one “Etsy took 10%” cell, you cannot see which lever moved when a rate changes.
• Listing fee is not a per-order fee. A workbook that puts $0.20 on every order is allocating the listing cost so you do not forget it. That is a convenience. If the listing has been live for months and already paid, that $0.20 is overhead for the period, not a cost of this one sale. Know which method you are using and stick to it.

Processing fees vary by the country of the seller’s bank account. The US figure above is the US row. If your bank is in another country, use Etsy’s table, not this page.

A $25 digital sale, worked

Hypothetical only — not a shop result and not a promise. US seller, $25 digital download, no shipping, no gift wrap, sale did not come from Offsite Ads, no sales tax on the item price.

Rounded to cents the way a sheet would. Fee take with the listing allocation: $2.83, or about 11.3% of the $25 price. Without allocating the listing fee to this order: net before COGS is $22.37.

If this were a physical print and the cardstock, ink, and mailer cost $4.10, COGS is $4.10 and net after COGS is $18.07 (with the listing allocation). Canva Pro is still not in that $4.10. Canva Pro is an expense row in the month you paid it.

If you refund the order, Etsy says the payment processing fee is credited proportionally on Etsy Payments refunds. Do not assume every other fee comes back. Log the refund as its own event. Do not delete the original sale row — you will lose the trail.

How to log one order (the weekly close)

Minimum columns that later become a P&L and a tax packet:

• Date and order ID (from Shop Manager, not from memory)
• Listing / SKU
• Gross — item + shipping charged + gift wrap charged
• Listing fee (allocated or not — pick a rule)
• Transaction fee
• Processing fee
• Offsite Ads or Etsy Ads — only when that order actually came from ads
• Refund — amount you actually returned
• COGS — materials and packaging for that order, or a standard cost you set per SKU
• Net — a formula. You do not type it.

Close the week in four passes:

1. Orders in. One row per sale. If you sold three of the same printable, that is three rows or one row with quantity — but then COGS must multiply. Quantity without COGS multiplication is how a “$200 week” hides $80 of paper.
2. Fees check. Compare the week’s fee total to Shop Manager. If the sheet is $12 high, you allocated listing fees the shop already billed in another week, or you applied Offsite Ads to organic orders.
3. Expenses out. One row per shop bill: date, category, vendor, amount, receipt. Software is not COGS. A one-time stock-photo pack you will use on twenty listings is overhead (or a prepaid you amortize yourself — the sheet will not decide that for you).
4. One-page totals. Revenue, total fees, fee %, net after fees, COGS, net after COGS, other expenses, profit. That packet is what you send a CPA. It is not a tax return.

Do this weekly. “I will sort it at tax time” is how April becomes a CSV scavenger hunt through twelve deposit emails.

COGS is not overhead

Cost of goods sold is what it cost to fulfill that order. Overhead is what it cost to keep the shop open that month.

Digital downloads have near-zero per-order COGS. That does not mean they have near-zero cost. It means the costs sit in expenses: the tools you used to make the file, the ads that found the buyer, the listing fees for the rest of the catalog. If you force those into COGS, every digital SKU looks unprofitable and you will underprice the next one to “fix” a problem the ledger invented.

Physical sellers: pick a standard cost per SKU (materials + packaging) and use it until you do a real count. Updating COGS every order from the last Target run is how the same printable shows $1.80 one week and $3.40 the next.

Price backwards from the net you want

Most new shops pick a round number ($6.99, $9.99) and hope. The better question is: after Etsy’s required fees, what do I keep, and is that enough to cover COGS plus a share of overhead?

Using the US required-fee stack on a digital item with no shipping and no ads:

Net ≈ price − (0.065 × price) − (0.03 × price + $0.25) − listing allocation

Which is: net ≈ 0.905 × price − $0.25 − listing allocation

To keep $20 after those required fees, with a $0.20 listing allocation: price ≈ ($20 + $0.25 + $0.20) / 0.905 ≈ $22.60. You would list at $22.99 or $24.99, not $19.99, if $20 after fees is the actual target. That is arithmetic, not a pricing strategy for your niche, and it ignores Offsite Ads. If a sale comes from Offsite Ads, the net drops by whatever rate Etsy charged on that order. Run the same formula with that extra percent before you enroll a listing.

The shop’s seller workbook includes a fee-calculator tab described as a “what should I charge?” solver: enter a price and see profit, or enter a target profit and see a price. Treat the rates in that tab as editable. If Etsy changes 6.5% or the US processing pair, the tab is wrong until you change the cells.

Quarterly estimates and sales tax collected — not a filing

Two piles that are not profit and are not optional to track:

• Sales tax Etsy collected and remitted. If Etsy collected it, it is not your revenue. If you also type it into a “sales” column, you will pay income tax on money you never kept. Keep a state-by-state collected/remitted log so April is a filter, not a reconstruction.
• Estimated tax. US sole proprietors often pay quarterly using Form 1040-ES. A spreadsheet that estimates a set-aside is a worksheet. It does not file, it does not know your other income, and it does not apply credits. Confirm with a tax preparer. The IRS page for estimated taxes is the source for due dates, not a blog post: IRS, Estimated Taxes.

Mileage to the post office or a craft fair belongs on a mileage log with date, destination, business purpose, and miles. Use the IRS standard mileage rate for the year you are logging — do not copy a rate from an old blog. Link: IRS standard mileage rates.

None of this is tax advice. A workbook that says “Schedule C” on a tab is organizing your numbers next to common labels. It is not a certified form and it is not a substitute for a preparer who can see your whole return.

A workbook that holds this ledger

Etsy Seller Bookkeeping Spreadsheet | Fee Calculator Profit COGS Tax Tracker Excel Google Sheets

Listing 4533025325 · $6.99 · state active (Etsy Open API, 5 September 2026)

This is the shop’s Etsy-specific seller workbook — the file for order-level fees and net profit. Live listing copy names a 12-tab Excel and Google Sheets workbook plus companion files. Instant digital download; four flat files, no ZIP: a 2-page Start Here PDF, the 12-tab .xlsx, and an interactive HTML dashboard (the listing’s remaining non-PDF file). No macros required for core functionality.

What the live listing says the workbook does:

• Order Log — one sale per row; listing fee ($0.20), transaction (6.5%), processing (3% + $0.25), optional Offsite Ads, and net profit calculate per order
• Expenses — Schedule-C-aligned categories, plus blank “add your own category” rows
• Dashboard — revenue, total fees, fee %, net profit, margin, orders, average order value, with charts
• Monthly P&L — twelve-month rollup with a revenue-vs-profit chart
• Fee Calculator — price → profit, or target profit → price
• Quarterly Estimated Tax — a simplified 1040-ES-style worksheet
• Sales Tax Collected — what Etsy collected/remitted by state
• Mileage Log — business-mileage style tracker
• Inventory & Supplies — materials on hand with a reorder flag
• Start Here / Sample Data Guide / Leave a Review — setup, pre-loaded example year, and a review prompt

Use this file when the problem is “what did I actually keep after Etsy.” It is not QuickBooks. It does not import Shop Manager CSV. It does not log into your shop. You type the orders. The formulas do the fee math from the rates in the file — change those rates if Etsy changes them.

Open Start Here first. Skim the sample year so you can see every formula working, then overwrite the sample rows. Excel 2016 or later, or upload the .xlsx to Google Drive and open with Sheets. The HTML dashboard is a browser companion (Chrome, Safari, Firefox) on PC, Mac, or tablet — no Excel required for that file, and the listing states your numbers stay on your device.

Open the live Etsy listing →

When the shop is not only Etsy

Etsy fees are a marketplace problem. Invoices, 1099 clients, and a general P&L are a business problem. If you also sell off-platform, bill clients, or want one book for the whole sole prop, these are the live siblings — not substitutes for the Etsy fee log.

Small Business Bookkeeping Spreadsheet | Self Employed P&L Tax Tracker Excel Sheets

Listing 4483358189 · $6.99 · state active

Income, expenses, invoices, mileage, and a tax-oriented summary for a sole prop that is not only an Etsy shop. Use this when you have Shopify or in-person sales next to Etsy and need one P&L. It will not split Etsy’s listing / transaction / processing the way the seller workbook does. Keep the Etsy fee log; roll a monthly total into this file if you want one business view.

Open the live listing →

Freelancer Invoice Tracker Spreadsheet | 1099 Client Tax Log Excel Google Sheets

Listing 4483358185 · $6.99 · state active

Clients, invoices, aging, and a quarterly set-aside — for 1099 work, not for marketplace orders. If you design templates by day and sell them on Etsy by night, the invoice file is the day job; the seller workbook is the shop.

Open the live listing →

Small Business Bookkeeping Bundle Spreadsheet | Freelancer Invoice Seller Tax Excel Google Sheets

Listing 4535716354 · $12.99 · state active

The bundle is the shop’s combined seller / freelancer / small-business set when you do not want to pick one file. Still not QuickBooks. Still not a tax filing.

Open the live listing →

How to choose

Practical stack for a digital-product Etsy shop: the seller workbook first. Add the small-business file only when a second channel exists. Add the freelancer file only when you invoice humans. Do not buy the bundle to feel complete if you have not logged a week of orders yet.

Same shop, different jobs (not seller books — linked so you can see the rest of the operator catalog):

• Church Tithe Tracker — giving log and year-end statements for a volunteer treasurer
• Home Maintenance Tracker — seasonal HVAC, warranties, repair log
• Landlord Rent Roll — who paid, late flags, rental income and expense

Love Guarantee and custom work

Every listing on this page carries the same 14-day Love Guarantee.

Love Guarantee (14 days): Message Smart Files Shop if the file is not right — free fix, free small customization, or refund.

Free small customizations (typical examples): rename a column, add a header, change a category label, put your SKU list on the dropdowns, update a fee rate cell to match a Shop Manager screenshot you send.

Paid customs — shop-wide / typical menu; message for a quote before any extra charge. Individual listings may quote lower for tweaks already in scope for that file — always by quote, never a surprise invoice. For paid customs, timeline is usually 1–3 business days after we lock the brief.

• Light custom $15–$29 — shop name / header on every tab; extra expense categories
• Standard custom $39–$79 — extra marketplace columns (Shopify next to Etsy), a board-report tab, branded export
• Deep custom $89–$149 by scope — branding, data import, multi-entity

The shop says yes to requests like “add our SKU names to the order-log dropdowns.” It does not take full bookkeeping outsourcing, tax filing, or Shop Manager cleanup. One free polish pass is included on paid customs after first delivery.

What these files will not do

They will not connect to Etsy, your bank, or QuickBooks. They will not file a Schedule C, compute self-employment tax for your whole return, or tell you whether you are a hobby. They will not import last year’s CSV in one click. They will keep a seller from reconstructing the year out of deposit emails and a Notes app.

If you want the files, buy them on Etsy through the live links above. This page is a guide, not a checkout. Browse the rest of the shop at etsy.com/shop/SmartFilesShopUS.

FAQ: Etsy seller fees and profit tracking