Etsy Seller Accounting: Converting Payment Reports

Etsy Payment Accounting Basics

Etsy's payment system works differently from Amazon and Shopify. Etsy uses a "payment account" model where sales, fees, shipping labels, and advertising charges all flow through a single account, with periodic deposits to your bank. Understanding this model is key to accurate bookkeeping for Etsy sellers.

The Etsy Payment Account CSV

You can download your payment account activity from Etsy's Shop Manager. The CSV contains these columns:

• Date: Transaction date
• Type: Transaction type (sale, fee, listing, deposit, etc.)
• Title: Description of the transaction
• Currency: Three-letter currency code
• Amount: Gross amount
• Fees & Taxes: Fees deducted by Etsy
• Net: Amount minus fees

Each row represents a single event in your payment account.

Etsy Fee Types Explained

Transaction Fees

Etsy charges a 6.5% transaction fee on the total sale amount (including shipping). This is their primary revenue source and your largest Etsy expense.

• Type: transaction or appears in the Fees & Taxes column
• Accounting: Debit to "Etsy Transaction Fees"

Listing Fees

Every listing on Etsy costs $0.20 and renews every 4 months or when an item sells (auto-renewal).

• Type: listing
• Accounting: Debit to "Listing Fees"

Payment Processing Fees

Etsy Payments charges a processing fee on each sale: 3% + $0.25 in the US (varies by country).

• This may appear combined with the transaction fee or as a separate line
• Accounting: Debit to "Payment Processing Fees" or combine with transaction fees

Etsy Ads / Offsite Ads

If you use Etsy Ads (on-platform advertising) or are enrolled in Offsite Ads (where Etsy advertises your listings on Google, Facebook, etc.):

• Etsy Ads: Charged based on your daily budget, appears as marketing/advertising type
• Offsite Ads: 12-15% fee on sales attributed to offsite advertising
• Accounting: Debit to "Marketing & Advertising"

Shipping Label Fees

If you purchase USPS shipping labels through Etsy, the cost is deducted from your payment account.

• Type: shipping
• Accounting: Debit to "Shipping Labels" or "Shipping Expense"

Regulatory Operating Fees

In some jurisdictions, Etsy charges a regulatory operating fee to offset compliance costs.

• Accounting: Debit to "Etsy Fees" or group with transaction fees

Building an Etsy Journal Entry

For each deposit period, create a journal entry with:

Credits

• Product Sales: Sum of all sale type Amount values
• This is your gross revenue from Etsy

Debits

• Etsy Transaction Fees: 6.5% transaction fees
• Payment Processing Fees: 3% + $0.25 per sale
• Listing Fees: $0.20 per listing
• Marketing & Advertising: Etsy Ads + Offsite Ads charges
• Shipping Labels: Postage purchased through Etsy
• Refunds: Customer refunds processed
• Bank Account (Deposit): The net amount deposited

Balance Verification

Gross Sales - Transaction Fees - Processing Fees - Listing Fees
  - Ads - Shipping Labels - Refunds = Net Deposit

Downloading Your Etsy Payment Data

1. Log in to Etsy Shop Manager
2. Go to Finances > Payment account
3. Select the month you want to export
4. Click Download CSV

Note: Etsy's CSV export is per-month, not per-deposit. You may need to filter for specific deposit periods if you want per-deposit journal entries.

Etsy vs. Amazon vs. Shopify: Key Differences

Understanding how Etsy differs from other platforms helps with accurate accounting:

Aspect	Etsy	Amazon FBA	Shopify
Fee structure	Transaction + processing + listing	Referral + FBA + storage	Processing only
Payout frequency	Weekly (configurable)	Biweekly	Daily to weekly
Report granularity	Monthly CSV	Per-settlement file	Per-payout CSV
Fee visibility	Mixed in payment account	Detailed in settlement	Per-transaction
Shipping labels	Deducted from payment account	Separate from settlement	Not included

The Etsy Deposit Timing Challenge

Etsy deposits money to your bank on a regular schedule, but fees are charged throughout the month. This means a single deposit might cover sales from multiple days, minus fees from different periods. When reconciling, match the deposit amount to your bank statement, not individual sales.

Common Etsy Accounting Mistakes

Mistake 1: Recording Only the Deposit Amount

Recording just the bank deposit misses the fee detail. Your P&L won't show the true cost of selling on Etsy.

Fix: Always record the gross sale and itemized fees, with the deposit as the bank debit.

Mistake 2: Double-Counting Shipping

If a customer pays for shipping, that amount is included in the sale Amount. Don't record it as both a sale and a separate shipping income line unless Etsy's CSV breaks it out.

Fix: Follow the CSV structure. If shipping is included in the Amount column, it's part of gross sales.

Mistake 3: Ignoring Listing Fees

At $0.20 each, listing fees seem trivial. But a seller with 500 active listings is spending $100/month just on listing renewals.

Fix: Track listing fees as a separate expense for visibility into true selling costs.

Mistake 4: Mixing Deposit Periods

Etsy's monthly CSV might span multiple deposits. Recording the entire month as one journal entry makes bank reconciliation harder.

Fix: Either create per-deposit journal entries or reconcile at the monthly level consistently.

Automating Etsy Accounting

Manual conversion of Etsy CSVs to journal entries follows the same pattern described above, but can be automated. SettleBooks supports Etsy payment account CSVs: upload the file, review the categorized journal entry, and export in your preferred format.

The tool automatically: - Identifies Etsy CSV format from the column headers - Categorizes each transaction type to the appropriate account - Sums amounts by category - Generates a balanced journal entry - Exports to QBO CSV, Xero CSV, Sage CSV, or IIF format

Best Practices for Etsy Bookkeeping

1. Download your CSV monthly — don't let months pile up
2. Reconcile deposits to bank statements — verify every deposit matches
3. Track fees by type — transaction fees, listing fees, and ads should be separate expense accounts
4. Record refunds as contra-revenue, not as expenses
5. Save the original CSVs — they're your source documents for audit purposes
6. Be consistent — use the same accounts and process every month

Summary

Etsy seller accounting requires understanding the payment account model and the various fee types. Download your monthly CSV from Shop Manager, categorize transactions into sales, fees, and deposits, build a balanced journal entry, and import it into your accounting software. Whether you do this manually or use an automated tool, the principles are the same: match gross sales to revenue, itemize fees as expenses, and verify the net deposit matches your bank.