How to read your Etsy monthly statement CSV
Your Etsy monthly statement lists every sale, fee, tax line, refund and bank deposit for the month. Read it wrong and your profit looks bigger or smaller than it really is. This guide explains each column and each kind of row.
Where to download it
In Etsy, open Shop Manager → Finances → Monthly statements. Choose a month, then click Download CSV. You get one file per month. Open it in Excel, Google Sheets or any text editor. Etsy may change the layout of these pages over time, so if the menu names differ, look for Finances and then statements.
The columns
| Column | What it means |
|---|---|
| Date | The day the entry was recorded, not always the day the buyer ordered. |
| Type | The kind of row: Sale, Fee, Tax, Refund, Marketing, Shipping, VAT, Deposit and so on. This is the most useful column for sorting. |
| Title | A short description, such as "Transaction fee: Ceramic Mug" or "Processing fee". Titles help tell apart fees that share the same Type. |
| Info | A reference such as an order number, listing number or label number. Use it to match fees back to a sale. |
| Currency | The currency of that row. Shops selling in more than one currency need to total each separately. |
| Amount | The gross money in. Usually filled for sales and refunds, and shown as "--" for most fees. |
| Fees & Taxes | The money taken out for fees, taxes and charges. Shown as "--" on rows that have none. |
| Net | What the row does to your balance. For most rows this is Amount plus Fees & Taxes. |
| Tax Details | Extra tax information where Etsy provides it. Often "--". |
The row types
| Type | What it is | Counts toward profit? |
|---|---|---|
| Sale | Payment for an order, shown as "Payment for Order #...". | Yes, as income (see the tax note below). |
| Fee | Transaction fees, processing fees, listing and auto-renew fees, regulatory operating fees, Etsy Plus. Also fee credits. | Yes, as a cost. |
| Tax | Sales tax or VAT paid by the buyer that Etsy collects for the government. | No. It is not your income. |
| Refund | Money returned to a buyer. | Yes, reduces income. |
| Marketing | Etsy Ads and Offsite Ads charges. | Yes, as a cost. |
| Shipping | Shipping labels bought through Etsy, and label adjustments. | Yes, as a cost. |
| VAT | VAT or similar tax charged on Etsy's own fees, in countries where it applies. | Yes, as a cost of the fees. |
| Deposit / Payment | Money sent to your bank, or a payment you made to Etsy for a bill. | No. It moves cash, it does not earn it. |
Rows with an unfamiliar Type, such as an adjustment, deserve a manual look. Do not guess which bucket they belong in.
A small example
Here is one order, refunded later in the month, plus a bank deposit. It follows the layout of a typical statement (some columns trimmed to fit).
| Date | Type | Title | Amount | Fees & Taxes | Net |
|---|---|---|---|---|---|
| Jan 3 | Sale | Payment for Order #3001234567 | $42.00 | -- | $42.00 |
| Jan 3 | Tax | Sales tax paid by buyer | -- | -$2.80 | -$2.80 |
| Jan 3 | Fee | Transaction fee: Ceramic Mug | -- | -$2.55 | -$2.55 |
| Jan 3 | Fee | Processing fee | -- | -$1.52 | -$1.52 |
| Jan 3 | Fee | Auto-renew sold | -- | -$0.20 | -$0.20 |
| Jan 4 | Shipping | USPS shipping label | -- | -$6.15 | -$6.15 |
| Jan 20 | Refund | Refund to buyer for Order #3001234567 | -$42.00 | -- | -$42.00 |
| Jan 20 | Fee | Credit for transaction fee | -- | $2.55 | $2.55 |
| Jan 20 | Tax | Refund of sales tax paid by buyer | -- | $2.80 | $2.80 |
| Jan 25 | Deposit | $1,000.00 sent to your bank account | -- | -- | -- |
Exact signs and wording can differ between statements and countries. Treat this as an illustration of the pattern.
Why sales tax rows are not income
When a buyer pays sales tax or VAT, Etsy collects it and passes it on to the tax authority. It is not revenue for your shop. If you add up every positive number and call it sales, a tax-heavy month will make you look better off than you are. Keep Tax rows in their own pile and leave them out of income and costs. In the example above, the tax paid and the tax refunded cancel out.
Why deposits are not profit
A Deposit row is Etsy paying your earnings to your bank. Those earnings already appeared as Sale rows, less fees. A deposit also depends on timing and reserves, so a month's deposits rarely match that month's sales. Profit comes from sales minus fees, ads, shipping, refunds and your own costs. Deposits only tell you where the cash went.
Fee credits on refunds
A refund returns the buyer's money, and Etsy may credit back part of the fees on that order. In the example, the $2.55 transaction fee comes back as a positive Fee row, and the sales tax is returned too. Notice what is not returned there: the processing fee and the shipping label. A refunded sale can still cost you money. When you add up fees, include the positive credits so they offset the original charges.
A quick checklist for any month
- Total the Sale rows, then subtract Refund rows.
- Set Tax rows aside. They are not income or expense.
- Add every Fee, Marketing, Shipping and VAT row, and net the positive credits against them.
- Ignore Deposit and Payment rows for profit.
- Check that your categories add back up to the statement total.
- Subtract your own costs, such as materials and packaging, which are not on the statement.
Skip the sorting
ShopTally reads the CSV files, puts every row in the right bucket and shows your profit by month. Everything stays on your computer.
One-time $24. Runs offline in your browser. The free edition shows your latest month only.
Questions
Where do I download the Etsy monthly statement CSV?
In Shop Manager, go to Finances, then Monthly statements. Pick a month and choose Download CSV. Repeat for each month you need.
Is the Amount column my income?
Not by itself. For sales it includes the amount the buyer paid, which can contain sales tax that Etsy collects for the government. Fees, taxes, refunds and deposits sit in other rows.
Why does a deposit row not count as profit?
A deposit is Etsy sending money you already earned to your bank. The sale and fee rows already counted it, so counting the deposit again would double it.
Why do I see positive fee rows after a refund?
When an order is refunded, Etsy can credit back some fees, such as the transaction fee. These show as positive amounts in the Fees & Taxes and Net columns. Check each fee against your own records, because not every fee is returned.
Can I read the statement without a spreadsheet?
Yes. ShopTally reads the CSV files and sorts every row into sales, tax, fees, marketing, shipping, refunds or non-profit transfers, then shows profit by month.