The payment account CSV is the file that answers "where did the money go?" — but its columns are unlabelled beyond one-word headers, and community threads are full of sellers adding up the wrong ones. Here's what each column means, and the two misreadings that cause most of the confusion. (Haven't got the file yet? Here's where it hides in Shop Manager.)
| Column | What it holds |
|---|---|
| Date | when the entry hit your payment account — not necessarily the order date |
| Type | the row's kind: Sale, Fee, Tax, Marketing, Refund, Deposit and similar — this is the column to filter on |
| Title | the human-readable line: which fee, which order, which ad charge |
| Info | supporting detail — often the order or listing the row relates to |
| Currency | the currency of the row (GBP for UK shops unless you sell in another currency) |
| Amount | the gross movement for that row — positive for money in, negative or empty for rows that only charge |
| Fees & Taxes | what was deducted on that row: the fee itself, or VAT charged on fees |
| Net | the row's actual effect on your balance once its deductions are applied |
On a single sale row it roughly does — but your payout is the sum of all rows since the last deposit, and many costs arrive as their own separate rows, not as deductions on the sale: listing fees when you list or renew, Etsy Ads charges, VAT-on-fees lines, refunds. Totting up sale rows alone always overstates what you'll receive. The deposit reconciliation explainer walks through a full example.
The Fees & Taxes column mixes genuinely different things: Etsy's own fees (listing, transaction, processing, the regulatory operating fee), VAT that Etsy charges on those fees, and tax amounts that pass through your account without ever being your money or your cost. Lumping them together makes your fee rate look worse than it is and makes your accounts wrong in both directions — the split matters if you're VAT-registered, and it matters at tax time either way.
Filter by Type, group the Fee and Marketing rows by their Title, total each group, and keep tax lines separate. For a month of statements that's an hour in a spreadsheet — or the drop-a-file job our auditor exists for: every fee category totalled, VAT-on-fees shown separately, and your true effective rate, entirely in your browser.
Based on the payment account CSV format as of September 2026 (Date / Type / Title / Info / Currency / Amount / Fees & Taxes / Net); Etsy adjusts its exports from time to time, and some statements add columns such as a running balance. Numbers are for information only — not tax, accounting or financial advice.