General Etsy recordkeeping guide

How to Track Etsy Income and Expenses

Organize gross receipts, fees, refunds, payouts, materials and inventory inputs, and supporting records without turning a spreadsheet into tax advice.

Read the direct answer

✓Direct answer

To track Etsy income expenses for taxes, keep gross receipts separate from fees and refunds, record each payout, preserve materials and inventory inputs, and retain the exports, statements, receipts, and deposit records behind each entry. Reconcile payouts instead of treating a payout as a complete sales record.

This is general information, not tax advice. Rules vary by jurisdiction and tax year.

A five-part Etsy recordkeeping workflow

Keep source amounts separate before anyone applies local rules

Preserve gross receipts

Record gross receipts from the source you choose before netting separate fees or refunds, and keep the currency visible.

Separate fees and refunds

Keep marketplace, payment-processing, advertising, shipping-label, and refund fields separate so differences remain traceable.

Reconcile payouts

Match Etsy Payments deposit records with bank deposits and investigate differences using the underlying records.

Preserve COGS and inventory inputs

Keep purchase documents and material or inventory inputs without using this template to calculate cost of goods sold.

Retain supporting records

Keep the exports, statements, invoices, receipts, deposit records, and corrections that support each entry.

A ledger label is an organizational choice. It does not decide whether an amount is income, deductible, reportable, or assigned to a form line.

Download the empty CSV ledger

A header-only template with a matching JSON schema

The approved template has one header row and no examples, personal information, formulas, macros, or calculations. Keep each row in one currency. The accompanying data dictionary explains all 18 fields and records the template review date.

Download the header-only CSV

The file organizes records only. It does not calculate COGS, deductions, tax, or filing values.

Jurisdiction and tax-year matrix

Missing rows remove dependent claims

Supported source scope by jurisdiction and effective window
Jurisdiction	Tax year or effective window	Entity scope	Boundary
Etsy platform (all seller locations)	Platform snapshot reviewed 2026-08-05; not a tax-year rule	Sellers with access to Etsy Shop Manager exports	Export availability and columns can change. Inspect your downloaded files; do not infer local tax treatment from an Etsy field name.
United States — federal	Publication 583 revision 12/2024; current Schedule C landing-page boundary reviewed 2026-08-05 without inferring a form year	General business records; Schedule C source applies only to qualifying sole proprietors	State and local rules are not covered. Recheck the authority for the tax year and entity type you are filing; this page makes no filing or deduction determination.
United Kingdom	Self Assessment guidance snapshot reviewed 2026-08-05; no tax year inferred	Self-employed sole traders and partners in a business partnership; not limited companies	Confirm the rules for your accounting period and business structure directly with HMRC/GOV.UK.

If your jurisdiction, tax year, or business type is absent, this guide makes no dependent tax or reporting claim for it. Preserve neutral source records, then check the current local authority before classifying an entry.

Scope and primary sources

Official guidance reviewed for this page

Updated August 5, 2026. We reviewed the official guidance below and included only facts supported within the stated jurisdiction and subject scope.

This page organizes records only. It does not classify deductions, calculate tax, choose an accounting method, map entries to a tax form, or determine filing and reporting duties.

Primary references

Etsy Help: How to Download a Spreadsheet of Your Sold Transactions — reviewed August 5, 2026. Current Etsy UI instructions for exporting order items, orders, Etsy Payments sales, and Etsy Payments deposits. It does not establish tax treatment or every export column.
U.S. Internal Revenue Service: Publication 583, Starting a Business and Keeping Records — reviewed August 5, 2026. General U.S. federal business recordkeeping, including transaction summaries, supporting documents, gross receipts, purchases, and inventory records. Not a filing-year determination for an individual seller.
U.S. Internal Revenue Service: About Schedule C (Form 1040) — reviewed August 5, 2026. U.S. federal sole-proprietor form boundary only. The source HTML does not establish a tax year, and this guide does not decide whether a reader must use the form or map ledger fields to form lines.
U.S. Internal Revenue Service: Understanding your Form 1099-K — reviewed August 5, 2026. Explains that Form 1099-K reports gross payments and can help determine correct income. No reporting threshold or individualized tax result is stated on this guide.
U.S. Internal Revenue Service: How long should I keep records? — reviewed August 5, 2026. U.S. federal retention periods vary with the record and tax situation. The guide links to the authority instead of publishing one universal duration.
GOV.UK: Business records if you're self-employed — reviewed August 5, 2026. UK sole traders and partners in a business partnership; business income and expense records for Self Assessment. Limited-company rules are outside this source scope.

Frequently Asked Questions

No. Use payouts to reconcile Etsy activity with deposit records. Keep gross receipts, fees, and refunds as separate fields so the source records remain traceable.

No. It records materials or COGS inputs for later review. It contains no formulas and makes no tax, deduction, inventory-method, or filing decision.

There is no duration on this page that applies to everyone. Use current retention guidance for your jurisdiction, record type, and circumstances.

Treat it as unsupported here. Preserve neutral source records and check the current authority for that location, period, entity type, and accounting method before applying tax treatment.

Organize your next Etsy research project

Workspace AI supports the current product and market research workflow. It does not provide bookkeeping, accounting, filing, individualized advice, or tax-ready books.

Use Workspace AI to organize your Etsy research workflow Create a free account