Etsy bookkeeping spreadsheet 2027 | every Etsy fee, true profit, Schedule C lines

Etsy bookkeeping spreadsheet 2027: every Etsy fee, true profit and your Schedule C lines

Etsy bookkeeping spreadsheet for Etsy sellers: type your year (or month) and see every Etsy fee line by your bank country, the deposits you should have received, true…

Example of the result this page gives you

How it works

Enter your details in the free version below.
See your result right away on this page.
Need more? The full version adds what is listed under "What you get".

Published 2026-11-15 · ReadyStack

Your shop's numbers (example: made-up US shop, 2026)

Bank account country (sets the fee rates) Sales: items + shipping + gift wrap ($) Number of orders Sales tax / VAT Etsy collected from buyers ($) Sales from orders Etsy marked as Offsite Ads ($) Offsite Ads rate Listing + renewal fees paid ($) Etsy Ads spend ($) Shipping labels bought on Etsy ($) Money sent back to buyers ($) Materials / cost of goods ($) Packaging + other supplies ($)

True profit$9,451.50

Etsy kept in fees$2,678.50

Deposits you should see$14,271.50before your own costs

Margin · fees per order51.4%$4.32

Pro keeps the whole year: import any number of Etsy statement CSVs, a month-by-month profit book, an Excel file with 3 sheets, a printable year summary and monthly close-the-books reminders. $24 per year or $4.99 per month. Get Pro yearly · $24 / year Monthly · $4.99 / month

Why a dashboard number is not your books

Etsy pays you sales minus every fee, label and buyer payback, so your bank deposits never match the sales figure in Shop Manager. Record sales at the full amount and each Etsy fee as an expense, or the fees end up taxed as if they were profit. Your 2026 books close on December 31, 2026; the US return with Schedule C is due April 15, 2027.

Fee rates read on Etsy Help on 2026-11-15: transaction fee 6.5% of item + shipping + gift wrap; payment processing by bank-account country on the total including sales tax; regulatory operating fee on item + shipping (CA 0.50%, FR 1.14%, HU 1.97%, IT 0.80%, ES 0.88%, UK 0.48%); Offsite Ads 15% or 12% of the order total, capped at $100 per order (this page applies the rate to your Offsite Ads sales total). Schedule C and Schedule SE lines from the IRS 2026 forms. A record-keeping tool, not tax advice.

Pro: your Etsy books for the whole year

Import Etsy statement CSVs: drop in one month or twelve; every row is sorted into sales, buyer paybacks, 6.5% transaction, processing, regulatory, Offsite Ads, listing, Etsy Ads, labels, VAT on fees and deposits. Rows already in the book are skipped.
Month-by-month profit book saved in this browser, with your materials and supplies entries (mark one as repeating and it carries into 2027).
Excel file (.xlsx, opens in Google Sheets): Monthly P&L with formulas, the full Ledger, Schedule C lines.
Printable year summary for you or your accountant, and a .ics reminder on the 2nd of each month to import last month's statement.
2027 book in one click.

Have a key?

Your numbers stay in this browser; nothing is uploaded. Not affiliated with Etsy, Inc.

Questions and answers

What does this page do?

Etsy bookkeeping spreadsheet for Etsy sellers: type your year (or month) and see every Etsy fee line by your bank country, the deposits you should have received, true profit and the Schedule C lines.

Is it free?

Yes. The free version on this page works without an account. The full version costs $24 / year.

How do I use it?

1. Enter your details in the free version below. 2. See your result right away on this page. 3. Need more? The full version adds what is listed under "What you get".