Import Etsy Sales Into
QuickBooks Instantly

Why Etsy Sellers Need a Dedicated QuickBooks Converter

Etsy is one of the largest marketplaces for handmade, vintage, and creative goods, with millions of active sellers worldwide. While Etsy provides a CSV export of your payment activity through Shop Manager, this file is designed for Etsy's internal reporting format — not for accounting software like QuickBooks. The CSV mixes sales, fees, refunds, shipping labels, listing fees, and deposits into a single flat file with column names and date formats that don't align with what QuickBooks expects during import. Without a conversion tool, sellers are left manually reformatting spreadsheets, categorizing transactions by hand, and entering data row by row — a tedious, error-prone process that becomes unmanageable as your shop grows.

Common Etsy Import Problems in QuickBooks

When attempting to work with raw Etsy CSV exports in QuickBooks, sellers commonly encounter these issues:

• Mixed transaction types — Etsy's CSV combines sales, fees, refunds, deposits, and listing charges in a single file. QuickBooks has no way to automatically categorize these different transaction types during a standard CSV import, resulting in everything landing in a single uncategorized bucket.
• Fee tracking difficulties — Etsy charges multiple types of fees: transaction fees (6.5% of each sale), payment processing fees (3% + $0.25), listing fees ($0.20 per listing), and optional advertising fees. These fees appear in a combined “Fees & Taxes” column that QuickBooks cannot automatically split into separate expense categories.
• Date format mismatches — Etsy exports dates in various formats depending on your account locale (e.g., “January 15, 2024”, “15 Jan 2024”, or “2024-01-15”). QuickBooks requires MM/DD/YYYY format for reliable import, and will reject or misparse dates that don't match.
• Deposit duplication — When Etsy deposits funds to your bank account, this shows up both in the Etsy CSV (as a “Deposit” row) and in your bank statement. Importing both without filtering creates duplicate entries that throw off your account balances.

How the Etsy to QuickBooks Converter Works

The converter addresses every compatibility gap between Etsy's CSV export and QuickBooks' import requirements through an automated four-step process:

1. Parse the Etsy CSV — The converter reads your CSV file and extracts all fields: Date, Type, Title, Info, Currency, Amount, Fees & Taxes, and Net. It handles quoted fields, special characters, and multi-line descriptions that are common in Etsy exports.
2. Categorize transactions — Each row is automatically categorized based on the Type column: sales, refunds, transaction fees, listing fees, shipping labels, deposits, tax remittances, and marketing charges. This categorization drives the account mapping in QuickBooks.
3. Apply conversion options — Based on your configuration, the converter splits fees into separate line items, filters out deposits to prevent duplication, includes or excludes listing fees, and normalizes all dates to MM/DD/YYYY format.
4. Generate output file — The final IIF or QBO file is assembled with proper formatting, account mapping, and transaction categorization ready for direct QuickBooks import.

Understanding Etsy's CSV Export Format

Etsy's payment CSV export contains eight columns that capture the full picture of your shop's financial activity. The Date column shows when each transaction occurred. The Type column identifies the transaction category (Sale, Fee, Refund, Deposit, Listing, Shipping Label, etc.). The Title column contains the item name for sales or a description for fees and other charges. The Info column provides additional context like order numbers or buyer names. The Currency column indicates the transaction currency. The Amount column shows the gross transaction value. The Fees & Taxes column shows deductions applied by Etsy. Finally, the Net column shows the amount after all fees are deducted. Understanding this structure is important because the converter maps each column to the appropriate QuickBooks field during conversion.

Etsy Fee Accounting Best Practices

Properly tracking Etsy fees is essential for accurate profit calculation and tax preparation. Etsy charges several types of fees that should be tracked in separate expense categories in QuickBooks:

• Transaction fees (6.5%) — Charged on every sale, including shipping costs charged to the buyer. This is Etsy's primary commission and should be tracked in a “Marketplace Commissions” or “Etsy Transaction Fees” expense account.
• Payment processing fees (3% + $0.25) — Charged for processing the buyer's payment through Etsy Payments. Track these in a “Payment Processing Fees” account, similar to how you would track Stripe or PayPal processing fees.
• Listing fees ($0.20) — Charged each time you create a new listing or a listing renews every four months. These are small but add up for shops with many listings.
• Offsite Ads fees (12-15%) — If Etsy's offsite advertising drives a sale to your shop, a 12-15% fee is charged. Track these separately in an “Advertising Expense” account for accurate marketing ROI analysis.

Importing into QuickBooks Online

After converting your Etsy CSV to QBO format, follow these steps to import into QuickBooks Online:

