Etsy Payment Account reconciliation guide for small sellers
Last updated: 2026-07-07
Payment reconciliation means connecting order rows to the money movement that follows: sales, refunds, fees, taxes collected by the platform, adjustments, and deposits. It helps explain why gross sales and cash deposits rarely match.
Why deposits rarely match gross sales
A deposit is not the same thing as profit, and it is usually not the same thing as gross sales. A deposit can combine multiple sales, subtract fees, reflect refunds, include tax handling, include reserves or adjustments, and arrive on a different date than the order. That is why a seller can have a strong sales week and still feel confused by the cash that lands in the bank.
The clean way to reconcile is to separate three views. The order item CSV explains what sold. The Payment Account or monthly statement explains how money and fees moved. Your SKU cost library explains what the sold items cost to make, pack, ship, and support. Reconciliation connects the first two; profit review adds the third.
Etsy's help center describes CSV downloads for order items, Etsy Payments sales, deposits, and monthly statements. Use those official exports as the source of truth for rows and categories, then use Seller Profit Guard to flag mismatches and missing cost context.
| View | What it tells you | What it does not tell you |
|---|---|---|
| Order item CSV | Items sold, item price, quantity, SKU when present, order grouping | Deposit timing, fee categories, cash movement, actual SKU cost. |
| Payment Account activity | Sales, fees, refunds, adjustments, deposits, statement activity | Material cost, labor cost, packaging cost, listing quality context. |
| Monthly statement CSV | Month-level activity that can support bookkeeping review | Whether a product was operationally profitable after your private costs. |
| SKU cost library | Material, packaging, labor, shipping, target margin assumptions | Official marketplace fee treatment or bank deposit status. |
The weekly reconciliation loop
Run reconciliation weekly instead of waiting until tax time. A weekly loop keeps the order, refund, replacement, and shipping label context fresh. It also prevents one confusing statement from turning into a month of unexplained differences.
Start with the order export and the Payment Account or monthly statement export for the same period. Match sales rows first, then mark unmatched orders, unmatched statement sales, refund rows, fee-only rows, and deposits. Deposits should be treated as cash transfers, not profit. Profit requires SKU costs and fulfillment cost.
Do not send private buyer data to a tool or support inbox just to reconcile amounts. Most reconciliation checks can work from transaction IDs, dates, row categories, and redacted examples. If a column mapping fails, report the column names and a made-up row instead of sharing a real order.
- Match order rows to statement sales before reviewing deposits.
- Classify refunds separately from sales so a refund does not look like a normal negative order.
- Classify fees separately from product costs; marketplace fees and material costs answer different questions.
- Review unmatched rows while they are still easy to explain.
- Keep private buyer data out of screenshots, community posts, and support requests.
Example: why a 500.00 sales week can deposit less
Suppose a seller sees 500.00 in gross item sales for a week. The bank deposit may be lower because Etsy fees, payment processing fees, shipping label purchases, refunds, taxes collected and remitted by the platform, reserves, or adjustments can all affect the Payment Account before cash is deposited.
That lower deposit is not automatically a problem. It is a reconciliation question. The seller should ask which rows explain the difference. If the difference is mostly normal fees, shipping labels, and one refund, the statement may be clean. If there are unmatched sales, unexplained fee-only rows, or a refund with no cost review, the seller has work to do.
Only after the statement rows are explained should the seller ask whether the week was profitable. That second question needs SKU cost, packaging, labor, label cost, and any expected replacement or support cost.
| Row type | How to treat it | Common mistake |
|---|---|---|
| Sale | Match to an order or order item row | Treating gross sale as net profit. |
| Fee | Keep as marketplace/payment cost | Mixing fee rows with product material cost. |
| Refund | Review revenue reversal plus replacement/support cost | Counting only the refunded amount. |
| Deposit | Treat as cash transfer | Trying to match one deposit to one order. |
| Adjustment or reserve | Flag for review against official statement context | Ignoring rows that do not fit normal sales categories. |
What to flag before tax time
Reconciliation is not tax preparation, but it can make tax-time cleanup less painful. The useful habit is to flag unexplained rows as they occur, not to decide their tax treatment inside the profit calculator.
A seller should keep a short note for any row that does not make sense: unmatched sale, refund without a reason, fee-only row, reserve status, deposit timing issue, or manual adjustment. Those notes make it easier to review official records with a bookkeeper or accountant later.
- Unmatched order rows.
- Unmatched statement sales.
- Refund rows without SKU-level loss review.
- Deposits that span multiple sales periods.
- Fee-only rows that are not explained by known fee categories.
- Rows affected by reserves, adjustments, or currency conversion.
How to use the reconciliation tool
Open the Payment Reconciliation tool, load the order file and the Payment Account or monthly statement-style activity file, then review the unmatched and formula-check sections. The tool is designed to point you to rows that deserve attention, not to make accounting decisions for you.
After the statement is clean enough, move low-margin or refund-heavy SKUs into the profit calculator. Reconciliation explains where the money went; SKU-level profit explains whether the product should keep its price, shipping promise, and ad exposure.
Related resources
- Open Payment Reconciliation: Compare order rows with statement activity.
- Check SKU-level profit: Move reconciled sales into margin review.
- Read CSV data privacy: Use redacted examples instead of private buyer data.
Sources and further reading
- 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.
- CSV data privacy: Understand what the local-first workflow needs and what it does not need.
Next step: Open the reconciliation tool.
This is operational planning help, not tax, accounting, legal, or platform-policy advice. Verify current platform rules and fee assumptions before changing prices.