Seller Profit Guard · How it works · CSV privacy

Etsy Payment Account reconciliation tool

Compare order rows with Payment Account or monthly statement activity to find unmatched sales, refunds, fee-only rows, deposits, and timing differences without treating a bank deposit as profit.

Maintained by Seller Profit Guard Editorial Team. Last reviewed: 2026-07-12.

What reconciliation explains

An order export explains what sold. Payment Account activity explains how sales, fees, refunds, adjustments, reserves, shipping labels, and deposits moved through the account. The two files answer different questions, which is why gross sales rarely equal a bank deposit.

The tool highlights rows that need review instead of forcing every difference into one profit number. Reconciliation should be completed before private SKU costs are used to evaluate whether a product was profitable.

• Match order sales to statement sales for the same period.
• Classify refunds, fees, adjustments, and deposits separately.
• Review unmatched rows and formula differences.
• Keep deposits classified as cash transfers, not revenue or profit.

Privacy and review boundary

Reconciliation needs transaction structure, amounts, dates, and row categories. It does not need buyer names, delivery addresses, messages, or payment credentials. Keep the source files local and use redacted examples for support.

If a difference could affect bookkeeping or tax reporting, confirm it in Etsy's official records and with an appropriate professional. Seller Profit Guard only provides an operational review layer.

Sources and further reading

• Etsy Help: What are the Fees and Taxes for Selling on Etsy?: Official overview of listing, transaction, payment, advertising, and other seller fees.
• Etsy Help: How Etsy's Offsite Ads Work: Official Offsite Ads fee, attribution, and fee-cap reference.
• Etsy Help: How to Download a Spreadsheet of Your Sold Transactions: Official CSV export workflow for order items, orders, Etsy Payments sales, and deposits.
• Etsy Help: How to Manage Your Payment Account: Official Payment Account and monthly statement reference.
• Etsy Help: How to Issue a Full or Partial Refund For an Order: Official refund workflow and Payment Account impact reference.

Related Seller Profit Guard tools

• Etsy CSV profit calculator: Run a local order profit check with editable fee and SKU cost assumptions.
• Payment reconciliation tool: Compare order rows with statement activity and flag unmatched rows.
• SKU cost library: Save or import material, labor, packaging, shipping, and target margin assumptions.
• Variant risk checker: Find missing SKUs and variation cost risks before a listing scales.
• Free shipping threshold calculator: Estimate when a shipping subsidy can still meet a target margin.
• Return window loss estimator: Model expected reverse shipping, restock work, recovery, and replacement loss.
• Etsy Ads break-even helper: Estimate target-margin-safe ad spend after product and fulfillment costs.
• CSV data privacy: Understand what the local-first workflow needs and what it does not need.

Use the interactive tool

Enable JavaScript to open the calculator and process browser-local inputs. The explanatory content and source links remain available without JavaScript.

Related guide: Read the Payment Account reconciliation guide.

This tool provides operating estimates, not tax, accounting, legal, financial, or marketplace-policy advice. Verify current official sources and your own records before changing prices or operations.