1. Log into QuickBooks Online and navigate to Banking from the left sidebar.
2. Click Upload transactions (or “Link account” → “Upload from file” if this is your first import).
3. Select the converted QBO file from your computer.
4. QuickBooks will display a preview of the imported transactions — verify that dates, descriptions, and amounts are correct.
5. Choose the QuickBooks account to import into (e.g., “Etsy Payments” or “Etsy Sales”).
6. Click Import to complete the process. Transactions will appear in the “For Review” tab.

Tip: Create a dedicated “Etsy Payments” bank account in QuickBooks to keep your Etsy transactions separate from your regular bank activity. This makes reconciliation much easier when Etsy deposits hit your checking account.

Importing IIF Files into QuickBooks Desktop

For QuickBooks Desktop (Pro, Premier, or Enterprise), the IIF import method is recommended:

1. Open QuickBooks Desktop and go to File → Utilities → Import → IIF Files.
2. Browse to and select your converted IIF file.
3. QuickBooks will import the transactions and create any necessary accounts that don't exist yet (like “Etsy Sales Income” and “Etsy Fees”).
4. Review the imported transactions in the appropriate registers to verify accuracy.

The IIF format creates proper double-entry journal transactions with offset accounts, so each sale automatically debits your Etsy Payments account and credits your Sales Income account. Fees debit the Etsy Fees expense account and credit the Etsy Payments account. This keeps your books balanced without manual journal entries.

Reconciling Etsy with Your Bank Account

Etsy deposits funds to your bank account on a regular schedule (daily, weekly, biweekly, or monthly depending on your settings). Each deposit represents the net of all sales, minus all fees and refunds, for that period. To reconcile properly:

• Exclude deposits from Etsy import — Since deposits appear in both the Etsy CSV and your bank statement, importing them creates duplicates. Use the converter's “exclude deposits” option and let the bank feed handle the deposit side.
• Match deposit totals — The sum of your sales minus fees minus refunds for a given period should match the deposit amount in your bank account. Use the converter's summary statistics to verify this before importing.
• Handle multi-currency — If you sell internationally, Etsy handles currency conversion and deposits in your local currency. The converter preserves the original amounts from the CSV, so check that the currency matches your QuickBooks settings.

Want the full picture of Etsy seller bookkeeping? Read our comprehensive Etsy Accounting Guide — covering transaction fees, listing fees, Offsite Ads accounting, deposit reconciliation, and tax preparation strategies tailored for Etsy shop owners.

Related Free Accounting Tools

The Etsy to QuickBooks Converter is part of our complete suite of free QuickBooks conversion tools:

• CSV to IIF Converter — Convert bank CSV files to QuickBooks Desktop IIF format.
• CSV to QBO Converter — Convert bank CSV files to QBO Web Connect format.
• QBO to IIF Converter — Convert QBO/OFX files to QuickBooks Desktop IIF format.
• IIF to QBO Converter — Upgrade legacy IIF files to QBO/OFX format.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF.
• IIF Viewer — Preview and validate IIF files before QuickBooks import.
• Bank CSV Cleaner — Clean messy bank CSV exports for QuickBooks.
• Chart of Accounts Generator — Generate industry-specific chart of accounts.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks format.
• PayPal to QuickBooks Converter — Convert PayPal activity exports to QuickBooks format.
• Square to QuickBooks Converter — Convert Square POS exports to QuickBooks format.
• Amazon to QuickBooks Converter — Convert Amazon Seller reports to QuickBooks format.
• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks format.
• OFX to QBO Converter — Convert OFX bank statement files to QuickBooks QBO format.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format.
• QBO to CSV Converter — Export QBO transaction files to CSV spreadsheets.
• OFX to CSV Converter — Convert OFX bank files to CSV for Excel and Google Sheets.
• OFX to IIF Converter — Convert OFX files to QuickBooks Desktop IIF format.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format.
• QIF to QBO Converter — Upgrade legacy Quicken QIF files to QBO format.
• QBO to PDF Converter — Generate professional PDF statements from QBO files.
• MT940 to QBO Converter — Convert SWIFT MT940 European bank statements to QBO.
• QIF to CSV Converter — Convert Quicken QIF files to CSV spreadsheet format.
• QIF to IIF Converter — Convert Quicken QIF files to QuickBooks IIF format.
• IIF to CSV Converter — Export QuickBooks IIF files to CSV spreadsheets.
• QBO to OFX Converter — Convert QuickBooks QBO files to standard OFX format.
• MT940 to CSV Converter — Convert SWIFT MT940 bank statements to CSV format.
• QBO Viewer — Preview and inspect QBO Web Connect files before import.
• OFX Viewer — Preview and inspect OFX bank statement files.
• XLSX to QBO Converter — Convert Excel XLSX files to QuickBooks QBO format.
• Duplicate Detector — Find and remove duplicate transactions before import.
• Import Troubleshooter — Diagnose and fix QuickBooks import errors.
• File Format Detector — Identify unknown financial file formats automatically.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 bank statements to QBO.