Etsy Profit Guard

How to reconcile Etsy order CSV with Payment Account CSV

Etsy deposits are not the same as order profit. Reconciliation should compare order rows to statement sales, classify fees and refunds separately, and treat deposits as cash transfers. A useful report highlights unmatched statement sales, unmatched orders, refunds, fee-only rows, and revenue differences.

Workflow

1. Import order items CSV first, then optional Payment Account or Monthly Statement CSV.
2. Map date, order ID, transaction, activity, amount, fee, deposit, and currency fields.
3. Compare order totals against statement sales and keep deposits out of profit.
4. Investigate unmatched sales, unmatched orders, refunds, and formula mismatches.

Use the reconciliation module: open Payment Reconciliation.

This is an operating estimate, not tax or accounting advice.